MySQL Database

ID #205

MySQL says I have too many connections.

Applies to: Grid System

If you have too many processes lingering around on the database server, then you may reach a limit and no new ones will be allowed to be started.

To see if this is the case, take a look at your processes from the MySQL Monitor prompt by typing:

show processlist;

Then you will see the lingering processes. Each has an ID, and you can kill them by process ID right in the MySQL Monitor by typing:

kill 2309344;

for example, where 2309344 might be a process ID.

Last update: 2010-10-03 16:36
Author: FAQ Admin
Revision: 1.2

Digg it! Share on Facebook Print this record Send FAQ to a friend Show this as PDF file
Please rate this FAQ:

Average rating: 3.43 (7 Votes)

completely useless 1 2 3 4 5 most valuable

You can comment this FAQ