 <p>Don't use mysql for this stuff. You need an engine optimized for indexing search material. You can use <code>elasticsearch</code> or <code>solr</code> for this purpose and index it using mysql. Mysql is simply not designed for this purpose</p>