MySQL Bugs: #37633: certain queries become very slow

Bug #37633	certain queries become very slow - locking related?
Submitted:	25 Jun 2008 14:58	Modified:	7 Nov 2015 7:37
Reporter:	Don Cohen	Email Updates:
Status:	Can't repeat	Impact on me:	None
Category:	MySQL Server: InnoDB storage engine	Severity:	S5 (Performance)
Version:	5.0.45	OS:	Any
Assigned to:	Heikki Tuuri	CPU Architecture:	Any

File:	Maximum allowed size is 50MB.
Description:
Privacy:

If the data you need to attach is more than 50MB, you should create a compressed archive of the data, split it to 50MB chunks, and upload each of them as a separate attachment.

To split a large file:

On *nix platforms use the split command e.g. split -b 50MB <my_large_archive> <my_split_archive_prefix>
On windows use WinZip or a similar utility to split the large file

transcript showing sample query, explain query, show profile before & after restarting server

Attachment: mysqlbug (application/octet-stream, text), 9.75 KiB.

long query followed by SHOW INNODB STATUS

Attachment: bug-transcript (application/octet-stream, text), 6.17 KiB.

transcript of several "show innodb status" commands while slow query running

Attachment: trans1 (application/octet-stream, text), 35.59 KiB.