Recently published on dev.mysql.com, the whitepaper I co-wrote with Teodor Danciu is available now at Creating a DBA Dashboard for MySQL.

It’s even available on the dev.mysql.com homepage if you act now.

The basic idea of the DBA dashboard is to monitor all of the mysql servers in your enterprise, and then show reports of time-based data, such as uptime, table growth, bytes sent/received per minute/hour/day, etc. You can think of it as the views that MySQL Administrator gives you, only over time. So MySQL Administrator is a peephole into the health of your server, and the DBA Dashboard can open the door to that data.

The data collection daemon portion of the DBA Dashboard was written in Java, and consumes very little CPU and memory (usually about 20MB for the VM). In testing, I was monitoring 100 servers every second, and the CPU utilization on my desktop was under 1%. Who says Java is slow?

If you are using MySQL heavily, and are the lucky one to admin the server(s), I strongly recommend you check it out, for your future sanity.

Popularity: 15%