MySQL :: MySQL 9.7 Reference Manual

Search Results

Displaying 21 to 30 of 38 total results

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

When you use CREATE TABLE or ALTER TABLE for a table that has no BLOB or TEXT columns, you can force the table format to FIXED or DYNAMIC with the ROW_FORMAT table option. Two of them, fixed and dynamic format, are chosen automatically depending on ...

28.4.23 The INFORMATION_SCHEMA INNODB_TABLES Table

https://dev.mysql.com/doc/refman/9.7/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 ...

17.6.3.3 General Tablespaces

https://dev.mysql.com/doc/refman/9.7/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 ...

25.4.2.5 NDB Cluster mysqld Option and Variable Reference

https://dev.mysql.com/doc/refman/9.7/en/mysql-cluster-option-tables.html

ndb-default-column-format: Use this value (FIXED or DYNAMIC) by default for COLUMN_FORMAT and ROW_FORMAT options when creating or adding table columns. The following list includes command-line options, system variables, and status variables ...

10.4.7 Limits on Table Column Count and Row Size

https://dev.mysql.com/doc/refman/9.7/en/column-count-limit.html

This section describes limits on the number of columns in tables and the size of individual rows. Column Count Limits Row Size Limits Column Count Limits MySQL has hard limit of 4096 columns per table, but the effective maximum may be less for a ...

18.2.3.1 Static (Fixed-Length) Table Characteristics

https://dev.mysql.com/doc/refman/9.7/en/static-format.html

Creating a table having such columns with an explicit ROW_FORMAT clause does not raise an error or warning; the format specification is ignored. It is used when the table contains no variable-length columns (VARCHAR, VARBINARY, BLOB, or TEXT). Of ...

17.9.1.3 Tuning Compression for InnoDB Tables

https://dev.mysql.com/doc/refman/9.7/en/innodb-compression-tuning.html

\! ls -l data/test/big_table.ibd CREATE TABLE key_block_size_4 LIKE big_table; ALTER TABLE key_block_size_4 key_block_size=4 row_format=compressed; INSERT INTO key_block_size_4 SELECT * FROM big_table; commit; -- Check how much space is needed for a ... Most often, the internal optimizations described in InnoDB Data Storage and Compression ensure that the system runs well with compressed ...

17.6.1.5 Converting Tables from MyISAM to InnoDB

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

When you convert MyISAM tables that are large, frequently accessed, and hold vital data, investigate and consider the innodb_file_per_table and innodb_page_size variables, and the ROW_FORMAT and KEY_BLOCK_SIZE clauses of the CREATE TABLE statement.

6.5.4 mysqldump — A Database Backup Program

https://dev.mysql.com/doc/refman/9.7/en/mysqldump.html

The mysqldump client utility performs logical backups, producing a set of SQL statements that can be executed to reproduce the original database object definitions and table data. It dumps one or more MySQL databases for backup or transfer to ...

25.7.4 NDB Cluster Replication Schema and Tables

https://dev.mysql.com/doc/refman/9.7/en/mysql-cluster-replication-schema.html

If this becomes an issue, you may be able to conserve space by using an InnoDB tablespace for this table, changing its ROW_FORMAT to COMPRESSED, or both. ndb_apply_status Table ndb_binlog_index Table ndb_replication Table Replication in NDB Cluster ...

Displaying 21 to 30 of 38 total results