Search Results
https://dev.mysql.com/doc/refman/8.4/en/group-replication-performance-xcom-cache.html
The group communication engine for Group Replication (XCom, a Paxos variant) includes a cache for messages (and their metadata) exchanged between the group members as a part of the consensus protocol. Among other functions, the message cache is ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-responses-failure-expel.html
You can use the group_replication_member_expel_timeout system variable to allow additional time between the creation of a suspicion and the expulsion of the suspect member. A suspicion is created when one server does not receive messages from ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-optimization.html
Applications that monitor databases may make frequent use of INFORMATION_SCHEMA tables. To write queries for these tables most efficiently, use the following general guidelines: Try to query only INFORMATION_SCHEMA tables that are views on data ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-statistics-table.html
The information_schema_stats_expiry system variable defines the period of time before cached table statistics expire. If there are no cached statistics or statistics have expired, statistics are retrieved from storage engines when querying table ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-tables-table.html
The information_schema_stats_expiry system variable defines the period of time before cached table statistics expire. If there are no cached statistics or statistics have expired, statistics are retrieved from storage engines when querying table ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-best-practices.html
Specify a primary key for every table using the most frequently queried column or columns, or an auto-increment value if there is no obvious primary key. Use joins wherever data is pulled from multiple tables based on identical ID values from those ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-change-buffer.html
The change buffer is a special data structure that caches changes to secondary index pages when those pages are not in the buffer pool. The buffered changes, which may result from INSERT, UPDATE, or DELETE operations (DML), are merged later when ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-information-schema-innodb_cmp.html
The INNODB_CMP and INNODB_CMP_RESET tables provide status information about operations related to compressed tables, which are described in Section 17.9, “InnoDB Table and Page Compression”. These two tables have identical contents, but reading ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-information-schema-innodb_cmpmem.html
The INNODB_CMPMEM and INNODB_CMPMEM_RESET tables provide status information about compressed pages that reside in the buffer pool. Please consult Section 17.9, “InnoDB Table and Page Compression” for further information on compressed tables and ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-init-startup-configuration.html
The first decisions to make about InnoDB configuration involve the configuration of data files, log files, page size, and memory buffers, which should be configured before initializing InnoDB. Modifying the configuration after InnoDB is initialized ...