Database monitoring

[dpkkumar01]

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