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/
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
