alter myissam index

Events happening in the community are now at Drupal community events on www.drupal.org.
lsiden's picture

Adding or dropping index on large myISSAM table == slow boat to China!

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
Subscribe with RSS Syndicate content