CODEWITHSUNDEEP
mysqlinnodbmyisam
S B
S B

Reputation: 1363

mysql - changing table engine from innoDB to MyISAM

I'm implementing app that requires search feature(full text Search).

EDIT:

I'm using mysql frequent select,insert,update,delete functions, joins also. I read this post. Is there any problem or disadvantages if i change table engine to MyISAM

Upvotes: 2

Views: 998

Answers (1)

Joachim Isaksson
Joachim Isaksson

Reputation: 180887

MyISAM does not have transaction support, so if you're using transactions, a conversion to MyISAM will cause problems.

Your best option is probably to use MySQL 5.6 or higher which supports full text indexes using InnoDB. Earlier versions only support full text indexes on MyISAM tables.

Full-text indexes can be used only with InnoDB or MyISAM tables, and can be created only for CHAR, VARCHAR, or TEXT columns.

Upvotes: 2

Related Questions