check_mysql - Queries per second avg: Time Frame

Marc Powell marc at ena.com
Thu Jul 5 20:07:49 CEST 2007



> -----Original Message-----
> From: nagios-users-bounces at lists.sourceforge.net [mailto:nagios-users-
> bounces at lists.sourceforge.net] On Behalf Of Eric Hernandez
> Sent: Thursday, July 05, 2007 11:15 AM
> To: nagios-users at lists.sourceforge.net
> Subject: [Nagios-users] check_mysql - Queries per second avg: Time
Frame
> 
> Hell Nagios Group,
> 
> What is the time range that check_mysql basis the Queries per second
avg.
> Is for the last hour, day or lifetime of the server?  or something
else?
> 
> Uptime: 77595  Threads: 20  Questions: 92715251  Slow queries: 1283
> Opens: 554642  Flush tables: 1  Open tables: 64  Queries per second
avg:
> 1194.861

It's coming directly from mysql via the 'status' command --

mysql> status;
--------------
mysql  Ver ...

Connection id:          581953
Current database:
Current user:           <redacted>@localhost
SSL:                    Not in use
Current pager:          stdout
Using outfile:          ''
Using delimiter:        ;
Server version:         <redacted>
Protocol version:       10
Connection:             Localhost via UNIX socket
Server characterset:    latin1
Db     characterset:    latin1
Client characterset:    latin1
Conn.  characterset:    latin1
UNIX socket:            /var/lib/mysql/mysql.sock
Uptime:                 197 days 12 hours 27 min 38 sec

Threads: 3  Questions: 3425958608  Slow queries: 0  Opens: 0  Flush
tables: 1  Open tables: 17  Queries per second avg: 452.425

While I can't quickly find a definitive reference to point to, it's my
understanding that it is the average q/s since the server was last
reset, in my case 197+ days.

--
Marc

-------------------------------------------------------------------------
This SF.net email is sponsored by DB2 Express
Download DB2 Express C - the FREE version of DB2 express and take
control of your XML. No limits. Just data. Click to get it now.
http://sourceforge.net/powerbar/db2/
_______________________________________________
Nagios-users mailing list
Nagios-users at lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/nagios-users
::: Please include Nagios version, plugin version (-v) and OS when reporting any issue. 
::: Messages without supporting info will risk being sent to /dev/null





More information about the Users mailing list