PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.2Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/group-replication-network-partitioning.html
The group needs to achieve consensus whenever a change that needs to be replicated happens. This is the case for regular transactions but is also required for group membership changes and some internal messaging that keeps the group consistent.
https://dev.mysql.com/doc/refman/5.7/en/if.html
[ELSE statement_list] END IF The IF statement for stored programs implements a basic conditional construct. Note There is also an IF() function, which differs from the IF statement described here. The IF statement can have THEN, ELSE, and ELSEIF ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-innodb-cmp-per-index-table.html
The INNODB_CMP_PER_INDEX and INNODB_CMP_PER_INDEX_RESET tables provide status information on operations related to compressed InnoDB tables and indexes, with separate statistics for each combination of database, table, and index, to help you ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-innodb-cmp-table.html
The INNODB_CMP and INNODB_CMP_RESET tables provide status information on operations related to compressed InnoDB tables. The INNODB_CMP and INNODB_CMP_RESET tables have these columns: PAGE_SIZE The compressed page size in bytes. COMPRESS_OPS The ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-innodb-ft-deleted-table.html
The INNODB_FT_DELETED table stores rows that are deleted from the FULLTEXT index for an InnoDB table. 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 contains ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-profiling-table.html
Its contents correspond to the information produced by the SHOW PROFILE and SHOW PROFILES statements (see Section 13.7.5.30, “SHOW PROFILE Statement”). The table is empty unless the profiling session variable is set to 1. Note This table is ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-compression-internals.html
This section describes some internal implementation details about compression for InnoDB tables. The information presented here may be helpful in tuning for performance, but is not necessary to know for basic use of compression. Compression ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-data-encryption.html
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 ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-preload-buffer-pool.html
To reduce the warmup period after restarting the server, InnoDB saves a percentage of the most recently used pages for each buffer pool at server shutdown and restores these pages at server startup. The percentage of recently used pages that is ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-read-only-instance.html
You can query InnoDB tables where the MySQL data directory is on read-only media by enabling the --innodb-read-only configuration option at server startup. How to Enable To prepare an instance for read-only operation, make sure all the necessary ...