MySQL错误：查询执行线程无法连接到MySQL [英] MySQL Error: Query Execute Thread cannot connect to MySQL

问题描述

Hello All，



执行查询时，我收到以下错误查询执行线程无法连接到MySQL，这不会一直发生。

我正在运行几个Web应用程序，它们引用了我的服务器中不同数据库的不同表，因此应用程序负责存储客户数据。



I我有以下MySQL配置，



1.Max_Connections = 200

2.Thread_Cache_Size = 8

3.Thread_Stack = 196608

4.Max_allowed_Packet = 1048576



我在My Web Applications中使用默认端口3306数据库连接。



当关闭任何一个繁忙的Web应用程序时，解决了这个问题。我认为这个问题与MySQL配置有关。



任何人都可以帮我摆脱这个问题！在此先感谢!!

解决方案

尝试检查用户的max_user_connections和其他帐户资源限制列。

参见http://dev.mysql.com/doc/refman/5.0/en/user-resources.html [ ^ ]有关详细信息。



为了安全起见，您还应该检查您的Web应用程序是否打开了多个连接并超出了max_connections。试试SHOW PROCESSLIST，看看会发生什么。



祝你好运。 ： - ）

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. :-)

这篇关于MySQL错误：查询执行线程无法连接到MySQL的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！