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 <[email protected]> wrote:
> 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, and be able to analyze it later.
>>
>> Thanks,
>> Shuly,
>>
>
> Shuly,
> Try show status where variable_name like "%connections%". This will
> tell you the number of connections, not the number of users. I don't think
> you can find the number of connected users unless you build it into your
> application.
>
> Mike
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
> http://lists.mysql.com/[email protected]
>
>
