CODEWITHSUNDEEP
mysqlinnodb
nasgor jancuk
nasgor jancuk

Reputation: 11

InnoDB restore database is very slow

I have Mysql installed version 5.1.49-1ubuntu8.1 (with default InnoDB without any modification)

When using InnoDB, the mysqldump and read performance is comparable to MyISAM, but restore database is very slow.

When trying to install Drupal on blank database also take too long

Other than default-storage-engine = innodb, Is there anything I need to do before use InnoDB?

Upvotes: 1

Views: 1364

Answers (1)

Sujoy Gupta
Sujoy Gupta

Reputation: 1474

  1. You should disable keys on the tables while restoring. This is the default behavior with the dumps generated from mysqldump. What is the command line you are using for dumping data?

  2. You should dump the tables in the order of the primary key.

Upvotes: 1

Related Questions