MySQL Administrators Guide [Electronic resources] نسخه متنی

9.3 InnoDB in MySQL 3.23

Beginning with MySQL 4.0, InnoDB is enabled by default, so the following information applies only to MySQL 3.23.Section 2.2.5, "Installing MySQL on Other Unix-Like Systems," and Section 4.1.2, "The mysqld-max Extended MySQL Server."Section 2.3, "MySQL Installation Using a Source Distribution."Section 9.4, "InnoDB Configuration.")

In MySQL 3.23, you must specify at the minimum an innodb_data_file_path value to configure the InnoDB data files. For example, to configure InnoDB to use a single 10MB auto-extending data file, place the following setting in the [mysqld] section of your option file:

[mysqld]
innodb_data_file_path=ibdata1:10M:autoextend

InnoDB will create the ibdata1 file in the MySQL data directory by default. To specify the location explicitly, specify an innodb_data_home_dir setting. See Section 9.4, "InnoDB Configuration."