Home » Performance » MySQL » MySQL Server Monitor With Nagios
MySQL Server Monitor With Nagios [message #3248] Fri, 04 July 2008 03:06 Go to next message
nanipando  is currently offline nanipando
Messages: 2
Registered: July 2008
Location: CA
Junior Member
Can any one tell how to monitor mysql using nagios and how configure plugins.


Re: MySQL Server Monitor With Nagios [message #3250 is a reply to message #3248 ] Sun, 06 July 2008 14:02 Go to previous messageGo to next message
mwallace  is currently offline mwallace
Messages: 14
Registered: April 2008
Location: CA
Junior Member
Have you installed nagios yet? Have you read the instructions?

What platform? What version? Which plugin(s)? Where are you having trouble?
Re: MySQL Server Monitor With Nagios [message #3255 is a reply to message #3250 ] Mon, 07 July 2008 11:00 Go to previous messageGo to next message
nanipando  is currently offline nanipando
Messages: 2
Registered: July 2008
Location: CA
Junior Member
I have Instaled nagios and configured with pluins.I strucked at
Check_mysql

My command.cfg contains

# 'check_mysql' command defination

define command{

command_name check_mysql

Command_line $USER1$/check_mysql -u $ARG1$ -p $ARG2$ -H$HOSTADDRESS$

}



In my service defination it



define service{

use local-service ; Name of service template to use

host_name localhost

is_volatile 0

check_period 24x7

max_check_attempts 4

normal_check_interval 5

retry_check_interval 1

notification_interval 960

notification_period 24x7

service_description MySQL Running

check_command mysql_check!root!toyota

}

When I start nagios I got error Service check command 'mysql_check' specified in service 'MySQL Running' for host 'localhost' not defined anywhere

Can any one tell me solution.


Re: MySQL Server Monitor With Nagios [message #3263 is a reply to message #3255 ] Tue, 08 July 2008 14:39 Go to previous messageGo to next message
erkules  is currently offline erkules
Messages: 58
Registered: December 2007
Member
lol
Your command_name is:
check_mysql

but in your service you demand:
mysql_check

see:-)

Use one name for both!

[Updated on: Tue, 08 July 2008 15:55]

Re: MySQL Server Monitor With Nagios [message #3264 is a reply to message #3263 ] Tue, 08 July 2008 22:02 Go to previous messageGo to next message
ramakrishna  is currently offline ramakrishna
Messages: 4
Registered: July 2008
Location: Fremont
Junior Member

Sorry Both were Mysql_check.Can you tell me what is exact problem
Re: MySQL Server Monitor With Nagios [message #3265 is a reply to message #3264 ] Wed, 09 July 2008 08:14 Go to previous message
erkules  is currently offline erkules
Messages: 58
Registered: December 2007
Member
no. Ive got no guessing-mode Crying or Very Sad

Previous Topic:Slow mysql query when using subquery
Next Topic:Mysql select query takes more time
Goto Forum:
  



Current Time: Fri Nov 21 02:21:22 EST 2008

Total time taken to generate the page: 0.04523 seconds
.:: Contact :: Home :: MySQL Support by Percona.com ::.

Powered by: FUDforum 2.7.5.
Copyright ©2001-2006 FUD Forum Bulletin Board Software

MySQL Performance | Forum authority Badge