Mysql InnoDB TABLESPACE Set Up [一] －－using file

using file for the tablesspace:

To set up the InnoDB tablespace files, use the innodb_data_file_path option in the [mysqld] section of the my.cnf option file.

        innodb_data_file_path=datafile_spec1[;datafile_spec2]...

 full datafile_spec1 syntax: file_name:file_size[:autoextend[:max:max_file_size]]

        sample1: single tablespace:

[mysqld]

innodb_data_file_path=ibdata1:10M:autoextend

This setting configures a single 10MB data file named ibdata1 that is auto-extending. No location for the file is given, so the default is the MySQL data directory.

sample2: multi-tablespaces:

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

[mysqld]

innodb_data_file_path=ibdata1:50M;ibdata2:50M:autoextend

 

notice:

The autoextend attribute and those following can be used only for the last data file in the innodb_data_file_path line. The increment is 8MB at a time.