Yep, I just had a look and all the searchindex tables are empty and the tables doesn't seem to be accessed at all when using $wgSearchType = 'DcsCirrusSearch', so there's definitely no need for any MyISAM anywhere :-)
On 28/07/19 2:33 PM, Aran via Wikitech-l wrote: > We're using InnoDB > 5.7 so full text search is definitely supported - > but also we use Elastic search anyway, does this mean we don't even need > the searchindex table? > > > On 28/07/19 1:07 PM, Manuel Arostegui wrote: >> On Sat, Jul 27, 2019 at 4:03 PM Bartosz Dziewoński <[email protected]> >> wrote: >> >>> 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. >> The math table isn't used, and it is being dropped in production: >> https://phabricator.wikimedia.org/T196055 >> >> Regarding MyISAM vs InnoDB: Always use InnoDB unless you have a very good >> reason to use MyISAM (like the one mentioned about full-text indexes). >> >> Cheers >> Manuel. >> _______________________________________________ >> Wikitech-l mailing list >> [email protected] >> https://lists.wikimedia.org/mailman/listinfo/wikitech-l > > _______________________________________________ > Wikitech-l mailing list > [email protected] > https://lists.wikimedia.org/mailman/listinfo/wikitech-l _______________________________________________ Wikitech-l mailing list [email protected] https://lists.wikimedia.org/mailman/listinfo/wikitech-l
