Welcome Guest, Not a member yet? Register   Sign In
SELECT GET_LOCK() showing up in slow query log (CI SESSIONS)
#2

You can just ignore this.

It's caused by the same user attempting to simultaneously load multiple pages (or one page with asynchronous AJAX calls) on your website. And it's exactly what is supposed to happen - wait for the lock to be freed (session closed on one page) before being able to acquire a lock for the second page load.

Concurrent users and the database engine are irrelevant. You didn't see this on MyISAM just because you didn't have a user with the same behavior during that temporary switch.
Reply


Messages In This Thread
RE: SELECT GET_LOCK() showing up in slow query log (CI SESSIONS) - by Narf - 04-08-2016, 11:21 AM



Theme © iAndrew 2016 - Forum software by © MyBB