Planet Ergo

Continuing on my previous blog post on trending the number of Average Queries per Second on a MySQL server;

It didn't really cover the scenario in which the MySQL server was rebooted, and so the average queries per second would restart at 0 (but not really).

The longer a peak in number of queries per second have to spread out over, the less the average is influenced; It's a good thing your average MySQL server does not have a 99.999% uptime ;-)

So, here's how the graph continues after a reboot of the server (we had a power interruption):

And so it seems we're back to where we were again, after one week of running in production.