Search Results
https://dev.mysql.com/doc/refman/8.4/en/group-replication-network-partitioning.html
For a group in single-primary mode, the primary might have transactions that are not yet present on other members at the time of the network partition. Warning For a group in single-primary mode, the primary might have transactions that are not yet ... The group needs to achieve consensus whenever a change that needs to be replicated ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-summary.html
For example, in multi-primary mode, a local transaction might be externalized immediately following certification, although a remote transaction that is earlier in the global order has not yet been applied. In single-primary mode, on the primary ...
https://dev.mysql.com/doc/refman/8.4/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. Alternatively, groups can be deployed in multi-primary mode, where all servers can accept updates, even if they are issued ... This chapter explains Group Replication in MySQL 8.4, and how to install, configure and monitor ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-parameters-table.html
The PARAMETER_NAME and PARAMETER_MODE values are NULL because the return value has no name and the mode does not apply. The PARAMETERS table provides information about parameters for stored routines (stored procedures and stored functions), and ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-routines-table.html
SQL_MODE The SQL mode in effect when the routine was created or altered, and under which the routine executes. The ROUTINES table provides information about stored routines (stored procedures and stored functions). The ROUTINES table does not ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-triggers-table.html
SQL_MODE The SQL mode in effect when the trigger was created, and under which the trigger executes. To see information about a table's triggers, you must have the TRIGGER privilege for the table. The TRIGGERS table has these columns: TRIGGER_CATALOG ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-information-schema-examples.html
This section describes the use of locking information as exposed by the Performance Schema data_locks and data_lock_waits tables. Identifying Blocking Transactions It is sometimes helpful to identify which transaction blocks another. The tables ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-performance-ro-txn.html
That is, a SELECT that does not use a FOR UPDATE or LOCK IN SHARED MODE clause. Until updates or explicit locks are required, a transaction stays in read-only mode. InnoDB can avoid the overhead associated with setting up the transaction ID (TRX_ID ...
https://dev.mysql.com/doc/refman/8.4/en/insert-on-duplicate.html
SELECT ON DUPLICATE KEY UPDATE statements are flagged as unsafe for statement-based replication. Such statements produce a warning in the error log when using statement-based mode and are written to the binary log using the row-based format when ...
https://dev.mysql.com/doc/refman/8.4/en/insert-select.html
Such statements produce a warning in the error log when using statement-based mode and are written to the binary log using the row-based format when using MIXED mode. INSERT [LOW_PRIORITY | HIGH_PRIORITY] [IGNORE] [INTO] tbl_name [PARTITION ...