PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 296.5Kb
Man Pages (Zip)
- 401.9Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/group-replication-enterprise-backup.html
For example: s3> rm -rf /var/lib/mysql/* If the system variables innodb_data_home_dir, innodb_log_group_home_dir, and innodb_undo_directory point to any directories other than the data directory, they should also be made empty; otherwise, the ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-functions-for-maximum-consensus.html
Default value is 10, valid values are integers in the range of 10 to 200. The following functions enable you to inspect and configure the maximum number of consensus instances that a group can execute in parallel.
https://dev.mysql.com/doc/refman/8.0/en/information-schema-innodb-ft-index-cache-table.html
The INNODB_FT_INDEX_CACHE table provides token information about newly inserted rows in a FULLTEXT index. Before querying it, set the value of the innodb_ft_aux_table system variable to the name (including the database name) of the table that ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-innodb-ft-index-table-table.html
The INNODB_FT_INDEX_TABLE table provides information about the inverted index used to process text searches against the FULLTEXT index of an InnoDB table. Before querying it, set the value of the innodb_ft_aux_table system variable to the name ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-innodb-temp-table-info-table.html
It does not provide information about internal InnoDB temporary tables used by the optimizer. Example mysql> CREATE TEMPORARY TABLE t1 (c1 INT PRIMARY KEY) ENGINE=INNODB; mysql> SELECT * FROM INFORMATION_SCHEMA.INNODB_TEMP_TABLE_INFO\G ... The ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-autocommit-commit-rollback.html
$> mysql test mysql> CREATE TABLE customer (a INT, b CHAR (20), INDEX (a)); Query OK, 0 rows affected (0.00 sec) mysql> -- Do a transaction with autocommit turned on. mysql> START TRANSACTION; Query OK, 0 rows affected (0.00 sec) mysql> INSERT INTO ...If autocommit mode is enabled, each SQL statement forms a single transaction on its ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-compression-tuning.html
Most often, the internal optimizations described in InnoDB Data Storage and Compression ensure that the system runs well with compressed data. When you are ready to conduct long-term testing and put compressed tables into production, see Section ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-data-encryption.html
Warning For encryption key management, the component_keyring_file and component_keyring_encrypted_file components, and the keyring_file and keyring_encrypted_file plugins are not intended as a regulatory compliance solution. mysql> CREATE TABLE t1 ... InnoDB supports data-at-rest encryption for file-per-table tablespaces, general tablespaces, the mysql system tablespace, redo logs, and undo ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-file-per-table-tablespaces.html
Tables created in file-per-table tablespaces can be backed up or restored quickly using MySQL Enterprise Backup, without interrupting the use of other InnoDB tables. The scan is performed with a broad internal lock, which may delay other operations.
https://dev.mysql.com/doc/refman/8.0/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. innodb_optimize_fulltext_only changes the way the OPTIMIZE TABLE statement operates on InnoDB tables, and is ...When OPTIMIZE TABLE is run, the INNODB_FT_BEING_DELETED table is emptied, and DOC_ID values are removed from the INNODB_FT_DELETED ...