From: Raj Shekhar (rajlistrajshekhar.net)
Date: Tue May 18 2010 - 18:04:29 CDT

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

In infinite wisdom Gallego Juan <Juan.Gallegoyellargentina.com> wrote:

> [1 <text/plain; us-ascii (quoted-printable)>]
> Hi,
>
> I want to ask you the next topic,
>
> 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.

Do you have monitoring for your db box? If not, you cannot generate
these reports. Check out cacti and cacti-mysql-templates
<http://code.google.com/p/mysql-cacti-templates/> once you have cacti
monitoring on your db box.

--
Raj Shekhar
-
If there's anything more important than my ego around, I want it
caught and shot now.

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]