How to do full text search in elasticsearch

Elastic Stack Elasticsearch
1

I have very big data in on table (more then 4lc rows). Right now i am using mysql full text search but its very slow.

I google and found many blog which suggest to use elastic search for searching. We are testing if elastic search will help in fast search.

but we are getting opposite result(mysql better search), but i doubt if i have used elastic search in correct way. Elastic search query i used is:-

{
"query" : {
"bool" : {
"must" : {
"query_string" : {
"query" : "goog*",
"default_field" : "search"
}
}
}
},
"size" : 1000
}

For same search in mysql we used

SELECT SQL_NO_CACHE * FROM table1 WHERE (MATCH (search) AGAINST (' +goog' IN BOOLEAN MODE))*
I get time diff:- elastic time = 0.34929585456848

mysql time = 0.02162504196167

Any suggestion where i am wrong I will very much appreciate

2

Don't use wildcards. It's not efficient at all.
Don't change size. Keep it to 10.

Then you could also reduce the number of shards to 1.

3

I forgot to ask. What is the "took" value in elasticsearch response ?

4

Hi @dadoonet,
I am new to elasticsearch and started elastic search only few days back.
What should i use in place of wild card?

this response i get

{
"took": 2793,
"timed_out": false,
"_shards": {
"total": 5,
"successful": 5,
"failed": 0
},
........

5

can you Please share link from where i can refer.

Basically i need to do full text searching on one field
and other searching %oogl% ( mysql LIKE %oogle%)