MySQL search how?

Question

MySQL

Hello.
There is a table of the form:
ID | COUNT | DATA | DATE | TYPE | IP
Every day, about 500 thousand records are added to the database.
How can you make a search in the DATA field fast and how long will it take to search in such a huge database in a week or a month?

Answer 1

sphinxsearch.com/ , no?

Answer 2

Why are you looking for links? Maybe it's worth highlighting from the link the information by which the search will take place, and storing it in a separate field with an index on this field?

Answer 3

what data is in the data field?

Answer 4

the speed will very much depend on whether an index will be created on the DATA field

Answer 5

The first thing to do for such a volume is to cut the table according to some criterion, because 500K records per day is a lot. I remember there was a table with 4 billion records, then all operations with this table were very slow
. Second, you did not explain what kind of data is contained in the DATA field. Can do fulltext (specify show create table). If the data is large enough, then as indicated in the first answer, then the sphinx