Debian Codegraph @

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

raw
1 "================== con1 connected =================="
2 select "MARKER_BEGIN" as marker;
3 marker
4 MARKER_BEGIN
5 select "This is simple statement one" as payload;
6 payload
7 This is simple statement one
8 select "This is simple statement two" as payload;
9 payload
10 This is simple statement two
11 select "This is the first part of a multi query" as payload;
12 select "And this is the second part of a multi query" as payload;
13 select "With a third part to make things complete" as payload;
14 $$
15 payload
16 This is the first part of a multi query
17 payload
18 And this is the second part of a multi query
19 payload
20 With a third part to make things complete
21 select "MARKER_END" as marker;
22 marker
23 MARKER_END
24 select "Con1 is done with payload" as status;
25 status
26 Con1 is done with payload
27 "================== con1 done =================="
28 set @con1_tid = (select thread_id from performance_schema.threads
29 where processlist_user = 'user1');
30 select (@con1_tid is not null) as expected;
31 expected
32 1
33 set @marker_begin = (select event_id from performance_schema.events_statements_history_long
34 where sql_text like "%MARKER_BEGIN%" and thread_id = @con1_tid);
35 select (@marker_begin is not null) as expected;
36 expected
37 1
38 set @marker_end = (select end_event_id from performance_schema.events_statements_history_long
39 where sql_text like "%MARKER_END%" and thread_id = @con1_tid);
40 select (@marker_end is not null) as expected;
41 expected
42 1
43 show global status like "performance_schema%_lost";
44 Variable_name Value
45 Performance_schema_accounts_lost 0
46 Performance_schema_cond_classes_lost 0
47 Performance_schema_cond_instances_lost 0
48 Performance_schema_digest_lost 0
49 Performance_schema_file_classes_lost 0
50 Performance_schema_file_handles_lost 0
51 Performance_schema_file_instances_lost 0
52 Performance_schema_hosts_lost 0
53 Performance_schema_index_stat_lost 0
54 Performance_schema_locker_lost 0
55 Performance_schema_memory_classes_lost 0
56 Performance_schema_metadata_lock_lost 0
57 Performance_schema_mutex_classes_lost 0
58 Performance_schema_mutex_instances_lost 0
59 Performance_schema_nested_statement_lost 0
60 Performance_schema_prepared_statements_lost 0
61 Performance_schema_program_lost 0
62 Performance_schema_rwlock_classes_lost 0
63 Performance_schema_rwlock_instances_lost 0
64 Performance_schema_session_connect_attrs_lost 0
65 Performance_schema_socket_classes_lost 0
66 Performance_schema_socket_instances_lost 0
67 Performance_schema_stage_classes_lost 0
68 Performance_schema_statement_classes_lost 0
69 Performance_schema_table_handles_lost 0
70 Performance_schema_table_instances_lost 0
71 Performance_schema_table_lock_stat_lost 0
72 Performance_schema_thread_classes_lost 0
73 Performance_schema_thread_instances_lost 0
74 Performance_schema_users_lost 0
75 select * from (
76 (
77 select (event_id - @marker_begin) as relative_event_id,
78 (end_event_id - @marker_begin) as relative_end_event_id,
79 event_name,
80 sql_text as comment,
81 nesting_event_type,
82 (nesting_event_id - @marker_begin) as relative_nesting_event_id
83 from performance_schema.events_statements_history_long
84 where (thread_id = @con1_tid)
85 and (@marker_begin <= event_id)
86 and (end_event_id <= @marker_end)
87 )
88 union
89 (
90 select (event_id - @marker_begin) as relative_event_id,
91 (end_event_id - @marker_begin) as relative_end_event_id,
92 event_name,
93 "(stage)" as comment,
94 nesting_event_type,
95 (nesting_event_id - @marker_begin) as relative_nesting_event_id
96 from performance_schema.events_stages_history_long
97 where (thread_id = @con1_tid)
98 and (@marker_begin <= event_id)
99 and (end_event_id <= @marker_end)
100 )
101 union
102 (
103 select (event_id - @marker_begin) as relative_event_id,
104 (end_event_id - @marker_begin) as relative_end_event_id,
105 event_name,
106 operation as comment,
107 nesting_event_type,
108 (nesting_event_id - @marker_begin) as relative_nesting_event_id
109 from performance_schema.events_waits_history_long
110 where (thread_id = @con1_tid)
111 and (@marker_begin <= event_id)
112 and (end_event_id <= @marker_end)
113 )
114 ) all_events
115 order by relative_event_id asc;
116 relative_event_id relative_end_event_id event_name comment nesting_event_type relative_nesting_event_id
117 0 15 statement/sql/select select "MARKER_BEGIN" as marker NULL NULL
118 1 4 stage/sql/starting (stage) STATEMENT 0
119 2 2 wait/synch/mutex/sql/THD::LOCK_thd_data lock STAGE 1
120 3 3 wait/synch/mutex/sql/THD::LOCK_thd_query lock STAGE 1
121 4 4 wait/io/file/sql/query_log write STAGE 1
122 5 5 stage/sql/checking permissions (stage) STATEMENT 0
123 6 6 stage/sql/Opening tables (stage) STATEMENT 0
124 7 7 stage/sql/init (stage) STATEMENT 0
125 8 8 stage/sql/optimizing (stage) STATEMENT 0
126 9 9 stage/sql/executing (stage) STATEMENT 0
127 10 10 stage/sql/end (stage) STATEMENT 0
128 11 11 stage/sql/query end (stage) STATEMENT 0
129 12 12 stage/sql/closing tables (stage) STATEMENT 0
130 13 13 stage/sql/freeing items (stage) STATEMENT 0
131 14 15 stage/sql/cleaning up (stage) STATEMENT 0
132 15 15 wait/synch/mutex/sql/THD::LOCK_thd_query lock STAGE 14
133 16 16 idle idle NULL NULL
134 17 32 statement/sql/select select "This is simple statement one" as payload NULL NULL
135 18 21 stage/sql/starting (stage) STATEMENT 17
136 19 19 wait/synch/mutex/sql/THD::LOCK_thd_data lock STAGE 18
137 20 20 wait/synch/mutex/sql/THD::LOCK_thd_query lock STAGE 18
138 21 21 wait/io/file/sql/query_log write STAGE 18
139 22 22 stage/sql/checking permissions (stage) STATEMENT 17
140 23 23 stage/sql/Opening tables (stage) STATEMENT 17
141 24 24 stage/sql/init (stage) STATEMENT 17
142 25 25 stage/sql/optimizing (stage) STATEMENT 17
143 26 26 stage/sql/executing (stage) STATEMENT 17
144 27 27 stage/sql/end (stage) STATEMENT 17
145 28 28 stage/sql/query end (stage) STATEMENT 17
146 29 29 stage/sql/closing tables (stage) STATEMENT 17
147 30 30 stage/sql/freeing items (stage) STATEMENT 17
148 31 32 stage/sql/cleaning up (stage) STATEMENT 17
149 32 32 wait/synch/mutex/sql/THD::LOCK_thd_query lock STAGE 31
150 33 33 idle idle NULL NULL
151 34 49 statement/sql/select select "This is simple statement two" as payload NULL NULL
152 35 38 stage/sql/starting (stage) STATEMENT 34
153 36 36 wait/synch/mutex/sql/THD::LOCK_thd_data lock STAGE 35
154 37 37 wait/synch/mutex/sql/THD::LOCK_thd_query lock STAGE 35
155 38 38 wait/io/file/sql/query_log write STAGE 35
156 39 39 stage/sql/checking permissions (stage) STATEMENT 34
157 40 40 stage/sql/Opening tables (stage) STATEMENT 34
158 41 41 stage/sql/init (stage) STATEMENT 34
159 42 42 stage/sql/optimizing (stage) STATEMENT 34
160 43 43 stage/sql/executing (stage) STATEMENT 34
161 44 44 stage/sql/end (stage) STATEMENT 34
162 45 45 stage/sql/query end (stage) STATEMENT 34
163 46 46 stage/sql/closing tables (stage) STATEMENT 34
164 47 47 stage/sql/freeing items (stage) STATEMENT 34
165 48 49 stage/sql/cleaning up (stage) STATEMENT 34
166 49 49 wait/synch/mutex/sql/THD::LOCK_thd_query lock STAGE 48
167 50 50 idle idle NULL NULL
168 51 65 statement/sql/select select "This is the first part of a multi query" as payload NULL NULL
169 52 56 stage/sql/starting (stage) STATEMENT 51
170 53 53 wait/synch/mutex/sql/THD::LOCK_thd_data lock STAGE 52
171 54 54 wait/synch/mutex/sql/THD::LOCK_thd_query lock STAGE 52
172 55 55 wait/synch/mutex/sql/THD::LOCK_thd_query lock STAGE 52
173 56 56 wait/io/file/sql/query_log write STAGE 52
174 57 57 stage/sql/checking permissions (stage) STATEMENT 51
175 58 58 stage/sql/Opening tables (stage) STATEMENT 51
176 59 59 stage/sql/init (stage) STATEMENT 51
177 60 60 stage/sql/optimizing (stage) STATEMENT 51
178 61 61 stage/sql/executing (stage) STATEMENT 51
179 62 62 stage/sql/end (stage) STATEMENT 51
180 63 63 stage/sql/query end (stage) STATEMENT 51
181 64 64 stage/sql/closing tables (stage) STATEMENT 51
182 65 65 stage/sql/freeing items (stage) STATEMENT 51
183 66 80 statement/sql/select select "And this is the second part of a multi query" as payload NULL NULL
184 67 71 stage/sql/starting (stage) STATEMENT 66
185 68 68 wait/synch/mutex/sql/THD::LOCK_thd_query lock STAGE 67
186 69 69 wait/synch/mutex/sql/THD::LOCK_thd_data lock STAGE 67
187 70 70 wait/synch/mutex/sql/THD::LOCK_thd_query lock STAGE 67
188 71 71 wait/io/file/sql/query_log write STAGE 67
189 72 72 stage/sql/checking permissions (stage) STATEMENT 66
190 73 73 stage/sql/Opening tables (stage) STATEMENT 66
191 74 74 stage/sql/init (stage) STATEMENT 66
192 75 75 stage/sql/optimizing (stage) STATEMENT 66
193 76 76 stage/sql/executing (stage) STATEMENT 66
194 77 77 stage/sql/end (stage) STATEMENT 66
195 78 78 stage/sql/query end (stage) STATEMENT 66
196 79 79 stage/sql/closing tables (stage) STATEMENT 66
197 80 80 stage/sql/freeing items (stage) STATEMENT 66
198 81 96 statement/sql/select select "With a third part to make things complete" as payload NULL NULL
199 82 85 stage/sql/starting (stage) STATEMENT 81
200 83 83 wait/synch/mutex/sql/THD::LOCK_thd_query lock STAGE 82
201 84 84 wait/synch/mutex/sql/THD::LOCK_thd_data lock STAGE 82
202 85 85 wait/io/file/sql/query_log write STAGE 82
203 86 86 stage/sql/checking permissions (stage) STATEMENT 81
204 87 87 stage/sql/Opening tables (stage) STATEMENT 81
205 88 88 stage/sql/init (stage) STATEMENT 81
206 89 89 stage/sql/optimizing (stage) STATEMENT 81
207 90 90 stage/sql/executing (stage) STATEMENT 81
208 91 91 stage/sql/end (stage) STATEMENT 81
209 92 92 stage/sql/query end (stage) STATEMENT 81
210 93 93 stage/sql/closing tables (stage) STATEMENT 81
211 94 94 stage/sql/freeing items (stage) STATEMENT 81
212 95 96 stage/sql/cleaning up (stage) STATEMENT 81
213 96 96 wait/synch/mutex/sql/THD::LOCK_thd_query lock STAGE 95
214 97 97 idle idle NULL NULL
215 98 113 statement/sql/select select "MARKER_END" as marker NULL NULL
216 99 102 stage/sql/starting (stage) STATEMENT 98
217 100 100 wait/synch/mutex/sql/THD::LOCK_thd_data lock STAGE 99
218 101 101 wait/synch/mutex/sql/THD::LOCK_thd_query lock STAGE 99
219 102 102 wait/io/file/sql/query_log write STAGE 99
220 103 103 stage/sql/checking permissions (stage) STATEMENT 98
221 104 104 stage/sql/Opening tables (stage) STATEMENT 98
222 105 105 stage/sql/init (stage) STATEMENT 98
223 106 106 stage/sql/optimizing (stage) STATEMENT 98
224 107 107 stage/sql/executing (stage) STATEMENT 98
225 108 108 stage/sql/end (stage) STATEMENT 98
226 109 109 stage/sql/query end (stage) STATEMENT 98
227 110 110 stage/sql/closing tables (stage) STATEMENT 98
228 111 111 stage/sql/freeing items (stage) STATEMENT 98
229 112 113 stage/sql/cleaning up (stage) STATEMENT 98
230 113 113 wait/synch/mutex/sql/THD::LOCK_thd_query lock STAGE 112