Bug #14893 alter table disable keys seems not work at 5.0.15
Submitted: 12 Nov 2005 2:40 Modified: 4 Feb 2006 12:42
Reporter: yue gong Email Updates:
Status: Can't repeat Impact on me:
Category:MySQL Server Severity:S3 (Non-critical)
Version:5.0.18 OS:Windows (win2000,xp,2003)
Assigned to: CPU Architecture:Any

[12 Nov 2005 2:40] yue gong
I dumped a 4.0.25 database with --opt option by mysqldump. When I run mysql 'newDatabase' < 'dumpfile' , it runs very slowly. I removed the '/*!40000...' before the alter statement, there was no help.

My 4.0.25 server's default character-set is gb2312,  5.0.15 server's default character-set is gbk. I had try all the mysqldump.exe bundled with 4.0.25 and 5.0.15. the mysql.exe is bundled with 5.0.15.


How to repeat:
Every time.
[12 Nov 2005 11:27] MySQL Verification Team
Can you please provide a dump file for test on our side? If you
want it not to be public you can upload a zip file at:


Also specification of your hardware which can affect the performance
processors, RAM, etc.

Thanks in advance.
[17 Nov 2005 7:07] yue gong
thanks for replay. 

My environment is win2ksp4 512MRAM 20GHD. I recoverd the same data in mysql 4.0 is very fast .

dump : C:\Program Files\MySQL\MySQL Server 5.0\bin>mysqldump -P3306 chinabase > c:cb.sql

revert : C:\Program Files\MySQL\MySQL Server 5.0\bin>mysql test < c:\cb.sql

database : CREATE DATABASE `test` DEFAULT CHARACTER SET gb2312 COLLATE gb2312_bin;
[17 Nov 2005 7:12] yue gong
I have uploaded a dump file 'cb.sql' to ftp://ftp.mysql.com/pub/mysql/upload.

[22 Nov 2005 19:00] Jorge del Conde
I was unable to reproduce this bug under Win2k, XP, XP64.  Your dump file loaded very fast into my 5.0.15 and 5.0.16 installation.
[4 Feb 2006 12:42] yue gong
The problem is still there , I test it in windows xp and 2003 with mysql 5.0.18, for about 40,000 records , it runs more than 1 hour. Who can give me some suggestion?