What is the best way to search through large volumes of text fields?

Question

MySQL

Let's say we have a couple of million - ten million records, they have a text field for 10k characters, the user enters some phrase in the search, we need to find matches (not only at the beginning, but also in the middle). How is such a search mechanism implemented, so that the request passes quickly?

Answer 1

https://dev.mysql.com/doc/refman/8.0/en/fulltext-s...
but better for such sphinxsearch or manticoresearch

Answer 2

Check out Elasticsearch. Although the muscle has fulltext indexes, it is better to use tools designed for fulltext search, with all sorts of weights and morphological parsing.