Hello all,
I have a drupal application that uses the database named db1. Each time a drupal request is sent, a new connection to database will be established.So after a certain number of conneections has reached the site turns offline showing the following error:

User db1 already has more than 'max_user_connections' active connections.

So my aim is to close the database connection and thereafter avoiding the offline error. For this I need to find the number of active connections made to my database.I have tried with the SHOW PROCESSLIST command. But it is not showing the number of connections.

Is there any method to find the number of database connections made to a mysql database?

Thanks

dunno if a an application can make that request. the information is available as various tools including workbench display that.

usually if you are hitting that sort of problem the best solutions are
close what ever connections as possible once the app has terminated using the connections
or if the app supports connection pooling use that
or go back over you system metrics and workout what sort of load you are putting ont he server and decide if you need to increase the number of connections available to the server. this may have an impact on the underlying hardware (you may need more memory a better processor more bandwidth, less clutter on the server and or network).

checking the design of the application software is usually a better way to go first, just increasing the number of connections available may be the final solution but you should check the application first

Thanks for your reply.....
I am trying to close the opened connections. That is the reason why I need to know the number of users connected to my database. By knowing this value I could confirm whether the connections are actually closed or not if I try to close it explicitly.

MySQL Workbench can show you open connections.