Change all storage engine from MyISAM to InnoDB? Possible?
By ssnobben on Wednesday, 15 December 2021
Posted in General
Likes 0
Views 871
Votes 0
Hi

as said by God Google you cant use their cloud service with some of Stackideas products ( EasySocial,..) if you use MyISAM instead of InnoDB database engine https://cloud.google.com/sql/faq#innodb

Why cant that be changed by 100% for all Stackideas products?

It works 100% for EasyDiscuss, 98% EasyBlog, EasyArticles but not for EasySocial, Kommento,

Cheers!

ps saw this by discussion in Joomla forum https://forum.joomla.org/viewtopic.php?f=810&p=3647137&sid=74d7480e7445cb441aa192d232fc3e7a#p3647137
Different table has different table structure, the reason why Easyblog tables can't 100% change to InnoDB engine is due to the usage of "FULLTEXT" index. In other words, as long as the table has used "FULLTEXT" type for indexes, this table can't change to the InnoDB engine.

In order to change other extension tables to support the InnoDB engine, we need more time to test this because it is not an easy task to change all to the InnoDB engine without internal testing for each of the features.

And yes, we do have a plan to switch all other extensions tables to support the InnoDB storage engine in the future.
Arlex Wong
·
Thursday, 16 December 2021 11:22
·
0 Likes
·
0 Votes
·
0 Comments
·
Thanks Arlex sounds great!

Merry Christmas to you all guys from Santa Claus in winter land!
ssnobben
·
Tuesday, 21 December 2021 20:05
·
0 Likes
·
0 Votes
·
0 Comments
·
You're most welcome.

Wish you have a great Merry Christmas too.
Arlex Wong
·
Wednesday, 22 December 2021 10:37
·
0 Likes
·
0 Votes
·
0 Comments
·
View Full Post