InnoDB in most cases uses some more CPU time than MyISAM. But the main
performance disadvantage of InnoDB is that tables in the InnoDB format
typically require 50 % - 300 % more disk space than MyISAM format tables.
Marko Mäkelä of Innobase Oy is writing a new InnoDB table format which will
reduce space usage substantially, maybe 30 % - 80 %. The new InnoDB table
format will probably be available in some MySQL-5.0.x release. We will
probably offer some PACK_KEYS=1 option in CREATE TABLE, so that the user can
control the tradeoff between using more CPU time to compress/uncompress
data, or using more disk bandwidth. You could find this from the TODO at
www.innodb.com, but unfortunately our web host has technical problems, and
the website is not accessible at the moment.
----- Original Message -----
From: "Bruce Ferrell" <bferrell@stripped>
Sent: Thursday, December 25, 2003 12:05 PM
Subject: relative performance between innodb and myisam
> we have a bit of a debate going on at work. The gist of it is that
> there is a a performance hit when using innodb tables vs myisam tables.
> I understand the for a given dataload innodb will be larger, but is
> there a performance hit as well? If so, as a rough comparison, how much
> of a hit is it?
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: