MyISAM engine for lots of tables

sasa.jovanovic@esenca.rs's picture
sasa.jovanovic@...
Tue, 09/26/2017 - 08:45
#1
MyISAM engine for lots of tables

Hello,

I've just bought Avendor theme. After extract all files from md_avendor_install_profile.zip, and install Drupal with your mdavendor profile, when I've checked my database I can see that lots of tables using MyISAM engine

When I've checked mdavendor.sql file in profile folder, I've discovered that ther ENGINE=MyISAM is defined for each table. Why you are using MyISAM as Drupal 7 use InnoDB as default engine? I'm not sure how this will reflect on other modules, and when I update drupal to new version? Can I just change all tables to InnoDB.

cindy's picture
cindy
Tue, 09/26/2017 - 23:34

Hi,

It is not us but Drupal uses MyISAM as default. 

We have no idea with your own customization because we have never modified like that

But, you should back up your site (database and source code) before making any change to avoid losing data 

Log in or register to post comments
Have More Idea?

We are here to build your website!

No Universal solution fits all special business requirements. Our experienced team is ready with ideas and state-of-the-art technical solutions to consult the best solution within your budget.