PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 296.6Kb
Man Pages (Zip)
- 402.0Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/replication-features-directory.html
If a DATA DIRECTORY or INDEX DIRECTORY table option is used in a CREATE TABLE statement on the source server, the table option is also used on the replica. This can be overridden by using the NO_DIR_IN_CREATE server SQL mode on the replica, which ...This can cause problems if no corresponding directory exists in the replica host file system or if it exists but is not accessible to the replica MySQL ...
https://dev.mysql.com/doc/refman/8.0/en/replication-features-load-data.html
If you use LOAD DATA with binlog_format=STATEMENT, each replica on which the changes are to be applied creates a temporary file containing the data. This temporary file is not encrypted, even if binary log encryption is active on the source, If ...
https://dev.mysql.com/doc/refman/8.0/en/replication-gtids-assign-anon.html
For a channel on a Group Replication group member, do not specify the Group Replication group name as the UUID for creating the GTIDs. The exception to this is any downstream replicas of the replica where you enabled ... From MySQL 8.0.23, you can ...
https://dev.mysql.com/doc/refman/8.0/en/replication-multi-source-provision-replica.html
The best strategy for provisioning such a replica is therefore to use mysqldump to create an appropriate dump file on each source, then use the mysql client to import the dump file on the replica. If the sources in the multi-source replication ...
https://dev.mysql.com/doc/refman/8.0/en/replication-options-gtids.html
Only statements that can be logged using GTID safe statements can be logged when enforce_gtid_consistency is set to ON, so the operations listed here cannot be used with this option: CREATE TEMPORARY TABLE or DROP TEMPORARY TABLE statements inside ... The MySQL Server system variables described in this section are used to monitor and control Global Transaction Identifiers ...
https://dev.mysql.com/doc/refman/8.0/en/replication-options-source.html
This section describes the server options and system variables that you can use on replication source servers. You can specify the options either on the command line or in an option file. On the source and each replica, you must set the server_id ...
https://dev.mysql.com/doc/refman/8.0/en/resetting-permissions.html
Create a text file containing the password-assignment statement on a single line. If you start the server as root without using --user=mysql, the server may create root-owned files in the data directory, such as log files, and these may cause ... If ...
https://dev.mysql.com/doc/refman/8.0/en/scheduler-component.html
When a caller invokes the mysql_scheduler.create() service, it creates a new scheduled task instance to add to the queue, which signals the semaphore of the background thread. When the caller invokes destroy() and passes in the handle it received ...
https://dev.mysql.com/doc/refman/8.0/en/select-into.html
The file is created on the server host, so you must have the FILE privilege to use this syntax. To create the resulting file on some other host, SELECT ... Note Any file created by INTO OUTFILE or INTO DUMPFILE is owned by the operating system user ...INTO form of SELECT enables a query result to be stored in variables or written to a file: SELECT ...
https://dev.mysql.com/doc/refman/8.0/en/select.html
You cannot use FOR UPDATE as part of the SELECT in a statement such as CREATE TABLE new_table SELECT ... (If you attempt to do so, the statement is rejected with the error Can't update table 'old_table' while 'new_table' is being created.) FOR SHARE ... SELECT [ALL | DISTINCT | DISTINCTROW ] [HIGH_PRIORITY] [STRAIGHT_JOIN] [SQL_SMALL_RESULT] [SQL_BIG_RESULT] [SQL_BUFFER_RESULT] [SQL_NO_CACHE] [SQL_CALC_FOUND_ROWS] select_expr [, select_expr] ...