maria-developers team mailing list archive

[Sergei Golubchik <sergii@xxxxxxxxx>]

Hi, Michael!

On Oct 24, Michael Widenius wrote:
> >>>>> "Sergei" == Sergei Golubchik <sergii@xxxxxxxxx> writes:
> 
> > Hi!
> > On Oct 22, worklog-noreply@xxxxxxxxxxxx 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 <serg@xxxxxxx>
 / /|_/ / // /\ \/ /_/ / /__  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