200字范文,内容丰富有趣,生活中的好帮手!
200字范文 > mysql连接错误码1040 mySQL错误1040:太多连接

mysql连接错误码1040 mySQL错误1040:太多连接

时间:2023-05-04 08:44:19

相关推荐

mysql连接错误码1040 mySQL错误1040:太多连接

How to fix these, "SQL Error 1040: Too Many Connection"

even I try to put

max_user_connection=500

still "Too many connection"

解决方案

If you are running out of connections like this, chances are excellent that you are not closing the connections that you have open.

Review code that opens connections and ensure the connections are closed as soon as practical. Typically you want to make use of the using keyword around anything that implements IDisposable (including database connections) to ensure that such objects are disposed as soon as they leave the scope where they are needed.

You can check the current number of active connections with this query:

show processlist

本内容不代表本网观点和政治立场,如有侵犯你的权益请联系我们处理。
网友评论
网友评论仅供其表达个人看法,并不表明网站立场。