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