Hello All,
When Executing Queries,I get the following error "Query Execute Thread cannot connect to MySQL" and this is not happen all the time.
I am Running several Web Applications that refers different Tables of different databases in My Server and thus Applications are responsible to Store Customer Datas.
I am Having following MySQL Configuration,
1.Max_Connections =200
2.Thread_Cache_Size=8
3.Thread_Stack =196608
4.Max_allowed_Packet=1048576
I am Using Default Port 3306 in My Web Applications for Database Connection.
This Problem is Solved, when Closing any one of the Busy Web App.I think this problem is relevant to MySQL Configuration.
Can any one help me to get rid of this Problem!! Thanks in Advance !!
解决方案Try checking max_user_connections and the other account resource limits columns for your user.
See http://dev.mysql.com/doc/refman/5.0/en/user-resources.html[^] for details.
Just to be on the safe side, you should also check that your web applications don't keep many connections open and go beyond your max_connections. Try a SHOW PROCESSLIST and see what happens.
Good luck. :-)