MySQL :: MySQL 9.7 Reference Manual

Search Results

Displaying 11 to 20 of 38 total results

https://dev.mysql.com/doc/refman/9.7/en/show-create-table.html

For example, when changing the storage engine from InnoDB to MyISAM, options specific to InnoDB, such as ROW_FORMAT=COMPACT, are retained, as shown here: mysql> CREATE TABLE t1 (c1 INT PRIMARY KEY) ROW_FORMAT=COMPACT ENGINE=InnoDB; mysql> ALTER ...

10.4.1 Optimizing Data Size

https://dev.mysql.com/doc/refman/9.7/en/data-size.html

To use a row format other than DYNAMIC, configure innodb_default_row_format, or specify the ROW_FORMAT option explicitly in a CREATE TABLE or ALTER TABLE statement. With ROW_FORMAT=REDUNDANT, CHAR(N) occupies N × the maximum byte length of the ...

17.6.1.1 Creating InnoDB Tables

https://dev.mysql.com/doc/refman/9.7/en/using-innodb-tables.html

The row format of a table can also be defined explicitly using the ROW_FORMAT table option in a CREATE TABLE or ALTER TABLE statement. row *************************** Name: t1 Engine: InnoDB Version: 10 Row_format: Dynamic Rows: 0 Avg_row_length: 0 ... InnoDB tables are created using the CREATE TABLE statement; for example: CREATE TABLE t1 (a INT, b CHAR (20), PRIMARY KEY (a)) ENGINE=InnoDB; The ENGINE=InnoDB clause is not required when InnoDB is defined as the default storage engine, which it is by ...

15.1.11 ALTER TABLE Statement

https://dev.mysql.com/doc/refman/9.7/en/alter-table.html

To change the InnoDB table to use compressed row-storage format: ALTER TABLE t1 ROW_FORMAT = COMPRESSED; The ENCRYPTION clause enables or disables page-level data encryption for an InnoDB table. ALTER TABLE tbl_name [alter_option [, alter_option] ...

28.3.44 The INFORMATION_SCHEMA TABLES Table

https://dev.mysql.com/doc/refman/9.7/en/information-schema-tables-table.html

The actual row format of the table is reported in the ROW_FORMAT column. The information_schema_stats_expiry system variable defines the period of time before cached table statistics expire. If there are no cached statistics or statistics have ...

28.4.24 The INFORMATION_SCHEMA INNODB_TABLESPACES Table

https://dev.mysql.com/doc/refman/9.7/en/information-schema-innodb-tablespaces-table.html

ROW_FORMAT The tablespace row format (Compact or Redundant, Dynamic or Compressed, or Undo). There is no way to determine from this flag information if the tablespace row format is Redundant or Compact, which is why one of the possible ROW_FORMAT ...

17.6.1.3 Importing InnoDB Tables

https://dev.mysql.com/doc/refman/9.7/en/innodb-table-import.html

If a ROW_FORMAT option is not defined explicitly in the table definition or ROW_FORMAT=DEFAULT is used, the innodb_default_row_format setting must be the same on the source and destination instances. This section describes how to import tables ...

15.7.7.39 SHOW TABLE STATUS Statement

https://dev.mysql.com/doc/refman/9.7/en/show-table-status.html

The actual row format of the table is reported in the Row_format column. SHOW TABLE STATUS [{FROM | IN} db_name] [LIKE 'pattern' | WHERE expr] SHOW TABLE STATUS works like SHOW TABLES, but provides a lot of information about each non-TEMPORARY ...

7.1.8 Server System Variables

https://dev.mysql.com/doc/refman/9.7/en/server-system-variables.html

require_row_format System Variable require_row_format Scope Session Dynamic Yes SET_VAR Hint Applies No Type Boolean Default Value OFF This variable is for internal server use by replication and mysqlbinlog. show_create_table_verbosity Command-Line ... The MySQL server maintains many system variables that affect its ...

25.4.3.9 MySQL Server Options and Variables for NDB Cluster

https://dev.mysql.com/doc/refman/9.7/en/mysql-cluster-options-variables.html

--ndb-default-column-format=[FIXED|DYNAMIC] Command-Line Format --ndb-default-column-format={FIXED|DYNAMIC} System Variable ndb_default_column_format Scope Global Dynamic Yes SET_VAR Hint Applies No Type Enumeration Default Value FIXED Valid Values ... This section provides information about MySQL server options, server and status variables that are specific to NDB ...

Displaying 11 to 20 of 38 total results