PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.5Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/regexp.html
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 operations. MySQL implements regular ...
https://dev.mysql.com/doc/refman/8.0/en/rename-table.html
RENAME TABLE tbl_name TO new_tbl_name [, tbl_name2 TO new_tbl_name2] ... You must have ALTER and DROP privileges for the original table, and CREATE and INSERT privileges for the new table. As of MySQL 8.0.13, you can rename tables locked with a ...
https://dev.mysql.com/doc/refman/8.0/en/replication-features-optimizer.html
(In general, this is not a good practice, even outside of replication.) Examples of nondeterministic statements include DELETE or UPDATE statements that use LIMIT with no ORDER BY clause; see Section 19.5.1.18, “Replication and LIMIT”, for a ...
https://dev.mysql.com/doc/refman/8.0/en/replication-features-row-searches.html
If there are suitable indexes, one index is selected from the candidates, in the following priority order: A primary key. When a replica using row-based replication format applies an UPDATE or DELETE operation, it must search the relevant table for ...
https://dev.mysql.com/doc/refman/8.0/en/replication-gtids-auto-positioning.html
The source must have GTID_MODE=ON set in order for the connection to succeed. GTIDs replace the file-offset pairs previously required to determine points for starting, stopping, or resuming the flow of data between source and replica. When GTIDs ...
https://dev.mysql.com/doc/refman/8.0/en/replication-howto-slavebaseconfig.html
Updates received from A must be logged by B to its binary log, in order to be passed on to C. Each replica must have a unique server ID, as specified by the server_id system variable. If you are setting up multiple replicas, each one must have a ...
https://dev.mysql.com/doc/refman/8.0/en/replication-options-gtids.html
You can set the value of gtid_purged in order to record on the server that the transactions in a certain GTID set have been applied, although they do not exist in any binary log on the server. The MySQL Server system variables described in this ...
https://dev.mysql.com/doc/refman/8.0/en/replication-rules-db-options.html
This means that you must select the default database explicitly with a USE statement in order for a DDL statement to be applied. When evaluating replication options, the replica begins by checking to see whether there are any --replicate-do-db or ...
https://dev.mysql.com/doc/refman/8.0/en/replication-sbr-rbr.html
DELETE and UPDATE statements that use a LIMIT clause without an ORDER BY are nondeterministic. For most users, the mixed replication format should provide the best combination of data integrity and performance. If, however, you want to take ...
https://dev.mysql.com/doc/refman/8.0/en/replication-semisync.html
If your goal is to implement a fault-tolerant replication topology where all the servers receive the same transactions in the same order, and a server that crashes can rejoin the group and be brought up to date automatically, you can use Group ...