Re: How many users access MySQL

2008-12-22 Thread Andy Shellam
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

Re: How many users access MySQL

2008-12-21 Thread Chandru
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

Re: How many users access MySQL

2008-12-21 Thread Jim Lyons
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

Re: How many users access MySQL

2008-12-21 Thread mos
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,

How many users access MySQL

2008-12-21 Thread Avraham, Shuly
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