DEV Community

auct
auct

Posted on

What is the best way to search full name in MySQL (1m rows)?

Hi. I need some help. Currently I have elastic search but it is very annoying (needs lots of ram, shutdowns everytime), So I want to get rid of it and get back to mysql search.
I have table with 1m rows.
Searchable columns: name, name_original (ofthen blank). Both of them are 2-3 words each, varchar 255.

How would you organize search?

Top comments (1)

Collapse
 
rhymes profile image
rhymes • Edited

How good is MySQL's full text search?