Asked by Gani Utomo

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

English Edit question
PHPDevShell Edit question
No assignee Edit question
Solved by:
Last query:
Last reply:
Revision history for this message
Best TitanKing (titan-phpdevshell) said :

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.

Revision history for this message
Gani Utomo (ganiutomo) said :

Thanks TitanKing, that solved my question.

Revision history for this message
jsherk (jeff-forerunnertv) said :

Here is an excellent article that really explains the difference between MyISAM and InnoDB:

Revision history for this message
Greg (gregfr) said :

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).