Search Results
https://dev.mysql.com/doc/refman/8.4/en/group-replication-restarting-group.html
You can do this manually by looking at the GTIDs, or you can compare the GTID sets using stored functions, as described in Section 19.1.3.8, “Stored Function Examples to Manipulate GTIDs”. For Group Replication, this includes both transactions ... Group Replication is designed to ensure that the database service is continuously available, even if some of the servers that form the group are currently unable to participate in it due to planned maintenance or unplanned ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-single-primary-mode.html
When deploying in single-primary mode, or changing the group to single-primary mode, this system variable must be set to OFF. When a new primary server is elected (automatically or manually), it is automatically set to read/write, and the other ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-understanding-consistency-guarantees.html
This means that as soon as the incoming traffic slows down or stops, all group members have the same data content. The events that relate to the consistency of a system can be split into control operations, either manual or automatically triggered ... In terms of distributed consistency guarantees, either in normal or failure repair operations, Group Replication has always been an eventual consistency ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-user-credentials.html
If group members have been set up to support the use of a remote cloning operation as part of distributed recovery, this replication user is also used as the clone user on the donor, and requires the correct permissions for this role too. Group ...
https://dev.mysql.com/doc/refman/8.4/en/hexadecimal-literals.html
Hexadecimal literal values are written using X'val' or 0xval notation, where val contains hexadecimal digits (0..9, A..F). Lettercase of the digits and of any leading X does not matter. A leading 0x is case-sensitive and cannot be written as 0X.
https://dev.mysql.com/doc/refman/8.4/en/innodb-dedicated-server.html
In MySQL 8.0, innodb_flush_method was also set automatically by this option, but in MySQL 8.4, this is no longer the case. If one of the variables listed previously is set explicitly in an option file or elsewhere, this explicit value is used, and a ... When the server is started with --innodb-dedicated-server, InnoDB automatically calculates values for and sets the following system variables: innodb_buffer_pool_size innodb_redo_log_capacity Note innodb_redo_log_capacity supersedes both innodb_log_file_size and innodb_log_files_in_group, which were set by --innodb-dedicated-server in older versions of MySQL, but which have since been ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-disabling-tablespace-path-validation.html
This feature is intended for environments where tablespaces files are not moved. Manually moved tablespace files will not be detected! Warning Starting the server with tablespace path validation disabled after moving tablespace files can lead to ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-enabling-monitors.html
When this option is used, InnoDB creates a file named innodb_status.pid in the data directory and writes output to it every 15 seconds, approximately. If an abnormal shutdown occurs, the status file may have to be removed manually. When InnoDB ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-online-ddl-operations.html
Online support details, syntax examples, and usage notes for DDL operations are provided under the following topics in this section. Some factors affect the performance, space usage, and semantics of this operation. This is a non-standard behavior ...Index Operations Primary Key Operations Column Operations Generated Column Operations Foreign Key Operations Table Operations Tablespace Operations Partitioning Operations Index Operations The following table provides an overview of online DDL support for index ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-performance-optimizer-statistics.html
This section describes how to configure persistent and non-persistent optimizer statistics for InnoDB tables. You can manually modify the mysql.innodb_table_stats and mysql.innodb_index_stats tables to force a specific query optimization plan or to ...Persistent optimizer statistics are persisted across server restarts, allowing for greater plan stability and more consistent query ...