List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:January 14 2003 7:53pm
Subject:Re: SHOW STATUS LIKE 'Com_%'
View as plain text  
At 19:11 +0100 1/14/03, Stefan Hinz wrote:
>Dear all,
>
>can anyone point me to a reference regarding the Com_ status information
>you get with SHOW STATUS LIKE 'Com_%'? I searched the MySQL website and
>Google groups, but nothing.

They're counters for the number of times various types of statements have
been executed.


Statement Counter Status Variables

As  of  MySQL  3.23.47, the server maintains a set of status
variables that serve as counters to indicate the  number  of
times  particular  types  of statements (commands) have been
executed.  There are dozens of such variables, and they  all
have  similar  names,  so  they  are not listed individually
here.  Each statement  counter  variable  name  begins  with
Com_,  and has a suffix that indicates the type of statement
to which the counter corresponds.  For  example,  Com_select
and  Com_drop_table  indicate how many SELECT and DROP TABLE
statements the server has executed.

>TIA,
>--
>   Stefan Hinz <hinz@stripped>
>   Geschäftsführer / CEO iConnect GmbH <http://iConnect.de>
>   Heesestr. 6, 12169 Berlin (Germany)
>   Tel: +49 30 7970948-0  Fax: +49 30 7970948-3

Thread
SHOW STATUS LIKE 'Com_%'Stefan Hinz14 Jan
  • RE: SHOW STATUS LIKE 'Com_%'Jennifer Goodie14 Jan
    • Re: SHOW STATUS LIKE 'Com_%'Stefan Hinz14 Jan
      • Re: SHOW STATUS LIKE 'Com_%'Jeremy Zawodny15 Jan
    • Re: SHOW STATUS LIKE 'Com_%'Stefan Hinz15 Jan
  • Re: SHOW STATUS LIKE 'Com_%'Paul DuBois14 Jan
  • Re: SHOW STATUS LIKE 'Com_%'Dan Nelson14 Jan