Debian Codegraph @

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

raw
1 include/master-slave.inc
2 Warnings:
3 Note #### Sending passwords in plain text without SSL/TLS is extremely insecure.
4 Note #### Storing MySQL user name or password information in the connection metadata repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START REPLICA; see the 'START REPLICA Syntax' in the MySQL Manual for more information.
5 [connection master]
6 drop table if exists test.t1;
7 reset master;
8 create table test.t1(a int);
9 drop table test.t1;
10 include/show_binlog_events.inc
11 Log_name Pos Event_type Server_id End_log_pos Info
12 slave-bin.000001 # Query # # use `test`; create table test.t1(a int)
13 slave-bin.000001 # Query # # use `test`; DROP TABLE `t1` /* generated by server */
14 "============ Performance schema on master ============"
15 select
16 substring(file_name, locate("master-", file_name)) as FILE_NAME,
17 EVENT_NAME,
18 if (count_read > 0, "MANY", "NONE") as COUNT_READ,
19 if (count_write > 0,"MANY", "NONE") as COUNT_WRITE,
20 if (sum_number_of_bytes_read > 0, "MANY", "NONE") as SUM_NUMBER_OF_BYTES_READ,
21 if (sum_number_of_bytes_write > 0, "MANY", "NONE") as SUM_NUMBER_OF_BYTES_WRITE
22 from performance_schema.file_summary_by_instance
23 where file_name like "%master-%" order by file_name;
24 FILE_NAME EVENT_NAME COUNT_READ COUNT_WRITE SUM_NUMBER_OF_BYTES_READ SUM_NUMBER_OF_BYTES_WRITE
25 master-bin.000001 wait/io/file/sql/binlog MANY MANY MANY MANY
26 master-bin.index wait/io/file/sql/binlog_index MANY NONE MANY NONE
27 select * from performance_schema.file_summary_by_instance
28 where file_name like "%slave-%" order by file_name;
29 FILE_NAME EVENT_NAME OBJECT_INSTANCE_BEGIN COUNT_STAR SUM_TIMER_WAIT MIN_TIMER_WAIT AVG_TIMER_WAIT MAX_TIMER_WAIT COUNT_READ SUM_TIMER_READ MIN_TIMER_READ AVG_TIMER_READ MAX_TIMER_READ SUM_NUMBER_OF_BYTES_READ COUNT_WRITE SUM_TIMER_WRITE MIN_TIMER_WRITE AVG_TIMER_WRITE MAX_TIMER_WRITE SUM_NUMBER_OF_BYTES_WRITE COUNT_MISC SUM_TIMER_MISC MIN_TIMER_MISC AVG_TIMER_MISC MAX_TIMER_MISC
30 "Expect a master binlog + binlog_index"
31 select
32 substring(file_name, locate("master-", file_name)) as FILE_NAME,
33 EVENT_NAME,
34 if (count_read > 0, "MANY", "NONE") as COUNT_READ,
35 if (count_write > 0,"MANY", "NONE") as COUNT_WRITE,
36 if (sum_number_of_bytes_read > 0, "MANY", "NONE") as SUM_NUMBER_OF_BYTES_READ,
37 if (sum_number_of_bytes_write > 0, "MANY", "NONE") as SUM_NUMBER_OF_BYTES_WRITE
38 from performance_schema.file_summary_by_instance
39 where event_name like "%binlog%" order by file_name;
40 FILE_NAME EVENT_NAME COUNT_READ COUNT_WRITE SUM_NUMBER_OF_BYTES_READ SUM_NUMBER_OF_BYTES_WRITE
41 master-bin.000001 wait/io/file/sql/binlog MANY MANY MANY MANY
42 master-bin.index wait/io/file/sql/binlog_index MANY NONE MANY NONE
43 select
44 EVENT_NAME,
45 if (count_read > 0, "MANY", "NONE") as COUNT_READ,
46 if (count_write > 0,"MANY", "NONE") as COUNT_WRITE,
47 if (sum_number_of_bytes_read > 0, "MANY", "NONE") as SUM_NUMBER_OF_BYTES_READ,
48 if (sum_number_of_bytes_write > 0, "MANY", "NONE") as SUM_NUMBER_OF_BYTES_WRITE
49 from performance_schema.file_summary_by_event_name
50 where event_name like "%binlog%" order by event_name;
51 EVENT_NAME COUNT_READ COUNT_WRITE SUM_NUMBER_OF_BYTES_READ SUM_NUMBER_OF_BYTES_WRITE
52 wait/io/file/sql/binlog MANY MANY MANY MANY
53 wait/io/file/sql/binlog_cache NONE NONE NONE NONE
54 wait/io/file/sql/binlog_index MANY NONE MANY NONE
55 wait/io/file/sql/binlog_index_cache NONE NONE NONE NONE
56 select
57 EVENT_NAME,
58 if (count_star > 0, "MANY", "NONE") as COUNT_STAR
59 from performance_schema.events_waits_summary_global_by_event_name
60 where event_name like "%MYSQL_BIN_LOG%"
61 and event_name not like "%MYSQL_BIN_LOG::update_cond"
62 order by event_name;
63 EVENT_NAME COUNT_STAR
64 wait/synch/cond/sql/MYSQL_BIN_LOG::COND_done NONE
65 wait/synch/cond/sql/MYSQL_BIN_LOG::COND_flush_queue NONE
66 wait/synch/cond/sql/MYSQL_BIN_LOG::COND_wait_for_group_turn NONE
67 wait/synch/cond/sql/MYSQL_BIN_LOG::prep_xids_cond NONE
68 wait/synch/mutex/sql/MYSQL_BIN_LOG::LOCK_after_commit MANY
69 wait/synch/mutex/sql/MYSQL_BIN_LOG::LOCK_after_commit_queue MANY
70 wait/synch/mutex/sql/MYSQL_BIN_LOG::LOCK_binlog_end_pos MANY
71 wait/synch/mutex/sql/MYSQL_BIN_LOG::LOCK_commit MANY
72 wait/synch/mutex/sql/MYSQL_BIN_LOG::LOCK_commit_queue MANY
73 wait/synch/mutex/sql/MYSQL_BIN_LOG::LOCK_done MANY
74 wait/synch/mutex/sql/MYSQL_BIN_LOG::LOCK_flush_queue MANY
75 wait/synch/mutex/sql/MYSQL_BIN_LOG::LOCK_index MANY
76 wait/synch/mutex/sql/MYSQL_BIN_LOG::LOCK_log MANY
77 wait/synch/mutex/sql/MYSQL_BIN_LOG::LOCK_sync MANY
78 wait/synch/mutex/sql/MYSQL_BIN_LOG::LOCK_sync_queue MANY
79 wait/synch/mutex/sql/MYSQL_BIN_LOG::LOCK_wait_for_group_turn NONE
80 wait/synch/mutex/sql/MYSQL_BIN_LOG::LOCK_xids NONE
81 "Expect no slave relay log"
82 select * from performance_schema.file_summary_by_instance
83 where event_name like "%relaylog%" order by file_name;
84 FILE_NAME EVENT_NAME OBJECT_INSTANCE_BEGIN COUNT_STAR SUM_TIMER_WAIT MIN_TIMER_WAIT AVG_TIMER_WAIT MAX_TIMER_WAIT COUNT_READ SUM_TIMER_READ MIN_TIMER_READ AVG_TIMER_READ MAX_TIMER_READ SUM_NUMBER_OF_BYTES_READ COUNT_WRITE SUM_TIMER_WRITE MIN_TIMER_WRITE AVG_TIMER_WRITE MAX_TIMER_WRITE SUM_NUMBER_OF_BYTES_WRITE COUNT_MISC SUM_TIMER_MISC MIN_TIMER_MISC AVG_TIMER_MISC MAX_TIMER_MISC
85 select * from performance_schema.file_summary_by_event_name
86 where event_name like "%relaylog%" order by event_name;
87 EVENT_NAME COUNT_STAR SUM_TIMER_WAIT MIN_TIMER_WAIT AVG_TIMER_WAIT MAX_TIMER_WAIT COUNT_READ SUM_TIMER_READ MIN_TIMER_READ AVG_TIMER_READ MAX_TIMER_READ SUM_NUMBER_OF_BYTES_READ COUNT_WRITE SUM_TIMER_WRITE MIN_TIMER_WRITE AVG_TIMER_WRITE MAX_TIMER_WRITE SUM_NUMBER_OF_BYTES_WRITE COUNT_MISC SUM_TIMER_MISC MIN_TIMER_MISC AVG_TIMER_MISC MAX_TIMER_MISC
88 wait/io/file/sql/relaylog 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
89 wait/io/file/sql/relaylog_cache 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
90 wait/io/file/sql/relaylog_index 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
91 wait/io/file/sql/relaylog_index_cache 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
92 select EVENT_NAME,
93 if (count_star > 0, "MANY", "NONE") as COUNT_STAR,
94 if (sum_timer_wait > 0, "MANY", "NONE") as SUM_TIMER_WAIT,
95 if (min_timer_wait > 0, "MANY", "NONE") as MIN_TIMER_WAIT,
96 if (avg_timer_wait > 0, "MANY", "NONE") as AVG_TIMER_WAIT,
97 if (max_timer_wait > 0, "MANY", "NONE") as MAX_TIMER_WAIT
98 from performance_schema.events_waits_summary_global_by_event_name
99 where event_name like "%MYSQL_RELAY_LOG%"
100 and event_name not like "%MYSQL_RELAY_LOG::update_cond"
101 order by event_name;
102 EVENT_NAME COUNT_STAR SUM_TIMER_WAIT MIN_TIMER_WAIT AVG_TIMER_WAIT MAX_TIMER_WAIT
103 wait/synch/mutex/sql/MYSQL_RELAY_LOG::LOCK_commit NONE NONE NONE NONE NONE
104 wait/synch/mutex/sql/MYSQL_RELAY_LOG::LOCK_index MANY MANY MANY MANY MANY
105 wait/synch/mutex/sql/MYSQL_RELAY_LOG::LOCK_log MANY MANY MANY MANY MANY
106 wait/synch/mutex/sql/MYSQL_RELAY_LOG::LOCK_log_end_pos NONE NONE NONE NONE NONE
107 wait/synch/mutex/sql/MYSQL_RELAY_LOG::LOCK_sync NONE NONE NONE NONE NONE
108 wait/synch/mutex/sql/MYSQL_RELAY_LOG::LOCK_xids NONE NONE NONE NONE NONE
109 "============ Performance schema on slave ============"
110 select * from performance_schema.file_summary_by_instance
111 where file_name like "%master-%" order by file_name;
112 FILE_NAME EVENT_NAME OBJECT_INSTANCE_BEGIN COUNT_STAR SUM_TIMER_WAIT MIN_TIMER_WAIT AVG_TIMER_WAIT MAX_TIMER_WAIT COUNT_READ SUM_TIMER_READ MIN_TIMER_READ AVG_TIMER_READ MAX_TIMER_READ SUM_NUMBER_OF_BYTES_READ COUNT_WRITE SUM_TIMER_WRITE MIN_TIMER_WRITE AVG_TIMER_WRITE MAX_TIMER_WRITE SUM_NUMBER_OF_BYTES_WRITE COUNT_MISC SUM_TIMER_MISC MIN_TIMER_MISC AVG_TIMER_MISC MAX_TIMER_MISC
113 select
114 substring(file_name, locate("slave-", file_name)) as FILE_NAME,
115 EVENT_NAME,
116 if (count_read > 0, "MANY", "NONE") as COUNT_READ,
117 if (count_write > 0,"MANY", "NONE") as COUNT_WRITE,
118 if (sum_number_of_bytes_read > 0, "MANY", "NONE") as SUM_NUMBER_OF_BYTES_READ,
119 if (sum_number_of_bytes_write > 0, "MANY", "NONE") as SUM_NUMBER_OF_BYTES_WRITE
120 from performance_schema.file_summary_by_instance
121 where file_name like "%slave-%"
122 and (file_name not like "%slave-relay-bin.0%"
123 or file_name like "%slave-relay-bin.000001"
124 or file_name like "%slave-relay-bin.000002")
125 order by file_name;
126 FILE_NAME EVENT_NAME COUNT_READ COUNT_WRITE SUM_NUMBER_OF_BYTES_READ SUM_NUMBER_OF_BYTES_WRITE
127 slave-bin.000001 wait/io/file/sql/binlog MANY MANY MANY MANY
128 slave-bin.index wait/io/file/sql/binlog_index MANY NONE MANY NONE
129 slave-relay-bin.000001 wait/io/file/sql/relaylog MANY MANY MANY MANY
130 slave-relay-bin.000002 wait/io/file/sql/relaylog MANY MANY MANY MANY
131 slave-relay-bin.index wait/io/file/sql/binlog_index MANY NONE MANY NONE
132 "Expect a slave binlog + binlog_index"
133 select
134 substring(file_name, locate("slave-", file_name)) as FILE_NAME,
135 EVENT_NAME,
136 if (count_read > 0, "MANY", "NONE") as COUNT_READ,
137 if (count_write > 0,"MANY", "NONE") as COUNT_WRITE,
138 if (sum_number_of_bytes_read > 0, "MANY", "NONE") as SUM_NUMBER_OF_BYTES_READ,
139 if (sum_number_of_bytes_write > 0, "MANY", "NONE") as SUM_NUMBER_OF_BYTES_WRITE
140 from performance_schema.file_summary_by_instance
141 where event_name like "%binlog%" order by file_name;
142 FILE_NAME EVENT_NAME COUNT_READ COUNT_WRITE SUM_NUMBER_OF_BYTES_READ SUM_NUMBER_OF_BYTES_WRITE
143 slave-bin.000001 wait/io/file/sql/binlog MANY MANY MANY MANY
144 slave-bin.index wait/io/file/sql/binlog_index MANY NONE MANY NONE
145 slave-relay-bin.index wait/io/file/sql/binlog_index MANY NONE MANY NONE
146 select
147 EVENT_NAME,
148 if (count_read > 0, "MANY", "NONE") as COUNT_READ,
149 if (count_write > 0,"MANY", "NONE") as COUNT_WRITE,
150 if (sum_number_of_bytes_read > 0, "MANY", "NONE") as SUM_NUMBER_OF_BYTES_READ,
151 if (sum_number_of_bytes_write > 0, "MANY", "NONE") as SUM_NUMBER_OF_BYTES_WRITE
152 from performance_schema.file_summary_by_event_name
153 where event_name like "%binlog%" order by event_name;
154 EVENT_NAME COUNT_READ COUNT_WRITE SUM_NUMBER_OF_BYTES_READ SUM_NUMBER_OF_BYTES_WRITE
155 wait/io/file/sql/binlog MANY MANY MANY MANY
156 wait/io/file/sql/binlog_cache NONE NONE NONE NONE
157 wait/io/file/sql/binlog_index MANY NONE MANY NONE
158 wait/io/file/sql/binlog_index_cache NONE NONE NONE NONE
159 select
160 EVENT_NAME,
161 if (count_star > 0, "MANY", "NONE") as COUNT_STAR
162 from performance_schema.events_waits_summary_global_by_event_name
163 where event_name like "%MYSQL_BIN_LOG%"
164 and event_name not like "%MYSQL_BIN_LOG::update_cond"
165 order by event_name;
166 EVENT_NAME COUNT_STAR
167 wait/synch/cond/sql/MYSQL_BIN_LOG::COND_done NONE
168 wait/synch/cond/sql/MYSQL_BIN_LOG::COND_flush_queue NONE
169 wait/synch/cond/sql/MYSQL_BIN_LOG::COND_wait_for_group_turn NONE
170 wait/synch/cond/sql/MYSQL_BIN_LOG::prep_xids_cond NONE
171 wait/synch/mutex/sql/MYSQL_BIN_LOG::LOCK_after_commit MANY
172 wait/synch/mutex/sql/MYSQL_BIN_LOG::LOCK_after_commit_queue MANY
173 wait/synch/mutex/sql/MYSQL_BIN_LOG::LOCK_binlog_end_pos MANY
174 wait/synch/mutex/sql/MYSQL_BIN_LOG::LOCK_commit MANY
175 wait/synch/mutex/sql/MYSQL_BIN_LOG::LOCK_commit_queue MANY
176 wait/synch/mutex/sql/MYSQL_BIN_LOG::LOCK_done MANY
177 wait/synch/mutex/sql/MYSQL_BIN_LOG::LOCK_flush_queue MANY
178 wait/synch/mutex/sql/MYSQL_BIN_LOG::LOCK_index MANY
179 wait/synch/mutex/sql/MYSQL_BIN_LOG::LOCK_log MANY
180 wait/synch/mutex/sql/MYSQL_BIN_LOG::LOCK_sync MANY
181 wait/synch/mutex/sql/MYSQL_BIN_LOG::LOCK_sync_queue MANY
182 wait/synch/mutex/sql/MYSQL_BIN_LOG::LOCK_wait_for_group_turn NONE
183 wait/synch/mutex/sql/MYSQL_BIN_LOG::LOCK_xids MANY
184 "Expect a slave relay log"
185 select
186 substring(file_name, locate("slave-", file_name)) as FILE_NAME,
187 EVENT_NAME,
188 if (count_read > 0, "MANY", "NONE") as COUNT_READ,
189 if (count_write > 0,"MANY", "NONE") as COUNT_WRITE,
190 if (sum_number_of_bytes_read > 0, "MANY", "NONE") as SUM_NUMBER_OF_BYTES_READ,
191 if (sum_number_of_bytes_write > 0, "MANY", "NONE") as SUM_NUMBER_OF_BYTES_WRITE
192 from performance_schema.file_summary_by_instance
193 where event_name like "%relaylog%"
194 and (file_name not like "%slave-relay-bin.0%"
195 or file_name like "%slave-relay-bin.000001"
196 or file_name like "%slave-relay-bin.000002")
197 order by file_name;
198 FILE_NAME EVENT_NAME COUNT_READ COUNT_WRITE SUM_NUMBER_OF_BYTES_READ SUM_NUMBER_OF_BYTES_WRITE
199 slave-relay-bin.000001 wait/io/file/sql/relaylog MANY MANY MANY MANY
200 slave-relay-bin.000002 wait/io/file/sql/relaylog MANY MANY MANY MANY
201 select
202 EVENT_NAME,
203 if (count_read > 0, "MANY", "NONE") as COUNT_READ,
204 if (count_write > 0,"MANY", "NONE") as COUNT_WRITE,
205 if (sum_number_of_bytes_read > 0, "MANY", "NONE") as SUM_NUMBER_OF_BYTES_READ,
206 if (sum_number_of_bytes_write > 0, "MANY", "NONE") as SUM_NUMBER_OF_BYTES_WRITE
207 from performance_schema.file_summary_by_event_name
208 where event_name like "%relaylog%" order by event_name;
209 EVENT_NAME COUNT_READ COUNT_WRITE SUM_NUMBER_OF_BYTES_READ SUM_NUMBER_OF_BYTES_WRITE
210 wait/io/file/sql/relaylog MANY MANY MANY MANY
211 wait/io/file/sql/relaylog_cache NONE NONE NONE NONE
212 wait/io/file/sql/relaylog_index MANY NONE NONE NONE
213 wait/io/file/sql/relaylog_index_cache NONE NONE NONE NONE
214 select
215 EVENT_NAME,
216 if (count_star > 0, "MANY", "NONE") as COUNT_STAR
217 from performance_schema.events_waits_summary_global_by_event_name
218 where event_name like "%MYSQL_RELAY_LOG%"
219 and event_name not like "%MYSQL_RELAY_LOG::update_cond"
220 order by event_name;
221 EVENT_NAME COUNT_STAR
222 wait/synch/mutex/sql/MYSQL_RELAY_LOG::LOCK_commit NONE
223 wait/synch/mutex/sql/MYSQL_RELAY_LOG::LOCK_index MANY
224 wait/synch/mutex/sql/MYSQL_RELAY_LOG::LOCK_log MANY
225 wait/synch/mutex/sql/MYSQL_RELAY_LOG::LOCK_log_end_pos MANY
226 wait/synch/mutex/sql/MYSQL_RELAY_LOG::LOCK_sync NONE
227 wait/synch/mutex/sql/MYSQL_RELAY_LOG::LOCK_xids MANY
228 include/rpl_end.inc