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/outer-join-simplification.html
Table expressions in the FROM clause of a query are simplified in many cases. At the parser stage, queries with right outer join operations are converted to equivalent queries containing only left join operations. When the optimizer evaluates plans ...
https://dev.mysql.com/doc/refman/8.0/en/pattern-matching.html
(This differs from a LIKE pattern match, which succeeds only if the pattern matches the entire value.) To anchor a pattern so that it must match the beginning or end of the value being tested, use ^ at the beginning or $ at the end of the pattern.
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-replication-applier-configuration-table.html
DESIRED_DELAY The number of seconds that the replica must lag the source. This table shows the configuration parameters that affect transactions applied by the replica. Parameters stored in the table can be changed at runtime with the CHANGE ...
https://dev.mysql.com/doc/refman/8.0/en/perl-support.html
To use DBI, you must install the DBI module, as well as a DataBase Driver (DBD) module for each type of database server you want to access. The Perl DBI module provides a generic interface for database access. You can write a DBI script that works ...DBI does not work if you have an older version of ...
https://dev.mysql.com/doc/refman/8.0/en/replication-asynchronous-connection-failover-source.html
GTID auto-positioning must be in use for the channel (SOURCE_AUTO_POSITION = 1 | MASTER_AUTO_POSITION = 1). To activate asynchronous connection failover for a replication channel set SOURCE_CONNECTION_AUTO_FAILOVER=1 on the CHANGE REPLICATION ...
https://dev.mysql.com/doc/refman/8.0/en/replication-features-functions.html
Certain functions do not replicate well under some conditions: The USER(), CURRENT_USER() (or CURRENT_USER), UUID(), VERSION(), and LOAD_FILE() functions are replicated without change and thus do not work reliably on the replica unless row-based ...
https://dev.mysql.com/doc/refman/8.0/en/replication-features-json.html
For this reason, when replicating to such a server from a server running MySQL 8.0.3 or later, binlog_row_value_options must be disabled on the source by setting this variable to '' (empty string). Before MySQL 8.0, an update to a JSON column was ...In MySQL 8.0, it is possible to log partial updates to JSON documents (see Partial Updates of JSON Values), which is more ...
https://dev.mysql.com/doc/refman/8.0/en/replication-features-timezone.html
If you are replicating between servers in different time zones, the time zone must be set on both source and replica. By default, source and replica servers assume that they are in the same time zone. Otherwise, statements depending on the local ...
https://dev.mysql.com/doc/refman/8.0/en/replication-functions-async-failover.html
managed_type: The type of managed service that the asynchronous connection failover mechanism must provide for this server. The following functions, which are available from MySQL 8.0.22 for standard source to replica replication and from MySQL ...
https://dev.mysql.com/doc/refman/8.0/en/return.html
There must be at least one RETURN statement in a stored function. RETURN expr The RETURN statement terminates execution of a stored function and returns the value expr to the function caller. There may be more than one if the function has multiple ...This statement is not used in stored procedures, triggers, or ...