Does MySQL 5.6 InnoDB FTS and Cluster work together
We are currently creating a new website that is similar to a search engine, where database is frequently updated. The search is done using FTS on this kind of index:
CREATE FULLTEXT INDEX IDX_OBJ_FTS ON `obj_data`
(topic_th,topic_en,description_th,description_en,developer,pname,name,near_by);
where description_en/th are TEXT, other fields are VARCHAR(255). With a small amount of users the performances are good, but when the number of users increases (by not much users) we have performance degradation. We currently have 4GB of RAM on the server and allocate 3.5 to mysql, so that the queries can run entirely in memory.
We can increase the server RAM to 16GB but at some point we will hit a user limit again. I am thinking of MySQL cluster but before I spend time to install I want to make sure that MySQL 5.6 with InnoDB still supports FTS when using MySQL cluster.
Subject
Views
Written By
Posted
Does MySQL 5.6 InnoDB FTS and Cluster work together
4266
August 09, 2013 01:21AM
2204
August 10, 2013 03:00PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.