Thanks again Heikki,
Mikel
P.S. Do you recommend the innodb hot backup tool, does it do faster than the other options, or is a combination of both?
From: "Heikki Tuuri" <[EMAIL PROTECTED]> To: "Mikel -" <[EMAIL PROTECTED]> CC: <[EMAIL PROTECTED]> Subject: Re: Too slow recovering mysqldump files Date: Wed, 21 Jan 2004 05:10:27 +0200
Mikel,
it is apparently disk-bound.
I recommend setting innodb_buffer_pool_size as high as 1.4 GB during such big import. Adjust innodb_log_file_size accordingly, and make key_buffer smaller during the big import.
Help is coming: Marko Mäkelä is writing a compressed InnoDB table format, which can squeeze a typical table to 1 / 4 the size of a normal InnoDB table. I believe the compressed format will be available in October 2004.
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]> To: <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Wednesday, January 21, 2004 12:32 AM Subject: Re: Too slow recovering mysqldump files
> Here we are my options: > > set-variable = innodb_log_file_size=150M > set-variable = innodb_log_buffer_size=8M > > I follow the example that came here: > "http://www.mysql.com/doc/en/InnoDB_start.html"; > > Greetings and best regards > > Mikel > > > >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] > > > > _________________________________________________________________ > MSN. Más Útil Cada Día http://www.msn.es/intmap/ >
_________________________________________________________________
MSN Fotos: la forma más fácil de compartir e imprimir fotos. http://photos.msn.es/support/worldwide.aspx
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
