Debian Codegraph @

mysql-test/suite/galera/r/galera_performance_schema.result

raw
1 connection node_2;
2 connection node_1;
3 use performance_schema;
4 SELECT name
5 FROM threads
6 WHERE name LIKE 'thread/sql/wsrep%'
7 ORDER BY name;
8 name thread/sql/wsrep_applier_thread
9 name thread/sql/wsrep_rollbacker_thread
10 use test;
11 create table t1 (a int not null primary key) engine=innodb;
12 insert into t1 values (1),(2);
13 use performance_schema;
14 select name from mutex_instances where name like 'wait/synch/mutex/sql/LOCK_wsrep%' order by name;
15 name wait/synch/mutex/sql/LOCK_wsrep_cluster_config
16 name wait/synch/mutex/sql/LOCK_wsrep_config_state
17 name wait/synch/mutex/sql/LOCK_wsrep_desync
18 name wait/synch/mutex/sql/LOCK_wsrep_donor_monitor
19 name wait/synch/mutex/sql/LOCK_wsrep_group_commit
20 name wait/synch/mutex/sql/LOCK_wsrep_gtid_wait_upto
21 name wait/synch/mutex/sql/LOCK_wsrep_joiner_monitor
22 name wait/synch/mutex/sql/LOCK_wsrep_ready
23 name wait/synch/mutex/sql/LOCK_wsrep_replaying
24 name wait/synch/mutex/sql/LOCK_wsrep_slave_threads
25 name wait/synch/mutex/sql/LOCK_wsrep_SR_pool
26 name wait/synch/mutex/sql/LOCK_wsrep_SR_store
27 name wait/synch/mutex/sql/LOCK_wsrep_sst
28 name wait/synch/mutex/sql/LOCK_wsrep_sst_init
29 select name from cond_instances where name like 'wait/synch/cond/sql/COND_wsrep%' order by name;
30 name wait/synch/cond/sql/COND_wsrep_donor_monitor
31 name wait/synch/cond/sql/COND_wsrep_joiner_monitor
32 name wait/synch/cond/sql/COND_wsrep_ready
33 name wait/synch/cond/sql/COND_wsrep_replaying
34 name wait/synch/cond/sql/COND_wsrep_sst
35 name wait/synch/cond/sql/COND_wsrep_sst_init
36 name wait/synch/cond/sql/COND_wsrep_wsrep_slave_threads
37 connection node_2;
38 use test;
39 SET SESSION wsrep_on=OFF;
40 CREATE TABLE t2 (f1 INTEGER) engine=innodb;
41 connection node_1;
42 use test;
43 CREATE TABLE t2 (f1 INTEGER) engine=innodb;
44 connection node_2;
45 SET SESSION wsrep_on=ON;
46 SELECT COUNT(*) FROM t1;
47 COUNT(*) 2
48 use performance_schema;
49 select count(*)>=1 from file_instances where file_name like '%GRA_%.log';
50 count(*)>=1 1
51 CALL mtr.add_suppression("Slave SQL: Error 'Table 't2' already exists' on query");
52 use test;
53 drop table t1;
54 drop table t2;