例如原先配置如下:
innodb_data_home_dir =
innodb_data_file_path = /ibdata/ibdata1:10M:autoextend
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
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.
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/25267658/viewspace-687919/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/25267658/viewspace-687919/