Chat now with support
Chat with Support

Spotlight on Oracle 10.9 - Getting Started Guide

Welcome to Spotlight Install Spotlight Start Spotlight Spotlight on Oracle Spotlight on Oracle Data Guard Spotlight on Oracle RAC Spotlight on Unix Spotlight on Windows Spotlight on MySQL Troubleshooting: Connection Problems

Inefficient Sort Alarm

This alarm fires when the number of temporary files created for sorts is high in comparison to the number of sorts performed.

When MySQL sorts some data – for instance, to resolve a query with an ORDER BY clause – it generates at least one disk file if the size of the SORT_BUFFER_SIZE is insufficient to sort all the data in memory.

If this happens, MySQL creates one or more disk files, and merges those files after all rows have been read.

If the average number of sort merge sort files is high, the sort will almost certainly benefit from more memory. If a sort generates only one disk file, adding more memory will improve the performance only if it allows the sort to avoid creating a disk file.

 

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating