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/replica-io-thread-states.html
This can last for a long time if the source is idle. Waiting for the slave SQL thread to free enough relay log space You are using a nonzero relay_log_space_limit value, and the relay logs have grown large enough that their combined size exceeds ...
https://dev.mysql.com/doc/refman/5.7/en/sys-io-by-thread-by-latency.html
max_latency The maximum single wait time of timed I/O events for the thread. These views summarize I/O consumers to display time waiting for I/O, grouped by thread. total_latency The total wait time of timed I/O events for the thread. min_latency ...The io_by_thread_by_latency and x$io_by_thread_by_latency views have these columns: user For foreground threads, the account associated with the ...
https://dev.mysql.com/doc/refman/5.7/en/events-metadata.html
The session time zone that is current when a CREATE EVENT or ALTER EVENT statement executes is used to interpret times specified in the event definition. This becomes the event time zone (ETZ); that is, the time zone that is used for event ...Event ... To obtain metadata about events: Query the event table of the mysql ...
https://dev.mysql.com/doc/refman/5.7/en/replication-features-reserved-words.html
Replication can fail in such cases with Error 1064 You have an error in your SQL syntax..., even if a database or table named using the reserved word or a table having a column named using the reserved word is excluded from replication. You can ...
https://dev.mysql.com/doc/refman/5.7/en/replication-channels.html
The maximum number of channels that can be created on one replica in a multi-source replication topology is 256. The error codes and messages that are issued when multi-source replication is enabled specify the channel that generated the error. In ...
https://dev.mysql.com/doc/refman/5.7/en/ldml-collation-example.html
To add a UCA collation for a Unicode character set without recompiling MySQL, use the following procedure. If you are unfamiliar with the LDML rules used to describe the collation's sort characteristics, see Section 10.14.4.2, “LDML Syntax ...
https://dev.mysql.com/doc/refman/5.7/en/change-master-to.html
The slave_net_timeout system variable specifies the number of seconds that the replica waits for either more data or a heartbeat signal from the source, before the replica considers the connection broken, aborts the read, and tries to reconnect. An ...When using a multithreaded replica (in other words slave_parallel_workers is greater than 0), stopping the replica can cause “gaps” in the sequence of transactions that have been executed from the relay log, regardless of whether the replica was stopped intentionally or ...
https://dev.mysql.com/doc/refman/5.7/en/bit-type.html
The maximum combined size of all BIT columns used in a given NDB table must not exceed 4096 bits. The BIT data type is used to store bit values. If you assign a value to a BIT(M) column that is less than M bits long, the value is padded on the left ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-replication-connection-configuration-table.html
Parameters stored in the table can be changed at runtime with the CHANGE MASTER TO statement, as indicated in the column descriptions. (CHANGE MASTER TO option: MASTER_CONNECT_RETRY) CONNECTION_RETRY_COUNT The number of times the replica can attempt ... This table shows the configuration parameters used by the replica for connecting to the ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-upgrade.html
Each time you upgrade MySQL, you should execute mysql_upgrade, which looks for incompatibilities with the upgraded MySQL server: It upgrades the system tables in the mysql schema so that you can take advantage of new privileges or capabilities that ...Failure to do so may result in the upgrade failing to execute ...If mysql_upgrade finds that a table has a possible incompatibility, it ...