PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/group-replication-functions.html
The functions described in the following sections are used with Group Replication.
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-transaction-summary-tables.html
The transaction access mode specifies whether transactions operate in read/write or read-only mode. The transaction access mode specifies whether transactions operate in read/write or read-only mode. Transaction Aggregation Rules Transaction event ... The Performance Schema maintains tables for collecting current and recent transaction events, and aggregates that information in summary ...
https://dev.mysql.com/doc/refman/8.0/en/precision-math-examples.html
In strict mode, inserting a value that is out of range for a column causes an error, rather than truncation to a legal value. This section provides some examples that show precision math query results in MySQL. These examples demonstrate the ...
https://dev.mysql.com/doc/refman/8.0/en/information-functions.html
It is multi-user safe because multiple clients can issue the UPDATE statement and get their own sequence value with the SELECT statement (or mysql_insert_id()), without affecting or being affected by other clients that generate their own sequence ...
https://dev.mysql.com/doc/refman/8.0/en/create-table-check-constraints.html
Foreign key referential actions (ON UPDATE, ON DELETE) are prohibited on columns used in CHECK constraints. CHECK constraints are evaluated for INSERT, UPDATE, REPLACE, LOAD DATA, and LOAD XML statements and an error occurs if a constraint evaluates ... Prior to MySQL 8.0.16, CREATE TABLE permits only the following limited version of table CHECK constraint syntax, which is parsed and ignored: CHECK (expr) As of MySQL 8.0.16, CREATE TABLE permits the core features of table and column CHECK constraints, for all storage ...
https://dev.mysql.com/doc/refman/8.0/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.0/en/group-replication-member-actions.html
By default, super read-only mode is disabled on the primary when it is elected, so that the primary becomes read-write, and accepts updates from a replication source server and from clients. If the server where you use the functions to configure a ... From MySQL 8.0.26, Group Replication has the capability to set actions for the members of a group to take in specified ...
https://dev.mysql.com/doc/refman/8.0/en/replication-rbr-usage.html
However, in MySQL 8.0, you cannot switch from row-based or mixed format for binary logging to statement-based format at runtime, due to any CREATE TEMPORARY TABLE statements having been omitted from the binary log in the previous mode. The MySQL ...
https://dev.mysql.com/doc/refman/8.0/en/forcing-innodb-recovery.html
As a safety measure, InnoDB prevents INSERT, UPDATE, or DELETE operations when innodb_force_recovery is greater than 0. If you are able to dump your tables with an innodb_force_recovery value of 3 or less, then you are relatively safe that only some ... To investigate database page corruption, you might dump your tables from the database with SELECT ...
https://dev.mysql.com/doc/refman/8.0/en/fido-pluggable-authentication.html
You need to understand the release model for MySQL innovation and long-term support (LTS) versions before you proceed with an upgrade. When the client program connects, the server places the client session in sandbox mode if the device must be ...