If you can’t do it with a shell script it usually ain’t worth doin’, right? Of course the number and quality of monitoring tools available to sys admins has gone up dramatically. Thanks to Nagios and other great tools it’s pretty easy to keep track of what’s going on and where and get notified pretty [...]
Homegrown MySQL monitoring
October 23rd, 2008 · No Comments
Tags: MySQL · Nagios · monitoring · sysadmin
When MySQL starts counting sheep
September 4th, 2008 · No Comments
We encountered a situation recently where the number of connections to our MySQL database started creeping up slowly but steadily. Strangely enough all the connections were in sleep mode and the database was not being stressed. The number of connections first reached 30 where it normally stays below 20 and started triggering our monitoring scripts. [...]
Tags: MySQL · Performance · monitoring
