master> sudo mysqlbinlog --short-form master-bin.000017
...
DELIMITER /*!*/;
SET TIMESTAMP=1285934400/*!*/;
...
BEGIN
/*!*/;
use `tac`/*!*/;
SET TIMESTAMP=1285934400/*!*/;
insert into test values(now())
/*!*/;
COMMIT/*!*/;
SET TIMESTAMP=1368372377/*!*/;
BEGIN
/*!*/;
SET TIMESTAMP=1368372377/*!*/;
insert into test values(now())
/*!*/;
COMMIT/*!*/;
...
User variable
User variable会被编码成十六进制串,含义不明,保密性不明。
1234567891011121314151617181920
mysql> flush logs;
Query OK, 0 rows affected (0.02 sec)
mysql> set @foo = now();
Query OK, 0 rows affected (0.00 sec)
mysql> insert into test values (@foo);
Query OK, 1 row affected (0.01 sec)
mysql> show binlog events in 'master-bin.000014';
+-------------------+-----+-------------+-----------+-------------+-----------------------------------------------------------------------------------+
| Log_name | Pos | Event_type | Server_id | End_log_pos | Info |
+-------------------+-----+-------------+-----------+-------------+-----------------------------------------------------------------------------------+
| master-bin.000014 | 4 | Format_desc | 1 | 107 | Server ver: 5.5.31-0ubuntu0.12.04.1-log, Binlog ver: 4 |
| master-bin.000014 | 107 | Query | 1 | 174 | BEGIN |
| master-bin.000014 | 174 | User var | 1 | 229 | @`foo`=_latin1 0x323031302D31302D30312031323A30303A3030 COLLATE latin1_swedish_ci |
| master-bin.000014 | 229 | Query | 1 | 321 | use `tac`; insert into test values (@foo) |
| master-bin.000014 | 321 | Xid | 1 | 348 | COMMIT /* xid=148 */ |
+-------------------+-----+-------------+-----------+-------------+-----------------------------------------------------------------------------------+
5 rows in set (0.00 sec)