Love the new feature of search as it now works like a charm, I have luck to get it working but it took me a while to figure it out how to make it work.
Beta1 it was working only on search thread but with Beta2, it is working on search everything.
I had a requirement for 2 chars length search and I only wanted the 2 columns which contains texts as members only search on them.
I'm running mysql 5.7 and php 7.4
Below are the steps which I noted so I can reuse them on live site.
Add the below 2 lines in mysqld.cnf
innodb_ft_min_token_size=2
ft_min_word_len=2
Restart mysql server.
Run the below sql queries
OPTIMIZE TABLE xf_post, xf_thread
Or you can optimize all tables if you want
ALTER TABLE xf_post ADD FULLTEXT (message);
ALTER TABLE xf_thread ADD FULLTEXT (title);
In forum root folder, as per instructions to manually update , you need to run
php cmd.php xf:convert-search-innodb
In admin console panel, in search options, Search minimum word length must also match the value you set for MYSQL FULLTEXT search
Now, I can search 2 chars words length in any order without the need for ES which is overkill for a small site like mine.
Hope it helps!