From: Stefan Kuhn Date: November 20 2012 3:26pm Subject: Aw: Re: Change storage engine to InnoDB List-Archive: http://lists.mysql.com/mysql/228667 Message-Id: MIME-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 7bit > 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? I doubt that insert alone (which is what the dump restore does) is a good measurement for performance. The improvement might be (and, you could say, should be) more in the selects.