# Innodb with full text search

**URL:** <https://forums.percona.com/t/innodb-with-full-text-search/3073>\
**Category:** Percona XtraDB Cluster 5.x\
**Created:** [November 12, 2013, 4:47am UTC](https://forums.percona.com/t/innodb-with-full-text-search/3073 "2013-11-12T04:47:27Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**Author:** ![markwillis82](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/markwillis82/32/966_2.png) [@markwillis82](https://forums.percona.com/u/markwillis82)\
**Post date:** [November 12, 2013, 4:47am UTC](https://forums.percona.com/t/innodb-with-full-text-search/3073/1 "2013-11-12T04:47:27Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![percona.jayj](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/percona.jayj/32/927_2.png) [@percona.jayj](https://forums.percona.com/u/percona.jayj)\
**Post date:** [November 12, 2013, 9:58am UTC](https://forums.percona.com/t/innodb-with-full-text-search/3073/2 "2013-11-12T09:58:55Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![markwillis82](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/markwillis82/32/966_2.png) [@markwillis82](https://forums.percona.com/u/markwillis82)\
**Post date:** [November 12, 2013, 10:14am UTC](https://forums.percona.com/t/innodb-with-full-text-search/3073/3 "2013-11-12T10:14:37Z")

</div>

Fantistic - thanks for your help

---

<div class="post-metadata">

**Author:** ![Sujeet](https://avatars.discourse-cdn.com/v4/letter/s/49beb7/32.png) [@Sujeet](https://forums.percona.com/u/Sujeet)\
**Post date:** [November 23, 2013, 11:49am UTC](https://forums.percona.com/t/innodb-with-full-text-search/3073/4 "2013-11-23T11:49:38Z")

</div>

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?

---

<div class="post-metadata">

**Author:** ![wagnerbianchi](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/wagnerbianchi/32/802_2.png) [@wagnerbianchi](https://forums.percona.com/u/wagnerbianchi)\
**Post date:** [November 23, 2013, 11:58pm UTC](https://forums.percona.com/t/innodb-with-full-text-search/3073/5 "2013-11-23T23:58:10Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![Sujeet](https://avatars.discourse-cdn.com/v4/letter/s/49beb7/32.png) [@Sujeet](https://forums.percona.com/u/Sujeet)\
**Post date:** [November 25, 2013, 4:55am UTC](https://forums.percona.com/t/innodb-with-full-text-search/3073/6 "2013-11-25T04:55:59Z")

</div>

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.

---

<div class="post-metadata">

**Author:** ![przemek](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/przemek/32/3_2.png) [@przemek](https://forums.percona.com/u/przemek)\
**Post date:** [December 3, 2013, 6:11am UTC](https://forums.percona.com/t/innodb-with-full-text-search/3073/7 "2013-12-03T06:11:17Z")

</div>

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]](http://www.mysqlperformanceblog.com/2013/07/31/innodb-full-text-search-in-mysql-5-6-part-3/%5B/url%5D)
