开发者

InnoDB restore database is very slow

开发者 https://www.devze.com 2023-02-16 03:23 出处:网络
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

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-st开发者_开发问答orage-engine = innodb, Is there anything I need to do before use InnoDB?


  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.

0

精彩评论

暂无评论...
验证码 换一张
取 消