By levensen on

After listening to the MySQL webinar presented by Jeremy T. of tag1consulting.com I understood that he recommended InnoDB (and I personally would use InnoDB over non-ACID compliant ISAM too, regardless of any performance issues). I loaded drupal 6 2rc and it is still (seemingly) using ISAM. Would you recommend converting to InnoDB? Is Drupal 6 going to 'officially' switch over to InnoDB?
thanks, all
Lesley

⋅ Categories: Drupal 6.x

Comments

dharamgollapudi’s picture

dharamgollapudi commented

Follow up....

Anonymous’s picture

Anonymous (not verified) commented

The innodb engine is not always available in shared hosts environments.
You can always change table definitions manually or change the default mysql engine to innodb before installing Drupal.

-----------------------------------------
Joep
CompuBase, Drupal websites and design

levensen’s picture

levensen commented

hello Joep, I have convereted databases to InnoDB from ISAM before so I know it can be done, but I wondered if Drupal 6 would officially develop with/use that engine.
I noticed, in Drupal 5, some of the tables get created as ISAM and some as InnoDB, not sure how that happened, e.g. term_* tables are InnoDb, content_* are ISAM..

Anonymous’s picture

Anonymous (not verified) commented

term_* tables are still isam. I think you must have changed it later on.