[root@percona-pxc55-1 mysql]# mysqlbinlog mysql-bin.000018
/*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=1*/;
/*!40019 SET @@session.max_insert_delayed_threads=0*/;
/*!50003 SET @OLD_COMPLETION_TYPE=@@COMPLETION_TYPE,COMPLETION_TYPE=0*/;
DELIMITER /*!*/;
# at 4
#140821 19:14:30 server id 3 end_log_pos 107 Start: binlog v 4, server v 5.5.37-35.0-55-log created 140821 19:14:30 at startup
...
# at 280
#140821 19:16:52 server id 3 end_log_pos 386 Query thread_id=5 exec_time=0 error_code=0
SET TIMESTAMP=1408628812/*!*/;
SET @@session.auto_increment_increment=1, @@session.auto_increment_offset=1/*!*/;
create table nil (id int, name varchar(10))
/*!*/;
# at 386
#140821 19:17:14 server id 3 end_log_pos 471 Query thread_id=5 exec_time=0 error_code=0
SET TIMESTAMP=1408628834/*!*/;
SET @@session.auto_increment_increment=2, @@session.auto_increment_offset=2/*!*/;
FLUSH QUERY CACHE
/*!*/;
DELIMITER ;
# End of log file
ROLLBACK /* added by mysqlbinlog */;
/*!50003 SET COMPLETION_TYPE=@OLD_COMPLETION_TYPE*/;
/*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=0*/;
[root@percona-pxc55-1 mysql]#
Verified with PXC 5.5 and 5.6. FLUSH QUERY CACHE is written in binlog but not RESET QUERY CACHE.
[root@percona- pxc55-1 ~]# mysql -uroot -p
Enter password:
...
mysql> create table nil (id int, name varchar(10));
Query OK, 0 rows affected (0.07 sec)
mysql> FLUSH QUERY CACHE;
Query OK, 0 rows affected (0.00 sec)
mysql> RESET QUERY CACHE;
Query OK, 0 rows affected (0.00 sec)
mysql> quit pxc55-1 ~]#
Bye
[root@percona-
[root@percona- pxc55-1 mysql]# mysqlbinlog mysql-bin.000018 PSEUDO_ SLAVE_MODE= 1*/; max_insert_ delayed_ threads= 0*/; _TYPE=@ @COMPLETION_ TYPE,COMPLETION _TYPE=0* /; 1408628812/ *!*/; auto_increment_ increment= 1, @@session. auto_increment_ offset= 1/*!*/; 1408628834/ *!*/; auto_increment_ increment= 2, @@session. auto_increment_ offset= 2/*!*/; TYPE=@OLD_ COMPLETION_ TYPE*/; PSEUDO_ SLAVE_MODE= 0*/; pxc55-1 mysql]#
/*!50530 SET @@SESSION.
/*!40019 SET @@session.
/*!50003 SET @OLD_COMPLETION
DELIMITER /*!*/;
# at 4
#140821 19:14:30 server id 3 end_log_pos 107 Start: binlog v 4, server v 5.5.37-35.0-55-log created 140821 19:14:30 at startup
...
# at 280
#140821 19:16:52 server id 3 end_log_pos 386 Query thread_id=5 exec_time=0 error_code=0
SET TIMESTAMP=
SET @@session.
create table nil (id int, name varchar(10))
/*!*/;
# at 386
#140821 19:17:14 server id 3 end_log_pos 471 Query thread_id=5 exec_time=0 error_code=0
SET TIMESTAMP=
SET @@session.
FLUSH QUERY CACHE
/*!*/;
DELIMITER ;
# End of log file
ROLLBACK /* added by mysqlbinlog */;
/*!50003 SET COMPLETION_
/*!50530 SET @@SESSION.
[root@percona-