Web Hosting Talk : Web Hosting Main Forums : Hosting Security and Technology : Frequent too many MySQL connections error

[Kailash12]

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

[amnetworx]

Kailash,

You can use the following command from the command prompt to monitor the mysql usage.

'mysqladmin -i3 processlist -umysqluser -ppassword'

[VIPoint]

Increase your Mysql connection limit. What is your current mysql conenction limit?

[shawn_linux]

increae number of mysq connection limit in /etc/my.cnf

[Kailash12]

Originally Posted by VIPoint

Increase your Mysql connection limit. What is your current mysql conenction limit?

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

[bvsonline]

mysql> mysqladmin -u <user> -p<password> version status proc

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/

[inspiron]

You can check the mysql processes using the command mysqladmin -proc

[centauricw]

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.

[Kailash12]

Thanks everyone!

I will try your suggestions to find the offending web sites that are creating the problem.

Kailash