Mikel,
what about playing with the autocommit setting?
I guess you use the mysql client for the restore, so you could set
autocommit off and perform a commit yourself every 10000 rows or so.
In our case this boosts recovery by a factor of 5 to 10.
Regards,
Frank.
Mikel - schrieb:
>
> I will review the log files, I guess that I set the correct size of my
> innodb log files, but I'll check it out again.
>
> Best Regards
>
> Mikel
>
> P.S. How about of InnoDB Hot Backup? does it do much faster?
>
> >From: "Heikki Tuuri" <[EMAIL PROTECTED]>
> >To: <[EMAIL PROTECTED]>
> >Subject: Re: Too slow recovering mysqldump files
> >Date: Mon, 19 Jan 2004 22:44:50 +0200
> >
> >Mikel,
> >
> >have you set the size of the InnoDB log files as recommended in the manual?
> >
> >Best regards,
> >
> >Heikki Tuuri
> >Innobase Oy
> >http://www.innodb.com
> >Foreign keys, transactions, and row level locking for MySQL
> >InnoDB Hot Backup - a hot backup tool for InnoDB which also backs up MyISAM
> >tables
> >
> >Order MySQL technical support from https://order.mysql.com/
> >
> >----- Original Message -----
> >From: ""Mikel -"" <[EMAIL PROTECTED]>
> >Newsgroups: mailing.database.myodbc
> >Sent: Monday, January 19, 2004 7:25 PM
> >Subject: Too slow recovering mysqldump files
> >
> >
> > > Hi list, does anyone know a faster way to recover a mysqldump file
> >cause
> > > When I recovered one dump file it took 26 hours ! to finish, I think
> >it's
> > > too slow.
> > > Thnx in advanced, greetings
> > >
> > > MySQL server 3.23.58
> > > RedHat 7.3
> > > 4GB RAM
> > > 2 scsi disk via fiber channel (333GB each)
> > > 2 processor Xeon 1.6GHZ
> > >
> > > dump file size: 2.5 GB
> > > ibdata: 11GB
> > > innodb tables
> > > key_buffer=850M
> > > innodb_buffer_pool_size=850M
> > > table_cache=1500
> > >
> > > _________________________________________________________________
> > > MSN. Más Útil Cada Día http://www.msn.es/intmap/
> > >
> > >
> > > --
> > > MySQL General Mailing List
> > > For list archives: http://lists.mysql.com/mysql
> > > To unsubscribe:
> >http://lists.mysql.com/[EMAIL PROTECTED]
> > >
> >
> >
> >--
> >MySQL General Mailing List
> >For list archives: http://lists.mysql.com/mysql
> >To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
> >
>
> _________________________________________________________________
> Charla con tus amigos en línea mediante MSN Messenger:
> http://messenger.microsoft.com/es
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
--
Dr. Frank Ullrich, DBA Netzwerkadministration
Heise Zeitschriften Verlag GmbH & Co KG, Helstorfer Str. 7, D-30625
Hannover
E-Mail: [EMAIL PROTECTED]
Phone: +49 511 5352 587; FAX: +49 511 5352 538
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
