EasyDiscuss, EasyBlog & EasySocial - INNODB Database engine
By Andrew on Friday, 07 August 2015
Posted in General
Replies 9
Likes 0
Views 540
Votes 0
We are wanting all of our tables changed to INNODB engine, but we are having some issues with EasyDiscuss and EasyBlog tables:

#1214 - The used table type doesn't support FULLTEXT indexes

Do the tables which are currently MyISAM from EB and ED and a couple from ES need to be MyISAM tables?
Mark, thanks for that.

Well from reading that it seems that moving towards INNODB is a good idea, especially that Full Text Search is supported in MySQL 5.6.4 and later. It would be possible for some of us, but others would have to wait till their hosting providers upgrade to 5.6.4.

However, if we should use 5.6.4 then we could still benefit from Full Text Search and be on INNODB. Win/Win situation I think.
Andrew
·
Tuesday, 11 August 2015 17:41
·
0 Likes
·
0 Votes
·
0 Comments
·
Hm, where are you getting these errors on the site?
Mark
·
Saturday, 08 August 2015 03:13
·
0 Likes
·
0 Votes
·
0 Comments
·
Hi Mark, Got it in SQL when we tried to run 'ALTER TABLE' syntax to change MyISAM tables to INNODB.
Thanks.
Andrew
·
Saturday, 08 August 2015 05:11
·
0 Likes
·
0 Votes
·
0 Comments
·
I think the problem is some of these columns are using fulltext indexes and innodb does not support this. You can remove the index and convert it to innodb but be cautious when doing so as the performance would be sluggish when it comes to searching.
Mark
·
Saturday, 08 August 2015 14:43
·
0 Likes
·
0 Votes
·
0 Comments
·
Mark, what is the plans for this going forward in ES. EB & ED etc? Since Joomla has now standardize on INNODB and it seems that is also the direction most are going.

Then, what is the real impact should we change all existing MyISAM (SI tables) to INNODB?
Andrew
·
Monday, 10 August 2015 17:16
·
0 Likes
·
0 Votes
·
0 Comments
·
We are not in a hurry to move to InnoDB yet because we are relying on fulltext searches and there are both pros and cons running on MyISAM and INNODB. See the discussions here, http://stackoverflow.com/questions/20148/myisam-versus-innodb
Mark
·
Tuesday, 11 August 2015 00:58
·
0 Likes
·
0 Votes
·
0 Comments
·
Sorry, but I don't have a work around for you currently.
Mark
·
Wednesday, 12 August 2015 18:12
·
0 Likes
·
0 Votes
·
0 Comments
·
not wanting a work-around... Merely commenting to the post....

thanks
Andrew
·
Wednesday, 12 August 2015 18:35
·
0 Likes
·
0 Votes
·
0 Comments
·
No problem
Mark
·
Wednesday, 12 August 2015 19:13
·
0 Likes
·
0 Votes
·
0 Comments
·
View Full Post