Date: 04/01/07 (MySQL Communtiy)    Keywords: mysql, sql

I swore there was an open source package to do this, but I wanted to monitor in 30 minute increments, the state of a server dedicated to MySQL. Generally its completely dedicated to MySQL, but it also has a number of IDX aggregator scripts that run throughout the day, some of which take up a considerable amount of resources to transform/normalize it. Instead of just giving MySQL everything (resource wise), I wanted to incrementally move up the caches and allocations until its using only what it needs to be at its best.


If there isn't an open source package, I was thinking a cronscript on the machine would work out, but wanted to see if I could save myself the time.

Source: http://community.livejournal.com/mysql/112479.html