![](https://csdnimg.cn/release/download_crawler_static/46737155/bg5.jpg)
zhiblog.com Linux
mysqld binlog.000001 binlog.index
mysqld binlog binlog
SQL mysqld binlog
FLUSHLOGS;
master.info relay-log.info
binlog MySQL mysqlbinlog
/usr/local/mysql/bin/mysqlbinlog /tmp/binlog.000001
SQL
/usr/local/mysql/bin/mysqlbinlog /tmp/binlog.000001 | mysql -uyejr -pyejr db_name
mysqlbinlog SQL
slave
5
[ ]
SQL
FLUSHTABLES WITH READLOCK;
Innodb ib_logfile* Innodb
6
( replication ) slave
7
DBA( )
SQL
CHECKTABLE REPAIRTABLE MyISAM
OPTIMIZE TABLE MyISAM
ANALYZETABLE MyISAM
myisamchk
Innodb