常用binlogログ操作コマンド

685 ワード

1.    binlog    
mysql> show master logs;
 
   
2.  master  ,   (  )  binlog       ,          pos   (Position) 
mysql> show master status;
 
   
3.  log  ,             binlog    
mysql> flush logs;
 :  mysqld     ,        ,  binlog  ; mysqldump       -F       binlog  ;
 
   
4.  (  )  binlog  
mysql> reset master;

 
転載先:https://www.cnblogs.com/liang545621/p/9400442.html