Maintenance

From Support
Jump to navigation Jump to search

Maintenance

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 */
Siebrand22:49, 24 May 2010