bearback Posted January 12, 2012 Share Posted January 12, 2012 had a drive fail on my server and had to reinstall everything again, all went well but having a problem with Error: 1040 - Too many connections error, when either optimising tables or when sphinx is enabled and runs its updates. did not have this problem before and everything the same as before, same php, mysq and server settings. any ideas what could be causing the problem, may be i have over looked something some where. my.cnf has the same settings and worked well before. centos 5.7 runing IPB 3.1.4 mysql 5077 php 5.2.17 xcache usually have 300 - 500 member online thank you Link to comment Share on other sites More sharing options...
Royzee Posted January 12, 2012 Share Posted January 12, 2012 Sounds like you need to raise max_connections in etc/my.cnf or maybe in /etc/mysql/my.cnf. Depends on centos version. Link to comment Share on other sites More sharing options...
Gary. Posted January 15, 2012 Share Posted January 15, 2012 Not only raise max_connections but set the limit so you have room for other software what uses mysql to function.So if you have max_connections=500, Add the line below it.max_user_connections=450 Link to comment Share on other sites More sharing options...
bearback Posted January 15, 2012 Author Share Posted January 15, 2012 thank you for your comments Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.