Hi, Michael! On Oct 24, Michael Widenius wrote: > >>>>> "Sergei" == Sergei Golubchik <[email protected]> writes: > > > Hi! > > On Oct 22, [email protected] 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 <[email protected]> / /|_/ / // /\ \/ /_/ / /__ 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 _______________________________________________ Mailing list: https://launchpad.net/~maria-developers Post to : [email protected] Unsubscribe : https://launchpad.net/~maria-developers More help : https://help.launchpad.net/ListHelp
