MySQL Bugs: #37411: Threads staying in the "Sending Data" for long periods of time

Bug #37411	Threads staying in the "Sending Data" for long periods of time
Submitted:	14 Jun 2008 19:21	Modified:	19 Nov 2008 18:45
Reporter:	Robin McMillon	Email Updates:
Status:	No Feedback	Impact on me:	None
Category:	MySQL Server: InnoDB storage engine	Severity:	S2 (Serious)
Version:	5.0.51a	OS:	Solaris
Assigned to:	Assigned Account	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

EXPLAIN results for queries mentioned in original report

Attachment: mysql_bug_report_attachment2.rtf (application/rtf, text), 9.10 KiB.

my.cnf from server. most variables are changed inside running mysql server as in my-innodb-heavy-4G.cnf

Attachment: my.cnf (application/octet-stream, text), 5.44 KiB.

result of SHOW INNODB STATUS while server is in high load.

Attachment: show-innodb-status-high-load.dump (application/octet-stream, text), 8.18 KiB.

SHOW MUTEX STATUS result

Attachment: show-mutex-status.dump (application/octet-stream, text), 472 bytes.