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来刷新
转载请注明原文地址: https://www.6miu.com/read-76143.html