Redis/db session drivers causing deadlocks (MySQL 5.6, CI 3.0.6)

Redis/db session drivers causing deadlocks (MySQL 5.6, CI 3.0.6)

kenjis
Administrator
Posts: 3,408
Threads: 91
Joined: Oct 2014
Reputation: 211

06-17-2017, 02:03 AM

We have the similar situation with Amazon Aurora.

We see too many `SELECT GET_LOCK('xxx', 300) AS ci_session_lock` queries in the processlist.
And MySQL reaches the max connections.

Any advice to get a clue?

ci-phpunit-test | CodeIgniter Testing Guide | CodeIgniter 3 to 4 Upgrade Helper

Messages In This Thread

Redis/db session drivers causing deadlocks (MySQL 5.6, CI 3.0.6) - by spjonez - 04-27-2016, 03:43 PM

RE: Redis/db session drivers causing deadlocks (MySQL 5.6, CI 3.0.6) - by consigliere - 05-20-2016, 06:22 PM

RE: Redis/db session drivers causing deadlocks (MySQL 5.6, CI 3.0.6) - by spjonez - 05-24-2016, 06:16 AM

RE: Redis/db session drivers causing deadlocks (MySQL 5.6, CI 3.0.6) - by kenjis - 06-17-2017, 02:03 AM