Home / Backup / MySQL / Tips / MySQL Restore slow

MySQL Restore slow

December 04, 2007 Backup , MySQL , Tips Edit

I notice dump restore is really slow and I tried to work on some parameters.

The following parameters afftect in a positive manner:

innodb_flush_log_at_trx_commit = 0

bulk_insert_buffer_size = 64

Vittorio Pavesi