We have an issue were mysqld hogs up 100% of one of our cpu cores from time to time. How can I configure monit to restart mysqld when this happens.
For an example of what I am talking about, top normally shows only one cpu but if you press '1' it will show all the cpus.
(normal top) top - 18:13:11 up 10 days, 21:59, 1 user, load average: 1.56, 1.81, 2.08 Tasks: 186 total, 5 running, 181 sleeping, 0 stopped, 0 zombie Cpu(s): 31.6% us, 7.6% sy, 0.0% ni, 60.8% id, 0.0% wa, 0.0% hi, 0.0% si