Introduction to Myisam and Innodb in Mysql

MyISAM ( -to create a MyISAM table, add ENGINE = MYISAM; at the end of cr...

-to create a MyISAM table, add ENGINE = MYISAM; at the end of create table script
-supports table locking (this is an issue when you need to backup the whole database)
-fast execution compared to innodb
-each table is stored in each own file
-has row limit
-produce more compact data
-use less storage space than innodb
-supports full-text search
-rollback is an issue

Innodb (
-supports row locking, which is good for huge amount of concurrent inserts/updates
-tables and indexes are stored in a tablespace (multiple files)
-efficient in processing large amount of data
-supports transaction (commit, rollback, etc)
-fast query algorithms but use more memory compared to MyISAM
-choose if transaction, primary and foreign key are important for your system
-I prefer this, because of referential integrity, transactions and rollbacks
-if your database is normalized and you have lots of foreign keys, there are tables
that are dependent on others, then you need this

Benchmark of Falcon, MyISAM and Innodb

Mysql Management Tools:
mysql gui tools -
sqlyog -
toad -


rdbms 3974828535482343706

Post a Comment Default Comments


Are you looking for freelancers in the Philippines? Get in touch.


If you like what I do, you can support this channel by buying me a coffee. I would be grateful for your contribution! Your donations will help me create more FREE online courses and learning materials for programmers and remote workers.