Bug #73931 Show NUMA stats

• Submitted: 16 Sep 2014 11:40
• Modified: 6 Feb 2015 9:17
• Reporter: Daniël van Eeden (OCA)
• Status: Verified
• Category: MySQL Enterprise Monitor: Web
• Severity: S4 (Feature request)
• Version: 3.0, 3.0.19
• OS: Any
• CPU Architecture: Any
• Tags: numa

[16 Sep 2014 11:40] Daniël van Eeden

Description:
NUMA can be important for MySQL and MySQL Cluster. MEM should have graphs and advisors to check numa related settings and usage.

More info:
http://blog.jcole.us/2012/04/16/a-brief-update-on-numa-and-mysql/
Bug #72811
https://blogs.oracle.com/LinuxJedi/entry/mysql_cluster_and_numa
http://dev.mysql.com/doc/refman/5.6/en/mysql-cluster-ndbd-definition.html#ndbparam-ndbd-nu...
http://mikaelronstrom.blogspot.nl/2010/12/mysql-server-and-numa-architectures.html

How to repeat:
Run MEM against a MySQL instances on a machines with multiple NUMA zones.

Suggested fix:
- Add a advisor to check the correct NUMA settings for MySQL Cluster and/or MySQL.
- Add a per-numa-node memory use graph.

[6 Feb 2015 9:17] MySQL Verification Team

Hello Daniel,

Thank you for the feature request.

Thanks,
Umesh