Avoid being blocked in case of the error :TOO MANY CONNECTIONS

Last update on July 3, 2009 09:40 AM by jak58
Published by jak58

Avoid being blocked in case of the error :TOO MANY CONNECTIONS



MySQL normally allows, by default, 100 (150 since version 5.1) connections to the server ...
Meaning that the 101st user will receive the error message "too many connections" ...

If this happens to you, for whatever reason (too many web site, the code loop, ...), then:

Just know that 101th Mysql connection gives higher privilege level.. So, by logging (for example) as root, you should be able to access the server:
examine what happens (SHOW FULL PROCESSLIST)
remove connections (KILL)
in the worst case stop the server (SHUTDOWN)


NOTE: As stated above, the 101th connection is reserved for SUPER users ... meaning that if the user set in PHP, for example, has himself thits own

privilege level, all this will not work ... so better not set up a website with a extended user feature ...

If this happens, however, it only remains for you to destroy the main process (kill -9), it is best to make a check tables then ...
Best answers for « Avoid being blocked in case of the error :TOO MANY CONNECTIONS » in :
Error connection with iphone Show Error connection with iphone After installation of installation of updates on your iPhone in view to access new applications from the apple storem, Iphone refuse to login and and display error which unable to login. To troubleshoot...
Error connection- 0x80072ee6 Show Error connection- 0x80072ee6 Below is a tips of a how to solve this problems. First of all, delete the cookies and clear the history and internet cache of Internet explorer. Then click on Start > Run and type the...
Error Connection (80048820) Show Error Connection (80048820) Solutions Before any configuration on your system, it is recommended that you check the status of MSN Messenger servers to determine if the problem does not come from there:...
MSN Connection Problems ShowMSN Connection Problems Error Codes Error code 0x80072ee6 Error code 81000377 Error code 0x80072efd / 80072ee7 Error code 80048820 Error code 8007277b UNICOWS.DLL Error Code Other error codes Connection problems have become...
Error 810003C1 ShowError 810003C1 How to proceed Error connection with Windows Live Messenger After failing to connect to Windows Live Messenger, Below error message appears on your screen : "The connection to Windows Live Messenger failed - The...
IPhone 3G blocked ShowiPhone 3G blocked When you connect your iPhone, and the following message appears: "Itunes could not connect to the Iphone because it is locked by a password. You must enter the password on the iPhone before it can be used with Itunes "...
Download Code::Blocks Studio ShowCode:: Blocks is a multi-platform IDE (Linux, Mac and Windows) completely coded in C ++. Code:: Blocks is based on a system of plugins which allows to develop it very easily without recompiling it. Since it supports a great number of compilers, the...
PC Case ShowThe casing The case (or chassis) of a computer is the metallic box which houses the various internal components. Cases also have other uses, such as blocking noise produced by the computer, and protection from electromagnetic radiation. There are...