MySQL Manual
7 MySQL Table Types
- 7.5
InnoDBTables- 7.5.1 InnoDB Tables Overview
- 7.5.2 InnoDB in MySQL Version 3.23
- 7.5.3 InnoDB Startup Options
- 7.5.4 Creating InnoDB Tablespace
- 7.5.5 Creating InnoDB Tables
- 7.5.6 Adding and Removing InnoDB Data and Log Files
- 7.5.7 Backing up and Recovering an InnoDB Database
- 7.5.8 Moving an InnoDB Database to Another Machine
- 7.5.9 InnoDB Transaction Model
- 7.5.10 Implementation of Multi-versioning
- 7.5.11 Table and Index Structures
- 7.5.12 File Space Management and Disk I/O
- 7.5.13 Error Handling
- 7.5.14 Restrictions on InnoDB Tables
- 7.5.15 InnoDB Change History
- 7.5.16
InnoDBContact Information
7.5.6 Adding and Removing InnoDB Data and Log Files
From version 3.23.50 and 4.0.2 you can specify the last InnoDB datafile
to autoextend. Alternatively, you can increase to your tablespace
by specifying an additional datafile. To do this you have to shut down
the MySQL server, edit the `my.cnf' file adding a new datafile
to innodb_data_file_path, and then start the MySQL server again.
Currently you cannot remove a datafile from InnoDB. To decrease the size of your database you have to use `mysqldump' to dump all your tables, create a new database, and import your tables to the new database.
If you want to change the number or the size of your InnoDB log files, you have to shut down MySQL and make sure that it shuts down without errors. Then copy the old log files into a safe place just in case something went wrong in the shutdown and you will need them to recover the database. Delete then the old log files from the log file directory, edit `my.cnf', and start MySQL again. InnoDB will tell you at the startup that it is creating new log files.
