中繼日誌
中繼日誌來自Master的二進位制日誌,I / O執行緒從Master讀取,然後寫入本地的一類日誌,類似於binary log。作為SQL執行緒的輸入,中繼日誌中的事件將透過SQL執行緒來重演,從而實現複製。
The relay log consists of the events read from the binary log of the master and written by the slave I/O thread. Events in the relay log are executed on the slave as part of the SQL thread.
相關的引數:
mysql> show variables like '%relay%';
+-----------------------+----------------+
| Variable_name | Value |
+-----------------------+----------------+
| max_relay_log_size | 0 |
| relay_log | |
| relay_log_index | |
| relay_log_info_file | relay-log.info |
| relay_log_purge | ON |
| relay_log_recovery | OFF |
| relay_log_space_limit | 0 |
| sync_relay_log | 0 |
| sync_relay_log_info | 0 |
+-----------------------+----------------+
The relay log consists of the events read from the binary log of the master and written by the slave I/O thread. Events in the relay log are executed on the slave as part of the SQL thread.
相關的引數:
mysql> show variables like '%relay%';
+-----------------------+----------------+
| Variable_name | Value |
+-----------------------+----------------+
| max_relay_log_size | 0 |
| relay_log | |
| relay_log_index | |
| relay_log_info_file | relay-log.info |
| relay_log_purge | ON |
| relay_log_recovery | OFF |
| relay_log_space_limit | 0 |
| sync_relay_log | 0 |
| sync_relay_log_info | 0 |
+-----------------------+----------------+
sync_relay_log
- Description: The MariaDB server will synchronize its to disk after this many writes to the log. The default until was 0, in which case the operating system handles flushing the file to disk. 1 is the safest, but slowest, choice, since the file is flushed after each write. If autocommit is enabled, there is one write per statement, otherwise there's one write per transaction. If the disk has cache backed by battery, synchronization will be fast and a more conservative number can be chosen.
- Commandline: --sync-relay-log=#
- Scope: Global
- Dynamic: Yes
- Data Type: numeric
- Default Value: 10000 (>= ), 0 (<= )
sync_relay_log_info和sync_relay_log類似
relay_log_purge
- Description: If set to 1 (the default), will be purged as soon as they are no longer necessary.
- Commandline: --relay-log-purge={0|1}
- Scope: Global
- Dynamic: Yes
- Data Type: boolean
-
Default Value: ON
完整的引數可以參考。
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/29497382/viewspace-2153357/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- mysql之 日誌體系(錯誤日誌、查詢日誌、二進位制日誌、事務日誌、中繼日誌)MySql中繼
- MySQL複製應用中繼日誌解析MySql中繼
- Nginx+awstats+jawstats繼續WEB日誌分析NginxWeb
- 程式中的日誌
- .NetCore中的日誌(1)日誌元件解析NetCore元件
- oracle中清空日誌組Oracle
- oracle日誌分析從列表中移去一個日誌檔案Oracle
- apache日誌中IP地址排序Apache排序
- MySQL資料庫中的日誌檔案---(1)錯誤日誌MySql資料庫
- MySQL資料庫中的日誌檔案---(3)慢查詢日誌MySql資料庫
- MySQL資料庫中的日誌檔案---(2)普通查詢日誌MySql資料庫
- php日誌,記錄日誌PHP
- 日誌分析-apache日誌分析Apache
- Node 中如何更好地打日誌
- 如何在 Linux 中管理日誌Linux
- 如何在程式碼中打日誌
- DATAGUARD中手工處理日誌GAP
- 探究MySQL中的日誌檔案MySql
- 談談Selenium中的日誌
- nginx日誌中顯示cookie資訊NginxCookie
- Laravel 中自定義日誌目錄Laravel
- 在Hibernate中開啟日誌
- 重做日誌檔案中的SCN
- .NetCore中的日誌(2)整合第三方日誌工具NetCore
- struts 中怎樣將系統日誌與使用者日誌分離
- 聯機重做日誌、歸檔日誌、備用重做日誌
- mysql 日誌之錯誤日誌MySql
- mysql 日誌之慢查詢日誌MySql
- 【Oracle日誌】- 日誌檔案重建Oracle
- 日誌
- [日誌分析篇]-利用ELK分析jumpserver日誌-日誌拆分篇Server
- MySQL中幾種常見的日誌MySql
- NAS中如何檢視日誌記錄?
- RAC中歸檔日誌得命名格式
- mysql 日誌之普通查詢日誌MySql
- Apche日誌系列(4):日誌分析(轉)
- 『無為則無心』Python日誌 — 66、將日誌資訊儲存到檔案中Python
- MySQL資料庫中的日誌檔案---(5)系統日誌表的特點MySql資料庫