Portal Home > Knowledgebase > Articles Database > Frequent too many MySQL connections error
Frequent too many MySQL connections error
Posted by Kailash12, 07-02-2010, 01:22 AM |
Hi,
I have a shared server running on Windows 2003 (32-bit) and MySQL 4.1 server. I frequently receive too many MySQL connections error. This is a shared server and there are around 300 websites and 50 MySQL databases are hosted. Can you suggest a tool to monitor the MySQL usage and connections?
Thanks,
Kailash
|
Posted by amnetworx, 07-02-2010, 01:31 AM |
Kailash,
You can use the following command from the command prompt to monitor the mysql usage.
'mysqladmin -i3 processlist -umysqluser -ppassword'
|
Posted by VIPoint, 07-02-2010, 02:04 AM |
Increase your Mysql connection limit. What is your current mysql conenction limit?
|
Posted by shawn_linux, 07-02-2010, 01:05 PM |
increae number of mysq connection limit in /etc/my.cnf
|
Posted by Kailash12, 07-02-2010, 02:53 PM |
Current limit is 800. It seems there is some bad written scripts on the server. Do you suggest installing any mysql monitoring tool?
Thanks,
Kailash
|
Posted by bvsonline, 07-03-2010, 07:13 AM |
Will give the process list. There are also many tools available in the market which has GUI interface too to monitor the mysql process like http://www.webyog.com/en/
|
Posted by inspiron, 07-04-2010, 01:37 PM |
You can check the mysql processes using the command mysqladmin -proc
|
Posted by centauricw, 07-04-2010, 08:20 PM |
You can increase the system-wide connection limit in the my.ini file, but you should first try to find the offending website. It sounds very like bad code that is opening a new connect for each query. If you can't get them to clean up their code, you impose connection limits just for them to protect the other users.
|
Posted by Kailash12, 07-05-2010, 01:24 AM |
Thanks everyone!
I will try your suggestions to find the offending web sites that are creating the problem.
Kailash
|
Add to Favourites Print this Article
Also Read