PDF (US Ltr)
- 35.0Mb
PDF (A4)
- 35.1Mb
Man Pages (TGZ)
- 255.0Kb
Man Pages (Zip)
- 359.9Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-programs-ndb-desc.html
Three of the table properties that can be set using NDB_TABLE comments embedded in CREATE TABLE and ALTER TABLE statements are also visible in ndb_desc output. You can check that the ALTER TABLE statement has the desired effect using SHOW CREATE ...
https://dev.mysql.com/doc/refman/5.7/en/replication-options-replica.html
Only statements involving tables are affected, not statements such as CREATE DATABASE, DROP DATABASE, and ALTER DATABASE. If the table name pattern is %, it matches any table name and the option also applies to database-level statements (CREATE ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-data-encryption.html
mysql> CREATE TABLE t1 (c1 INT) ENCRYPTION='Y'; To enable encryption for an existing file-per-table tablespace, specify the ENCRYPTION option in an ALTER TABLE statement. mysql> ALTER TABLE t1 ENCRYPTION='Y'; To disable encryption for file-per-table ...About Data-at-Rest Encryption Encryption Prerequisites Enabling File-Per-Table Tablespace Encryption Master Key Rotation Encryption and Recovery Exporting Encrypted Tablespaces Encryption and Replication Identifying Encrypted Tablespaces Encryption Usage Notes Encryption Limitations About Data-at-Rest Encryption InnoDB uses a two tier encryption key architecture, consisting of a master encryption key and tablespace ...
https://dev.mysql.com/doc/refman/5.7/en/memory-storage-engine.html
The value in effect for CREATE TABLE, or a subsequent ALTER TABLE or TRUNCATE TABLE, is the value used for the life of the table. To free up the memory used by deleted rows, use ALTER TABLE ENGINE=MEMORY to force a table rebuild. The MEMORY storage ...A typical use case for the MEMORY engine involves these characteristics: Operations involving transient, non-critical data such as session management or ...
https://dev.mysql.com/doc/refman/5.7/en/analyze-table.html
ANALYZE TABLE is supported for partitioned tables, and you can use ALTER TABLE ... ANALYZE PARTITION to analyze one or more partitions; for more information, see Section 13.1.8, “ALTER TABLE Statement”, and Section 22.3.4, “Maintenance of ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-innodb-sys-tables-table.html
Tables assigned to the system tablespace using CREATE TABLE or ALTER TABLE TABLESPACE=innodb_system have a SPACE_TYPE of General. The INNODB_SYS_TABLES table provides metadata about InnoDB tables, equivalent to the information from the SYS_TABLES ...The number reported includes three hidden columns that are created by InnoDB (DB_ROW_ID, DB_TRX_ID, and ...
https://dev.mysql.com/doc/refman/5.7/en/partitioning-maintenance.html
You can use a number of extensions to ALTER TABLE for performing operations of this type on one or more partitions directly, as described in the following list: Rebuilding partitions. If you have deleted a large number of rows from a partition or if ... A number of table and partition maintenance tasks can be carried out using SQL statements intended for such purposes on partitioned tables in MySQL ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-files-table.html
For NDB: The name of an UNDO log file created by CREATE LOGFILE GROUP or ALTER LOGFILE GROUP, or of a data file created by CREATE TABLESPACE or ALTER TABLESPACE. This is the same value that was used in the INITIAL_SIZE clause of the CREATE LOGFILE ... The FILES table provides information about the files in which MySQL tablespace data is ...For additional information specific to InnoDB, see InnoDB ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-information-schema-fulltext_index-tables.html
INNODB_FT_BEING_DELETED: Provides a snapshot of the INNODB_FT_DELETED table; it is used only during an OPTIMIZE TABLE maintenance operation. When OPTIMIZE TABLE is run, the INNODB_FT_BEING_DELETED table is emptied, and DOC_ID values are removed from ...INNODB_FT_INDEX_CACHE: Provides token information about newly inserted rows in a FULLTEXT ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-analyze-table-complexity.html
To set the number of pages sampled for an individual table, use the STATS_SAMPLE_PAGES option with CREATE TABLE or ALTER TABLE. ANALYZE TABLE complexity for InnoDB tables is dependent on: The number of pages sampled, as defined by ...Note ...