Reports

MySQL & MariaDB Other MySQL® Questions
1

Hi,

I have to deliver some reports and i want to know if exists some reporting open source tool to generate them.

The reports that i need are:

  • how many users, sessions,cursors by hour, day, week
    How mysql manage them? is this information stored in some place?
  • size of each database, data, logs, indexes. I kown how to obtain them
  • Memory used, CPU used.

The main report that i want to make is the first one. I don’t know how to do it?

thanks for your help.

2

I would recommend Cacti templates from [URL]Google Code Archive - Long-term storage for Google Code Project Hosting.

3

Thanks for your help.