Adding or dropping index on large myISSAM table == slow boat to China!
Posted by lsiden on September 20, 2010 at 1:12am
Has anybody seen this: http://lists.mysql.com/mysql/202489 ? Like Inspector Renault in "Casablanca", if this is true, I am shocked!
I'm upgrading a Drupal 5 site with > 19M business listings to Drupal 6. The url_alias table has twice that many rows. ./modules/system.install takes several passes over this table, and what should have taken a few hours at most is taking days!
Read more