PDF (US Ltr)
- 41.8Mb
PDF (A4)
- 41.9Mb
Man Pages (TGZ)
- 272.4Kb
Man Pages (Zip)
- 378.4Kb
Info (Gzip)
- 4.2Mb
Info (Zip)
- 4.2Mb
Search Results
https://dev.mysql.com/doc/refman/9.7/en/group-replication-limitations.html
To avoid these issues use the following mitigations: If unnecessary expulsions occur due to large messages, use the system variable group_replication_member_expel_timeout to allow additional time before a member under suspicion of having failed is ... Limit on Group Size Limits on Transaction Size The following known limitations exist for Group ...
https://dev.mysql.com/doc/refman/9.7/en/group-replication-performance-xcom-cache-increase.html
In this situation, consider increasing the group_replication_message_cache_size limit with reference to the expected volume of messages in the time period specified by the group_replication_member_expel_timeout system variable plus the 5-second ...
https://dev.mysql.com/doc/refman/9.7/en/group-replication-upgrading-member.html
Note The longer it takes to upgrade a server, the more time that member is offline and therefore the more time it takes for the server to catch up when added back to the group. This section explains the steps required for upgrading a member of a ...
https://dev.mysql.com/doc/refman/9.7/en/group-replication.html
Groups can operate in a single-primary mode with automatic primary election, where only one server accepts updates at a time. There is a built-in group membership service that keeps the view of the group consistent and available for all servers at ... This chapter explains Group Replication in MySQL 9.7, and how to install, configure and monitor ...
https://dev.mysql.com/doc/refman/9.7/en/host-cache.html
(In this case, another DNS resolution attempt occurs the next time a client connects from this IP.) If an error occurs while processing an incoming client connection from a given IP address, the server updates the corresponding error counters in the ... The MySQL server maintains an in-memory host cache that contains information about clients: IP address, host name, and error ...
https://dev.mysql.com/doc/refman/9.7/en/ibd2sdi.html
ibd2sdi can be used at runtime or while the server is offline. During DDL operations, ROLLBACK operations, and undo log purge operations related to SDI, there may be a short interval of time when ibd2sdi fails to read SDI data stored in the ...
https://dev.mysql.com/doc/refman/9.7/en/index-condition-pushdown-optimization.html
ICP can reduce the number of times the storage engine must access the base table and the number of times the MySQL server must access the storage engine. Index Condition Pushdown (ICP) is an optimization for the case where MySQL retrieves rows from ...
https://dev.mysql.com/doc/refman/9.7/en/information-schema-innodb-buffer-page-lru-table.html
ACCESS_TIME An abstract number used to judge the first access time of the page. Querying this table can require MySQL to allocate a large block of contiguous memory, more than 64 bytes times the number of active pages in the buffer pool. The ...
https://dev.mysql.com/doc/refman/9.7/en/information-schema-innodb-cmpmem-table.html
RELOCATION_OPS The number of times a block of size PAGE_SIZE has been relocated. RELOCATION_TIME The total time in microseconds used for relocating blocks of size PAGE_SIZE. row *************************** page_size: 1024 buffer_pool_instance: 0 ...
https://dev.mysql.com/doc/refman/9.7/en/information-schema-innodb-metrics-table.html
(The _RESET columns act like the lap counter on a stopwatch: you can measure the activity during some time interval, while the cumulative figures are still available in COUNT, MAX_COUNT, and so on.) MAX_COUNT_RESET The maximum counter value since it ... The INNODB_METRICS table provides a wide variety of InnoDB performance information, complementing the specific focus areas of the Performance Schema tables for ...