MySQL 8 Cookbook

Resizing the InnoDB system tablespace

The ibdata1 file in the data directory  is the default system tablespace. You can configure ibdata1 using the innodb_data_file_path and innodb_data_home_dir configuration options. The innodb_data_file_path configuration option is used to configure the InnoDB system tablespace data files. The value of innodb_data_file_path should be a list of one or more data file specifications. If you name two or more data files, separate them by semicolon (;) characters.

If you want a tablespace containing a fixed-size 50 MB data file named ibdata1 and a 50 MB auto-extending file named ibdata2 in the data directory, it can be configured like this:

shell> sudo vi /etc/my.cnf[mysqld]innodb_data_file_path=ibdata1:50M;ibdata2:50M:autoextend ...