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%
Best Answer
Here are the things I look at when reviewing a server: