diff options
Diffstat (limited to 'mysql-test/suite/perfschema/r/binlog_ok_stmt.result')
| -rw-r--r-- | mysql-test/suite/perfschema/r/binlog_ok_stmt.result | 119 |
1 files changed, 119 insertions, 0 deletions
diff --git a/mysql-test/suite/perfschema/r/binlog_ok_stmt.result b/mysql-test/suite/perfschema/r/binlog_ok_stmt.result new file mode 100644 index 00000000..9fd9af6c --- /dev/null +++ b/mysql-test/suite/perfschema/r/binlog_ok_stmt.result @@ -0,0 +1,119 @@ +set binlog_format=statement; +RESET MASTER; +drop database if exists my_local_db; +create database my_local_db; +create table my_local_db.my_tx_table(a bigint) engine = innodb; +create table my_local_db.my_non_tx_table(a bigint) engine = myisam; +use test; +drop table if exists marker_start; +Warnings: +Note 1051 Unknown table 'test.marker_start' +use my_local_db; +insert into my_tx_table(a) +values (1000), (2000), (3000); +insert into my_non_tx_table(a) +values (1000), (2000), (3000); +use test; +drop table if exists marker_truncate; +Warnings: +Note 1051 Unknown table 'test.marker_truncate' +use performance_schema; +truncate table events_waits_history; +truncate table events_waits_history_long; +use test; +truncate table performance_schema.events_statements_history_long; +truncate table performance_schema.host_cache; +use test; +drop table if exists marker_update; +Warnings: +Note 1051 Unknown table 'test.marker_update' +use performance_schema; +update setup_instruments set enabled='NO'; +update setup_instruments set timed='NO'; +use test; +update performance_schema.setup_instruments set enabled='YES', timed='YES'; +update performance_schema.threads set instrumented='YES'; +use test; +drop table if exists marker_insert; +Warnings: +Note 1051 Unknown table 'test.marker_insert' +insert into performance_schema.setup_actors(`user`, `host`, `role`) +values ('XXX', 'XXX', 'XXX'), +('YYY', 'YYY', 'YYY'), +('ZZZ', 'ZZZ', 'ZZZ'); +select * from performance_schema.setup_actors +where user in ('XXX', 'YYY', 'ZZZ') order by user; +HOST USER ROLE ENABLED HISTORY +XXX XXX XXX YES YES +YYY YYY YYY YES YES +ZZZ ZZZ ZZZ YES YES +insert into performance_schema.setup_objects +(object_type, object_schema, object_name, enabled, timed) +values ('TABLE', 'DB1', 'AAA', 'YES', 'YES'), +('TABLE', 'DB1', 'BBB', 'NO', 'NO'), +('TABLE', 'DB2', 'CCC', 'YES', 'NO'), +('TABLE', 'DB2', 'DDD', 'NO', 'YES'); +select * from performance_schema.setup_objects +where object_schema like 'DB%' order by object_name; +OBJECT_TYPE OBJECT_SCHEMA OBJECT_NAME ENABLED TIMED +TABLE DB1 AAA YES YES +TABLE DB1 BBB NO NO +TABLE DB2 CCC YES NO +TABLE DB2 DDD NO YES +use test; +drop table if exists marker_insert_select; +Warnings: +Note 1051 Unknown table 'test.marker_insert_select' +use my_local_db; +insert into my_tx_table(a) +select thread_id from performance_schema.threads; +insert into my_non_tx_table(a) +select thread_id from performance_schema.threads; +insert into my_tx_table(a) +select id from information_schema.processlist; +insert into my_non_tx_table(a) +select id from information_schema.processlist; +insert into my_tx_table(a) +select thread_id from mysql.general_log; +insert into my_non_tx_table(a) +select thread_id from mysql.general_log; +insert into my_tx_table(a) +select thread_id from mysql.slow_log; +insert into my_non_tx_table(a) +select thread_id from mysql.slow_log; +insert into my_tx_table(a) +select Relay_log_pos from mysql.slave_relay_log_info; +insert into my_non_tx_table(a) +select Relay_log_pos from mysql.slave_relay_log_info; +insert into my_tx_table(a) +select Master_log_pos from mysql.slave_master_info; +insert into my_non_tx_table(a) +select Master_log_pos from mysql.slave_master_info; +insert into my_tx_table(a) +select Relay_log_pos from mysql.slave_worker_info; +insert into my_non_tx_table(a) +select Relay_log_pos from mysql.slave_worker_info; +use test; +drop table if exists marker_delete; +Warnings: +Note 1051 Unknown table 'test.marker_delete' +delete from performance_schema.setup_actors +where user in ('XXX', 'YYY', 'ZZZ'); +delete from performance_schema.setup_objects +where object_schema like 'DB%'; +use test; +drop table if exists marker_end; +Warnings: +Note 1051 Unknown table 'test.marker_end' +drop database my_local_db; +include/show_binlog_events.inc +Log_name Pos Event_type Server_id End_log_pos Info +master-bin.000001 # Query # # use `test`; create table my_local_db.my_tx_table(a bigint) engine = innodb +master-bin.000001 # Query # # use `test`; create table my_local_db.my_non_tx_table(a bigint) engine = myisam +master-bin.000001 # Query # # use `test`; DROP TABLE IF EXISTS `marker_start` /* generated by server */ +master-bin.000001 # Query # # use `test`; DROP TABLE IF EXISTS `marker_truncate` /* generated by server */ +master-bin.000001 # Query # # use `test`; DROP TABLE IF EXISTS `marker_update` /* generated by server */ +master-bin.000001 # Query # # use `test`; DROP TABLE IF EXISTS `marker_insert` /* generated by server */ +master-bin.000001 # Query # # use `test`; DROP TABLE IF EXISTS `marker_insert_select` /* generated by server */ +master-bin.000001 # Query # # use `test`; DROP TABLE IF EXISTS `marker_delete` /* generated by server */ +master-bin.000001 # Query # # use `test`; DROP TABLE IF EXISTS `marker_end` /* generated by server */ |