Bruce, 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. Merry Christmas! Heikki ----- Original Message ----- From: "Bruce Ferrell" <[EMAIL PROTECTED]> Newsgroups: mailing.database.myodbc 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: http://lists.mysql.com/[EMAIL PROTECTED] > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
