I need a MySQL Monitoring Script in Bash or Perl for Linux.
I found some but they are quite big with a lots of checks that are not useful at all for me and in this case I should customise the script a lot.
Any idea for most important parameters of MySQL monitoring in a Shell or Perl script?
Following parameters should be monitored:
qcache_hits SHOW GLOBAL STATUS; SHOW SESSION STATUS; slow_queries max_connections key_buffer_size mysql availability STATUS Error log SHOW ENGINE INNODB STATUS; max_used_connections Handler_read%