Mysql - How to fix mysql slow connection, Mysql Sleep Connection
How to fix mysql slow connectionHow to fix mysql slow connection?
Most of would have faced MySQL slow connection issue, it might be because of improper configuration or bad queries we use. The best way of coding will be to make a check and close MySQL connection properly.
MySQL: show processlist;Where, you might find too many sleep connections.
To set MySQL variables during run time
mysql>SET GLOBAL interactive_timeout = 180; mysql>SET GLOBAL wait_timeout = 180;
The same can be configured in MySQL configuration file too
# vi /etc/my.cnf file interactive_timeout = 180; wait_timeout = 180;
This will not close the connections already open but, it will cause the new connections to close in 180 sec
To fix MySQL slow connection problem, you have to set the variable as below and restart your MySQL connection
MySQL: interactive_timeout=180; MySQL: set wait_timeout=180;
The topic on Mysql - How to fix mysql slow connection is posted by - Leon
Hope you have enjoyed, Mysql - How to fix mysql slow connectionThanks for your time