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

Hey All,

My database is tuned pretty well overall but I am seeing statements like this in my MySQL slow query log:

# [email protected]: heatware_dotcom[heatware_dotcom] @ localhost []  Id: 91681
# Query_time: 1.086505  Lock_time: 0.000000 Rows_sent: 1  Rows_examined: 0
SET timestamp=1460134851;
SELECT GET_LOCK('a7642ffa05034f140c3fc90be7efd272828a600a', 300) AS ci_session_lock;
# [email protected]: heatware_dotcom[heatware_dotcom] @ localhost []  Id: 91682
# Query_time: 1.112502  Lock_time: 0.000000 Rows_sent: 1  Rows_examined: 0
SET timestamp=1460134851;
SELECT GET_LOCK('a7642ffa05034f140c3fc90be7efd272828a600a', 300) AS ci_session_lock;
# [email protected]: heatware_dotcom[heatware_dotcom] @ localhost []  Id: 91683
# Query_time: 1.132454  Lock_time: 0.000000 Rows_sent: 1  Rows_examined: 0
SET timestamp=1460134851;
SELECT GET_LOCK('a7642ffa05034f140c3fc90be7efd272828a600a', 300) AS ci_session_lock;
# [email protected]: heatware_dotcom[heatware_dotcom] @ localhost []  Id: 91684
# Query_time: 1.165734  Lock_time: 0.000000 Rows_sent: 1  Rows_examined: 0
SET timestamp=1460134851;
SELECT GET_LOCK('a7642ffa05034f140c3fc90be7efd272828a600a', 300) AS ci_session_lock;

My website is NOT high traffic and may only have a handful of users online concurrently. My ci_sessions table is setup for INNODB although, I did not see these GET_LOCK() slow queries when I temporarily switched it over to MyISAM.

Any ideas why these are showing up in slow query log?
Reply


Messages In This Thread
SELECT GET_LOCK() showing up in slow query log (CI SESSIONS) - by heat23 - 04-08-2016, 10:31 AM



Theme © iAndrew 2016 - Forum software by © MyBB