Debian Codegraph @

mysql-test/suite/clone/r/remote_monitor_progress.result

raw
1 CALL sys.ps_setup_disable_thread(CONNECTION_ID());
2 summary
3 Disabled 1 thread
4 CALL sys.ps_setup_disable_thread(CONNECTION_ID());
5 summary
6 Disabled 1 thread
7 CALL sys.ps_setup_disable_thread(CONNECTION_ID());
8 summary
9 Disabled 1 thread
10 INSTALL PLUGIN clone SONAME 'CLONE_PLUGIN';
11 CALL sys.ps_setup_enable_instrument('%stage/innodb/clone%');
12 summary
13 Enabled X instruments
14 CALL sys.ps_setup_enable_instrument('statement/clone/%');
15 summary
16 Enabled X instruments
17 CALL sys.ps_setup_enable_consumer('events_statements%');
18 summary
19 Enabled X consumers
20 CALL sys.ps_setup_enable_consumer('events_stages%');
21 summary
22 Enabled X consumers
23 SELECT *
24 FROM performance_schema.setup_instruments
25 WHERE name LIKE "%stage/innodb/clone%"
26 OR name LIKE "statement/clone/%"
27 OR name LIKE "wait/io/file/innodb/innodb_clone_file"
28 ORDER BY NAME;
29 NAME ENABLED TIMED PROPERTIES FLAGS VOLATILITY DOCUMENTATION
30 stage/innodb/clone (file copy) YES YES progress NULL 0 NULL
31 stage/innodb/clone (page copy) YES YES progress NULL 0 NULL
32 stage/innodb/clone (redo copy) YES YES progress NULL 0 NULL
33 statement/clone/client YES YES NULL 0 NULL
34 statement/clone/local YES YES NULL 0 NULL
35 statement/clone/server YES YES NULL 0 NULL
36 wait/io/file/innodb/innodb_clone_file YES YES NULL 0 NULL
37 SELECT *
38 FROM performance_schema.setup_consumers
39 WHERE name LIKE "events_statements_%" OR name LIKE "events_stages_%"
40 ORDER BY NAME;
41 NAME ENABLED
42 events_stages_current YES
43 events_stages_history YES
44 events_stages_history_long YES
45 events_statements_cpu YES
46 events_statements_current YES
47 events_statements_history YES
48 events_statements_history_long YES
49 TRUNCATE TABLE performance_schema.events_stages_history;
50 TRUNCATE TABLE performance_schema.events_stages_history_long;
51 TRUNCATE TABLE performance_schema.events_statements_history;
52 TRUNCATE TABLE performance_schema.events_statements_history_long;
53 # Case 1 - Monitoring a normal Clone operation.
54 CALL sys.ps_setup_enable_thread(CONNECTION_ID());
55 summary
56 Enabled 1 thread
57 SET GLOBAL clone_autotune_concurrency = OFF;
58 SET GLOBAL clone_max_concurrency = 8;
59 SET GLOBAL clone_valid_donor_list = 'HOST:PORT';
60 CLONE INSTANCE FROM USER@HOST:PORT IDENTIFIED BY '' DATA DIRECTORY = 'CLONE_DATADIR';
61 select ID, STATE, ERROR_NO from performance_schema.clone_status;
62 ID STATE ERROR_NO
63 1 Completed 0
64 select ID, STAGE, STATE from performance_schema.clone_progress;
65 ID STAGE STATE
66 1 DROP DATA Completed
67 1 FILE COPY Completed
68 1 PAGE COPY Completed
69 1 REDO COPY Completed
70 1 FILE SYNC Completed
71 1 RESTART Not Started
72 1 RECOVERY Not Started
73 SELECT EVENT_NAME, TIMER_START > 0, TIMER_END > 0, TIMER_WAIT > 0,
74 SQL_TEXT, CURRENT_SCHEMA
75 FROM performance_schema.events_statements_history_long
76 WHERE event_name LIKE "statement/clone/%"
77 ORDER BY EVENT_NAME;
78 EVENT_NAME TIMER_START > 0 TIMER_END > 0 TIMER_WAIT > 0 SQL_TEXT CURRENT_SCHEMA
79 statement/clone/client 1 1 1 CLONE INSTANCE FROM USER@HOST:PORT IDENTIFIED BY <secret> DATA DIRECTORY = '$CLONE_DATADIR' test
80 statement/clone/server 1 1 1 NULL NULL
81 SELECT EVENT_NAME, TIMER_START > 0,
82 TIMER_END > 0, WORK_COMPLETED = WORK_ESTIMATED
83 FROM performance_schema.events_stages_history_long
84 WHERE event_name LIKE "%stage/innodb/clone%"
85 ORDER BY EVENT_NAME;
86 EVENT_NAME TIMER_START > 0 TIMER_END > 0 WORK_COMPLETED = WORK_ESTIMATED
87 stage/innodb/clone (file copy) 1 1 1
88 stage/innodb/clone (file copy) 1 1 1
89 stage/innodb/clone (page copy) 1 1 1
90 stage/innodb/clone (page copy) 1 1 1
91 stage/innodb/clone (redo copy) 1 1 1
92 stage/innodb/clone (redo copy) 1 1 1
93 TRUNCATE TABLE performance_schema.events_stages_history;
94 TRUNCATE TABLE performance_schema.events_stages_history_long;
95 TRUNCATE TABLE performance_schema.events_statements_history;
96 TRUNCATE TABLE performance_schema.events_statements_history_long;
97 # Case 2 - Monitoring Clone operation which has more estimated work
98 # during file and page copy stage than in a default run.
99 CREATE PROCEDURE prepare_data(IN val INT)
100 BEGIN
101 DECLARE i INT DEFAULT 0;
102 WHILE i < val DO
103 INSERT INTO t1 (b,c) VALUES (REPEAT(a,500), REPEAT(b,100));
104 INSERT INTO t2 (b,c) VALUES (REPEAT(a,500), REPEAT(b,100));
105 INSERT INTO t3 (b,c) VALUES (REPEAT(a,500), REPEAT(b,100));
106 SET i = i + 1;
107 END WHILE;
108 END|
109 CREATE TABLE t1 (a INT NOT NULL PRIMARY KEY AUTO_INCREMENT, b LONGBLOB, c LONGBLOB);
110 CREATE TABLE t2 (a INT NOT NULL PRIMARY KEY AUTO_INCREMENT, b LONGBLOB, c LONGBLOB);
111 CREATE TABLE t3 (a INT NOT NULL PRIMARY KEY AUTO_INCREMENT, b LONGBLOB, c LONGBLOB);
112 SET GLOBAL innodb_buf_flush_list_now = 1;
113 SET DEBUG_SYNC = 'clone_file_copy SIGNAL page_signal WAIT_FOR go_page';
114 SET DEBUG_SYNC = 'clone_page_copy SIGNAL redo_signal WAIT_FOR go_redo';
115 SET GLOBAL clone_autotune_concurrency = OFF;
116 SET GLOBAL clone_max_concurrency = 8;
117 SET GLOBAL clone_valid_donor_list = 'HOST:PORT';
118 CLONE INSTANCE FROM USER@HOST:PORT IDENTIFIED BY '' DATA DIRECTORY = 'CLONE_DATADIR';
119 SET DEBUG_SYNC = 'now WAIT_FOR page_signal';
120 CALL prepare_data(50);
121 SET GLOBAL innodb_buf_flush_list_now = 1;
122 SET DEBUG_SYNC = 'now SIGNAL go_page';
123 SET DEBUG_SYNC = 'now WAIT_FOR redo_signal';
124 SELECT EVENT_NAME, TIMER_START > 0, TIMER_END > 0, TIMER_WAIT > 0,
125 SQL_TEXT, CURRENT_SCHEMA
126 FROM performance_schema.events_statements_current
127 WHERE event_name LIKE "statement/clone/%"
128 ORDER BY EVENT_NAME;
129 EVENT_NAME TIMER_START > 0 TIMER_END > 0 TIMER_WAIT > 0 SQL_TEXT CURRENT_SCHEMA
130 statement/clone/client 1 1 1 CLONE INSTANCE FROM USER@HOST:PORT IDENTIFIED BY <secret> DATA DIRECTORY = '$CLONE_DATADIR' test
131 statement/clone/server 1 1 1 NULL NULL
132 CALL prepare_data(50);
133 SET DEBUG_SYNC = 'now SIGNAL go_redo';
134 SELECT EVENT_NAME, WORK_COMPLETED > 0, TIMER_START > 0,
135 TIMER_END > 0, WORK_COMPLETED = WORK_ESTIMATED
136 FROM performance_schema.events_stages_history_long
137 WHERE event_name LIKE "%stage/innodb/clone%"
138 ORDER BY EVENT_NAME;
139 EVENT_NAME WORK_COMPLETED > 0 TIMER_START > 0 TIMER_END > 0 WORK_COMPLETED = WORK_ESTIMATED
140 stage/innodb/clone (file copy) 1 1 1 1
141 stage/innodb/clone (file copy) 1 1 1 1
142 stage/innodb/clone (page copy) 1 1 1 1
143 stage/innodb/clone (page copy) 1 1 1 1
144 stage/innodb/clone (redo copy) 1 1 1 1
145 stage/innodb/clone (redo copy) 1 1 1 1
146 SELECT EVENT_NAME, TIMER_START > 0, TIMER_END > 0, TIMER_WAIT > 0,
147 SQL_TEXT, CURRENT_SCHEMA
148 FROM performance_schema.events_statements_history_long
149 WHERE thread_id = ps_thread_id(CONNECTION_ID())
150 AND event_name LIKE "statement/clone/%";
151 EVENT_NAME TIMER_START > 0 TIMER_END > 0 TIMER_WAIT > 0 SQL_TEXT CURRENT_SCHEMA
152 statement/clone/client 1 1 1 CLONE INSTANCE FROM USER@HOST:PORT IDENTIFIED BY <secret> DATA DIRECTORY = '$CLONE_DATADIR' test
153 SET DEBUG_SYNC='RESET';
154 TRUNCATE TABLE performance_schema.events_stages_history;
155 TRUNCATE TABLE performance_schema.events_stages_history_long;
156 TRUNCATE TABLE performance_schema.events_statements_history;
157 TRUNCATE TABLE performance_schema.events_statements_history_long;
158 DROP TABLE t1;
159 DROP TABLE t2;
160 DROP TABLE t3;
161 # Case 3 - Monitoring progress in the middle of file copy.
162 CREATE TABLE t1 (a INT NOT NULL PRIMARY KEY AUTO_INCREMENT, b INT);
163 CREATE TABLE t2 (a INT NOT NULL PRIMARY KEY AUTO_INCREMENT, b INT);
164 CREATE TABLE t3 (a INT NOT NULL PRIMARY KEY AUTO_INCREMENT, b INT);
165 SET DEBUG_SYNC = 'clone_file_copy SIGNAL file_signal WAIT_FOR go_file';
166 SET GLOBAL clone_autotune_concurrency = OFF;
167 SET GLOBAL clone_max_concurrency = 8;
168 SET GLOBAL clone_valid_donor_list = 'HOST:PORT';
169 CLONE INSTANCE FROM USER@HOST:PORT IDENTIFIED BY '' DATA DIRECTORY = 'CLONE_DATADIR';
170 SET DEBUG_SYNC= 'now WAIT_FOR file_signal';
171 SELECT EVENT_NAME, WORK_COMPLETED <= WORK_ESTIMATED
172 FROM performance_schema.events_stages_current
173 WHERE event_name LIKE "%file copy%"
174 ORDER BY EVENT_NAME;
175 EVENT_NAME WORK_COMPLETED <= WORK_ESTIMATED
176 stage/innodb/clone (file copy) 1
177 stage/innodb/clone (file copy) 1
178 SET DEBUG_SYNC= 'now SIGNAL go_file';
179 SET DEBUG_SYNC = 'RESET';
180 DROP TABLE t1;
181 DROP TABLE t2;
182 DROP TABLE t3;
183 TRUNCATE TABLE performance_schema.events_stages_history;
184 TRUNCATE TABLE performance_schema.events_stages_history_long;
185 TRUNCATE TABLE performance_schema.events_statements_history;
186 TRUNCATE TABLE performance_schema.events_statements_history_long;
187 # Case 4 - Monitoring progress in the middle of page copy.
188 CREATE TABLE t1 (a INT NOT NULL PRIMARY KEY AUTO_INCREMENT, b LONGBLOB, c LONGBLOB);
189 CREATE TABLE t2 (a INT NOT NULL PRIMARY KEY AUTO_INCREMENT, b LONGBLOB, c LONGBLOB);
190 CREATE TABLE t3 (a INT NOT NULL PRIMARY KEY AUTO_INCREMENT, b LONGBLOB, c LONGBLOB);
191 SET GLOBAL innodb_buf_flush_list_now = 1;
192 SET DEBUG_SYNC = 'clone_file_copy SIGNAL page_signal WAIT_FOR go_page';
193 SET DEBUG_SYNC = 'clone_page_copy SIGNAL page_middle_signal WAIT_FOR go_page_middle';
194 SET GLOBAL clone_autotune_concurrency = OFF;
195 SET GLOBAL clone_max_concurrency = 8;
196 SET GLOBAL clone_valid_donor_list = 'HOST:PORT';
197 CLONE INSTANCE FROM USER@HOST:PORT IDENTIFIED BY '' DATA DIRECTORY = 'CLONE_DATADIR';
198 SET DEBUG_SYNC = 'now WAIT_FOR page_signal';
199 CALL prepare_data(50);
200 SET GLOBAL innodb_buf_flush_list_now = 1;
201 SET DEBUG_SYNC = 'now SIGNAL go_page';
202 SET DEBUG_SYNC = 'now WAIT_FOR page_middle_signal';
203 SELECT EVENT_NAME, WORK_COMPLETED <= WORK_ESTIMATED
204 FROM performance_schema.events_stages_current
205 WHERE event_name LIKE "%page copy%"
206 ORDER BY EVENT_NAME;
207 EVENT_NAME WORK_COMPLETED <= WORK_ESTIMATED
208 stage/innodb/clone (page copy) 1
209 stage/innodb/clone (page copy) 1
210 SET DEBUG_SYNC = 'now SIGNAL go_page_middle';
211 SET DEBUG_SYNC = 'RESET';
212 DROP TABLE t1;
213 DROP TABLE t2;
214 DROP TABLE t3;
215 TRUNCATE TABLE performance_schema.events_stages_history;
216 TRUNCATE TABLE performance_schema.events_stages_history_long;
217 TRUNCATE TABLE performance_schema.events_statements_history;
218 TRUNCATE TABLE performance_schema.events_statements_history_long;
219 # Case 5 - Monitoring progress in the middle of redo copy.
220 CREATE TABLE t1 (a INT NOT NULL PRIMARY KEY AUTO_INCREMENT, b LONGBLOB, c LONGBLOB);
221 CREATE TABLE t2 (a INT NOT NULL PRIMARY KEY AUTO_INCREMENT, b LONGBLOB, c LONGBLOB);
222 CREATE TABLE t3 (a INT NOT NULL PRIMARY KEY AUTO_INCREMENT, b LONGBLOB, c LONGBLOB);
223 SET DEBUG_SYNC = 'clone_page_copy SIGNAL redo_signal WAIT_FOR go_redo';
224 SET DEBUG_SYNC = 'clone_redo_copy SIGNAL redo_middle_signal WAIT_FOR go_redo_middle';
225 SET GLOBAL clone_autotune_concurrency = OFF;
226 SET GLOBAL clone_max_concurrency = 8;
227 SET GLOBAL clone_valid_donor_list = 'HOST:PORT';
228 CLONE INSTANCE FROM USER@HOST:PORT IDENTIFIED BY '' DATA DIRECTORY = 'CLONE_DATADIR';
229 SET DEBUG_SYNC= 'now WAIT_FOR redo_signal';
230 CALL prepare_data(50);
231 SET DEBUG_SYNC= 'now SIGNAL go_redo';
232 SET DEBUG_SYNC = 'now WAIT_FOR redo_middle_signal';
233 SELECT EVENT_NAME, WORK_COMPLETED <= WORK_ESTIMATED
234 FROM performance_schema.events_stages_current
235 WHERE event_name LIKE "%redo copy%"
236 ORDER BY EVENT_NAME;
237 EVENT_NAME WORK_COMPLETED <= WORK_ESTIMATED
238 stage/innodb/clone (redo copy) 1
239 stage/innodb/clone (redo copy) 1
240 SET DEBUG_SYNC = 'now SIGNAL go_redo_middle';
241 SET DEBUG_SYNC = 'RESET';
242 DROP PROCEDURE prepare_data;
243 USE test;
244 DROP TABLE t1;
245 DROP TABLE t2;
246 DROP TABLE t3;
247 UNINSTALL PLUGIN clone;