MySQL monitoring devices
Don't neglect to check the underlying system. I would certainly check
- IOPS on the log, information and also tmp tools (you do have those on 3 seperate LUNs do not you?)
- Exchanging (greater than a couple of web pages/ 2nd misbehaves for mysql, google "mysql swappiness" to figure out why)
- Memory data for the host OS. A basic general rule I adhere to is to allocate no greater than 80% to the mysql procedure to leave some area for the OS and also the barrier cache
You can make use of SNMP and also Cacti to check every one of these points
Mysql has a free one called Mysql Administrator which becomes part of the mysql GUI devices plan.
Mysql Administrator link documentation.
There is additionally the Mysql Enterprise Monitor which has much more monitoring attributes. You can check Mysql on various other web servers see faq question 7.