InnoDB

Asked by Gani Utomo on 2009-11-16

I currently install PHPDevShell. I realize it uses a lot of InnoDB engine, instead of MyISAM.
I'm wondering, is there any specific function or any proses that require InnoDB engine?
If there is none, I'd like to know the main reason using InnoDB engine.

Question information

Language:
English Edit question
Status:
Solved
For:
PHPDevShell Edit question
Assignee:
No assignee Edit question
Solved by:
TitanKing
Solved:
2009-11-17
Last query:
2009-11-17
Last reply:
2009-11-16
Best TitanKing (titan-phpdevshell) said : #1

InnoDB offers more reliable locking of tables, although a bit slower. The main reason why we are using it is to support transactions and rolling back of broken queries ensuring no half queries gets executed when broken.

So mainly for reliability.

You need no extra steps in your database setup or requirements though.

Gani Utomo (ganiutomo) said : #2

Thanks TitanKing, that solved my question.

jsherk (jeff-forerunnertv) said : #3

Here is an excellent article that really explains the difference between MyISAM and InnoDB:
http://tag1consulting.com/MySQL_Engines_MyISAM_vs_InnoDB

Greg (gregfr) said : #4

Thanks for the link. As far as I know, PHPDevShell doesn't require any engine-specific features, to allow maximum flexibility. The new architecture of PHPDevShell 3.0 plans to allow other supports (for you nosql fans).