Debian Codegraph @

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

raw
1 update performance_schema.setup_instruments set enabled='NO';
2 update performance_schema.setup_consumers set enabled='YES';
3 update performance_schema.setup_instruments set enabled='YES'
4 where name like "wait/synch/mutex/mysys/THR_LOCK_myisam";
5 drop table if exists test.t1;
6 truncate table performance_schema.events_waits_current;
7 truncate table performance_schema.events_waits_history;
8 truncate table performance_schema.events_waits_history_long;
9 show global variables like "thread_handling";
10 Variable_name Value
11 thread_handling no-threads
12 show status like "Performance_schema_thread_instances_lost";
13 Variable_name Value
14 Performance_schema_thread_instances_lost 0
15 create table test.t1(a int);
16 show global variables like "performance_schema";
17 Variable_name Value
18 performance_schema ON
19 show global variables like "performance_schema_max_thread%";
20 Variable_name Value
21 performance_schema_max_thread_classes 100
22 performance_schema_max_thread_instances 50
23 select count(*) from performance_schema.threads
24 where name like "thread/sql/main";
25 count(*)
26 1
27 select count(*) from performance_schema.threads
28 where name like "thread/sql/OneConnection";
29 count(*)
30 0
31 select event_name, operation,
32 left(source, locate(":", source)) as short_source
33 from performance_schema.events_waits_current;
34 event_name operation short_source
35 wait/synch/mutex/mysys/THR_LOCK_myisam lock mi_create.cc:
36 select event_name, operation,
37 left(source, locate(":", source)) as short_source
38 from performance_schema.events_waits_history;
39 event_name operation short_source
40 wait/synch/mutex/mysys/THR_LOCK_myisam lock mi_create.cc:
41 select event_name, operation,
42 left(source, locate(":", source)) as short_source
43 from performance_schema.events_waits_history_long;
44 event_name operation short_source
45 wait/synch/mutex/mysys/THR_LOCK_myisam lock mi_create.cc:
46 update performance_schema.setup_instruments set enabled='YES';
47 drop table test.t1;