Locked State
This is a monitoring script fetching data from SHOW FULL PROCESSLIST:
Im getting tons of Locked query that will hangs my server.
Can you help me to troubleshoot this?
Id Command Time State Info
[Tue Jan 10 04:08:01 CET 2012] 127458 Query 50 Locked UPDATE phpbb_sessions\n\t\tSET session_user_id = -1, session_start = 1326164831, session_time = 1326164831, session_page = -2, session_logged_in = 0, session_admin = 0\n\t\tWHERE session_id = '372c63a349822613841f9dc42524b96c' \n\t\t\tAND session_ip = '42f9472f'
[Tue Jan 10 04:08:01 CET 2012] 127461 Query 49 Locked UPDATE phpbb_sessions\n\t\tSET session_user_id = -1, session_start = 1326164832, session_time = 1326164832, session_page = 3, session_logged_in = 0, session_admin = 0\n\t\tWHERE session_id = '' \n\t\t\tAND session_ip = '41346ebf'
[Tue Jan 10 04:09:01 CET 2012] 127754 Query 75 Locked UPDATE phpbb_sessions\n\t\tSET session_user_id = -1, session_start = 1326164866, session_time = 1326164866, session_page = -9, session_logged_in = 0, session_admin = 0\n\t\tWHERE session_id = '' \n\t\t\tAND session_ip = '41346ebf'
[Tue Jan 10 04:09:01 CET 2012] 127757 Query 74 Locked UPDATE phpbb_sessions\n\t\tSET session_user_id = -1, session_start = 1326164867, session_time = 1326164867, session_page = -2, session_logged_in = 0, session_admin = 0\n\t\tWHERE session_id = '372c63a349822613841f9dc42524b96c' \n\t\t\tAND session_ip = '42f9472f'
[Tue Jan 10 04:09:01 CET 2012] 127997 Query 40 Locked UPDATE phpbb_sessions\n\t\tSET session_user_id = -1, session_start = 1326164901, session_time = 1326164901, session_page = 15, session_logged_in = 0, session_admin = 0\n\t\tWHERE session_id = '' \n\t\t\tAND session_ip = '41346d13'
[Tue Jan 10 04:09:01 CET 2012] 128000 Query 39 Locked UPDATE phpbb_sessions\n\t\tSET session_user_id = -1, session_start = 1326164902, session_time = 1326164902, session_page = 5, session_logged_in = 0, session_admin = 0\n\t\tWHERE session_id = '' \n\t\t\tAND session_ip = '41346d13'