MySQL Forums :: General :: Find the number of active connections per database in MySQL


Advanced Search

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 Neeraja cp 07/18/2011 03:49AM
Re: Find the number of active connections per database in MySQL Rick James 07/19/2011 09:35PM


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.