Bug #13413 Unable to get any information or stats on additional key buffers
Submitted: 22 Sep 2005 21:51
Reporter: Matthew Lord Email Updates:
Status: Verified Impact on me:
Category:MySQL Server: General Severity:S4 (Feature request)
Version:4.1.x, 5.0.x OS:Any (all)
Assigned to: CPU Architecture:Any

[22 Sep 2005 21:51] Matthew Lord
When using multiple key buffers, to get around the 4GB limit or for
better performance, you cannot see anything about them in show variables
or show status.

How to repeat:
Create an additional key buffer and try to find out anything about it in show variables
or show status.

Suggested fix:
Since dynamically making more status variables available might be
difficult to implement, I would suggest that MySQL makes an overall set
of status tables in the information schema. Ideally you could track all
system status information in these tables, which would provide a clean
approach to retrieving their values. One of the biggest headaches with
MySQL right now is you need to know many statements to find different
variables (i.e. is it local, global, status, etc...). If this was in
the information schema then it would be a simple select statement.

To be more specific, for the key_buffers I would like to see an
information schema table that defines the key_buffers, all there
attributes, and all there status variables.