PDF (US Ltr)
- 43.2Mb
PDF (A4)
- 43.3Mb
Man Pages (TGZ)
- 295.2Kb
Man Pages (Zip)
- 400.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/group-replication-configuring-online-group.html
Once all members declare the action as finished, the invoking member returns the result to the client. You can configure an online group while Group Replication is running by using a set of functions, which rely on a group action coordinator. These ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-distributed-recovery.html
When the joining member is up to date with all the group's transactions, it is declared online and can participate in the group as a normal member, and distributed recovery is complete. Whenever a member joins or rejoins a replication group, it ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-restarting-group.html
However, a Group Replication group member never removes a transaction that has been certified, which is a declaration of the member’s intent to commit the transaction. Group Replication is designed to ensure that the database service is ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-best-practices.html
For fast join performance, define foreign keys on the join columns, and declare those columns with the same data type in each table. Specify a primary key for every table using the most frequently queried column or columns, or an auto-increment ...
https://dev.mysql.com/doc/refman/8.0/en/insert-on-duplicate.html
If you specify an ON DUPLICATE KEY UPDATE clause and a row to be inserted would cause a duplicate value in a UNIQUE index or PRIMARY KEY, an UPDATE of the old row occurs. If column b is also unique, the INSERT is equivalent to this UPDATE statement ...
https://dev.mysql.com/doc/refman/8.0/en/insert.html
Warnings can occur under any of the following conditions: Inserting NULL into a column that has been declared NOT NULL. INSERT [LOW_PRIORITY | DELAYED | HIGH_PRIORITY] [IGNORE] [INTO] tbl_name [PARTITION (partition_name [, partition_name] ...)] ...
https://dev.mysql.com/doc/refman/8.0/en/is-null-optimization.html
MySQL can perform the same optimization on col_name IS NULL that it can use for col_name = constant_value. For example, MySQL can use indexes and ranges to search for NULL with IS NULL. This optimization does not occur in cases when the column ...
https://dev.mysql.com/doc/refman/8.0/en/join.html
This option follows the name of the table and precedes any alias declaration. MySQL supports the following JOIN syntax for the table_references part of SELECT statements and multiple-table DELETE and UPDATE statements: table_references: ...
https://dev.mysql.com/doc/refman/8.0/en/json.html
This optimization can be performed for an update that meets the following conditions: The column being updated was declared as JSON. The JSON data type provides these advantages over storing JSON-format strings in a string column: Automatic ...
https://dev.mysql.com/doc/refman/8.0/en/keywords.html
Certain keywords, such as SELECT, DELETE, or BIGINT, are reserved and require special treatment for use as identifiers such as table and column names. This may also be true for the names of built-in functions. Some keywords which are otherwise ...