Re: How many users access MySQL
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 attractive feature, I've read that performance while it's switched on is less than desirable. The 5.1 manual also supports this: Currently, logging to tables incurs significantly more server overhead than logging to files. If you enable the general log or slow query log and require highest performance, you should log to files and not to tables. Hopefully this performance difference will be resolved in future releases of 5.1. Andy -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
How many users access MySQL
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=arch...@jab.org
Re: How many users access MySQL
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
Re: How many users access MySQL
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
Re: How many users access MySQL
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 mo...@fastmail.fm 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/mysql?unsub=chandru@gmail.com