Debian Codegraph @

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

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