Configure InnoDB

• The InnoDB storage engine is enabled by default.
  • To disable the use of InnoDB tables, add the skip-innodb to the MySQL option file.

• If no InnoDB configuration options are specified, MySQL creates files in the MySQL data directory:
  • An auto-extending 10MB data file named ibdata1
  • Two 5MB log files named ib_logfile0 and ib_logfile1

• To set up the InnoDB tablespace files, use the innodb_data_file_path option in the [mysqld] section of the my.cnf option file.
  • To explicitly create a tablespace having the same characteristics as the default is as follows:

    [mysqld]
    

    innodb_data_file_path=ibdata1:10M:autoextend

• InnoDB creates tablespace files in the MySQL data directory by default.
  • To specify a location explicitly, use the innodb_data_home_dir option.
  • For example, to use two files named ibdata1 and ibdata2 but create them in the /ibdata directory, configure InnoDB like this:

    [mysqld]
    

    innodb_data_home_dir = /ibdata

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

• InnoDB does not create directories, so make sure the /ibdata directory exists before starting the server.
  • This is also true of any log file directories.
  • Use the Linux mkdir command to create any necessary directories.

Is there a sample InnoDB configuration file?

---

---

© 2007 John Michael Pierobon

Notes