Hi, Michael! On Oct 24, Michael Widenius wrote:

...

...

...

...

...

"Sergei" == Sergei Golubchik writes:

...

Hi! On Oct 22, worklog-noreply@askmonty.org wrote:

...

DESCRIPTION:

Provide the key cache statistics available for the default cache (key blocks used, unflushed, etc.) for all named caches.

Monty answers in an email:

This is a much simpler task and something that is important to get done. We would have to introduce a 'show keycache statistics' command that would iterate over all keycaches and provide the statistics.

...

Why not to add this to show status where the default keycache statistics is ? It won't be more difficult that adding a new command.

As one can have any number of key caches (each one has a name) and we have several variables for each of these, it will be a bit hard to have them as show variables (I think).

Serg, do you have a suggestion how the variables would look like ?

Sure. Just like all configuration variables for keycaches should be visible in SHOW VARIABLES using the cachename.varname pattern (but aren't), status variables can be seen using the same cachename.varname pattern (but aren't). Regards / Mit vielen Grüßen, Sergei -- __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Sergei Golubchik / /|_/ / // /\ \/ /_/ / /__ Principal Software Engineer/Server Architect /_/ /_/\_, /___/\___\_\___/ Sun Microsystems GmbH, HRB München 161028 <___/ Sonnenallee 1, 85551 Kirchheim-Heimstetten Geschäftsführer: Thomas Schroeder, Wolfgang Engels, Wolf Frenkel Vorsitzender des Aufsichtsrates: Martin Häring