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]
