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/mysql?unsub=arch...@jab.org
