reports

--_000_5EC48AAC2073C3419456812C5FDFEE0956C642F7A7exyellar01y el_
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: 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.

The main report that i want to make is the first one and i don't know how t=
o obtain it.

Thanks for your help.

Juan Gallego.


EL Ahorro de papel nos ayuda a proteger el medio ambiente.Imprime s?lo lo n=
ecesario.

Aviso de Confidencialidad:
Este mensaje se dirige exclusivamente a su destinatario y puede contener in=
formaci?n CONFIDENCIAL sometida a secreto profesional.Cualquier reproduccio=
n, distribucion o divulgaci?n de su contenido est?n estrictamente prohibido=
s en virtud de la legislaci?n vigente. Si ha recibido este mensaje por erro=
r, le rogamos que nos lo comunique inmediatamente por esta misma v?a o por =
tel?fono (+ 34 91 339 60 00) y proceda a su destruccion, sin obtener copia =
del mismo ni distribuirlo ni revelar su contenido.
N?tese que este correo electr?nico v?a Internet no permite asegurar ni la c=
onfidencialidad de los mensajes que se trasmiten ni la correcta recepci?n d=
e los mismos.En caso de que el destinatario de este mensaje no desee que se=
le remitan mensajes a trav?s del correo electr?nico v?a internet, rogamos =
lo pongo en nuestro conocimiento de manera inmediata

Privileged and confidential:
This message is intended exclusively for its addressee and may contain info=
rmation that is CONFIDENTIAL and protected bye a profesional privilege,Law =
strictly prhobits and dissmention, distribution or disclosure of its conten=
t,If this message has been received in error,please immediately notify us v=
ia e-mail or by telephone (+34 91 339 60 00) and delete it,whitout copyn it=
,distributing it,or disclosing its contents.Please note that this Internet =
e-mail dos not guarantee the confidentiality or proper receipt of the messa=
ges sent,If the addressee of this message does not desire to receive messag=
es by internet e-mail,please comunicate it to us immediatly.

--_000_5EC48AAC2073C3419456812C5FDFEE0956C642F7A7exyellar01y el_--

Re: reports

In infinite wisdom Gallego Juan wrote:

> [1 ]
> 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
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
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org