Search Results
https://dev.mysql.com/doc/refman/8.4/en/checking-gpg-signature-windows.html
The Section 2.1.4.2, “Signature Checking Using GnuPG” section describes how to verify MySQL downloads using GPG. Download and install Gpg4win, load Kleopatra, and add the MySQL Release Engineering certificate. Type "Mysql Release Engineering" ...That guide also applies to Microsoft Windows, but another option is to use a GUI tool like ...
https://dev.mysql.com/doc/refman/8.4/en/date-and-time-types.html
Each temporal type has a range of valid values, as well as a “zero” value that may be used when you specify an invalid value that MySQL cannot represent. Although MySQL tries to interpret values in several formats, date parts must always be ...
https://dev.mysql.com/doc/refman/8.4/en/datetime.html
MySQL recognizes DATE, DATETIME, and TIMESTAMP values in several formats, described in Section 11.1.3, “Date and Time Literals”. For information about fractional seconds support in MySQL, see Section 13.2.6, “Fractional Seconds in Time ...This ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-responses-failure-exit.html
In order of impact, the exit actions are as follows: If READ_ONLY is the exit action, the instance switches MySQL to super read only mode by setting the system variable super_read_only to ON. If OFFLINE_MODE is the exit action, the instance switches ... The group_replication_exit_state_action system variable specifies what Group Replication does when the member leaves the group unintentionally due to an error or problem, and either fails to auto-rejoin or does not ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-restarting-group.html
Edit the MySQL Server configuration file (typically named my.cnf on Linux and Unix systems, or my.ini on Windows systems) and set the system variable group_replication_start_on_boot=OFF. This setting prevents Group Replication from starting when ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-row-format.html
REDUNDANT Row Format COMPACT Row Format DYNAMIC Row Format COMPRESSED Row Format Defining the Row Format of a Table Determining the Row Format of a Table REDUNDANT Row Format The REDUNDANT format provides compatibility with older versions of MySQL.
https://dev.mysql.com/doc/refman/8.4/en/innodb-troubleshooting-datadict.html
Restoring Orphan File-Per-Table ibd Files This procedure describes how to restore orphan file-per-table .ibd files to another MySQL instance. You might use this procedure if the system tablespace is lost or unrecoverable and you want to restore .ibd ... Information about table definitions is stored in the InnoDB data ...
https://dev.mysql.com/doc/refman/8.4/en/join.html
MySQL supports the following JOIN syntax for the table_references part of SELECT statements and multiple-table DELETE and UPDATE statements: table_references: escaped_table_reference [, escaped_table_reference] ... The syntax of table_factor is ...
https://dev.mysql.com/doc/refman/8.4/en/parenthesized-query-expressions.html
| TABLE | VALUES order_by_clause: ORDER BY as for SELECT limit_clause: LIMIT as for SELECT into_clause: INTO as for SELECT set_op: UNION | INTERSECT | EXCEPT MySQL 8.4 supports parenthesized query expressions according to the preceding syntax.
https://dev.mysql.com/doc/refman/8.4/en/partitioning-limitations-partitioning-keys-unique-keys.html
This section discusses the relationship of partitioning keys with primary keys and unique keys. The rule governing this relationship can be expressed as follows: All columns used in the partitioning expression for a partitioned table must be part ...