From: Lorenzo Milesi
Date: November 20 2012 3:09pm
Subject: Re: Change storage engine to InnoDB
List-Archive: http://lists.mysql.com/mysql/228666
Message-Id: <1822232417.26875.1353424191840.JavaMail.root@yetopen.it>
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit

> InnoDB is _often_ faster than MyISAM.  

I restored a 700M gzipped dump on MyISAM tables and it took 20 minutes.
I then replaced the CREATE TABLE statements to use InnoDB, the same restore on the same machine took 105 minutes. 
Not a big improvement, isn't it?
Am I missing something?

Using 5.5.28.

Thanks
-- 
Lorenzo Milesi - lorenzo.milesi@stripped

GPG/PGP Key-Id: 0xE704E230 - http://keyserver.linux.it