- 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来刷新
sync_master_info
最新推荐文章于 2024-04-21 12:36:47 发布