Bug #35299 mysql client hangs and uses excessive CPU loading a dumped file
Submitted: 14 Mar 2008 19:10 Modified: 17 May 2008 13:16
Reporter: philip antoniades Email Updates:
Status: No Feedback Impact on me:
None 
Category:MySQL Server: Backup Severity:S2 (Serious)
Version:5.1.23 OS:Linux (ubuntu 7.10 x86)
Assigned to: CPU Architecture:Any
Tags: mysqldump dump

[14 Mar 2008 19:10] philip antoniades 
Description:
A large OEM customer gave me a 4M dump file that takes them close to 5 hours to load in to their servers. On my desktop (mysql 5.1.23RC) it consumes 100% of CPU time and ran for half an hour before I killed it - it had loaded 4 of 26 tables. I ran the same dump file through 5.0.22 and it completed without errors in 4.8 seconds. 

How to repeat:
Load dump file in mysql 5.1.23
[14 Mar 2008 19:51] Valeriy Kravchuk 
This looks like a duplicate of bug #33057. Please, check.
[14 Apr 2008 23:00] Bugs System 
No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".
[17 Apr 2008 13:16] Susanne Ebrecht 
Philip,

we still need feedback here.
[17 May 2008 23:00] Bugs System 
No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".