首页 / MYSQL / 【转载】How long is “too long” for MySQL Connections to sleep?

【转载】How long is “too long” for MySQL Connections to sleep?

内容导读

互联网集市收集整理的这篇技术教程文章主要介绍了【转载】How long is “too long” for MySQL Connections to sleep?，小编现在分享给大家，供广大互联网技能从业者学习和参考。文章包含2076字，纯文字阅读大概需要3分钟。

内容图文

11

I logged onto my server to check the status of the database and noticed on the SHOW PROCESSLIST;that there are a large number of connections sleeping that are very old.

【转载】How long is “too long” for MySQL Connections to sleep? - 文章图片What duration should the connection time limit be before the connection should be killed?

How do I set the time limit in MySQL 5.0.51a-3ubuntu5.4?

Note:

I am using PHP 5.2.x and symfony framework 1.2.

mysql mysql-5
shareimprove this question edited Aug 23 ‘11 at 3:33 【转载】How long is “too long” for MySQL Connections to sleep? - 文章图片 RolandoMySQLDBA 103k14132264 asked Mar 3 ‘11 at 20:37 【转载】How long is “too long” for MySQL Connections to sleep? - 文章图片 Patrick 1,46461625
  add a comment

1 Answer

activeoldestvotes
up vote32down voteaccepted

mysqld will timeout DB Connections based on two(2) server options:

  • interactive_timeout
  • wait_timetout

Both are 28800 seconds (8 hours) by default.

You can set these options in /etc/my.cnf

If your connections are persistent (opened via mysql_pconnect) you could lower these numbers to something reasonable like 600 (10 min) or even 60 (1 min). Or, if your app works just fine, you can leave the default. This is up to you.

You must set these as follows in my.cnf (takes effect after mysql restart):

[mysqld]
interactive_timeout=180
wait_timeout=180

If you do not want to restart mysql, then run these two commands:

SET GLOBAL interactive_timeout = 180;
SET GLOBAL wait_timeout = 180;

This will not close the connections already open. This will cause new connections to close in 180 sec.

shareimprove this answer edited Dec 13 ‘11 at 22:52     answered Mar 3 ‘11 at 21:22 【转载】How long is “too long” for MySQL Connections to sleep? - 文章图片 RolandoMySQLDBA 103k14132264
 
    
so in /etc/my.cnf I would just put wait_timeout=180? – Patrick Mar 3 ‘11 at 22:28
    
@Patrick Yes, but you need to set both interactive_timeout and wait_timeout to 180. I updated my answer for your response. – RolandoMySQLDBA Mar 3 ‘11 at 22:29 
    
This file can be elsewhere dev.mysql.com/doc/refman/5.1/en/option-files.html and these options may not be explicited (write them by yourself) – nicolallias Jun 15 ‘15 at 15:33
add a comment

【转载】How long is “too long” for MySQL Connections to sleep?

标签：

本文系统来源：http://www.cnblogs.com/ddddemo/p/5650538.html

内容总结

以上是互联网集市为您收集整理的【转载】How long is “too long” for MySQL Connections to sleep?全部内容，希望文章能够帮你解决【转载】How long is “too long” for MySQL Connections to sleep?所遇到的程序开发问题。 如果觉得互联网集市技术教程内容还不错，欢迎将互联网集市网站推荐给程序员好友。

内容备注

版权声明：本文内容由互联网用户自发贡献，该文观点与技术仅代表作者本人。本站仅提供信息存储空间服务，不拥有所有权，不承担相关法律责任。如发现本站有涉嫌侵权/违法违规的内容， 请发送邮件至 gblab@vip.qq.com 举报，一经查实，本站将立刻删除。

内容手机端

扫描二维码推送至手机访问。

本文链接：https://qyyshop.com/info/466801.html

来源：【匿名】