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...