Debian Codegraph @

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

raw
1 include/master-slave.inc
2 [connection master]
3 drop table if exists test.t1;
4 connection slave;
5 reset master;
6 create table test.t1(a int);
7 drop table test.t1;
8 include/show_binlog_events.inc
9 Log_name Pos Event_type Server_id End_log_pos Info
10 slave-bin.000001 # Gtid # # GTID #-#-#
11 slave-bin.000001 # Query # # use `test`; create table test.t1(a int)
12 slave-bin.000001 # Gtid # # GTID #-#-#
13 slave-bin.000001 # Query # # use `test`; DROP TABLE `t1` /* generated by server */
14 connection 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-%" and file_name not like "%sql/share%" 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.000001.idx wait/io/file/sql/gtid_index NONE MANY NONE MANY
27 master-bin.index wait/io/file/sql/binlog_index MANY MANY MANY MANY
28 select * from performance_schema.file_summary_by_instance
29 where file_name like "%slave-%" order by file_name;
30 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
31 "Expect a master binlog + binlog_index"
32 select
33 substring(file_name, locate("master-", file_name)) as FILE_NAME,
34 EVENT_NAME,
35 if (count_read > 0, "MANY", "NONE") as COUNT_READ,
36 if (count_write > 0,"MANY", "NONE") as COUNT_WRITE,
37 if (sum_number_of_bytes_read > 0, "MANY", "NONE") as SUM_NUMBER_OF_BYTES_READ,
38 if (sum_number_of_bytes_write > 0, "MANY", "NONE") as SUM_NUMBER_OF_BYTES_WRITE
39 from performance_schema.file_summary_by_instance
40 where event_name like "%binlog%" order by file_name;
41 FILE_NAME EVENT_NAME COUNT_READ COUNT_WRITE SUM_NUMBER_OF_BYTES_READ SUM_NUMBER_OF_BYTES_WRITE
42 master-bin.000001 wait/io/file/sql/binlog MANY MANY MANY MANY
43 master-bin.index wait/io/file/sql/binlog_index MANY MANY MANY MANY
44 select
45 EVENT_NAME,
46 if (count_read > 0, "MANY", "NONE") as COUNT_READ,
47 if (count_write > 0,"MANY", "NONE") as COUNT_WRITE,
48 if (sum_number_of_bytes_read > 0, "MANY", "NONE") as SUM_NUMBER_OF_BYTES_READ,
49 if (sum_number_of_bytes_write > 0, "MANY", "NONE") as SUM_NUMBER_OF_BYTES_WRITE
50 from performance_schema.file_summary_by_event_name
51 where event_name like "%binlog%" order by event_name;
52 EVENT_NAME COUNT_READ COUNT_WRITE SUM_NUMBER_OF_BYTES_READ SUM_NUMBER_OF_BYTES_WRITE
53 wait/io/file/sql/binlog MANY MANY MANY MANY
54 wait/io/file/sql/binlog_cache NONE NONE NONE NONE
55 wait/io/file/sql/binlog_index MANY MANY MANY MANY
56 wait/io/file/sql/binlog_index_cache NONE NONE NONE NONE
57 wait/io/file/sql/binlog_state NONE NONE NONE NONE
58 select
59 EVENT_NAME,
60 if (count_star > 0, "MANY", "NONE") as COUNT_STAR
61 from performance_schema.events_waits_summary_global_by_event_name
62 where event_name like "%MYSQL_BIN_LOG%"
63 and event_name not like "%MYSQL_BIN_LOG::update_cond"
64 and event_name not like "%MYSQL_BIN_LOG::COND_binlog_background_thread%"
65 and event_name not like "%MYSQL_BIN_LOG::COND_xid_list"
66 order by event_name;
67 EVENT_NAME COUNT_STAR
68 wait/synch/cond/sql/MYSQL_BIN_LOG::COND_bin_log_updated MANY
69 wait/synch/cond/sql/MYSQL_BIN_LOG::COND_queue_busy NONE
70 wait/synch/cond/sql/MYSQL_BIN_LOG::COND_relay_log_updated NONE
71 wait/synch/mutex/sql/MYSQL_BIN_LOG::LOCK_binlog_background_thread MANY
72 wait/synch/mutex/sql/MYSQL_BIN_LOG::LOCK_binlog_end_pos MANY
73 wait/synch/mutex/sql/MYSQL_BIN_LOG::LOCK_index MANY
74 wait/synch/mutex/sql/MYSQL_BIN_LOG::LOCK_xid_list MANY
75 "Expect no slave relay log"
76 select * from performance_schema.file_summary_by_instance
77 where event_name like "%relaylog%" order by file_name;
78 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
79 select * from performance_schema.file_summary_by_event_name
80 where event_name like "%relaylog%" order by event_name;
81 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
82 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
83 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
84 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
85 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
86 select * from performance_schema.events_waits_summary_global_by_event_name
87 where event_name like "%MYSQL_RELAY_LOG%"
88 and event_name not like "%MYSQL_RELAY_LOG::update_cond"
89 order by event_name;
90 EVENT_NAME COUNT_STAR SUM_TIMER_WAIT MIN_TIMER_WAIT AVG_TIMER_WAIT MAX_TIMER_WAIT
91 wait/synch/cond/sql/MYSQL_RELAY_LOG::COND_bin_log_updated 0 0 0 0 0
92 wait/synch/cond/sql/MYSQL_RELAY_LOG::COND_queue_busy 0 0 0 0 0
93 wait/synch/cond/sql/MYSQL_RELAY_LOG::COND_relay_log_updated 0 0 0 0 0
94 wait/synch/mutex/sql/MYSQL_RELAY_LOG::LOCK_binlog_end_pos 0 0 0 0 0
95 wait/synch/mutex/sql/MYSQL_RELAY_LOG::LOCK_index 0 0 0 0 0
96 connection slave;
97 "============ Performance schema on slave ============"
98 select * from performance_schema.file_summary_by_instance
99 where file_name like "%master-%" order by file_name;
100 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
101 select
102 substring(file_name, locate("slave-", file_name)) as FILE_NAME,
103 EVENT_NAME,
104 if (count_read > 0, "MANY", "NONE") as COUNT_READ,
105 if (count_write > 0,"MANY", "NONE") as COUNT_WRITE,
106 if (sum_number_of_bytes_read > 0, "MANY", "NONE") as SUM_NUMBER_OF_BYTES_READ,
107 if (sum_number_of_bytes_write > 0, "MANY", "NONE") as SUM_NUMBER_OF_BYTES_WRITE
108 from performance_schema.file_summary_by_instance
109 where file_name like "%slave-%"
110 and (file_name not like "%slave-relay-bin.0%"
111 or file_name like "%slave-relay-bin.000001"
112 or file_name like "%slave-relay-bin.000002")
113 order by file_name;
114 FILE_NAME EVENT_NAME COUNT_READ COUNT_WRITE SUM_NUMBER_OF_BYTES_READ SUM_NUMBER_OF_BYTES_WRITE
115 slave-bin.000001 wait/io/file/sql/binlog MANY MANY MANY MANY
116 slave-bin.000001.idx wait/io/file/sql/gtid_index NONE MANY NONE MANY
117 slave-bin.index wait/io/file/sql/binlog_index MANY MANY MANY MANY
118 slave-relay-bin.000001 wait/io/file/sql/relaylog MANY MANY MANY MANY
119 slave-relay-bin.000002 wait/io/file/sql/relaylog MANY MANY MANY MANY
120 slave-relay-bin.index wait/io/file/sql/relaylog_index MANY MANY MANY MANY
121 "Expect a slave binlog + binlog_index"
122 select
123 substring(file_name, locate("slave-", file_name)) as FILE_NAME,
124 EVENT_NAME,
125 if (count_read > 0, "MANY", "NONE") as COUNT_READ,
126 if (count_write > 0,"MANY", "NONE") as COUNT_WRITE,
127 if (sum_number_of_bytes_read > 0, "MANY", "NONE") as SUM_NUMBER_OF_BYTES_READ,
128 if (sum_number_of_bytes_write > 0, "MANY", "NONE") as SUM_NUMBER_OF_BYTES_WRITE
129 from performance_schema.file_summary_by_instance
130 where event_name like "%binlog%" order by file_name;
131 FILE_NAME EVENT_NAME COUNT_READ COUNT_WRITE SUM_NUMBER_OF_BYTES_READ SUM_NUMBER_OF_BYTES_WRITE
132 slave-bin.000001 wait/io/file/sql/binlog MANY MANY MANY MANY
133 slave-bin.index wait/io/file/sql/binlog_index MANY MANY MANY MANY
134 select
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_event_name
141 where event_name like "%binlog%" order by event_name;
142 EVENT_NAME COUNT_READ COUNT_WRITE SUM_NUMBER_OF_BYTES_READ SUM_NUMBER_OF_BYTES_WRITE
143 wait/io/file/sql/binlog MANY MANY MANY MANY
144 wait/io/file/sql/binlog_cache NONE NONE NONE NONE
145 wait/io/file/sql/binlog_index MANY MANY MANY MANY
146 wait/io/file/sql/binlog_index_cache NONE NONE NONE NONE
147 wait/io/file/sql/binlog_state NONE NONE NONE NONE
148 select
149 EVENT_NAME,
150 if (count_star > 0, "MANY", "NONE") as COUNT_STAR
151 from performance_schema.events_waits_summary_global_by_event_name
152 where event_name like "%MYSQL_BIN_LOG%"
153 and event_name not like "%MYSQL_BIN_LOG::update_cond"
154 and event_name not like "%MYSQL_BIN_LOG::COND_binlog_background_thread%"
155 and event_name not like "%MYSQL_BIN_LOG::COND_xid_list"
156 order by event_name;
157 EVENT_NAME COUNT_STAR
158 wait/synch/cond/sql/MYSQL_BIN_LOG::COND_bin_log_updated NONE
159 wait/synch/cond/sql/MYSQL_BIN_LOG::COND_queue_busy NONE
160 wait/synch/cond/sql/MYSQL_BIN_LOG::COND_relay_log_updated NONE
161 wait/synch/mutex/sql/MYSQL_BIN_LOG::LOCK_binlog_background_thread MANY
162 wait/synch/mutex/sql/MYSQL_BIN_LOG::LOCK_binlog_end_pos MANY
163 wait/synch/mutex/sql/MYSQL_BIN_LOG::LOCK_index MANY
164 wait/synch/mutex/sql/MYSQL_BIN_LOG::LOCK_xid_list MANY
165 "Expect a slave relay log"
166 select
167 substring(file_name, locate("slave-", file_name)) as FILE_NAME,
168 EVENT_NAME,
169 if (count_read > 0, "MANY", "NONE") as COUNT_READ,
170 if (count_write > 0,"MANY", "NONE") as COUNT_WRITE,
171 if (sum_number_of_bytes_read > 0, "MANY", "NONE") as SUM_NUMBER_OF_BYTES_READ,
172 if (sum_number_of_bytes_write > 0, "MANY", "NONE") as SUM_NUMBER_OF_BYTES_WRITE
173 from performance_schema.file_summary_by_instance
174 where event_name like "%relaylog%"
175 and (file_name not like "%slave-relay-bin.0%"
176 or file_name like "%slave-relay-bin.000001"
177 or file_name like "%slave-relay-bin.000002")
178 order by file_name;
179 FILE_NAME EVENT_NAME COUNT_READ COUNT_WRITE SUM_NUMBER_OF_BYTES_READ SUM_NUMBER_OF_BYTES_WRITE
180 slave-relay-bin.000001 wait/io/file/sql/relaylog MANY MANY MANY MANY
181 slave-relay-bin.000002 wait/io/file/sql/relaylog MANY MANY MANY MANY
182 slave-relay-bin.index wait/io/file/sql/relaylog_index MANY MANY MANY MANY
183 select
184 EVENT_NAME,
185 if (count_read > 0, "MANY", "NONE") as COUNT_READ,
186 if (count_write > 0,"MANY", "NONE") as COUNT_WRITE,
187 if (sum_number_of_bytes_read > 0, "MANY", "NONE") as SUM_NUMBER_OF_BYTES_READ,
188 if (sum_number_of_bytes_write > 0, "MANY", "NONE") as SUM_NUMBER_OF_BYTES_WRITE
189 from performance_schema.file_summary_by_event_name
190 where event_name like "%relaylog%" order by event_name;
191 EVENT_NAME COUNT_READ COUNT_WRITE SUM_NUMBER_OF_BYTES_READ SUM_NUMBER_OF_BYTES_WRITE
192 wait/io/file/sql/relaylog MANY MANY MANY MANY
193 wait/io/file/sql/relaylog_cache NONE NONE NONE NONE
194 wait/io/file/sql/relaylog_index MANY MANY MANY MANY
195 wait/io/file/sql/relaylog_index_cache NONE NONE NONE NONE
196 select
197 EVENT_NAME,
198 if (count_star > 0, "MANY", "NONE") as COUNT_STAR
199 from performance_schema.events_waits_summary_global_by_event_name
200 where event_name like "%MYSQL_RELAY_LOG%"
201 and event_name not like "%MYSQL_RELAY_LOG::update_cond"
202 order by event_name;
203 EVENT_NAME COUNT_STAR
204 wait/synch/cond/sql/MYSQL_RELAY_LOG::COND_bin_log_updated NONE
205 wait/synch/cond/sql/MYSQL_RELAY_LOG::COND_queue_busy NONE
206 wait/synch/cond/sql/MYSQL_RELAY_LOG::COND_relay_log_updated MANY
207 wait/synch/mutex/sql/MYSQL_RELAY_LOG::LOCK_binlog_end_pos NONE
208 wait/synch/mutex/sql/MYSQL_RELAY_LOG::LOCK_index MANY
209 include/stop_slave.inc