Add InnoDB Data Files

• The easiest way to increase the size of the InnoDB tablespace is to configure it from the beginning to be auto-extending.
  • Specify the autoextend attribute for the last data file in the tablespace definition.

• InnoDB increases the size of the file automatically in 8MB increments when it runs out of space.
  • The increment size can be changed by setting the value of the innodb_autoextend_increment system variable, which is measured in MB.

• Alternatively, the size of the tablespace can increased by adding another data file.
  • When adding a new file to the tablespace configuration, make sure that it does not exist.
  • Here is the procedure.
    • Shut down the MySQL server.
    • Change the tablespace configuration to add a new data file to the end of innodb_data_file_path.
    • Restart the server.
      • InnoDB will create and initialize the file.

How do I remove InnoDB data files?

---

---

© 2007 John Michael Pierobon

Notes