RE: SHOW STATUS LIKE 'Com_%'
can anyone point me to a reference regarding the Com_ status information What exaclty do you mean? http://www.mysql.com/doc/en/SHOW_STATUS.html states that the com_ is just how many times the command has been issued. So if com_select = 34021 there have been 34021 selects issued to the server. Do you need something more in depth or are you just trying to figure out what they mean in general? - 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
Re: SHOW STATUS LIKE 'Com_%'
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
Re: SHOW STATUS LIKE 'Com_%'
In the last episode (Jan 14), Stefan Hinz said: 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. http://www.mysql.com/doc/en/SHOW_STATUS.html `Com_xxx' Number of times each xxx command has been executed. Not all that useful, but a quick way to see what your update/select ratio is. -- Dan Nelson [EMAIL PROTECTED] - 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
Re: SHOW STATUS LIKE 'Com_%'
Jennifer, Paul, can anyone point me to a reference regarding the Com_ status information http://www.mysql.com/doc/en/SHOW_STATUS.html states that the com_ is just how many times the command has been issued. Sorry. I didn't see the com_... line on this page, must consult the eye doctor ... Regards, -- 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 - Original Message - From: Jennifer Goodie [EMAIL PROTECTED] To: Stefan Hinz [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Tuesday, January 14, 2003 8:42 PM Subject: RE: SHOW STATUS LIKE 'Com_%' can anyone point me to a reference regarding the Com_ status information What exaclty do you mean? http://www.mysql.com/doc/en/SHOW_STATUS.html states that the com_ is just how many times the command has been issued. So if com_select = 34021 there have been 34021 selects issued to the server. Do you need something more in depth or are you just trying to figure out what they mean in general? - 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
Re: SHOW STATUS LIKE 'Com_%'
On Tue, Jan 14, 2003 at 10:35:32PM +0100, Stefan Hinz wrote: Jennifer, Paul, can anyone point me to a reference regarding the Com_ status information http://www.mysql.com/doc/en/SHOW_STATUS.html states that the com_ is just how many times the command has been issued. Sorry. I didn't see the com_... line on this page, must consult the eye doctor ... Cool! Your eye doctor uses MySQL? I've been trying to convert mine, but he really likes his old dBase III setup. Anyway, it's on the page. Really. Search for Com_xxx and you'll see it in the table. Jeremy -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! [EMAIL PROTECTED] | http://jeremy.zawodny.com/ MySQL 3.23.51: up 30 days, processed 1,011,408,831 queries (380/sec. avg) - 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