Hi, Many times mysql users asking me "show processlist showing list of many sleep queries on their environment". This post is for mysql user.
Sleep meaning that thread is do nothing. Its not a query waiting for connection. It's a connection pointer waiting for the timeout to terminate. and it doesn't have an impact on performance .
To varify on your instance run below query..
show variables like '% wait_timeout%'
Then we will see setting is default wait_timeout=28800 or something else as configured;
So we can set values smaller,eg 10-20. We can also kill the thread status maked to sleep, that will not impact system.
Thanks
Sleep meaning that thread is do nothing. Its not a query waiting for connection. It's a connection pointer waiting for the timeout to terminate. and it doesn't have an impact on performance .
To varify on your instance run below query..
show variables like '% wait_timeout%'
Then we will see setting is default wait_timeout=28800 or something else as configured;
So we can set values smaller,eg 10-20. We can also kill the thread status maked to sleep, that will not impact system.
Thanks
Comments
Post a Comment
Plz dont forget to like Facebook Page..
https://www.facebook.com/pages/Sql-DBAcoin/523110684456757