Search Results
https://dev.mysql.com/doc/refman/8.4/en/group-replication-message-compression.html
For messages sent between online group members, Group Replication enables message compression by default. Whether a specific message is compressed depends on the threshold that you configure using the group_replication_compression_threshold system ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-offline-upgrade.html
To perform an offline upgrade of a Group Replication group, you remove each member from the group, perform an upgrade of the member and then restart the group as usual. In a multi-primary group you can shutdown the members in any order. In a ...
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-innodb-buffer-page-lru-table.html
The INNODB_BUFFER_PAGE_LRU table provides information about the pages in the InnoDB buffer pool; in particular, how they are ordered in the LRU list that determines which pages to evict from the buffer pool when it becomes full. The ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-next-key-locking.html
The so-called phantom problem occurs within a transaction when the same query produces different sets of rows at different times. For example, if a SELECT is executed twice, but returns a row the second time that was not returned the first time, ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-performance-read_ahead.html
A read-ahead request is an I/O request to prefetch multiple pages in the buffer pool asynchronously, in anticipation of impending need for these pages. InnoDB uses two read-ahead algorithms to improve I/O performance: Linear read-ahead is a ...
https://dev.mysql.com/doc/refman/8.4/en/linux-installation-debian.html
Oracle provides Debian packages for installing MySQL on Debian or Debian-like Linux systems. The packages are available through two different channels: The MySQL APT Repository. This is the preferred method for installing MySQL on Debian-like ...
https://dev.mysql.com/doc/refman/8.4/en/linux-installation-native.html
Many Linux distributions include a version of the MySQL server, client tools, and development components in their native software repositories and can be installed with the platforms' standard package management systems. This section provides basic ...
https://dev.mysql.com/doc/refman/8.4/en/monitor-mysql-memory-use.html
The following example demonstrates how to use Performance Schema and sys schema to monitor MySQL memory usage. Instruments can be enabled by updating the ENABLED column of the Performance Schema setup_instruments table. Memory instruments have ...
https://dev.mysql.com/doc/refman/8.4/en/multiple-column-indexes.html
MySQL can create composite indexes (that is, indexes on multiple columns). For certain data types, you can index a prefix of the column (see Section 10.3.5, “Column Indexes”). MySQL can use multiple-column indexes for queries that test all the ...