- edited description
Database monitoring
Issue #744
closed
I want to monitor my mysql database performance with this tool. I have to capture the below mysql data.
mysql_connections
mysql_locks
mysql_task
mysql_slow_query.............etc.
I have configured the mysql process monitoring with the below configurations. but i am not sure how to get those parameters using this tool. Please help me on this.
Also we are using the other databases like redis,mongo,elasticsearch. we have to capture those database data as well.
Configuration:
check process mysql with pidfile /usr/local/mysql-5.7.19-linux-glibc2.12-x86_64/data/host.net.pid
group database
start program = "/usr/local/mysql/bin/mysqld_safe"
stop program = "/usr/local/mysql/bin/mysqladmin shutdown"
if failed host my_ip port 3306 protocol mysql username "root" password "test" then restart
depends on mysql_bin
depends on mysql_rc
check file mysql_bin with path /usr/local/mysql/bin/mysqld
group database
if failed checksum then unmonitor
if failed permission 755 then unmonitor
if failed uid root then unmonitor
if failed gid root then unmonitor
check file mysql_rc with path /etc/init.d/mysql
group database
if failed checksum then unmonitor
if failed permission 755 then unmonitor
if failed uid root then unmonitor
if failed gid root then unmonitor
Thanks in advance
Comments (3)
-
repo owner -
repo owner Monit currently doesn't have native test for extended mysql parameters, you can however monitor it using custom script and integrate it with monit via the "check program" statement, see monit manual for more details: https://mmonit.com/monit/documentation/monit.html#PROGRAM-STATUS-TEST
-
repo owner - changed status to closed
- Log in to comment