PDF (US Ltr)
- 43.2Mb
PDF (A4)
- 43.3Mb
Man Pages (TGZ)
- 296.3Kb
Man Pages (Zip)
- 401.7Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/generated-column-index-optimizations.html
For example: CREATE TABLE t1 (f1 INT, gc INT AS (f1 + 1) STORED, INDEX (gc)); The generated column, gc, is defined as the expression f1 + 1. For example, gc INT AS (f1) STORED consists only of a column reference, so indexes on gc are not considered.
https://dev.mysql.com/doc/refman/8.0/en/information-schema-columns-table.html
The related ST_GEOMETRY_COLUMNS table provides information about table columns that store spatial data. The value is YES if NULL values can be stored in the column, NO if not. It contains the column SRID value that indicates the spatial reference ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-files-table.html
The FILES table provides information about the files in which MySQL tablespace data is stored. In NDB Cluster, this table also provides information about the files in which NDB Cluster Disk Data tables are stored. NDBCLUSTER stores a copy of each ...For additional information specific to InnoDB, see InnoDB Notes, later in this section; for additional information specific to NDB Cluster, see NDB ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-partitions-table.html
AVG_ROW_LENGTH The average length of the rows stored in this partition or subpartition, in bytes. DATA_LENGTH The total length of all rows stored in this partition or subpartition, in bytes; that is, the total number of bytes stored in the partition ...Each row in this table corresponds to an individual partition or subpartition of a partitioned ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-compression-tuning.html
For those cases where there are long rows, the use of compression might result in long column values being stored “off-page”, as discussed in DYNAMIC Row Format. When you compress the data in the application and store the results in a compressed ... Most often, the internal optimizations described in InnoDB Data Storage and Compression ensure that the system runs well with compressed ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-information-schema-fulltext_index-tables.html
INNODB_FT_DELETED: Stores rows that are deleted from the FULLTEXT index for an InnoDB table. To avoid expensive index reorganization during DML operations, information about newly deleted records is stored separately, filtered out of search results ...INNODB_FT_BEING_DELETED: Provides a snapshot of the INNODB_FT_DELETED table; it is used only during an OPTIMIZE TABLE maintenance ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-memcached-replication.html
set test1 10 0 1 t1 STORED On the source server, check that the record was inserted into the demo_test table. set test1 10 0 2 new STORED The update is replicated to the replica server (notice that the cas value is also updated). Escape character is ... Because the daemon_memcached plugin supports the MySQL binary log, source server through the memcached interface can be replicated for backup, balancing intensive read workloads, and high ...
https://dev.mysql.com/doc/refman/8.0/en/keyring-encrypted-file-plugin.html
The keyring_encrypted_file keyring plugin stores keyring data in an encrypted, password-protected file local to the server host. To ensure that keys are flushed only when the correct keyring storage file exists, keyring_encrypted_file stores a ...
https://dev.mysql.com/doc/refman/8.0/en/keyring-system-variables.html
For example, InnoDB uses the file to store the master key used to decrypt the data in tables that use InnoDB tablespace encryption; see Section 17.13, “InnoDB Data-at-Rest Encryption”. keyring_hashicorp_commit_store_path Introduced 8.0.18 System ...These variables are unavailable unless the appropriate keyring plugin is installed (see Section 8.4.4.3, “Keyring Plugin ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-backup-concepts.html
The data actually stored in the database tables at the time that the backup was made Transaction log. A sequential record telling how and when data was stored in the database Each of these parts is saved on all nodes participating in the backup. A ...