List:General Discussion« Previous MessageNext Message »
From:Dan Nelson Date:March 13 2001 3:37pm
Subject:Re: Innobase in MySQL
View as plain text  
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
Thread
Re: Innobase in MySQLHeikki Tuuri12 Mar
  • Re: Innobase in MySQLJoshua J. Kugler12 Mar
RE: Innobase in MySQLHeikki Tuuri12 Mar
RE: Innobase in MySQLHeikki Tuuri12 Mar
Re: Innobase in MySQLHeikki Tuuri12 Mar
  • Re[2]: Innobase in MySQLPeter Zaitsev13 Mar
    • Re: Innobase in MySQLDan Nelson13 Mar
      • Re[2]: Innobase in MySQLPeter Zaitsev14 Mar
        • Re[2]: Innobase in MySQLMichael Widenius14 Mar
          • Re[3]: Innobase in MySQLPeter Zaitsev16 Mar
            • Re[3]: Innobase in MySQLMichael Widenius16 Mar
    • Re: Re[2]: Innobase in MySQLWilliam R. Mussatto13 Mar
  • Re: Innobase in MySQLGreg Cope17 Mar
    • Re[2]: Innobase in MySQLPeter Zaitsev18 Mar
  • Re: Innobase in MySQLGreg Cope18 Mar
    • Re[2]: Innobase in MySQLPeter Zaitsev18 Mar
Re: Innobase in MySQLAndreas Vierengel17 Mar
  • Re[2]: Innobase in MySQLPeter Zaitsev18 Mar
Re: Innobase in MySQLHeikki Tuuri17 Mar
Re: Innobase in MySQLAndreas Vierengel18 Mar
Re: Re[2]: Innobase in MySQLAndreas Vierengel18 Mar