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 <avra...@cshl.edu> 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, > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/mysql?unsub=jlyons4...@gmail.com > > -- Jim Lyons Web developer / Database administrator http://www.weblyons.com
