[Wolves] Disable / enable keys slow in MySQL

DragonMaster LUG at clews.homelinux.net
Wed Aug 5 15:36:27 UTC 2009


I've posted a query on the mysql forum, but thought I would tap the fonts
of all knowledge as well :-)

I've got a small database - about 14 million records and I run a weekly
update on it which takes about 18 hours to run.  I've read that disabling
the keys on the table, running the updates and then enabling the keys
should be faster as the enable keys function uses a different algorithm.

  However, when I have done this, the rebuild takes 27 hours! - and that's
without actually making any changes to the data!  Any ideas as to why
this would be?

TIA,

DM





More information about the Wolves mailing list