Hi
If you don't mind keeping the general log, you can periodically parse it. I
read that MySQL 5.1 (or some later version) will have an option to keep the
general log in a table - that will be very handy.
Be careful if you use this option (logging to a table) - while it's an
extremely att
Hi Shuly,
you can use the method suggested by Shuly or you cook up your
query logs if you need more accurate information. May be you can write a
small script to do the job.
Regards,
Chandru
forums.mafiree.com
On Mon, Dec 22, 2008 at 7:34 AM, mos wrote:
> At 02:32 PM 12/21/2008, y
If you don't mind keeping the general log, you can periodically parse it. I
read that MySQL 5.1 (or some later version) will have an option to keep the
general log in a table - that will be very handy.
On Sun, Dec 21, 2008 at 2:32 PM, Avraham, Shuly wrote:
>
> Hi,
>
> Is there any way to figure
At 02:32 PM 12/21/2008, you wrote:
Hi,
Is there any way to figure out how many, if any, people are accessing and
using our MySQL server?
I am aware of the SHOW PROCESSLIST command, but this one only shows how
many processes are currently running. I would like to register this
information,
Hi,
Is there any way to figure out how many, if any, people are accessing and using
our MySQL server?
I am aware of the SHOW PROCESSLIST command, but this one only shows how many
processes are currently running. I would like to register this information, and
be able to analyze it later.
Than