sync_master_info
来源:互联网 发布:花呗充值qb的淘宝店 编辑:程序博客网 时间:2024/05/04 01:38
- master_info_repository = TABLE. If the value of sync_master_info is greater than 0, the slave updates its master info repository table after every sync_master_info events. If
-
- it is 0, the table is never updated.
-
-
- 如果设置master_info_repository = TABLE,那么sync_master_info的值>0, slave 更新它的master info 每sync_master_info events
-
- 如果设置为0, 表永远不给更新。
-
-
- master_info_repository = FILE. If the value of sync_master_info is greater than 0, the slave synchronizes its master.info file to disk (using fdatasync()) after every
-
- sync_master_info events. If it is 0, the MySQL server performs no synchronization of the master.info file to disk; instead, the server relies on the operating system to flush
-
- its contents periodically as with any other file.
-
-
- 如果设置为FILE,如果sync_master_info的值>0,slave同步它的master.info file to disk (使用fdatasync()) 在every sync_master_info events)
-
- 如果设置为0,MySQL server 不执行同步,代替的是, 依赖OS来刷新