> -----Original Message----- > From: [EMAIL PROTECTED] [mailto:nagios-users- > [EMAIL PROTECTED] On Behalf Of Eric Hernandez > Sent: Thursday, July 05, 2007 11:15 AM > To: nagios-users@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@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