From: Dan Nelson
Date: October 23 2003 5:15pm
Subject: Re: Innodb vs myisam
List-Archive: http://lists.mysql.com/mysql/152266
Message-Id: <20031023171551.GE36611@dan.emsphone.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii

In the last episode (Oct 24), Chris Nolan said:
> The answer is actually quite simple!
> 
> There are a few reasons:
> 
> 1. Features.
> 
> Each table type has something over the other. While InnoDB has transactions, 
> foreign keys, hot backup capabilities, consistant read and better write
> concurrency (for many situations), MyISAM has FULLTEXT indexes, the
> option of having secondary AUTO_INCREMENT columns, OpenGIS
> data storage (in 4.1 and above) as well as slighly simplified offline backups. 
> Additionally, MyISAM has lower disk space requirements for any given amount 
> of data.

MyISAM also lets you put indexes and tables onto separate disks for
more performance, and supports a compressed read-only format.

-- 
	Dan Nelson
	dnelson@stripped