Technologies/MySQL/mysql.performance.sort_merge_passes
MySQLMySQLMetric

mysql.performance.sort_merge_passes

The number of merge passes that the sort algorithm has had to do. If this value is large, you should consider increasing the value of the `sort_buffer_size` system variable.
Dimensions:None
Available on:DatadogDatadog (1)
Interface Metrics (1)
DatadogDatadog
The number of merge passes that the sort algorithm has had to do. If this value is large, you should consider increasing the value of the `sort_buffer_size` system variable.
Dimensions:None
Sources
mysql.performance.sort_merge_passesgithub.com
Related Insights (1)
Sort Buffer Exhaustionwarning

Sort operations exceeding sort_buffer_size, requiring multi-pass merge sorts and temporary files. Causes significant performance degradation for queries with ORDER BY, GROUP BY, or large JOINs requiring sorting.

▸