Maintenance
From Support
Jump to navigation
Jump to search
Converted a few tables from MyISAM to InnoDB. Took a while for some tables, causing the wiki basically to be read-only, and lighttpd to serve some '500' errors.
ALTER TABLE `bw_text` ENGINE = InnoDB; 5 min 45.90 sec */
ALTER TABLE `bw_archive` ENGINE = InnoDB; 54.54 sec */
ALTER TABLE `bw_logging` ENGINE = InnoDB; 1 min 22.49 sec */
ALTER TABLE `bw_watchlist` ENGINE = InnoDB; 21 min 48.14 sec */
ALTER TABLE `bw_templatelinks` ENGINE = InnoDB; 4.37 sec */
ALTER TABLE `bw_pagelinks` ENGINE = InnoDB; 25.69 sec */
ALTER TABLE `bw_categorylinks` ENGINE = InnoDB; 0.91 sec */
ALTER TABLE `bw_externallinks` ENGINE = InnoDB; 12.14 sec */
ALTER TABLE `bw_imagelinks` ENGINE = InnoDB; 0.28 sec */
ALTER TABLE `bw_revision` ENGINE = InnoDB; 1 hour 44 min 57.29 sec */
Two tables to go, will try and find a faster solution for those...
ALTER TABLE `bw_page` ENGINE = InnoDB; /* 1 hour 10 min 33.22 sec on test db */
ALTER TABLE `bw_recentchanges` ENGINE = InnoDB; /* 54 min 50.80 sec on test db */