|List:||General Discussion||« Previous MessageNext Message »|
|From:||Stefan Kuhn||Date:||November 20 2012 3:26pm|
|Subject:||Aw: Re: Change storage engine to InnoDB|
|View as plain text|
> 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.
|• Aw: Re: Change storage engine to InnoDB||Stefan Kuhn||20 Nov|
|• Re: Aw: Re: Change storage engine to InnoDB||Lorenzo Milesi||20 Nov|