Bug #78448 Provide better metrics on innodb_sort_buffer_size usage
Submitted: 16 Sep 2015 6:16 Modified: 21 Sep 2015 8:28
Reporter: Simon Mudd (OCA) Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Server: Performance Schema Severity:S4 (Feature request)
Version:5.6.26 OS:Any
Assigned to: CPU Architecture:Any

[16 Sep 2015 6:16] Simon Mudd 
Description:
See: bug#78273

As suggested I'm making a separate feature request here for improving metrics on innodb_sort_buffer_size so we can figure out if the settings are good or need changing.

Maybe this is now for 5.7 or 5.8?

How to repeat:
see above.

Suggested fix:
I_S.innodb_metrics ddl_sort_file_alter_table seems to provide this data but by default it's disabled. Perhaps it's worthwhile enabling this setting by default?

If other P_S tables provide information about memory and usage related to innodb_sort_buffer_size then perhaps it's worth adding documentation so we know where to look. This would help us then monitor and be able to tune the setting to get best performance out of the server.
[21 Sep 2015 8:28] MySQL Verification Team 
Hello Simon,

Thank you for the feature request!

Thanks,
Umesh