tablespace


A data file that can hold data for one or more tables. The system tablespace contains the tables that make up the data dictionary, and by default holds all the other InnoDB tables. Turning on the innodb-file-per-table option allows newly created tables to each have their own tablespace, with a separate data file for each table.

Tablespaces created by the built-in InnoDB storage engine are upward compatible with the InnoDB Plugin. Tablespaces created by the InnoDB Plugin are downward compatible with the built-in InnoDB storage engine, if they use the Antelope file format.

See also Antelope.

See also Barracuda.

See also compressed row format.

See also data dictionary.

See also file-per-table.

See also ibdata file.

See also innodb-file-per-table.

See also system tablespace.

Retornar