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/range-optimization.html
The optimizer estimates the cost of reading qualifying rows for equality range comparisons as follows: If there is a unique index on col_name, the row estimate for each range is 1 because at most one row can have the given value. Each pair of dives ... The range access method uses a single index to retrieve a subset of table rows that are contained within one or several index value ...
https://dev.mysql.com/doc/refman/8.0/en/regexp.html
If the arguments have different character sets or collations, coercibility rules apply as described in Section 12.8.4, “Collation Coercibility in Expressions”. Any character that does not have a defined special meaning inside a [] pair matches ...This section discusses the functions and operators available for regular expression matching and illustrates, with examples, some of the special characters and constructs that can be used for regular expression ...
https://dev.mysql.com/doc/refman/8.0/en/rename-user.html
To use RENAME USER, you must have the global CREATE USER privilege, or the UPDATE privilege for the mysql system schema. (That is, the statement fails if renaming an account would cause a stored object to become orphaned.) To perform the operation ... RENAME USER old_user TO new_user [, old_user TO new_user] ...
https://dev.mysql.com/doc/refman/8.0/en/replica-io-thread-states.html
If the incompatible changes have an impact for you, set the terminology_use_previous system variable to BEFORE_8_0_26 to make MySQL Server use the old versions of the names for the objects specified in the previous list. Waiting for the slave SQL ...
https://dev.mysql.com/doc/refman/8.0/en/replica-logs-relaylog.html
Relay log files have the same format as binary log files and can be read using mysqlbinlog (see Section 6.6.9, “mysqlbinlog — Utility for Processing Binary Log Files”). For the default replication channel, relay log file names have the default ... The relay log, like the binary log, consists of a set of numbered files containing events that describe database changes, and an index file that contains the names of all used relay log ...
https://dev.mysql.com/doc/refman/8.0/en/replication-asynchronous-connection-failover-replica.html
Because the sources do not have to be in a managed group, you can set up the function to synchronize a group of receivers with one or more alternative standalone senders, or even a single sender. In MySQL 8.0.27 and later, asynchronous connection ...
https://dev.mysql.com/doc/refman/8.0/en/replication-compatibility.html
A source might also have optional features enabled that are not understood by older replicas, such as binary log transaction compression, where the resulting compressed transaction payloads cannot be read by a replica at a release before MySQL ...
https://dev.mysql.com/doc/refman/8.0/en/replication-encrypted-connections.html
To be able to connect, the replica must have at least one TLS version in common with the source. For example: mysql> CREATE USER 'repl'@'%.example.com' IDENTIFIED BY 'password' -> REQUIRE SSL; mysql> GRANT REPLICATION SLAVE ON *.* -> TO ... To use ...
https://dev.mysql.com/doc/refman/8.0/en/replication-features-auto-increment.html
If it is important to have the same order on the source and replica, the rows must be ordered before assigning an AUTO_INCREMENT number. Statement-based replication of AUTO_INCREMENT, LAST_INSERT_ID(), and TIMESTAMP values is carried out subject to ...
https://dev.mysql.com/doc/refman/8.0/en/replication-features-invoked.html
Replication of invoked features such as loadable functions and stored programs (stored procedures and functions, triggers, and events) provides the following characteristics: The effects of the feature are always replicated. The following ...