MySQL Bugs: #14893: alter table disable keys seems not work at 5.0.15

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:	None
Category:	MySQL Server	Severity:	S3 (Non-critical)
Version:	5.0.18	OS:	Windows (win2000,xp,2003)
Assigned to:		CPU Architecture:	Any

Description:
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.

Thanks!

How to repeat:
Every time.

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:

ftp://ftp.mysql.com:/pub/mysql/upload

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

Thanks in advance.

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;

I have uploaded a dump file 'cb.sql' to ftp://ftp.mysql.com/pub/mysql/upload.

Thanks.

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.

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?

Thanks.