Too Many Connections MySQL Sleep Process - Ubuntu

Too Many Connections MySQL Sleep Process - Ubuntu

Set these as follows in my.cnf (takes effect after mysqld is restarted):

[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 seconds.

Berlangganan update artikel terbaru via email:

Belum ada Komentar untuk "Too Many Connections MySQL Sleep Process - Ubuntu"

Posting Komentar

Iklan Atas Artikel

Iklan Tengah Artikel 1

Iklan Tengah Artikel 2

Iklan Bawah Artikel