1set binlog_format=statement; 2RESET MASTER; 3drop database if exists my_local_db; 4create database my_local_db; 5create table my_local_db.my_tx_table(a bigint) engine = innodb; 6create table my_local_db.my_non_tx_table(a bigint) engine = myisam; 7use test; 8drop table if exists marker_start; 9Warnings: 10Note 1051 Unknown table 'test.marker_start' 11use my_local_db; 12insert into my_tx_table(a) 13values (1000), (2000), (3000); 14insert into my_non_tx_table(a) 15values (1000), (2000), (3000); 16use test; 17drop table if exists marker_truncate; 18Warnings: 19Note 1051 Unknown table 'test.marker_truncate' 20use performance_schema; 21truncate table events_waits_history; 22truncate table events_waits_history_long; 23use test; 24truncate table performance_schema.events_statements_history_long; 25truncate table performance_schema.host_cache; 26use test; 27drop table if exists marker_update; 28Warnings: 29Note 1051 Unknown table 'test.marker_update' 30use performance_schema; 31update setup_instruments set enabled='NO'; 32update setup_instruments set timed='NO'; 33use test; 34update performance_schema.setup_instruments set enabled='YES', timed='YES'; 35update performance_schema.threads set instrumented='YES'; 36use test; 37drop table if exists marker_insert; 38Warnings: 39Note 1051 Unknown table 'test.marker_insert' 40insert into performance_schema.setup_actors(`user`, `host`, `role`) 41values ('XXX', 'XXX', 'XXX'), 42('YYY', 'YYY', 'YYY'), 43('ZZZ', 'ZZZ', 'ZZZ'); 44select * from performance_schema.setup_actors 45where user in ('XXX', 'YYY', 'ZZZ') order by user; 46HOST USER ROLE 47XXX XXX XXX 48YYY YYY YYY 49ZZZ ZZZ ZZZ 50insert into performance_schema.setup_objects 51(object_type, object_schema, object_name, enabled, timed) 52values ('TABLE', 'DB1', 'AAA', 'YES', 'YES'), 53('TABLE', 'DB1', 'BBB', 'NO', 'NO'), 54('TABLE', 'DB2', 'CCC', 'YES', 'NO'), 55('TABLE', 'DB2', 'DDD', 'NO', 'YES'); 56select * from performance_schema.setup_objects 57where object_schema like 'DB%' order by object_name; 58OBJECT_TYPE OBJECT_SCHEMA OBJECT_NAME ENABLED TIMED 59TABLE DB1 AAA YES YES 60TABLE DB1 BBB NO NO 61TABLE DB2 CCC YES NO 62TABLE DB2 DDD NO YES 63use test; 64drop table if exists marker_insert_select; 65Warnings: 66Note 1051 Unknown table 'test.marker_insert_select' 67use my_local_db; 68insert into my_tx_table(a) 69select thread_id from performance_schema.threads; 70insert into my_non_tx_table(a) 71select thread_id from performance_schema.threads; 72insert into my_tx_table(a) 73select id from information_schema.processlist; 74insert into my_non_tx_table(a) 75select id from information_schema.processlist; 76insert into my_tx_table(a) 77select thread_id from mysql.general_log; 78insert into my_non_tx_table(a) 79select thread_id from mysql.general_log; 80insert into my_tx_table(a) 81select thread_id from mysql.slow_log; 82insert into my_non_tx_table(a) 83select thread_id from mysql.slow_log; 84insert into my_tx_table(a) 85select Relay_log_pos from mysql.slave_relay_log_info; 86insert into my_non_tx_table(a) 87select Relay_log_pos from mysql.slave_relay_log_info; 88insert into my_tx_table(a) 89select Master_log_pos from mysql.slave_master_info; 90insert into my_non_tx_table(a) 91select Master_log_pos from mysql.slave_master_info; 92insert into my_tx_table(a) 93select Relay_log_pos from mysql.slave_worker_info; 94insert into my_non_tx_table(a) 95select Relay_log_pos from mysql.slave_worker_info; 96use test; 97drop table if exists marker_delete; 98Warnings: 99Note 1051 Unknown table 'test.marker_delete' 100delete from performance_schema.setup_actors 101where user in ('XXX', 'YYY', 'ZZZ'); 102delete from performance_schema.setup_objects 103where object_schema like 'DB%'; 104use test; 105drop table if exists marker_end; 106Warnings: 107Note 1051 Unknown table 'test.marker_end' 108drop database my_local_db; 109include/show_binlog_events.inc 110Log_name Pos Event_type Server_id End_log_pos Info 111master-bin.000001 # Query # # use `test`; create table my_local_db.my_tx_table(a bigint) engine = innodb 112master-bin.000001 # Query # # use `test`; create table my_local_db.my_non_tx_table(a bigint) engine = myisam 113master-bin.000001 # Query # # use `test`; DROP TABLE IF EXISTS `marker_start` /* generated by server */ 114master-bin.000001 # Query # # use `test`; DROP TABLE IF EXISTS `marker_truncate` /* generated by server */ 115master-bin.000001 # Query # # use `test`; DROP TABLE IF EXISTS `marker_update` /* generated by server */ 116master-bin.000001 # Query # # use `test`; DROP TABLE IF EXISTS `marker_insert` /* generated by server */ 117master-bin.000001 # Query # # use `test`; DROP TABLE IF EXISTS `marker_insert_select` /* generated by server */ 118master-bin.000001 # Query # # use `test`; DROP TABLE IF EXISTS `marker_delete` /* generated by server */ 119master-bin.000001 # Query # # use `test`; DROP TABLE IF EXISTS `marker_end` /* generated by server */ 120