S sajal Active member Nov 14, 2019 #1 Any reasons Why xf_search_index MyISAM and others are InnoDB? This causes performance issues on our site which has over 12M records. Can we convert it to InnoDB?
Any reasons Why xf_search_index MyISAM and others are InnoDB? This causes performance issues on our site which has over 12M records. Can we convert it to InnoDB?
K Kirby Well-known member Nov 14, 2019 #2 Older versions of InnoDB did not support FULLTEXT indexes, it is only supported since MySQL 5.6 - and XF 2 does only requrie MySQL 5.5. But for 12M records I wouldn't bother with MySQL FT anyway, use Elasticsearch.
Older versions of InnoDB did not support FULLTEXT indexes, it is only supported since MySQL 5.6 - and XF 2 does only requrie MySQL 5.5. But for 12M records I wouldn't bother with MySQL FT anyway, use Elasticsearch.
