Timeline for mysql fulltext query is very slow
Current License: CC BY-SA 3.0
4 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Jul 21, 2014 at 13:41 | comment | added | dmgig | Fulltext is meant generally for phrases and whole words. I would suggest having just a standard index on there as well. I also think that ORDER statement is slowing you down and I'm not sure what its purpose is. | |
| Jul 21, 2014 at 13:17 | comment | added | dmgig | My guess is full text searches are not meant for single letters like that. I would suggest having just a standard index on there as well. | |
| Jul 19, 2014 at 8:16 | comment | added | Manish Sapkal | thanks @dgig, I have changed ft_min_word_length and rebuilt index again. but when I restart mysqld service and then run query first time it is taking to much time (may be worm up time), but still this is taking too much time. do you any guess | |
| Jul 16, 2014 at 13:45 | history | answered | dmgig | CC BY-SA 3.0 |