Innodb with full text search

MySQL & MariaDB Percona XtraDB Cluster 5.x
1

Hi,

At the moment INNODB with full text search is part of percona server 5.6, is this functionality also going to be PXC 5.6?

Thanks

2

All Innodb functionality in 5.6 will be present as well in PXC 5.6.

3

Fantistic - thanks for your help

4

Hi,

We have to convert some MyISAM tables to InnDB on Percona 5.6.13 server. The MyISAM tables are using full-text indexing, so if I will move these tables as InnoDB then does It impact then query performance?

5

Sujeet, I think this is something you really need to create a test environment first and execute some benchmarks. In my thoughts you’ll need to pay more attention on fine tuning things for the whole InnoDB, not just for the things regarding Full Text indexes. Cheers, WB

6

Hi WB,

Thanks for the suggestion!!

We have converted few MyISAM table as InnoDB, only skipped out few MyISAM tables which contains full text index. I saw many post over net and found that InnoDB with full-text index will slow down the query performance. So just want to confirm this with you.

7

Sujeet, it will really depend on actual data and workload, some FTS queries may be faster on MyISAM, some on InnoDB.
I think this post will be interesting for you:
[url]http://www.mysqlperformanceblog.com/2013/07/31/innodb-full-text-search-in-mysql-5-6-part-3/[/url]