MyISAM to InnoDB
By Gregor on Tuesday, 25 September 2018
Posted in Technical Issues
Replies 5
Likes 0
Views 555
Votes 0
Hi,

My hosting recommends me to change the MyISAM tables to InnoDB. Is this possible? This recommendation came because of the peaks in DB use and error reduction.

Regards,
Mark
You're most welcome.

Logically it will not revert back to MyISAM when you update to next version because all those table already created in your database.

The reason why it using MyISAM when you fresh installation Easysocial on your site is because from the SQL file we already specify to use MyISAM engine.

By the way, remember do it on your development site first because for now I can't guarantee that existing table structure is it compatible with InnoDB engine or not.
Arlex Wong
·
Tuesday, 23 October 2018 10:06
·
0 Likes
·
0 Votes
·
0 Comments
·
If i recall correctly, we have one of our customer to tried convert his site database from MyISAM to InnoDB, but some of the tables is not compatible with InnoDB.

It would be best convert this from your development site database, in case if there got any issue, it will not affect your live site.
Arlex Wong
·
Tuesday, 25 September 2018 18:30
·
0 Likes
·
0 Votes
·
0 Comments
·
Hi Arlex,

Ok thank you. Are there any plans for this in the future. When I update the database will be reset to MyISAM right?

Regards,
Mark
Gregor
·
Monday, 22 October 2018 19:21
·
0 Likes
·
0 Votes
·
0 Comments
·
Hi Arlex,

Ok, thank you :-) Maybe I'll give it a try in development.

Regards,
Mark
Gregor
·
Friday, 02 November 2018 22:44
·
0 Likes
·
0 Votes
·
0 Comments
·
You're most welcome.
Arlex Wong
·
Saturday, 03 November 2018 11:10
·
0 Likes
·
0 Votes
·
0 Comments
·
View Full Post