| Bug #48515 | Mysqldump hangs with ** DEAD ** processes in the processlist with kernel Oops | ||
|---|---|---|---|
| Submitted: | 3 Nov 2009 20:20 | Modified: | 14 Jan 2013 18:32 |
| Reporter: | Lisa Williams | Email Updates: | |
| Status: | Can't repeat | Impact on me: | |
| Category: | MySQL Server: mysqldump Command-line Client | Severity: | S3 (Non-critical) |
| Version: | 5.0.67, 5.1.40 | OS: | Linux (openSUSE 11.1 x86_64) |
| Assigned to: | Matthew Lord | CPU Architecture: | Any |
| Tags: | *** DEAD ***, checking permissions, mysqldump, process hang | ||
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
[3 Nov 2009 20:25]
Lisa Williams
[3 Nov 2009 20:26]
Lisa Williams
my.cnf with some changes afterwards - it still occurs
Attachment: my.cnf_after.txt (text/plain), 5.19 KiB.
[3 Nov 2009 20:27]
Lisa Williams
current my.cnf based on performance model found on web with some edits
Attachment: my.cnf.now (text/plain), 17.73 KiB.
[3 Nov 2009 20:30]
Lisa Williams
output of show variables
Attachment: mysql_vars.txt (text/plain), 14.94 KiB.
[24 Jan 2010 13:44]
Jasper E
my.cnf
Attachment: my.cnf.txt (text/plain), 3.92 KiB.
[5 Feb 2010 18:34]
Jasper E
my.cnf used on error recreation on mysqld-5.1.43
Attachment: my.cnf.txt (text/plain), 4.40 KiB.
[5 Feb 2010 18:38]
Jasper E
Output from "SHOW VARIABLES;" while threads are stuck.
Attachment: variables.txt (text/plain), 5.47 KiB.
