how to fast copy a large innodb table
how to fast copy mysql innodb table size开发者_JAVA百科 8.4G?
the fast way is to copy the files but to do this in innodb engine you need to use
Per-Table Tablespaces
Using multiple tablespaces can be beneficial to users who want to move specific tables to separate physical disks or who wish to restore backups of single tables quickly without interrupting the use of other InnoDB tables.
精彩评论