Search Results
https://dev.mysql.com/doc/refman/8.4/en/group-replication-monitoring.html
Replication channels created by the Group Replication plugin are listed here: group_replication_recovery: Used for replication changes related to distributed recovery. Note If you are monitoring one or more secondary instances using mysqladmin, you ... You can use the MySQL Performance Schema to monitor Group ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-network-partitioning.html
If misused, it could create an artificial split-brain scenario or block the entire system altogether. In that case, forcing a group membership list with s1 and s2 could create an artificial split-brain situation. The group needs to achieve ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-responses-failure.html
If a group member does not receive any messages from a particular fellow member for 5 seconds, when this detection period ends, it creates a suspicion of the fellow member. By default, the following behaviors happen if a member is suspected of ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication.html
MySQL Group Replication enables you to create elastic, highly-available, fault-tolerant replication topologies. Section 20.2, “Getting Started” explains how to configure multiple MySQL Server instances to create a group. This chapter explains ...
https://dev.mysql.com/doc/refman/8.4/en/help.html
HELP 'search_string' The HELP statement returns online information from the MySQL Reference Manual. Its proper operation requires that the help tables in the mysql database be initialized with help topic information (see Section 7.1.17, ...
https://dev.mysql.com/doc/refman/8.4/en/if.html
[ELSE statement_list] END IF The IF statement for stored programs implements a basic conditional construct. Note There is also an IF() function, which differs from the IF statement described here. The IF statement can have THEN, ELSE, and ELSEIF ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-innodb-virtual-table.html
CREATE TABLE `t1` ( `a` int(11) DEFAULT NULL, `b` int(11) DEFAULT NULL, `c` int(11) GENERATED ALWAYS AS (5) VIRTUAL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; However, metadata for such a column does appear in the INNODB_COLUMNS table. The ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-key-column-usage-table.html
This table provides no information about functional key parts because they are expressions and the table provides information only about columns. The KEY_COLUMN_USAGE table has these columns: CONSTRAINT_CATALOG The name of the catalog to which the ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-information-schema-metrics-table.html
Create a simple InnoDB table: mysql> USE test; Database changed mysql> CREATE TABLE t1 (c1 INT) ENGINE=INNODB; Query OK, 0 rows affected (0.02 sec) Enable the dml_inserts counter. The INNODB_METRICS table provides information about InnoDB ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-online-ddl-failure-conditions.html
The tmpdir or innodb_tmpdir file system runs out of disk space, while MySQL writes temporary sort files on disk during index creation. For example, you might insert duplicate values into a column while a unique index is being created, or you might ... The failure of an online DDL operation is typically due to one of the following conditions: An ALGORITHM clause specifies an algorithm that is not compatible with the particular type of DDL operation or storage ...