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

    技术2022-05-20  56

    例如原先配置如下: 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.


    最新回复(0)