On Thu, Sep 11, 2003 at 04:27:10PM -0400, Brent Baisley wrote:
> Have tried using the --opt parameter on mysqldump? This is supposed
> optimize the dump speed and create a file optimized for reloading. I
> haven't played with this option, so I don't know what kind of
> difference it makes.
It makes a very big difference. --opt tells mysqldump to use MySQL's
extended insert syntax, so you're insering the data for many rows with
a single query. That can often give you a speed boost of 10x or more.
Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo!
<Jeremy@stripped> | http://jeremy.zawodny.com/
MySQL 4.0.15-Yahoo-SMP: up 4 days, processed 168,707,245 queries (449/sec. avg)