Can anyone know the way to get the number of DB connection being used , in MYSQL 5.0
+1
A:
12.5.5.31. SHOW PROCESSLIST Syntax
Shows you how many people are connected to the server.
Phil Carter
2009-05-05 11:23:48
Actually, i need to know how many DB connections have been opened so far
2009-05-05 11:32:35
In That case you can use: SHOW STATUS WHERE variable_name = 'Threads_created';And to see the maximum connections opened at any one time use SHOW STATUS WHERE variable_name = 'Max_used_connections';
Phil Carter
2009-05-05 12:37:27