What does HackerNews think of manticoresearch?
Easy to use open source fast database for search | Good alternative to Elasticsearch now | Drop-in replacement for E in the ELK soon
If it works for you - great. If you need more flexibility in terms of data tokenization, matching and ranking you can consider Manticore Search [1] instead of Elasticsearch since it's a continuation (a fork made in 2017) of the Sphinx search engine mentioned in the article on mysql.com and has a better integration with MySQL than Elasticsearch (e.g. you can use Linux mysql client or any programming language mysql connector to make queries to Manticore).
[1] https://dev.mysql.com/blog-archive/rankings-with-innodb-full...
https://github.com/manticoresoftware/manticoresearch/
https://db-benchmarks.com/test-taxi/#manticore-search-vs-ela...
Another search engine which can be considered general, is not based on Lucene and is not less powerful than Elasticsearch/Solr is Manticore Search [1]
[1]: https://github.com/manticoresoftware/manticoresearch
> I would love to see some benchmarks by category :)
I'd love too. We started this work on db-benchmarks [2] , hopefully we'll have resources to continue it. Contributions are very welcome. It's 100% opensource [3]
[2]: https://db-benchmarks.com/ [3]: https://github.com/db-benchmarks/db-benchmarks