[Maria-developers] New (by Bothorsen): Provide key cache statistics (58)
----------------------------------------------------------------------- WORKLOG TASK -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- TASK...........: Provide key cache statistics CREATION DATE..: Thu, 22 Oct 2009, 12:28 SUPERVISOR.....: Bothorsen IMPLEMENTOR....: COPIES TO......: CATEGORY.......: Server-RawIdeaBin TASK ID........: 58 (http://askmonty.org/worklog/?tid=58) VERSION........: WorkLog-3.4 STATUS.........: Un-Assigned PRIORITY.......: 60 WORKED HOURS...: 0 ESTIMATE.......: 0 (hours remain) ORIG. ESTIMATE.: 0 PROGRESS NOTES: 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. The raw coding is probably 1-2 days, but on top if this we need testing, a test environment and building of biniaries for you. Henrik/Bo and Igor will come back to you with a more exact estimate. ESTIMATED WORK TIME ESTIMATED COMPLETION DATE ----------------------------------------------------------------------- WorkLog (v3.5.9)
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. Regards / Mit vielen Grüßen, Sergei -- __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Sergei Golubchik <serg@sun.com> / /|_/ / // /\ \/ /_/ / /__ 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
Hi!
"Sergei" == Sergei Golubchik <sergii@pisem.net> writes:
Sergei> Hi! Sergei> 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.
Sergei> Why not to add this to show status where the default keycache statistics Sergei> 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 ? For example, show keycache statistics would look like: Key_cache_name Key_blocks_not_flushed Key_blocks_unused Key_blocks_used Key_read_requests Key_reads Key_write_requests Key_writes cache1 0 13389 7 22 7 0 0 Regards, Monty
Hi, Michael! On Oct 24, Michael Widenius wrote:
"Sergei" == Sergei Golubchik <sergii@pisem.net> 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 <serg@sun.com> / /|_/ / // /\ \/ /_/ / /__ 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
participants (3)
-
Michael Widenius -
Sergei Golubchik -
worklog-noreply＠askmonty.org