Effective MySQL:Replication Techniques in Depth

Binary Logs
MYCNF="/etc/my.cnf"
BINLOG=`grep log-bin ${MYCNF} | cut -d'=' -f2`
echo ${BINLOG}
DIR=`dirname${BINLOG}`
cd ${DIR}
ls -lh *
cat *.index
/opt/mysql/binlog/mysql-bin


Binary Log Analysis

引用

The mysqlbinlog utility is the recommended tool for reading binary logs

mysqlbinlog `pwd` /mysql-bin.000001

引用

It is possible to record the slow query infomation into the mysql.slow_log table useing the log_format configuration option.This can be of benefit if enable for a few seconds to record all SQL statements, which then can be mined for additional information, including the read/write ratio and breaddown on per-table basis.

stat mysql-bin.000001

引用

stat looks like a ls -l output

The information about the binary log in MySQL can be found with the SHOW MASTER STATUS command:
mysql -uroot -p -e "SHOW MASTER STATUS\g"

the binary log names follow a base_name.nnnnnn convention, where nnnnnn represents a sequential file number. This number is increamented when the individual binary log raches the size as specified by max_binlog_size, the server is restarted, or the FLUSH [BINARY] LOGS statement is issued

http://ronaldbradford.com/blog/mysql-dml-stats-per-table-2009-09-09/