MySQL Forums
Forum List  »  General

Find the number of active connections per database in MySQL
Posted by: Neeraja cp
Date: July 18, 2011 03:49AM

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

Options: ReplyQuote


Subject
Written By
Posted
Find the number of active connections per database in MySQL
July 18, 2011 03:49AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.