MyISAM vs Innodb – Quick comparison Table:

Storage Engine:-
Code:
mysql -uroot -p
Password:
mysql> show engines;

This should provide a list of supported storage engines for your server. The standard engines supported by MySQL are:

  • MyISAM
  • InnoDB
  • MERGE
  • MEMORY (HEAP)
  • BDB (BerkeleyDB)
  • EXAMPLE
  • ARCHIVE
  • CSV
  • BLACKHOLE
  • ISAM

MyISAM vs Innodb – Quick comparison Table:

MyISAM Innodb
Not *ACID compliant and non-transactional *ACID compliant and hence fully transactional with ROLLBACK andCOMMIT and support for Foreign Keys
MySQL 5.0 Default Engine Rackspace Cloud Default Engine
Offers Compression Offers Compression
Requires full repair/rebuild of indexes/tables Auto recovery from crash via replay of logs
Changed Db pages written to disk instantly Dirty pages converted from random to sequential before commit and flush to disk
No ordering in storage of data Row data stored in pages in PK order
Table level locking Row level locking
Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s