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/functions.html
Note By default, there must be no whitespace between a function name and the parenthesis following it. Expressions can be used at several points in SQL statements, such as in the ORDER BY or HAVING clauses of SELECT statements, in the WHERE clause ...
https://dev.mysql.com/doc/refman/8.0/en/generated-column-index-optimizations.html
For example: CREATE TABLE t1 (f1 INT, gc INT AS (f1 + 1) STORED, INDEX (gc)); The generated column, gc, is defined as the expression f1 + 1. The column is also indexed and the optimizer can take that index into account during execution plan ...
https://dev.mysql.com/doc/refman/8.0/en/glossary.html
Often denotes a class of applications with relatively simple database usage (basic DDL, DML and query statements in SQL) that can be implemented quickly in any language. Note: MySQL 8.0 is a Bugfix series that preceded the LTS release model. These ...
https://dev.mysql.com/doc/refman/8.0/en/grant.html
Note MySQL automatically assigns all privileges granted to 'username'@'%' to the 'username'@'localhost' account as well. [WITH GRANT OPTION] [AS user [WITH ROLE DEFAULT | NONE | ALL | ALL EXCEPT role [, role ] ... ] ] } GRANT PROXY ON user_or_role ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-communication-protocol.html
From MySQL 8.0.16, Group Replication has the concept of a communication protocol for the group. The Group Replication communication protocol version can be managed explicitly, and set to accommodate the oldest MySQL Server version that you want the ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-compatibility-communication.html
Note that the group_replication_get_communication_protocol() function returns the minimum MySQL version that the group supports, which might differ from the version number that was passed to the group_replication_set_communication_protocol() ... A ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-compatibility-upgrade.html
Note that if you require the primary to remain the same throughout (except when it is being upgraded itself), you must first upgrade all of the secondaries to a version higher than or equal to the target primary member version, then upgrade the ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-configuring-consistency-guarantees.html
Note that the higher consistency levels BEFORE, AFTER, and BEFORE_AND_AFTER also include the consistency guarantees provided by BEFORE_ON_PRIMARY_FAILOVER. Although the Transaction Synchronization Points section explains that conceptually there are ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-configuring-instances.html
Set the disabled_storage_engines system variable as follows to prevent their use: disabled_storage_engines="MyISAM,BLACKHOLE,FEDERATED,ARCHIVE,MEMORY" Note that with the MyISAM storage engine disabled, when you are upgrading a MySQL instance to a ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-deploying-locally.html
Note The non-default port of 24801 is used because in this tutorial the three server instances use the same hostname. The most common way to deploy Group Replication is using multiple server instances, to provide high availability. It is also ...