XF 2.3 $config['searchInnoDb'] = true;

[🔥Iggy🔥]

hello,
can someone please explain more exactly what this line is in config?

$config['searchInnoDb'] = true;

its default install but not mentioned in the manual....i found 3 threads briefly mentioning the line with no helpful info...also no info in the XFES section.

kind regards

 

[Jeremy P]

Explained further here: https://xenforo.com/community/threa...ull-innodb-support-with-improved-mysql-search

It's only relevant if you're using MySQL for search. It's the default for new installations. Upgrades from XF<2.3 must run the conversion CLI command and update config.php to benefit, like when upgrading to full unicode support.

 

[🔥Iggy🔥]

Explained further here: https://xenforo.com/community/threa...ull-innodb-support-with-improved-mysql-search

It's only relevant if you're using MySQL for search. It's the default for new installations. Upgrades from <XF 2.3 must run the conversion CLI command and update config.php, like when upgrading to full unicode support.

oh ok so its alot about those tables all being innodb...i did do that after upgrading, im still a little confused about switching to ElasticSearch tho as we generally dont want to use mysql search any more....is that fully unrelated, i.e. meant to disregard?

regards

 

[Jeremy P]

If you have XFES installed and enabled then it's safe to run the command and edit config.php anyway, but it'll make no practical difference so it's not strictly required.