Re: Innobase in MySQL

[Dan Nelson]

In the last episode (Mar 13), Peter Zaitsev said:
> Well guys mysqldump have one serious problem - the speed.
> 
> The backup speed is quite upsetting and loads system much, but the
> worst thing is recovery speed.
> In my case the data is added in realtime - most queries are inserts
> which utilize system quite hard. So to recover data I have gathered
> for a month it will take about 1 week to feed mysql with mysqldump
> output, even with extended inserts. So at least this is not complete
> solution.

Make sure you remove all your indexes during the load; that can really
slow down inserts.

-- 
	Dan Nelson
	dnelson@stripped