Debian Codegraph @

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

raw
1 connect con1, localhost, root, , ;
2 connect con2, localhost, root, , ;
3 connect con3, localhost, root, , ;
4 connection default;
5 update performance_schema.setup_instruments set enabled='YES'
6 where name like "wait/synch/mutex/mysys/THR_LOCK_myisam";
7 drop table if exists test.t1;
8 drop table if exists test.t2;
9 drop table if exists test.t3;
10 truncate table performance_schema.events_waits_history_long;
11 show global variables like "thread_handling";
12 Variable_name Value
13 thread_handling one-thread-per-connection
14 connection con1;
15 create table test.t1(a int) engine=MYISAM;
16 connection con2;
17 create table test.t2(a int) engine=MYISAM;
18 connection con3;
19 create table test.t3(a int) engine=MYISAM;
20 connection default;
21 execute stmt_dump_events using @tid;
22 event_name short_source operation number_of_bytes
23 wait/synch/mutex/mysys/THR_LOCK_myisam lock NULL
24 execute stmt_dump_thread using @tid;
25 name
26 thread/sql/one_connection
27 execute stmt_dump_events using @tid;
28 event_name short_source operation number_of_bytes
29 wait/synch/mutex/mysys/THR_LOCK_myisam lock NULL
30 execute stmt_dump_thread using @tid;
31 name
32 thread/sql/one_connection
33 execute stmt_dump_events using @tid;
34 event_name short_source operation number_of_bytes
35 wait/synch/mutex/mysys/THR_LOCK_myisam lock NULL
36 execute stmt_dump_thread using @tid;
37 name
38 thread/sql/one_connection
39 drop table test.t1;
40 drop table test.t2;
41 drop table test.t3;
42 update performance_schema.setup_instruments set enabled='YES';
43 connection con1;
44 disconnect con1;
45 connection con2;
46 disconnect con2;
47 connection con3;
48 disconnect con3;
49 connection default;