MySQL Bugs: #58524: More detailed information on custom key caches

Bug #58524	More detailed information on custom key caches
Submitted:	26 Nov 2010 17:19	Modified:	30 Nov 2010 16:51
Reporter:	Haluk Akin	Email Updates:
Status:	Verified	Impact on me:	None
Category:	MySQL Server: MyISAM storage engine	Severity:	S4 (Feature request)
Version:	5.x	OS:	Any
Assigned to:		CPU Architecture:	Any
Tags:	key buffer

Description:
The following page shows details on how to create additional key caches and how to assign some tables' indexes to those new key caches:

http://dev.mysql.com/doc/refman/5.0/en/multiple-key-caches.html

There is no information on:
-How to list previously created custom key caches
-How to query those custom key caches' sizes
-How to see which tables are assigned to which custom key caches

I think mysql should provide the above informations.

Additionaly,
-it would also be great to see how much of those custom key caches are actually in use, similar to the way we can track how good the default key cache is being used.

Thanks,
Haluk

How to repeat:
This is a feature request.

Thank you for the feature request.

'mysqladmin debug' sends some information about each keycache to the server error log..

That's helpful information Shane. Thank you. I've shared this information on the mysql doc pages as well.

If "mysqladmin debug" were also to output which tables' indexes are assigned to which custom key caches, it would cover most of the need.

That said, I'm not enough of a mysql expert to say if in general "mysqladmin debug" can be considered as a proper way of getting information on the current state of mysql.