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