Re: [Wikitech-l] InnoDB / MyISAM

[Bartosz Dziewoński]

The 'searchindex' table uses MyISAM because until recently, InnoDB did 
not support fulltext indexes, which MediaWiki uses for the search. All 
other tables should use InnoDB.


According to https://stackoverflow.com/a/9397060 fulltext indexes are 
available on InnoDB since MySQL 5.6.4. If you're running that version or 
newer, it is possible you could use InnoDB for that table, but as far as 
I know no one has tried it before.


According to https://www.mediawiki.org/wiki/Compatibility#Database 
MediaWiki only requires MySQL 5.5.8, so we can't change that in our 
table definitions (yet).


No idea about the 'math' table.


--
Bartosz Dziewoński

___
Wikitech-l mailing list
Wikitech-l@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikitech-l

[Wikitech-l] InnoDB / MyISAM

[Aran via Wikitech-l]

Hello,

I've recently noticed that in a wiki farm I look after, about 20% of the
tables are MyISAM, but it doesn't seem very consistent - i.e. some
tables that are MyISAM in some wikis are InnoDB in others. searchindex
and math look to be all MyISAM.

From what I've read about them it seems that InnoDB is the best option,
especially for recent versions. Would it be a good idea to change them
all to InnoDB?

Thanks,
Aran


___
Wikitech-l mailing list
Wikitech-l@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikitech-l