Bug #15289 low performance when importing databases
Submitted: 28 Nov 2005 14:36 Modified: 28 Dec 2005 14:47
Reporter: Moritz Unbekannt Email Updates:
Status: No Feedback Impact on me:
None 
Category:MySQL Server Severity:S5 (Performance)
Version:5.0.16 OS:Linux (debian sarge x86_64)
Assigned to: CPU Architecture:Any

[28 Nov 2005 14:36] Moritz Unbekannt 
Description:
A database import (zcat dump.sql.gz | mysql database) of a large database takes about 5 hours with mysql 5, while it took only 3 hours with mysql 4.1. This is repeatable...
Running performance also seems slower, but i have no proof here..

How to repeat:
---
[28 Nov 2005 14:47] Valeriy Kravchuk 
Thank you for a problem report. Are you sure, that all server system variables have the same values in 5.0 as in 4.1, and it is OK for them to be the same? Please, send the my.cnf content you used for 4.1.x and for 5.0.x.
[28 Nov 2005 15:08] Valeriy Kravchuk 
What storage engine is used in most of the tables you are importing? InnoDB?
[29 Dec 2005 0: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".