Web Design and Search Engine Optimisation FreeLancer




MySQL : InnoDb vs MyISAM

Category : MySQL Settings · by Nov 13th, 2014

now its time for Database. the major thing that beginners are curioues to know what are the difference between InnoDB and MyISAM. when where to use when.

The Simple is that to show By The Table.

My ISAM InnoDB
Required full text Search Yes
Require Transactions Yes
frequent select queries Yes
frequent insert,update,delete Yes
Row Locking (multi processing on single table) Yes
Relational base design Yes

 

if there is any doubt which to use when. then MyISAM is your default choice.
you can also mix different table types in same database. Hence it  is recommended.
i think table has told the everthing. 🙂 and nothing more to explain.
Source From http://developer99.blogspot.com.au/2011/07/mysql-innodb-vs-myisam.html
SHARE :