InnoDB 加载新的tablespace 的方法以及注意事项。

例如原先配置如下：

innodb_data_home_dir =
innodb_data_file_path = /ibdata/ibdata1:10M:autoextend

在加载的时候，必须将目前的原有的ibdata1的真实大小写入配置中，然后后面再跟新的要创建的tablespace。参考如下手册原话

Suppose that this data file, over time, has grown to 988MB. Here is the configuration line after modifying the original data file to not be auto-extending and adding another auto-extending data file:

新的添加ibdata2 tablespace 配置如下

innodb_data_home_dir =
innodb_data_file_path = /ibdata/ibdata1:988M;/disk2/ibdata2:50M:autoextend

 

When you add a new file to the tablespace configuration, make sure that it does not exist. InnoDB will create and initialize the file when you restart the server.