统计mysql binlog中的dml语句 master@root@test 07:44:52gt;create table tab02(id int(10) primary key,name varchar(20)); q
统计mysql binlog中的dml语句
master@root@test 07:44:52>create table tab02(id int(10) primary key,name varchar(20)); 
query ok, 0 rows affected (0.10 sec)
master@root@test 08:34:54> 
master@root@test 08:34:54> 
master@root@test 08:34:54>insert into tab02 values(1,'ddd'); 
query ok, 1 row affected (0.00 sec)
master@root@test 08:34:59>insert into tab02 values(2,'ddd'); 
query ok, 1 row affected (0.00 sec)
master@root@test 08:35:01>insert into tab02 values(3,'ddd'); 
query ok, 1 row affected (0.00 sec)
master@root@test 08:35:03>insert into tab02 values(4,'ddd'); 
query ok, 1 row affected (0.00 sec)
master@root@test 08:35:04>insert into tab02 values(5,'ddd'); 
query ok, 1 row affected (0.01 sec)
master@root@test 08:35:07>insert into tab02 values(6,'ddd'); 
query ok, 1 row affected (0.00 sec)
master@root@test 08:35:09>delete from tab02 where id=6; 
query ok, 1 row affected (0.02 sec)
master@root@test 08:35:19>update tab02 set where id=1 
    -> ; 
query ok, 1 row affected (0.00 sec) 
rows matched: 1  changed: 1  warnings: 0
master@root@test 08:35:39>update tab02 set where id=3; 
query ok, 1 row affected (0.00 sec) 
rows matched: 1  changed: 1  warnings: 0
[root@mynode1 mysql]# /service/mysql/bin/mysqlbinlog binlog-master.000006 |\ 
> grep -i -e ^update -e ^insert -e ^delete -e ^replace -e ^alter  | \ 
> cut -c1-100 | tr '[a-z]' '[a-z]' |  \ 
> sed -e s/\t/ /g;s/\`//g;s/(.*$//;s/ set .*$//;s/ as .*$// | sed -e s/ where .*$// |  \ 
> sort | uniq -c | sort -nr 
      7 insert into tab02 values 
      2 update tab02 
      1 delete from tab02 
相关阅读：
mysql 大dml操作建议
mysql常用ddl、dml、dcl语言整理（附样例）
mysql中binlog日记清理
，