| Bug #17019 | Hudge DELETE queries consume all memory and cpu resources | ||
|---|---|---|---|
| Submitted: | 1 Feb 2006 18:29 | Modified: | 2 Feb 2006 16:22 |
| Reporter: | Guy Baconnière | Email Updates: | |
| Status: | Duplicate | Impact on me: | |
| Category: | MySQL Server | Severity: | S1 (Critical) |
| Version: | 5.0.18 | OS: | Linux (Debian Sarge/Kernel 2.6.15/Libc) |
| Assigned to: | CPU Architecture: | Any | |
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
[1 Feb 2006 18:35]
Guy Baconnière
[1 Feb 2006 18:44]
Guy Baconnière
bug.sql part2
Attachment: bug.sql-part2 (text/plain), 200.00 KiB.
[1 Feb 2006 18:44]
Guy Baconnière
bug.sql part3
Attachment: bug.sql-part3 (text/plain), 31.82 KiB.
[1 Feb 2006 18:45]
Guy Baconnière
data and structure
Attachment: data.sql (text/plain), 13.02 KiB.
[1 Feb 2006 18:45]
Guy Baconnière
mysql config file
Attachment: my.cnf (text/plain), 5.01 KiB.
