LINUX.ORG.RU

История изменений

Исправление Qwentor, (текущая версия) :

show engine innodb status;


http://pastebin.com/qyTGde2Z

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;


http://pastebin.com/qyTGde2Z

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