Debian Codegraph @

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

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