Debian Codegraph @

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

raw
1 SET GLOBAL event_scheduler = OFF;
2 SELECT name, type, processlist_user, processlist_host, processlist_db,
3 processlist_command, processlist_info,
4 IF(parent_thread_id IS NULL, parent_thread_id, 'unified parent_thread_id')
5 AS unified_parent_thread_id,
6 `role`, instrumented
7 FROM performance_schema.threads
8 WHERE name LIKE 'thread/sql%'
9 ORDER BY name;
10 name thread/sql/compress_gtid_table
11 type FOREGROUND
12 processlist_user NULL
13 processlist_host NULL
14 processlist_db NULL
15 processlist_command Daemon
16 processlist_info NULL
17 unified_parent_thread_id unified parent_thread_id
18 role NULL
19 instrumented YES
20 name thread/sql/main
21 type BACKGROUND
22 processlist_user NULL
23 processlist_host NULL
24 processlist_db mysql
25 processlist_command NULL
26 processlist_info NULL
27 unified_parent_thread_id NULL
28 role NULL
29 instrumented YES
30 name thread/sql/one_connection
31 type FOREGROUND
32 processlist_user root
33 processlist_host localhost
34 processlist_db test
35 processlist_command Query
36 processlist_info SELECT name, type, processlist_user, processlist_host, processlist_db,
37 processlist_command, processlist_info,
38 IF(parent_thread_id IS NULL, parent_thread_id, 'unified parent_thread_id')
39 AS unified_parent_thread_id,
40 `role`, instrumented
41 FROM performance_schema.threads
42 WHERE name LIKE 'thread/sql%'
43 ORDER BY name
44 unified_parent_thread_id unified parent_thread_id
45 role NULL
46 instrumented YES
47 name thread/sql/signal_handler
48 type BACKGROUND
49 processlist_user NULL
50 processlist_host NULL
51 processlist_db NULL
52 processlist_command NULL
53 processlist_info NULL
54 unified_parent_thread_id unified parent_thread_id
55 role NULL
56 instrumented YES
57 CREATE TEMPORARY TABLE t1 AS
58 SELECT thread_id FROM performance_schema.threads
59 WHERE name LIKE 'thread/sql%';
60 SET GLOBAL event_scheduler = ON;
61 SELECT name, type, processlist_user, processlist_host, processlist_db,
62 processlist_command, processlist_info,
63 IF(parent_thread_id IS NULL, parent_thread_id, 'unified parent_thread_id')
64 AS unified_parent_thread_id,
65 `role`, instrumented
66 FROM performance_schema.threads
67 WHERE name LIKE 'thread/sql%'
68 AND thread_id NOT IN (SELECT thread_id FROM t1)
69 ORDER BY name;
70 name thread/sql/event_scheduler
71 type FOREGROUND
72 processlist_user event_scheduler
73 processlist_host localhost
74 processlist_db NULL
75 processlist_command Daemon
76 processlist_info NULL
77 unified_parent_thread_id unified parent_thread_id
78 role NULL
79 instrumented YES
80 TRUNCATE t1;
81 INSERT INTO t1
82 SELECT thread_id FROM performance_schema.threads
83 WHERE name LIKE 'thread/sql%';
84 SELECT COUNT(*) INTO @aux FROM t1;
85 DROP EVENT IF EXISTS t_ps_event;
86 CREATE EVENT t_ps_event
87 ON SCHEDULE AT CURRENT_TIMESTAMP + INTERVAL 1 SECOND
88 DO SELECT SLEEP(3);
89 SELECT name, type, processlist_user, processlist_host, processlist_db,
90 processlist_command, processlist_info,
91 IF(parent_thread_id IS NULL, parent_thread_id, 'unified parent_thread_id')
92 AS unified_parent_thread_id,
93 `role`, instrumented
94 FROM performance_schema.threads
95 WHERE name LIKE 'thread/sql%'
96 AND thread_id NOT IN (SELECT thread_id FROM t1)
97 ORDER BY name;
98 name thread/sql/event_worker
99 type FOREGROUND
100 processlist_user event_scheduler
101 processlist_host localhost
102 processlist_db test
103 processlist_command Connect
104 processlist_info SELECT SLEEP(3)
105 unified_parent_thread_id unified parent_thread_id
106 role NULL
107 instrumented YES
108 SELECT t2.name AS parent_thread_name, t1.name AS child_thread_name
109 FROM performance_schema.threads t1 INNER JOIN performance_schema.threads t2
110 ON t1.parent_thread_id = t2.thread_id
111 WHERE t1.name LIKE 'thread/sql%'
112 AND t1.parent_thread_id IS NOT NULL
113 ORDER BY parent_thread_name, child_thread_name;
114 parent_thread_name child_thread_name
115 thread/sql/event_scheduler thread/sql/event_worker
116 thread/sql/main thread/sql/compress_gtid_table
117 thread/sql/main thread/sql/one_connection
118 thread/sql/main thread/sql/signal_handler
119 thread/sql/one_connection thread/sql/event_scheduler