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 <[EMAIL PROTECTED]>
  Geschäftsführer / CEO iConnect GmbH <http://iConnect.de>
  Heesestr. 6, 12169 Berlin (Germany)
  Tel: +49 30 7970948-0  Fax: +49 30 7970948-3

---------------------------------------------------------------------
Before posting, please check:
  http://www.mysql.com/manual.php   (the manual)
  http://lists.mysql.com/           (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Reply via email to