Mysql Daily Performance Reporting

Question

I wish to create a daily report on how my mysql server perform on the day. But it seems like mysql only stores aggregate data since uptime.
One way is to generate a report and then do a mysql restart (or do a FLUSH STATUS).

Any other suggestions to do the same?

Answer 1

Check out MySQL Cacti Templates. They provide a large number of graphs that display your MySQL server performance over time. Here is a demo page.

Answer 2

Cacti is pretty awesome. It also helps you determine performance over time as you make changes to your code base.

Also, some of the values it reports on are pretty cryptic. Here's the answer to kilorows: http://bit.ly/5ZKRa

Answer 3

I agree that Cacti is awesome but I preferred using Munin since I found it easier to create new templates in Munin.