Search Results
https://dev.mysql.com/doc/refman/8.4/en/group-replication-member-actions.html
Group Replication increments the version number for its member actions configuration each time a member action is enabled or disabled. Whenever a member action is enabled or disabled using the functions, the version number is incremented. Group ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-view-changes.html
Using these two different parts enables the view identifier to identify incremental group changes caused by members joining or leaving, and also to identify the situation where all members leave the group in a full group shutdown, so no information ... When Group Replication's distributed recovery process is carrying out state transfer from the binary log, to synchronize the joining member with the donor up to a specific point in time, the joining member and donor make use of GTIDs (see Section 19.1.3, “Replication with Global Transaction ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-locking-reads.html
Note Locking reads are only possible when autocommit is disabled (either by beginning transaction with START TRANSACTION or by setting autocommit to 0. To implement reading and incrementing the counter, first perform a locking read of the counter ...
https://dev.mysql.com/doc/refman/8.4/en/internal-temporary-tables.html
When the limit determined by tmp_table_size is reached, MySQL automatically converts the in-memory internal temporary table to an InnoDB on-disk internal temporary table. When using the MEMORY storage engine for in-memory temporary tables ... In ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-replication-pitr.html
(See Section 6.6.9, “mysqlbinlog — Utility for Processing Binary Log Files”.) See also Section 9.5, “Point-in-Time (Incremental) Recovery”, for more information about the binary log, replication, and incremental recovery. Point-in-time ...
https://dev.mysql.com/doc/refman/8.4/en/order-by-optimization.html
To obtain memory for filesort operations, the optimizer allocates memory buffers incrementally as needed, up to the size indicated by the sort_buffer_size system variable. This section describes when MySQL can use an index to satisfy an ORDER BY ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-component-scheduler-tasks-table.html
TIMES_RUN A counter that increments by one every time the task runs successfully. TIMES_FAILED A counter that increments by one every time the execution of the task fails. The component_scheduler_tasks table contains a row for each scheduled task.
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-host-cache-table.html
Any or all of them can fail, independently incrementing SUM_CONNECT_ERRORS, possibly beyond the value of max_connect_errors. Depending on the type of error, one of these columns is incremented: COUNT_AUTHENTICATION_ERRORS, COUNT_AUTH_PLUGIN_ERRORS, ... The MySQL server maintains an in-memory host cache that contains client host name and IP address information and is used to avoid Domain Name System (DNS) ...
https://dev.mysql.com/doc/refman/8.4/en/recovery-from-backups.html
To restore the changes made since then, we must use the incremental backups; that is, the gbichot2-bin.000007 and gbichot2-bin.000008 binary log files. | mysql For more information about using mysqlbinlog to process binary log files, see Section ...
https://dev.mysql.com/doc/refman/8.4/en/show-warnings.html
The sql_notes system variable controls whether note messages increment warning_count and whether the server stores them. In the mysql client, you can enable and disable automatic warnings display using the warnings and nowarning commands, ... SHOW ...