PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.2Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/replication-channels.html
For instructions to configure sources and replicas for multi-source replication, to start, stop and reset multi-source replicas, and to monitor multi-source replication, see Section 16.1.5, “MySQL Multi-Source Replication”. This channel is ...
https://dev.mysql.com/doc/refman/5.7/en/replication-features-max-allowed-packet.html
On a multi-threaded replica (slave_parallel_workers > 0), ensure that the system variable slave_pending_jobs_size_max is set to a value equal to or greater than the setting for the max_allowed_packet system variable on the source. The default ...If ...
https://dev.mysql.com/doc/refman/5.7/en/binary-log.html
The session values of the following system variables are written to the binary log and honored by the replica when parsing the binary log: sql_mode (except that the NO_DIR_IN_CREATE mode is not replicated; see Section 16.4.1.37, “Replication and ...However, the benefits of the binary log in enabling you to set up replication and for restore operations generally outweigh this minor performance ...The ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-online-operations.html
Such operations do not require single user mode for NDB table alterations made in an NDB cluster with multiple API nodes; transactions can continue uninterrupted during online DDL operations. row *************************** Level: Warning Code: 1478 ...For ALGORITHM=COPY, the mysqld NDB Cluster handler performs the following actions: Tells the data nodes to create an empty copy of the table, and to make the required schema changes to this ...
https://dev.mysql.com/doc/refman/5.7/en/dynamic-system-variables.html
For a description of the privilege requirements for setting system variables, see Section 5.1.8.1, “System Variable Privileges” The following table lists all dynamic system variables applicable within mysqld. Please see the corresponding item ...
https://dev.mysql.com/doc/refman/5.7/en/fulltext-stopwords.html
The stopword list is loaded and searched for full-text queries using the server character set and collation (the values of the character_set_server and collation_server system variables). False hits or misses might occur for stopword lookups if the ...For example, lookups are case-insensitive if the collation is latin1_swedish_ci, whereas lookups are case-sensitive if the collation is latin1_general_cs or ...
https://dev.mysql.com/doc/refman/5.7/en/type-conversion.html
mysql> SELECT 38.8, CAST(38.8 AS CHAR); -> 38.8, '38.8' mysql> SELECT 38.8, CONCAT(38.8); -> 38.8, '38.8' See later in this section for information about the character set of implicit number-to-string conversions, and for modified rules that apply ...For example, MySQL automatically converts strings to numbers as necessary, and vice ... When an operator is used ...
https://dev.mysql.com/doc/refman/5.7/en/replication-delayed.html
Delayed replication can be used for several purposes: To protect against user mistakes on the source. Use the MASTER_DELAY option for CHANGE MASTER TO to set the delay to N seconds: CHANGE MASTER TO MASTER_DELAY = N; An event received from the ...
https://dev.mysql.com/doc/refman/5.7/en/data-directory.html
All MySQL installations have certain standard databases: The mysql directory corresponds to the mysql system database, which contains information required by the MySQL server as it runs. The sys directory corresponds to the sys schema, which ...Some ...
https://dev.mysql.com/doc/refman/5.7/en/reset-slave.html
RESET SLAVE does not change any replication connection parameters such as the source's host name and port, or the replication user account name and its password. RESET SLAVE [ALL] [channel_option] channel_option: FOR CHANNEL channel RESET SLAVE ...