• sync_master_info


    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来刷新

  • 相关阅读:
    myssl.com SSL 检测
    tp中model加载机制
    号码归属地
    七牛云刷新缓存
    盒子模型
    eclipse中将项目发布到tomcat的root目录
    php二维数组搜索
    linux 编译 'aclocal-1.14' is missing on your system
    windows安装 centos
    svn ignore 的用法
  • 原文地址:https://www.cnblogs.com/hzcya1995/p/13351558.html
Copyright © 2020-2023  润新知