PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 296.6Kb
Man Pages (Zip)
- 402.0Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/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 ...
https://dev.mysql.com/doc/refman/8.0/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 ...
https://dev.mysql.com/doc/refman/8.0/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 ...
https://dev.mysql.com/doc/refman/8.0/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 ...
https://dev.mysql.com/doc/refman/8.0/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 ...
https://dev.mysql.com/doc/refman/8.0/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] ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-innodb-tables-table.html
row *************************** TABLE_ID: 1064 NAME: test/t1 FLAG: 33 N_COLS: 6 SPACE: 3 ROW_FORMAT: Dynamic ZIP_PAGE_SIZE: 0 SPACE_TYPE: Single INSTANT_COLS: 0 TOTAL_ROW_VERSIONS: 3 Notes You must have the PROCESS privilege to query this table. For ...
https://dev.mysql.com/doc/refman/8.0/en/general-tablespaces.html
For a general tablespace to contain compressed tables (ROW_FORMAT=COMPRESSED), the FILE_BLOCK_SIZE option must be specified, and the FILE_BLOCK_SIZE value must be a valid compressed page size in relation to the innodb_page_size value. mysql> CREATE ... A general tablespace is a shared InnoDB tablespace that is created using CREATE TABLESPACE ...
https://dev.mysql.com/doc/refman/8.0/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 likes SHOW TABLES, but provides a lot of information about each non-TEMPORARY ...
https://dev.mysql.com/doc/refman/8.0/en/server-system-variables.html
require_row_format Introduced 8.0.19 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. The MySQL server ...