Have Geek Brain

Mysql daily reporting

I want to generate a daily report of how my mysql server is running on the same day. But it looks like mysql only stores aggregated data since the idle time.
One way is to create a report and then restart mysql (or create FLUSH STATUS).

Any other suggestions to do the same?

0


a source to share


3 answers


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 .



+1


a source


Cacti are pretty amazing. It also helps you measure performance over time as you make changes to your codebase.



Also, some of the meanings he reports are rather cryptic. Here's an answer explaining the number of kilocars .

0


a source


I agree that Cacti is awesome, but I preferred to use Munin as it was easier for me to create new templates in Munin.

0


a source






More articles:


All Articles