Debian Codegraph @

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

raw
1 set binlog_format=row;
2 RESET MASTER;
3 select count(*) > 0 from performance_schema.setup_instruments;
4 count(*) > 0
5 1
6 update performance_schema.setup_instruments set enabled='NO'
7 where name like "wait/synch/rwlock/sql/%"
8 and name not in ("wait/synch/rwlock/sql/CRYPTO_dynlock_value::lock");
9 select count(*) > 0 from performance_schema.events_waits_current;
10 count(*) > 0
11 1
12 drop table if exists test.t1;
13 drop table if exists test.t2;
14 create table test.t1 (thread_id integer);
15 create table test.t2 (name varchar(128));
16 insert into test.t1
17 select thread_id from performance_schema.events_waits_current;
18 insert into test.t2
19 select name from performance_schema.setup_instruments
20 where name like "wait/synch/rwlock/sql/%"
21 and name not in ("wait/synch/rwlock/sql/CRYPTO_dynlock_value::lock");
22 drop table test.t1;
23 drop table test.t2;
24 update performance_schema.setup_instruments set enabled='YES'
25 where name like "wait/synch/rwlock/sql/%"
26 and name not in ("wait/synch/rwlock/sql/CRYPTO_dynlock_value::lock");
27 include/show_binlog_events.inc
28 Log_name Pos Event_type Server_id End_log_pos Info
29 master-bin.000001 # Gtid # # GTID #-#-#
30 master-bin.000001 # Query # # use `test`; DROP TABLE IF EXISTS `t1` /* generated by server */
31 master-bin.000001 # Gtid # # GTID #-#-#
32 master-bin.000001 # Query # # use `test`; DROP TABLE IF EXISTS `t2` /* generated by server */
33 master-bin.000001 # Gtid # # GTID #-#-#
34 master-bin.000001 # Query # # use `test`; create table test.t1 (thread_id integer)
35 master-bin.000001 # Gtid # # GTID #-#-#
36 master-bin.000001 # Query # # use `test`; create table test.t2 (name varchar(128))
37 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
38 master-bin.000001 # Annotate_rows # # insert into test.t1
39 select thread_id from performance_schema.events_waits_current
40 master-bin.000001 # Table_map # # table_id: # (test.t1)
41 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
42 master-bin.000001 # Query # # COMMIT
43 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
44 master-bin.000001 # Annotate_rows # # insert into test.t2
45 select name from performance_schema.setup_instruments
46 where name like "wait/synch/rwlock/sql/%"
47 and name not in ("wait/synch/rwlock/sql/CRYPTO_dynlock_value::lock")
48 master-bin.000001 # Table_map # # table_id: # (test.t2)
49 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
50 master-bin.000001 # Query # # COMMIT
51 master-bin.000001 # Gtid # # GTID #-#-#
52 master-bin.000001 # Query # # use `test`; DROP TABLE `t1` /* generated by server */
53 master-bin.000001 # Gtid # # GTID #-#-#
54 master-bin.000001 # Query # # use `test`; DROP TABLE `t2` /* generated by server */