Tag Info

New answers tagged


The guidance in the manual (5.0-5.5) is If you see many Sort_merge_passes per second in SHOW GLOBAL STATUS output, you can consider increasing the sort_buffer_size value to speed up ORDER BY or GROUP BY operations that cannot be improved with query optimization or improved indexing. The entire buffer is allocated even if it is not all needed, so ...

Top 50 recent answers are included