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/create-table-secondary-indexes.html
A secondary index defined on a virtual column is sometimes referred to as a “virtual index”. If a secondary index is not defined on a virtual column, there are additional costs for reads, as virtual column values must be computed each time the ...A secondary index may be created on one or more virtual columns or on a combination of virtual columns and regular columns or stored generated ...
https://dev.mysql.com/doc/refman/8.0/en/signal.html
The following statements cause that error because the named condition is associated with a MySQL error number: DECLARE no_such_table CONDITION FOR 1051; SIGNAL no_such_table; If a condition with a given name is declared multiple times in different ...For information about the diagnostics area, see Section 15.6.7.7, “The MySQL Diagnostics ...SIGNAL ...
https://dev.mysql.com/doc/refman/8.0/en/alter-tablespace.html
The UNDO keyword, introduced in MySQL 8.0.14, is used with the SET {ACTIVE | INACTIVE} clause to mark an InnoDB undo tablespace as active or inactive. The ENCRYPTION clause enables or disables page-level data encryption for an InnoDB general ...It ...
https://dev.mysql.com/doc/refman/8.0/en/charset-configuration.html
The MySQL server has a compiled-in default character set and collation. For example, to specify a directory to be used by MySQL client programs, list it in the [client] group of your option file. The examples given here show what the setting might ...To change these defaults, use the --character-set-server and --collation-server options when you start the ...
https://dev.mysql.com/doc/refman/8.0/en/connection-access.html
When you attempt to connect to a MySQL server, the server accepts or rejects the connection based on these conditions: Your identity and whether you can verify it by supplying the proper credentials. Your identity is based on two pieces of ...A ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-distributed-recovery-connections.html
For distributed recovery prior to MySQL 8.0.21, group members offer their standard SQL client connection to joining members, as specified by hostname and port. In MySQL 8.0.21 and later, group members may advertise an alternative list of distributed ... When a joining member connects to an online existing member for state transfer during distributed recovery, the joining member acts as a client on the connection and the existing member acts as a ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-functions-for-communication-protocol.html
Versions from MySQL 5.7.14 allow compression of messages (see Section 20.7.4, “Message Compression”). Versions from MySQL 8.0.16 also allow fragmentation of messages (see Section 20.7.5, “Message Fragmentation”). Versions from MySQL 8.0.27 ... The following functions enable you to inspect and configure the Group Replication communication protocol version that is used by a replication ...
https://dev.mysql.com/doc/refman/8.0/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.0/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.0/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 ...