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
If the ibdata files become so big, especially when innodb_file_per_table is not enabled and the disk becomes...