Debian Codegraph @

mysql-test/suite/perfschema/r/binlog_ok_mix.result

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