Debian Codegraph @

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

raw
1 include/master-slave.inc
2 [connection master]
3 drop table if exists test.t1;
4 connection slave;
5 reset master;
6 create table test.t1(a int);
7 drop table test.t1;
8 include/show_binlog_events.inc
9 Log_name Pos Event_type Server_id End_log_pos Info
10 slave-bin.000001 # Gtid # # GTID #-#-#
11 slave-bin.000001 # Query # # use `test`; create table test.t1(a int)
12 slave-bin.000001 # Gtid # # GTID #-#-#
13 slave-bin.000001 # Query # # use `test`; DROP TABLE `t1` /* generated by server */
14 connection master;
15 "============ Performance schema on master ============"
16 select ID from INFORMATION_SCHEMA.PROCESSLIST
17 where COMMAND = "Binlog Dump"
18 into @master_dump_pid;
19 select COMMAND, STATE
20 from INFORMATION_SCHEMA.PROCESSLIST
21 where ID = @master_dump_pid;
22 COMMAND STATE
23 Binlog Dump Master has sent all binlog to slave; waiting for more updates
24 select NAME, TYPE, PROCESSLIST_COMMAND, PROCESSLIST_STATE
25 from performance_schema.threads
26 where PROCESSLIST_ID = @master_dump_pid;
27 NAME TYPE PROCESSLIST_COMMAND PROCESSLIST_STATE
28 thread/sql/one_connection FOREGROUND Binlog Dump Master has sent all binlog to slave; waiting for more updates
29 connection slave;
30 "============ Performance schema on slave ============"
31 select ID from INFORMATION_SCHEMA.PROCESSLIST
32 where STATE like "Waiting for master to send event%"
33 into @slave_io_pid;
34 select COMMAND, STATE
35 from INFORMATION_SCHEMA.PROCESSLIST
36 where ID = @slave_io_pid;
37 COMMAND STATE
38 Slave_IO Waiting for master to send event
39 select NAME, TYPE, PROCESSLIST_COMMAND, PROCESSLIST_STATE
40 from performance_schema.threads
41 where PROCESSLIST_ID = @slave_io_pid;
42 NAME TYPE PROCESSLIST_COMMAND PROCESSLIST_STATE
43 select ID from INFORMATION_SCHEMA.PROCESSLIST
44 where STATE like "Slave has read all relay log%"
45 into @slave_sql_pid;
46 select COMMAND, STATE
47 from INFORMATION_SCHEMA.PROCESSLIST
48 where ID = @slave_sql_pid;
49 COMMAND STATE
50 Slave_SQL Slave has read all relay log; waiting for more updates
51 select NAME, TYPE, PROCESSLIST_COMMAND, PROCESSLIST_STATE
52 from performance_schema.threads
53 where PROCESSLIST_ID = @slave_sql_pid;
54 NAME TYPE PROCESSLIST_COMMAND PROCESSLIST_STATE
55 #
56 # MDEV-33031 Assertion failure upon reading from performance schema with binlog enabled
57 #
58 select variable_name, variable_value from performance_schema.status_by_thread
59 where variable_name like '%impossible%';
60 variable_name variable_value
61 include/rpl_end.inc