wait_timeout issue

Description

Hi Team

We have set out wait_time out and interactive_timeout to the below values but we still ssee connections which are hanging more than 20067. Can you guys help us to solve this issue.

 

Thank you,

Santhosh Amradhi

Environment

None

Smart Checklist

Activity

Show:

Jira Bot March 29, 2020 at 4:15 PM

Hello ,
It's been 65 days since this issue went into Incomplete and we haven't heard
from you on this.

At this point, our policy is to Close this issue, to keep things from getting
too cluttered. If you have more information about this issue and wish to
reopen it, please reply with a comment containing "jira-bot=reopen".

Jira Bot March 6, 2020 at 9:56 PM

Hello ,
It's jira-bot again. Your bug report is important to us, but we haven't heard
from you since the previous notification. If we don't hear from you on
this in 7 days, the issue will be automatically closed.

George Lorch January 23, 2020 at 9:37 PM

This system is for requesting new features and reporting software defects.  This appears to be a support request.  You can try asking for help from the community in our public forums here https://www.percona.com/forums/questions-discussions/mysql-and-percona-server or you can reach out to our support team here https://www.percona.com/services/support/mysql-support

Santhosh Amradhi January 23, 2020 at 9:10 PM

Right now the values are set at 

 

mysql> show variables like'%wait_timeout%';
------------------------------------+

Variable_name

Value

------------------------------------+

innodb_lock_wait_timeout

600

lock_wait_timeout

31536000

wait_timeout

3600

------------------------------------+
3 rows in set (0.00 sec)

 

mysql> show variables like'%interactive%';
----------------------------+

Variable_name

Value

----------------------------+

interactive_timeout

3600

----------------------------+
1 row in set (0.00 sec)

 

 

Incomplete

Details

Assignee

Reporter

Priority

Smart Checklist

Created January 23, 2020 at 9:08 PM
Updated March 6, 2024 at 11:22 AM
Resolved March 29, 2020 at 4:15 PM

Flag notifications