PHPDevShell

InnoDB

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

Language:
English Edit question
Status:
Solved
For:
PHPDevShell Edit question
Assignee:
No assignee Edit question
Solved by:
TitanKing
Solved:
Last query:
Last reply:
Revision history for this message
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.

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

Thanks TitanKing, that solved my question.

Revision history for this message
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

Revision history for this message
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).