Database monitoring

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)