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/plugin-loading.html
Alternatively, the INSTALL PLUGIN statement causes the server to load the plugin code from the library file at runtime: INSTALL PLUGIN myplugin SONAME 'somepluglib.so'; INSTALL PLUGIN also causes “permanent” plugin registration: The plugin is ...
https://dev.mysql.com/doc/refman/8.0/en/bit-value-literals.html
In numeric contexts, MySQL treats a bit literal like an integer. A leading 0b is case-sensitive and cannot be written as 0B. To ensure numeric treatment of a bit literal, use it in numeric context. For example, a bit literal assigned to a ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-compression-syntax-warnings.html
mysql> SHOW WARNINGS; +---------+------+---------------------------------------------------------------+ | Level | Code | Message | +---------+------+---------------------------------------------------------------+ | Warning | 1478 | InnoDB: ...
https://dev.mysql.com/doc/refman/8.0/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.0.22 and higher supports parenthesized query expressions according to the preceding ... parenthesized_query_expression: ( query_expression [order_by_clause] [limit_clause] ) [order_by_clause] [limit_clause] [into_clause] query_expression: query_block [set_op query_block [set_op query_block ...]] [order_by_clause] [limit_clause] [into_clause] query_block: SELECT ...
https://dev.mysql.com/doc/refman/8.0/en/partitioning.html
In MySQL 8.0, partitioning support is provided by the InnoDB and NDB storage engines. MySQL 8.0 does not currently support partitioning of tables using any storage engine other than InnoDB or NDB, such as MyISAM. MySQL 8.0 Community binaries ...Note ...
https://dev.mysql.com/doc/refman/8.0/en/reset-replica.html
From MySQL 8.0.22, use RESET REPLICA in place of RESET SLAVE, which is deprecated from that release. It also resets to 0 the replication delay specified with the SOURCE_DELAY | MASTER_DELAY option of the CHANGE REPLICATION SOURCE TO statement (from ... RESET REPLICA [ALL] [channel_option] channel_option: FOR CHANNEL channel RESET REPLICA makes the replica forget its position in the source's binary ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-connection-attribute-tables.html
FEDERATED storage engine connections: program_name: mysqld _client_role: federated_storage Connection Attribute Limits There are limits on the amount of connection attribute data transmitted from client to server: A fixed limit imposed by the client ... Connection attributes are key-value pairs that application programs can pass to the server at connect ...These Performance Schema tables expose attribute information: session_account_connect_attrs: Connection attributes for the current session, and other sessions associated with the session account session_connect_attrs: Connection ...
https://dev.mysql.com/doc/refman/8.0/en/replication-gtids-lifecycle.html
If a GTID was assigned for the transaction, the GTID is persisted atomically at commit time by writing it to the binary log at the beginning of the transaction (as a Gtid_log_event). Whenever the binary log is rotated or the server is shut down, the ... The life cycle of a GTID consists of the following steps: A transaction is executed and committed on the ...
https://dev.mysql.com/doc/refman/8.0/en/backup-and-recovery.html
Backups are also essential as a safeguard before upgrading a MySQL installation, and they can be used to transfer a MySQL installation to another system or to set up replica servers. MySQL offers a variety of backup strategies from which you can ...
https://dev.mysql.com/doc/refman/8.0/en/clone-plugin-limitations.html
Only a single MySQL instance can be cloned at a time. The clone plugin is subject to these limitations: An instance cannot be cloned from a different MySQL server series. For example, you cannot clone between MySQL 8.0 and MySQL 8.4, but can clone ...A workaround is to use dedicated donor instances, which can accommodate DDL operations being blocked while data is ...