From: Mitchell Maltenfort Date: April 3 2010 12:50am Subject: Re: MyISAM better than innodb for large files? List-Archive: http://lists.mysql.com/mysql/221132 Message-Id: MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable >> You want the crash safety and data integrity that comes with InnoDB. =A0= Even >> more so as your dataset grows. =A0It's performance is far better than my= isam >> tables for most OLTP users, and as your number of concurrent readers and >> writers grows, the improvement in performance from using innodb over >> myisam becomes more pronounced. > > His scenario is "perhaps updated once a year", though, so crash recovery = and > multiple writer performance is not important. And the concurrent reader and writer number is set at one, unless I undergo mitosis or something.