[Check_mk (english)] how to monitor mysql performance using check_mk

Archive checkmk-en
1

Hello,

anybody there use check_mk to monitor mysql database server performance?

regards,
Norman

2

Hello,

i'm using check_mysql_health with check_mk's mrpe.cfg.

Daniel

···

Am 24.05.2010 08:41, schrieb Norman Vicente:

Hello,

anybody there use check_mk to monitor mysql database server performance?

regards,
Norman
_______________________________________________
checkmk-en mailing list
checkmk-en@lists.mathias-kettner.de
http://lists.mathias-kettner.de/mailman/listinfo/checkmk-en

3

Thats the way I'm doing as well and it works fine

[mailto:checkmk-en-bounces@lists.mathias-kettner.de] On Behalf Of Daniel
Nauck

···

-----Original Message-----
From: checkmk-en-bounces@lists.mathias-kettner.de
Sent: 24 May 2010 12:55
To: checkmk-en@lists.mathias-kettner.de
Subject: Re: [Check_mk (english)] how to monitor mysql performance using
check_mk

Hello,

i'm using check_mysql_health with check_mk's mrpe.cfg.

Daniel

Am 24.05.2010 08:41, schrieb Norman Vicente:

Hello,

anybody there use check_mk to monitor mysql database server performance?

regards,
Norman
_______________________________________________
checkmk-en mailing list
checkmk-en@lists.mathias-kettner.de
http://lists.mathias-kettner.de/mailman/listinfo/checkmk-en
  

_______________________________________________
checkmk-en mailing list
checkmk-en@lists.mathias-kettner.de
http://lists.mathias-kettner.de/mailman/listinfo/checkmk-en

4

Hello,

i'm using check_mysql_health with check_mk's mrpe.cfg.

+1

Joerg

···

Am 24.05.10 13:55, schrieb Daniel Nauck:

Am 24.05.2010 08:41, schrieb Norman Vicente:

Hello,

anybody there use check_mk to monitor mysql database server performance?

regards,
Norman
_______________________________________________
checkmk-en mailing list
checkmk-en@lists.mathias-kettner.de
http://lists.mathias-kettner.de/mailman/listinfo/checkmk-en
  

_______________________________________________
checkmk-en mailing list
checkmk-en@lists.mathias-kettner.de
http://lists.mathias-kettner.de/mailman/listinfo/checkmk-en

5

Hello,

sorry for asking lame question.. 0:) how can I use this check_mysql_health?

is this some like this?

MySQLD /usr/lib/nagios/plugins/check_mysqld.pl -p -f -u mysql -a
uptime,threads_connected,questions,slow_queries,open_tables -A
threads_running,innodb_row_lock_time_avg -w "," -c ",>25" -H
localhost -v

···

On Mon, May 24, 2010 at 8:48 PM, Joerg Linge <pitchfork@pnp4nagios.org> wrote:

Am 24.05.10 13:55, schrieb Daniel Nauck:

Hello,

i'm using check_mysql_health with check_mk's mrpe.cfg.

+1

Joerg

Am 24.05.2010 08:41, schrieb Norman Vicente:

Hello,

anybody there use check_mk to monitor mysql database server performance?

regards,
Norman
_______________________________________________
checkmk-en mailing list
checkmk-en@lists.mathias-kettner.de
http://lists.mathias-kettner.de/mailman/listinfo/checkmk-en

_______________________________________________
checkmk-en mailing list
checkmk-en@lists.mathias-kettner.de
http://lists.mathias-kettner.de/mailman/listinfo/checkmk-en

_______________________________________________
checkmk-en mailing list
checkmk-en@lists.mathias-kettner.de
http://lists.mathias-kettner.de/mailman/listinfo/checkmk-en

6

Hello,

for example:

MySQL
/usr/local/nagiosUser/libexec/check_mysql_health --username nagiosUser
--password xxxxx --mode connection-time
MySQL-Uptime
/usr/local/nagiosUser/libexec/check_mysql_health --username nagiosUser
--password xxxxx --mode uptime
MySQL-Connections
/usr/local/nagiosUser/libexec/check_mysql_health --username nagiosUser
--password xxxxx --mode threads-connected
MySQL-Thread-Cache-Hitrate
/usr/local/nagiosUser/libexec/check_mysql_health --username nagiosUser
--password xxxxx --mode threadcache-hitrate
MySQL-Query-Cache-Hitrate
/usr/local/nagiosUser/libexec/check_mysql_health --username nagiosUser
--password xxxxx --mode querycache-hitrate --lookback 1800 --warning 50:
--critical 20:
MySQL-MyISAM-Cache-Hitrate
/usr/local/nagiosUser/libexec/check_mysql_health --username nagiosUser
--password xxxxx --mode myisam-keycache-hitrate --warning 50: --critical 20:
MySQL-INNODB-Bufferpool-Hitrate
/usr/local/nagiosUser/libexec/check_mysql_health --username nagiosUser
--password xxxxx --mode innodb-bufferpool-hitrate --warning 50:
--critical 20:
MySQL-INNODB-Bufferpool-Wait-Free
/usr/local/nagiosUser/libexec/check_mysql_health --username nagiosUser
--password xxxxx --mode innodb-bufferpool-wait-free
MySQL-INNODB-Log-Waits
/usr/local/nagiosUser/libexec/check_mysql_health --username nagiosUser
--password xxxxx --mode innodb-log-waits
MySQL-Table-Cache-Hitrate
/usr/local/nagiosUser/libexec/check_mysql_health --username nagiosUser
--password xxxxx --mode tablecache-hitrate --warning 20: --critical 10:
MySQL-Table-Lock-Contention
/usr/local/nagiosUser/libexec/check_mysql_health --username nagiosUser
--password xxxxx --mode table-lock-contention
MySQL-Index-Usage
/usr/local/nagiosUser/libexec/check_mysql_health --username nagiosUser
--password xxxxx --mode index-usage --warning 30: --critical 10:
MySQL-Tmp-Disk-Tables
/usr/local/nagiosUser/libexec/check_mysql_health --username nagiosUser
--password xxxxx --mode tmp-disk-tables
MySQL-Slow-Queries
/usr/local/nagiosUser/libexec/check_mysql_health --username nagiosUser
--password xxxxx --mode slow-queries
MySQL-Long-Running-Procs
/usr/local/nagiosUser/libexec/check_mysql_health --username nagiosUser
--password xxxxx --mode long-running-procs

Daniel

···

Am 26.05.2010 13:54, schrieb Norman Vicente:

Hello,

sorry for asking lame question.. 0:) how can I use this check_mysql_health?

is this some like this?

MySQLD /usr/lib/nagios/plugins/check_mysqld.pl -p -f -u mysql -a
uptime,threads_connected,questions,slow_queries,open_tables -A
threads_running,innodb_row_lock_time_avg -w "," -c ",>25" -H
localhost -v

On Mon, May 24, 2010 at 8:48 PM, Joerg Linge <pitchfork@pnp4nagios.org> wrote:
  

Am 24.05.10 13:55, schrieb Daniel Nauck:
    

Hello,

i'm using check_mysql_health with check_mk's mrpe.cfg.
      

+1

Joerg

Am 24.05.2010 08:41, schrieb Norman Vicente:
      

Hello,

anybody there use check_mk to monitor mysql database server performance?

regards,
Norman
_______________________________________________
checkmk-en mailing list
checkmk-en@lists.mathias-kettner.de
http://lists.mathias-kettner.de/mailman/listinfo/checkmk-en

_______________________________________________
checkmk-en mailing list
checkmk-en@lists.mathias-kettner.de
http://lists.mathias-kettner.de/mailman/listinfo/checkmk-en

_______________________________________________
checkmk-en mailing list
checkmk-en@lists.mathias-kettner.de
http://lists.mathias-kettner.de/mailman/listinfo/checkmk-en

_______________________________________________
checkmk-en mailing list
checkmk-en@lists.mathias-kettner.de
http://lists.mathias-kettner.de/mailman/listinfo/checkmk-en

7

ok thanks...

its now working

···

On Wed, May 26, 2010 at 8:01 PM, Daniel Nauck <daniel.nauck@gmail.com> wrote:

Hello,

for example:

MySQL
/usr/local/nagiosUser/libexec/check_mysql_health --username nagiosUser
--password xxxxx --mode connection-time
MySQL-Uptime
/usr/local/nagiosUser/libexec/check_mysql_health --username nagiosUser
--password xxxxx --mode uptime
MySQL-Connections
/usr/local/nagiosUser/libexec/check_mysql_health --username nagiosUser
--password xxxxx --mode threads-connected
MySQL-Thread-Cache-Hitrate
/usr/local/nagiosUser/libexec/check_mysql_health --username nagiosUser
--password xxxxx --mode threadcache-hitrate
MySQL-Query-Cache-Hitrate
/usr/local/nagiosUser/libexec/check_mysql_health --username nagiosUser
--password xxxxx --mode querycache-hitrate --lookback 1800 --warning 50:
--critical 20:
MySQL-MyISAM-Cache-Hitrate
/usr/local/nagiosUser/libexec/check_mysql_health --username nagiosUser
--password xxxxx --mode myisam-keycache-hitrate --warning 50: --critical 20:
MySQL-INNODB-Bufferpool-Hitrate
/usr/local/nagiosUser/libexec/check_mysql_health --username nagiosUser
--password xxxxx --mode innodb-bufferpool-hitrate --warning 50:
--critical 20:
MySQL-INNODB-Bufferpool-Wait-Free
/usr/local/nagiosUser/libexec/check_mysql_health --username nagiosUser
--password xxxxx --mode innodb-bufferpool-wait-free
MySQL-INNODB-Log-Waits
/usr/local/nagiosUser/libexec/check_mysql_health --username nagiosUser
--password xxxxx --mode innodb-log-waits
MySQL-Table-Cache-Hitrate
/usr/local/nagiosUser/libexec/check_mysql_health --username nagiosUser
--password xxxxx --mode tablecache-hitrate --warning 20: --critical 10:
MySQL-Table-Lock-Contention
/usr/local/nagiosUser/libexec/check_mysql_health --username nagiosUser
--password xxxxx --mode table-lock-contention
MySQL-Index-Usage
/usr/local/nagiosUser/libexec/check_mysql_health --username nagiosUser
--password xxxxx --mode index-usage --warning 30: --critical 10:
MySQL-Tmp-Disk-Tables
/usr/local/nagiosUser/libexec/check_mysql_health --username nagiosUser
--password xxxxx --mode tmp-disk-tables
MySQL-Slow-Queries
/usr/local/nagiosUser/libexec/check_mysql_health --username nagiosUser
--password xxxxx --mode slow-queries
MySQL-Long-Running-Procs
/usr/local/nagiosUser/libexec/check_mysql_health --username nagiosUser
--password xxxxx --mode long-running-procs

Daniel

Am 26.05.2010 13:54, schrieb Norman Vicente:

Hello,

sorry for asking lame question.. 0:) how can I use this check_mysql_health?

is this some like this?

MySQLD /usr/lib/nagios/plugins/check_mysqld.pl -p -f -u mysql -a
uptime,threads_connected,questions,slow_queries,open_tables -A
threads_running,innodb_row_lock_time_avg -w "," -c ",>25" -H
localhost -v

On Mon, May 24, 2010 at 8:48 PM, Joerg Linge <pitchfork@pnp4nagios.org> wrote:

Am 24.05.10 13:55, schrieb Daniel Nauck:

Hello,

i'm using check_mysql_health with check_mk's mrpe.cfg.

+1

Joerg

Am 24.05.2010 08:41, schrieb Norman Vicente:

Hello,

anybody there use check_mk to monitor mysql database server performance?

regards,
Norman
_______________________________________________
checkmk-en mailing list
checkmk-en@lists.mathias-kettner.de
http://lists.mathias-kettner.de/mailman/listinfo/checkmk-en

_______________________________________________
checkmk-en mailing list
checkmk-en@lists.mathias-kettner.de
http://lists.mathias-kettner.de/mailman/listinfo/checkmk-en

_______________________________________________
checkmk-en mailing list
checkmk-en@lists.mathias-kettner.de
http://lists.mathias-kettner.de/mailman/listinfo/checkmk-en

_______________________________________________
checkmk-en mailing list
checkmk-en@lists.mathias-kettner.de
http://lists.mathias-kettner.de/mailman/listinfo/checkmk-en

_______________________________________________
checkmk-en mailing list
checkmk-en@lists.mathias-kettner.de
http://lists.mathias-kettner.de/mailman/listinfo/checkmk-en