DEV Community

auct
auct

Posted on

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

#sql #mysql #help

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?

Read next

grahamthedev profile image

True Alphanumeric / natural sorting in MySQL - why is the answer always recursion?

GrahamTheDev -

xxzeroxx profile image

MySQL Terminal: Alter table, charset and delete

Antonio Silva -

adityabhuyan profile image

Best Practices for Handling Sensitive Data in MySQL Databases

Aditya Pratap Bhuyan -

dm8ry profile image

Populating a Vertica Database with Random Data

Dmitry Romanoff -