MySQL Forums
Forum List  »  Full-Text Search

Does MySQL 5.6 InnoDB FTS and Cluster work together
Posted by: Cedric Rochefolle
Date: August 09, 2013 01:21AM

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.

Options: ReplyQuote


Subject
Views
Written By
Posted
Does MySQL 5.6 InnoDB FTS and Cluster work together
3545
August 09, 2013 01:21AM


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.