Debian Codegraph @

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

raw
1 set binlog_format=mixed;
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_replicated_db;
6 call mtr.add_suppression("Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT");
7 create database my_replicated_db;
8 create table my_replicated_db.my_non_tx_table(a bigint) engine = myisam;
9 use test;
10 drop table if exists marker_start;
11 Warnings:
12 Note 1051 Unknown table 'test.marker_start'
13 use my_replicated_db;
14 insert into my_non_tx_table(a)
15 values (1000), (2000), (3000);
16 use test;
17 drop table if exists marker_insert_select;
18 Warnings:
19 Note 1051 Unknown table 'test.marker_insert_select'
20 use my_replicated_db;
21 insert into my_non_tx_table(a)
22 select thread_id from performance_schema.threads;
23 insert into my_non_tx_table(a)
24 select id from information_schema.processlist;
25 Warnings:
26 Warning 1287 'INFORMATION_SCHEMA.PROCESSLIST' is deprecated and will be removed in a future release. Please use performance_schema.processlist instead
27 insert into my_non_tx_table(a)
28 select thread_id from mysql.general_log;
29 insert into my_non_tx_table(a)
30 select thread_id from mysql.slow_log;
31 insert into my_non_tx_table(a)
32 select Relay_log_pos from mysql.slave_relay_log_info;
33 insert into my_non_tx_table(a)
34 select Master_log_pos from mysql.slave_master_info;
35 insert into my_non_tx_table(a)
36 select Relay_log_pos from mysql.slave_worker_info;
37 use test;
38 drop table if exists marker_multi_update;
39 Warnings:
40 Note 1051 Unknown table 'test.marker_multi_update'
41 use my_replicated_db;
42 update my_non_tx_table, performance_schema.setup_instruments
43 set my_non_tx_table.a = my_non_tx_table.a + 1,
44 performance_schema.setup_instruments.timed= 'NO';
45 use test;
46 drop table if exists marker_multi_delete;
47 Warnings:
48 Note 1051 Unknown table 'test.marker_multi_delete'
49 use my_replicated_db;
50 insert into performance_schema.setup_actors
51 values ('BAR', 'BAR', 'BAR', 'YES', 'YES');
52 delete my_non_tx_table.*, performance_schema.setup_actors.*
53 from my_non_tx_table, performance_schema.setup_actors
54 where my_non_tx_table.a != 1000
55 or performance_schema.setup_actors.role='BAR';
56 use test;
57 drop table if exists marker_end;
58 Warnings:
59 Note 1051 Unknown table 'test.marker_end'
60 drop database my_replicated_db;
61 include/show_binlog_events.inc
62 Log_name Pos Event_type Server_id End_log_pos Info
63 binlog.000001 # Query # # drop database if exists my_replicated_db
64 binlog.000001 # Query # # BEGIN
65 binlog.000001 # Query # # use `mtr`; INSERT INTO test_suppressions (pattern) VALUES ( NAME_CONST('pattern',_utf8mb4'Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT' COLLATE 'utf8mb4_0900_ai_ci'))
66 binlog.000001 # Xid # # COMMIT /* XID */
67 binlog.000001 # Query # # create database my_replicated_db
68 binlog.000001 # Query # # use `test`; create table my_replicated_db.my_non_tx_table(a bigint) engine = myisam
69 binlog.000001 # Query # # use `test`; DROP TABLE IF EXISTS `marker_start` /* generated by server */
70 binlog.000001 # Query # # BEGIN
71 binlog.000001 # Query # # use `my_replicated_db`; insert into my_non_tx_table(a)
72 values (1000), (2000), (3000)
73 binlog.000001 # Query # # COMMIT
74 binlog.000001 # Query # # use `test`; DROP TABLE IF EXISTS `marker_insert_select` /* generated by server */
75 binlog.000001 # Query # # BEGIN
76 binlog.000001 # Table_map # # table_id: # (my_replicated_db.my_non_tx_table)
77 binlog.000001 # Write_rows # # table_id: # flags: STMT_END_F
78 binlog.000001 # Query # # COMMIT
79 binlog.000001 # Query # # BEGIN
80 binlog.000001 # Query # # use `my_replicated_db`; insert into my_non_tx_table(a)
81 select id from information_schema.processlist
82 binlog.000001 # Query # # COMMIT
83 binlog.000001 # Query # # use `test`; DROP TABLE IF EXISTS `marker_multi_update` /* generated by server */
84 binlog.000001 # Query # # BEGIN
85 binlog.000001 # Table_map # # table_id: # (my_replicated_db.my_non_tx_table)
86 binlog.000001 # Update_rows # # table_id: # flags: STMT_END_F
87 binlog.000001 # Query # # COMMIT
88 binlog.000001 # Query # # use `test`; DROP TABLE IF EXISTS `marker_multi_delete` /* generated by server */
89 binlog.000001 # Query # # BEGIN
90 binlog.000001 # Table_map # # table_id: # (my_replicated_db.my_non_tx_table)
91 binlog.000001 # Delete_rows # # table_id: # flags: STMT_END_F
92 binlog.000001 # Query # # COMMIT
93 binlog.000001 # Query # # use `test`; DROP TABLE IF EXISTS `marker_end` /* generated by server */
94 binlog.000001 # Query # # use `my_replicated_db`; DROP TABLE IF EXISTS `my_non_tx_table` /* generated by server */
95 binlog.000001 # Query # # drop database my_replicated_db
96 truncate table performance_schema.setup_actors;
97 insert into performance_schema.setup_actors values ('%', '%', '%', 'YES', 'YES');