История изменений
Исправление Qwentor, (текущая версия) :
show engine innodb status;
show processlist;
Id User Host db Command Time State Info
242 root localhost:44988 bets Query 340 Waiting for table level lock select id,bookmakerId,playTypeId,marketTypeId,resultTypeId,competitionId,competition,runner_id,runne
245 root localhost:45029 bets Sleep 1579 NULL
270 root localhost:45216 bets Query 340 Waiting for table level lock select count(*) from mem_bets
272 root localhost:45246 bets Query 340 Waiting for table level lock update mem_bets set koef = 1.676, updated_at = '2016-09-09 20:26:58.990' where bookmakerId = (select
273 root localhost:45247 bets Query 340 Waiting for table level lock update mem_bets set koef = 1.676, updated_at = '2016-09-09 20:26:55.722' where bookmakerId = (select
274 root localhost:45248 bets Query 340 Waiting for table level lock update mem_bets set koef = 1.746, updated_at = '2016-09-09 20:26:55.143' where bookmakerId = (select
278 root localhost:45252 bets Query 340 Waiting for table level lock update mem_bets set koef = 1.54, updated_at = '2016-09-09 20:27:14.221', link_attr_name = 'bet-selec
281 root localhost:45255 bets Query 340 Waiting for table level lock update mem_bets set koef = 2.56, updated_at = '2016-09-09 20:27:13.330', link_attr_name = 'bet-selec
286 root localhost:45260 bets Query 340 Waiting for table level lock update mem_bets set koef = 1.32, updated_at = '2016-09-09 20:27:16.108', link_attr_name = 'bet-selec
288 root localhost:45305 bets Query 531 NULL call psurebets(1)
293 root localhost:45356 bets Query 291 Waiting for table level lock DELETE FROM mem_bets WHERE datetime < NOW()
294 root localhost:45372 bets Query 231 Waiting for table level lock call psurebets(1)
295 root localhost:45390 bets Query 171 Waiting for table level lock DELETE FROM mem_bets WHERE datetime < NOW()
296 root localhost:45416 bets Query 50 Waiting for table level lock DELETE FROM mem_bets WHERE datetime < NOW()
297 root localhost NULL Query 0 NULL show processlist
Исходная версия Qwentor, :
show engine innodb status;
show processlist;
Id User Host db Command Time State Info
242 root localhost:44988 bets Query 340 Waiting for table level lock select id,bookmakerId,playTypeId,marketTypeId,resultTypeId,competitionId,competition,runner_id,runne
245 root localhost:45029 bets Sleep 1579 NULL
270 root localhost:45216 bets Query 340 Waiting for table level lock select count(*) from mem_bets
272 root localhost:45246 bets Query 340 Waiting for table level lock update mem_bets set koef = 1.676, updated_at = '2016-09-09 20:26:58.990' where bookmakerId = (select
273 root localhost:45247 bets Query 340 Waiting for table level lock update mem_bets set koef = 1.676, updated_at = '2016-09-09 20:26:55.722' where bookmakerId = (select
274 root localhost:45248 bets Query 340 Waiting for table level lock update mem_bets set koef = 1.746, updated_at = '2016-09-09 20:26:55.143' where bookmakerId = (select
278 root localhost:45252 bets Query 340 Waiting for table level lock update mem_bets set koef = 1.54, updated_at = '2016-09-09 20:27:14.221', link_attr_name = 'bet-selec
281 root localhost:45255 bets Query 340 Waiting for table level lock update mem_bets set koef = 2.56, updated_at = '2016-09-09 20:27:13.330', link_attr_name = 'bet-selec
286 root localhost:45260 bets Query 340 Waiting for table level lock update mem_bets set koef = 1.32, updated_at = '2016-09-09 20:27:16.108', link_attr_name = 'bet-selec
288 root localhost:45305 bets Query 531 NULL call psurebets(1)
293 root localhost:45356 bets Query 291 Waiting for table level lock DELETE FROM mem_bets WHERE datetime < NOW()
294 root localhost:45372 bets Query 231 Waiting for table level lock call psurebets(1)
295 root localhost:45390 bets Query 171 Waiting for table level lock DELETE FROM mem_bets WHERE datetime < NOW()
296 root localhost:45416 bets Query 50 Waiting for table level lock DELETE FROM mem_bets WHERE datetime < NOW()
297 root localhost NULL Query 0 NULL show processlist