• Registered: 03/30/2013
  • Posts: 9

Topic: Why ENGINE=MyISAM + ENGINE=InnoDB

In the setup of the DB tables I see that 2 different engines are installed.
Why ENGINE=MyISAM + ENGINE=InnoDB instead of only 1 of the 2?

Does someone knows this and can explain it to me.

  • From: USA, OH, Cincinnati
  • Registered: 11/08/2012
  • Posts: 39

Re: Why ENGINE=MyISAM + ENGINE=InnoDB

change to InnoDB if you need to perform transactions. Itronics has indicated that change to this storage method has no negative implications.

swheeler's Website

  • Registered: 09/08/2013
  • Posts: 6

Re: Why ENGINE=MyISAM + ENGINE=InnoDB

I believe InnoDB supports "transactions", not money, but a type of db action that does not commit unless the full action is completed

  • From: Singapore, India, Chennai
  • Registered: 05/02/2009
  • Posts: 6,160

Re: Why ENGINE=MyISAM + ENGINE=InnoDB

Making all as ENGINE=InnoDB is okay as far as FA v2.3.x is concerned - it just won't use the Foreign Key CASCADE ON INSERT/DELETE/UPDATE feature..

apmuthu's Website