THEOWEB.DEV

WhatsappBot, BrowserAutomation, TelegramBot, JabberBot, IBankingBot, custom software developer, internet marketing

Too Many Connections MySQL Sleep Process - Ubuntu

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.

Posting Komentar

Protected By Copyscape