mysql mysqlbinlog 使用
mysqlbinlog -R -h 192.168.56.221 -u tongchao -p111111 mysql0-bin.000001 --start-datetime="2010-12-22 00:00:00" --stop-datetime="2010-12-22 05:00:00" 远程binlog获取 需要权限：replication slave权限 mysqlbinlog -d 591up /data0/mysql/3306/tc/log-bin.000536 --start-datetime='2010-12-20 00:02:50' | grep ol_question >/data0/mysql/ol_question2.txt mysqlbinlog -d 591up /data0/mysql/3306/tc/log-bin.000536 --start-datetime='2010-12-20 00:02:50' | grep ol_question >/data0/mysql/ol_question2.txt mysqlbinlog -d servant_591up "D:/3.7/logbin/log-bin.000456" --start-datetime="2011-03-04 21:00:00" --stop-datetime="2011-03-04 22:10:00" >d:/sql/2011race/binlog.sql mysqlbinlog -d servant_591up D:\sql\0415race\log-bin.000545 >> D:\sql\0415race\servant_591up.sql mysqlbinlog -d servant_591up D:\sql\0415race\log-bin.000546 >> D:\sql\0415race\servant_591up.sql mysqlbinlog -d servant_591up D:\sql\0415race\log-bin.000547 >> D:\sql\0415race\servant_591up.sql mysqlbinlog -d servant_591up D:\sql\0415race\log-bin.000548 >> D:\sql\0415race\servant_591up.sql //分析binlog mysqlsla.pl -lt binary "D:\sql\0415race\servant_591up.sql" > D:\sql\0415race\mysqlsla.txt --top 100 // 使用mysqlsla 分析满查询 mysqlsla.pl --log-type slow "D:/861028/slow_query.log" >d:/sql/slow.txt 满查询 mysqlsla.pl -lt slow "D:/_861028/slow_query.log" -R print-unique -mf "db=591up" -sf "+SELECT"
