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/replica-sql-thread-states.html
Waiting until MASTER_DELAY seconds after master executed event From MySQL 8.0.26: Waiting until SOURCE_DELAY seconds after master executed event The SQL thread has read an event but is waiting for the replica delay to lapse. The following list ...
https://dev.mysql.com/doc/refman/8.0/en/replication-features-shutdowns.html
However, the replica notices the network outage only after receiving no data from the source for replica_net_timeout or slave_net_timeout seconds. It is safe to shut down a replication source server and restart it later. When a replica loses its ...
https://dev.mysql.com/doc/refman/8.0/en/replication-features-transaction-inconsistencies.html
If the last transaction in the relay log is only half-received and the multithreaded replica's coordinator thread has started to schedule the transaction to a worker, then STOP REPLICA waits up to 60 seconds for the transaction to be received. If ...
https://dev.mysql.com/doc/refman/8.0/en/replication-features-transactions.html
However, when a second connection updates the nontransactional table before the first connection transaction is complete, statements can be logged out of order because the second connection update is written immediately after it is performed, ...In ...
https://dev.mysql.com/doc/refman/8.0/en/replication-functions-synchronization.html
If a timeout value is specified, MASTER_POS_WAIT() stops waiting when timeout seconds have elapsed. If a timeout value is specified, SOURCE_POS_WAIT() stops waiting when timeout seconds have elapsed. The functions listed in this section are used ...
https://dev.mysql.com/doc/refman/8.0/en/replication-mode-change-online-verify-transactions.html
There are several possible ways to wait for transactions to replicate: The simplest method, which works regardless of your topology but relies on timing is as follows: if you are sure that the replica never lags more than N seconds, just wait for a ... This section explains how to monitor a replication topology and verify that all anonymous transactions have been ...
https://dev.mysql.com/doc/refman/8.0/en/replication-options-source.html
rpl_semi_sync_source_timeout Command-Line Format --rpl-semi-sync-source-timeout=# Introduced 8.0.26 System Variable rpl_semi_sync_source_timeout Scope Global Dynamic Yes SET_VAR Hint Applies No Type Integer Default Value 10000 Minimum Value 0 ...
https://dev.mysql.com/doc/refman/8.0/en/reusing-ssl-sessions.html
For example, change the cache timeout value from the default (300 seconds) to 600 seconds: mysql> SET GLOBAL ssl_session_cache_timeout = 600; The members of each pair of system and status variables may have different values temporarily due to the ...
https://dev.mysql.com/doc/refman/8.0/en/select-optimization.html
Tuning these statements is a top priority, whether to achieve sub-second response times for dynamic web pages, or to chop hours off the time to generate huge overnight reports. With efficient use of the InnoDB buffer pool, MyISAM key cache, and the ... Queries, in the form of SELECT statements, perform all the lookup operations in the ...
https://dev.mysql.com/doc/refman/8.0/en/set-operations.html
FROM t2) ORDER BY sort_col; To maintain sort order within individual results, add a secondary column to the ORDER BY clause: (SELECT 1 AS sort_col, col1a, col1b, ... Result Set Column Names and Data Types Set Operations with TABLE and VALUES ...