Resizing the InnoDB system tablespace

The ibdata1 file in the data directory  is the default system tablespace. You can configureibdata1 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

If the ibdata files become so big, especially when innodb_file_per_table is not enabled and the disk becomes full, you might want to add another data file on another disk.

How to do it...

Resizing the InnoDB system tablespace is one...