· 6 years ago · Apr 28, 2019, 08:06 PM
1............ DUMPING MAIN DATABASE ............
2***** DUMPING global_variables *****
3+-----------------------------------------------------+--------------------+
4| variable_name | variable_value |
5+-----------------------------------------------------+--------------------+
6| mysql-shun_on_failures | 5 |
7| mysql-shun_recovery_time_sec | 10 |
8| mysql-query_retries_on_failure | 1 |
9| mysql-client_multi_statements | true |
10| mysql-connect_retries_delay | 1 |
11| mysql-connection_delay_multiplex_ms | 0 |
12| mysql-connection_max_age_ms | 0 |
13| mysql-connect_timeout_server_max | 10000 |
14| mysql-eventslog_filename | |
15| mysql-eventslog_filesize | 104857600 |
16| mysql-default_charset | utf8 |
17| mysql-free_connections_pct | 10 |
18| mysql-session_idle_ms | 1000 |
19| mysql-have_ssl | false |
20| mysql-client_found_rows | true |
21| mysql-monitor_enabled | true |
22| mysql-monitor_connect_timeout | 600 |
23| mysql-monitor_ping_max_failures | 3 |
24| mysql-monitor_ping_timeout | 1000 |
25| mysql-monitor_read_only_max_timeout_count | 3 |
26| mysql-monitor_replication_lag_interval | 10000 |
27| mysql-monitor_replication_lag_timeout | 1000 |
28| mysql-monitor_groupreplication_healthcheck_interval | 5000 |
29| mysql-monitor_groupreplication_healthcheck_timeout | 800 |
30| mysql-monitor_galera_healthcheck_interval | 5000 |
31| mysql-monitor_galera_healthcheck_timeout | 800 |
32| mysql-monitor_replication_lag_use_percona_heartbeat | |
33| mysql-monitor_query_interval | 60000 |
34| mysql-monitor_query_timeout | 100 |
35| mysql-monitor_slave_lag_when_null | 60 |
36| mysql-monitor_threads_min | 8 |
37| mysql-monitor_threads_max | 128 |
38| mysql-monitor_threads_queue_maxsize | 128 |
39| mysql-monitor_wait_timeout | true |
40| mysql-monitor_writer_is_also_reader | true |
41| mysql-max_allowed_packet | 4194304 |
42| mysql-throttle_connections_per_sec_to_hostgroup | 1000000 |
43| mysql-max_transaction_time | 14400000 |
44| mysql-multiplexing | true |
45| mysql-forward_autocommit | false |
46| mysql-enforce_autocommit_on_reads | false |
47| mysql-autocommit_false_not_reusable | false |
48| mysql-autocommit_false_is_transaction | false |
49| mysql-verbose_query_error | false |
50| mysql-hostgroup_manager_verbose | 1 |
51| mysql-binlog_reader_connect_retry_msec | 3000 |
52| mysql-threshold_query_length | 524288 |
53| mysql-threshold_resultset_size | 4194304 |
54| mysql-query_digests_max_digest_length | 2048 |
55| mysql-query_digests_max_query_length | 65000 |
56| mysql-wait_timeout | 28800000 |
57| mysql-throttle_max_bytes_per_second_to_client | 0 |
58| mysql-throttle_ratio_server_to_client | 0 |
59| mysql-max_stmts_per_connection | 20 |
60| mysql-max_stmts_cache | 10000 |
61| mysql-mirror_max_concurrency | 16 |
62| mysql-mirror_max_queue_length | 32000 |
63| mysql-default_max_latency_ms | 1000 |
64| mysql-query_processor_iterations | 0 |
65| mysql-query_processor_regex | 1 |
66| mysql-reset_connection_algorithm | 2 |
67| mysql-auto_increment_delay_multiplex | 5 |
68| mysql-long_query_time | 1000 |
69| mysql-query_cache_size_MB | 256 |
70| mysql-poll_timeout_on_failure | 100 |
71| mysql-server_capabilities | 569867 |
72| mysql-kill_backend_connection_when_disconnect | true |
73| mysql-session_idle_show_processlist | true |
74| mysql-query_digests | true |
75| mysql-query_digests_lowercase | false |
76| mysql-query_digests_normalize_digest_text | false |
77| mysql-query_digests_track_hostname | false |
78| mysql-servers_stats | true |
79| mysql-default_reconnect | true |
80| mysql-ssl_p2s_ca | |
81| mysql-ssl_p2s_cert | |
82| mysql-ssl_p2s_key | |
83| mysql-ssl_p2s_cipher | |
84| mysql-init_connect | |
85| mysql-ldap_user_variable | |
86| mysql-add_ldap_user_comment | |
87| mysql-default_sql_mode | |
88| mysql-default_time_zone | SYSTEM |
89| mysql-connpoll_reset_queue_length | 50 |
90| mysql-stats_time_backend_query | false |
91| mysql-stats_time_query_processor | false |
92| mysql-query_cache_stores_empty_result | true |
93| admin-stats_credentials | stats:stats |
94| admin-stats_mysql_connections | 60 |
95| admin-stats_mysql_connection_pool | 60 |
96| admin-stats_mysql_query_cache | 60 |
97| admin-stats_system_cpu | 60 |
98| admin-stats_system_memory | 60 |
99| admin-telnet_admin_ifaces | (null) |
100| admin-telnet_stats_ifaces | (null) |
101| admin-refresh_interval | 2000 |
102| admin-read_only | false |
103| admin-hash_passwords | true |
104| admin-vacuum_stats | true |
105| admin-version | 2.0.3-29-g00f26d5 |
106| admin-cluster_username | |
107| admin-cluster_password | |
108| admin-cluster_check_interval_ms | 1000 |
109| admin-cluster_check_status_frequency | 10 |
110| admin-cluster_mysql_query_rules_diffs_before_sync | 3 |
111| admin-cluster_mysql_servers_diffs_before_sync | 3 |
112| admin-cluster_mysql_users_diffs_before_sync | 3 |
113| admin-cluster_proxysql_servers_diffs_before_sync | 3 |
114| admin-cluster_mysql_query_rules_save_to_disk | true |
115| admin-cluster_mysql_servers_save_to_disk | true |
116| admin-cluster_mysql_users_save_to_disk | true |
117| admin-cluster_proxysql_servers_save_to_disk | true |
118| admin-checksum_mysql_query_rules | true |
119| admin-checksum_mysql_servers | true |
120| admin-checksum_mysql_users | true |
121| admin-web_enabled | false |
122| admin-web_port | 6080 |
123| admin-admin_credentials | admin:admin |
124| admin-mysql_ifaces | 0.0.0.0:6032 |
125| mysql-threads | 4 |
126| mysql-max_connections | 2048 |
127| mysql-default_query_delay | 0 |
128| mysql-default_query_timeout | 36000000 |
129| mysql-have_compress | true |
130| mysql-poll_timeout | 2000 |
131| mysql-interfaces | 0.0.0.0:6033 |
132| mysql-default_schema | information_schema |
133| mysql-stacksize | 1048576 |
134| mysql-server_version | 5.5.30 |
135| mysql-connect_timeout_server | 3000 |
136| mysql-monitor_username | monitor |
137| mysql-monitor_password | monitor |
138| mysql-monitor_history | 600000 |
139| mysql-monitor_connect_interval | 60000 |
140| mysql-monitor_ping_interval | 10000 |
141| mysql-monitor_read_only_interval | 1500 |
142| mysql-monitor_read_only_timeout | 500 |
143| mysql-ping_interval_server_msec | 120000 |
144| mysql-ping_timeout_server | 500 |
145| mysql-commands_stats | true |
146| mysql-sessions_sort | true |
147| mysql-connect_retries_on_failure | 10 |
148+-----------------------------------------------------+--------------------+
149***** END OF DUMPING global_variables *****
150
151***** DUMPING mysql_collations *****
152+------+------------------------------+----------+---------+
153| Id | Collation | Charset | Default |
154+------+------------------------------+----------+---------+
155| 1 | big5_chinese_ci | big5 | Yes |
156| 2 | latin2_czech_cs | latin2 | Yes |
157| 3 | dec8_swedisch_ci | dec8 | Yes |
158| 4 | cp850_general_ci | cp850 | Yes |
159| 5 | latin1_german_ci | latin1 | Yes |
160| 6 | hp8_english_ci | hp8 | Yes |
161| 7 | koi8r_general_ci | koi8r | Yes |
162| 8 | latin1_swedish_ci | latin1 | |
163| 9 | latin2_general_ci | latin2 | |
164| 10 | swe7_swedish_ci | swe7 | Yes |
165| 11 | ascii_general_ci | ascii | Yes |
166| 12 | ujis_japanese_ci | ujis | Yes |
167| 13 | sjis_japanese_ci | sjis | Yes |
168| 14 | cp1251_bulgarian_ci | cp1251 | Yes |
169| 15 | latin1_danish_ci | latin1 | |
170| 16 | hebrew_general_ci | hebrew | Yes |
171| 17 | filename | filename | Yes |
172| 18 | tis620_thai_ci | tis620 | Yes |
173| 19 | euckr_korean_ci | euckr | Yes |
174| 20 | latin7_estonian_cs | latin7 | Yes |
175| 21 | latin2_hungarian_ci | latin2 | |
176| 22 | koi8u_general_ci | koi8u | Yes |
177| 23 | cp1251_ukrainian_ci | cp1251 | |
178| 24 | gb2312_chinese_ci | gb2312 | Yes |
179| 25 | greek_general_ci | greek | Yes |
180| 26 | cp1250_general_ci | cp1250 | Yes |
181| 27 | latin2_croatian_ci | latin2 | |
182| 28 | gbk_chinese_ci | gbk | Yes |
183| 29 | cp1257_lithunian_ci | cp1257 | Yes |
184| 30 | latin5_turkish_ci | latin5 | Yes |
185| 31 | latin1_german2_ci | latin1 | |
186| 32 | armscii8_general_ci | armscii8 | Yes |
187| 33 | utf8_general_ci | utf8 | Yes |
188| 34 | cp1250_czech_cs | cp1250 | |
189| 35 | ucs2_general_ci | ucs2 | Yes |
190| 36 | cp866_general_ci | cp866 | Yes |
191| 37 | keybcs2_general_ci | keybcs2 | Yes |
192| 38 | macce_general_ci | macce | Yes |
193| 39 | macroman_general_ci | macroman | Yes |
194| 40 | cp852_general_ci | cp852 | Yes |
195| 41 | latin7_general_ci | latin7 | |
196| 42 | latin7_general_cs | latin7 | |
197| 43 | macce_bin | macce | |
198| 44 | cp1250_croatian_ci | cp1250 | |
199| 45 | utf8mb4_general_ci | utf8mb4 | Yes |
200| 46 | utf8mb4_bin | utf8mb4 | |
201| 47 | latin1_bin | latin1 | |
202| 48 | latin1_general_ci | latin1 | |
203| 49 | latin1_general_cs | latin1 | |
204| 50 | cp1251_bin | cp1251 | |
205| 51 | cp1251_general_ci | cp1251 | |
206| 52 | cp1251_general_cs | cp1251 | |
207| 53 | macroman_bin | macroman | |
208| 54 | utf16_general_ci | utf16 | Yes |
209| 55 | utf16_bin | utf16 | |
210| 56 | utf16_general_ci | utf16le | Yes |
211| 57 | cp1256_general_ci | cp1256 | Yes |
212| 58 | cp1257_bin | cp1257 | |
213| 59 | cp1257_general_ci | cp1257 | |
214| 60 | utf32_general_ci | utf32 | Yes |
215| 61 | utf32_bin | utf32 | |
216| 62 | utf16_bin | utf16le | |
217| 63 | binary | binary | Yes |
218| 64 | armscii8_bin | armscii8 | |
219| 65 | ascii_bin | ascii | |
220| 66 | cp1250_bin | cp1250 | |
221| 67 | cp1256_bin | cp1256 | |
222| 68 | cp866_bin | cp866 | |
223| 69 | dec8_bin | dec8 | |
224| 70 | greek_bin | greek | |
225| 71 | hebrew_bin | hebrew | |
226| 72 | hp8_bin | hp8 | |
227| 73 | keybcs2_bin | keybcs2 | |
228| 74 | koi8r_bin | koi8r | |
229| 75 | koi8u_bin | koi8u | |
230| 77 | latin2_bin | latin2 | |
231| 78 | latin5_bin | latin5 | |
232| 79 | latin7_bin | latin7 | |
233| 80 | cp850_bin | cp850 | |
234| 81 | cp852_bin | cp852 | |
235| 82 | swe7_bin | swe7 | |
236| 83 | utf8_bin | utf8 | |
237| 84 | big5_bin | big5 | |
238| 85 | euckr_bin | euckr | |
239| 86 | gb2312_bin | gb2312 | |
240| 87 | gbk_bin | gbk | |
241| 88 | sjis_bin | sjis | |
242| 89 | tis620_bin | tis620 | |
243| 90 | ucs2_bin | ucs2 | |
244| 91 | ujis_bin | ujis | |
245| 92 | geostd8_general_ci | geostd8 | Yes |
246| 93 | geostd8_bin | geostd8 | |
247| 94 | latin1_spanish_ci | latin1 | |
248| 95 | cp932_japanese_ci | cp932 | Yes |
249| 96 | cp932_bin | cp932 | |
250| 97 | eucjpms_japanese_ci | eucjpms | Yes |
251| 98 | eucjpms_bin | eucjpms | |
252| 99 | cp1250_polish_ci | cp1250 | |
253| 101 | utf16_unicode_ci | utf16 | |
254| 102 | utf16_icelandic_ci | utf16 | |
255| 103 | utf16_latvian_ci | utf16 | |
256| 104 | utf16_romanian_ci | utf16 | |
257| 105 | utf16_slovenian_ci | utf16 | |
258| 106 | utf16_polish_ci | utf16 | |
259| 107 | utf16_estonian_ci | utf16 | |
260| 108 | utf16_spanish_ci | utf16 | |
261| 109 | utf16_swedish_ci | utf16 | |
262| 110 | utf16_turkish_ci | utf16 | |
263| 111 | utf16_czech_ci | utf16 | |
264| 112 | utf16_danish_ci | utf16 | |
265| 113 | utf16_lithunian_ci | utf16 | |
266| 114 | utf16_slovak_ci | utf16 | |
267| 115 | utf16_spanish2_ci | utf16 | |
268| 116 | utf16_roman_ci | utf16 | |
269| 117 | utf16_persian_ci | utf16 | |
270| 118 | utf16_esperanto_ci | utf16 | |
271| 119 | utf8_spanish_ci | utf8 | |
272| 120 | utf16_sinhala_ci | utf16 | |
273| 121 | utf16_german2_ci | utf16 | |
274| 122 | utf16_croatian_mysql561_ci | utf16 | |
275| 123 | utf16_unicode_520_ci | utf16 | |
276| 124 | utf16_vietnamese_ci | utf16 | |
277| 128 | ucs2_unicode_ci | ucs2 | |
278| 129 | ucs2_icelandic_ci | ucs2 | |
279| 130 | ucs2_latvian_ci | ucs2 | |
280| 131 | ucs2_romanian_ci | ucs2 | |
281| 132 | ucs2_slovenian_ci | ucs2 | |
282| 133 | ucs2_polish_ci | ucs2 | |
283| 134 | ucs2_estonian_ci | ucs2 | |
284| 135 | ucs2_spanish_ci | ucs2 | |
285| 136 | ucs2_swedish_ci | ucs2 | |
286| 137 | ucs2_turkish_ci | ucs2 | |
287| 138 | ucs2_czech_ci | ucs2 | |
288| 139 | ucs2_danish_ci | ucs2 | |
289| 140 | ucs2_lithunian_ci | ucs2 | |
290| 141 | ucs2_slovak_ci | ucs2 | |
291| 142 | ucs2_spanish2_ci | ucs2 | |
292| 143 | ucs2_roman_ci | ucs2 | |
293| 144 | ucs2_persian_ci | ucs2 | |
294| 145 | ucs2_esperanto_ci | ucs2 | |
295| 146 | ucs2_hungarian_ci | ucs2 | |
296| 147 | ucs2_sinhala_ci | ucs2 | |
297| 148 | ucs2_german2_ci | ucs2 | |
298| 149 | ucs2_croatian_ci | ucs2 | |
299| 150 | ucs2_unicode_520_ci | ucs2 | |
300| 151 | ucs2_vietnamese_ci | ucs2 | |
301| 159 | ucs2_general_mysql500_ci | ucs2 | |
302| 160 | utf32_unicode_ci | utf32 | |
303| 161 | utf32_icelandic_ci | utf32 | |
304| 162 | utf32_latvian_ci | utf32 | |
305| 163 | utf32_romanian_ci | utf32 | |
306| 164 | utf32_slovenian_ci | utf32 | |
307| 165 | utf32_polish_ci | utf32 | |
308| 166 | utf32_estonian_ci | utf32 | |
309| 167 | utf32_spanish_ci | utf32 | |
310| 168 | utf32_swedish_ci | utf32 | |
311| 169 | utf32_turkish_ci | utf32 | |
312| 170 | utf32_czech_ci | utf32 | |
313| 171 | utf32_danish_ci | utf32 | |
314| 172 | utf32_lithunian_ci | utf32 | |
315| 173 | utf32_slovak_ci | utf32 | |
316| 174 | utf32_spanish_ci | utf32 | |
317| 175 | utf32_roman_ci | utf32 | |
318| 176 | utf32_persian_ci | utf32 | |
319| 177 | utf32_esperanto_ci | utf32 | |
320| 178 | utf32_hungarian_ci | utf32 | |
321| 179 | utf32_sinhala_ci | utf32 | |
322| 180 | utf32_german2_ci | utf32 | |
323| 181 | utf32_croatian_mysql561_ci | utf32 | |
324| 182 | utf32_unicode_520_ci | utf32 | |
325| 183 | utf32_vietnamese_ci | utf32 | |
326| 192 | utf8_unicode_ci | utf8 | |
327| 193 | utf8_icelandic_ci | utf8 | |
328| 194 | utf8_latvian_ci | utf8 | |
329| 195 | utf8_romanian_ci | utf8 | |
330| 196 | utf8_slovenian_ci | utf8 | |
331| 197 | utf8_polish_ci | utf8 | |
332| 198 | utf8_estonian_ci | utf8 | |
333| 199 | utf8_spanish_ci | utf8 | |
334| 200 | utf8_swedish_ci | utf8 | |
335| 201 | utf8_turkish_ci | utf8 | |
336| 202 | utf8_czech_ci | utf8 | |
337| 203 | utf8_danish_ci | utf8 | |
338| 204 | utf8_lithunian_ci | utf8 | |
339| 205 | utf8_slovak_ci | utf8 | |
340| 206 | utf8_spanish2_ci | utf8 | |
341| 207 | utf8_roman_ci | utf8 | |
342| 208 | utf8_persian_ci | utf8 | |
343| 209 | utf8_esperanto_ci | utf8 | |
344| 210 | utf8_hungarian_ci | utf8 | |
345| 211 | utf8_sinhala_ci | utf8 | |
346| 212 | utf8_german_ci | utf8 | |
347| 213 | utf8_croatian_ci | utf8 | |
348| 214 | utf8_unicode_520_ci | utf8 | |
349| 215 | utf8_vietnamese_ci | utf8 | |
350| 223 | utf8_general_mysql500_ci | utf8 | |
351| 224 | utf8mb4_unicode_ci | utf8mb4 | |
352| 225 | utf8mb4_icelandic_ci | utf8mb4 | |
353| 226 | utf8mb4_latvian_ci | utf8mb4 | |
354| 227 | utf8mb4_romanian_ci | utf8mb4 | |
355| 228 | utf8mb4_slovenian_ci | utf8mb4 | |
356| 229 | utf8mb4_polish_ci | utf8mb4 | |
357| 230 | utf8mb4_estonian_ci | utf8mb4 | |
358| 231 | utf8mb4_spanish_ci | utf8mb4 | |
359| 232 | utf8mb4_swedish_ci | utf8mb4 | |
360| 233 | utf8mb4_turkish_ci | utf8mb4 | |
361| 234 | utf8mb4_czech_ci | utf8mb4 | |
362| 235 | utf8mb4_danish_ci | utf8mb4 | |
363| 236 | utf8mb4_lithuanian_ci | utf8mb4 | |
364| 237 | utf8mb4_slovak_ci | utf8mb4 | |
365| 238 | utf8mb4_spanish2_ci | utf8mb4 | |
366| 239 | utf8mb4_roman_ci | utf8mb4 | |
367| 240 | utf8mb4_persian_ci | utf8mb4 | |
368| 241 | utf8mb4_esperanto_ci | utf8mb4 | |
369| 242 | utf8mb4_hungarian_ci | utf8mb4 | |
370| 243 | utf8mb4_sinhala_ci | utf8mb4 | |
371| 244 | utf8mb4_german2_ci | utf8mb4 | |
372| 245 | utf8mb4_croatian_mysql561_ci | utf8mb4 | |
373| 246 | utf8mb4_unicode_520_ci | utf8mb4 | |
374| 247 | utf8mb4_vietnamese_ci | utf8mb4 | |
375| 254 | utf8_general_cs | utf8 | |
376| 255 | utf8mb4_0900_ai_ci | utf8mb4 | |
377| 576 | utf8_croatian_ci | utf8 | |
378| 577 | utf8_myanmar_ci | utf8 | |
379| 578 | utf8_thai_520_w2 | utf8 | |
380| 608 | utf8mb4_croatian_ci | utf8mb4 | |
381| 609 | utf8mb4_myanmar_ci | utf8mb4 | |
382| 610 | utf8mb4_thai_520_w2 | utf8mb4 | |
383| 640 | ucs2_croatian_ci | ucs2 | |
384| 641 | ucs2_myanmar_ci | ucs2 | |
385| 642 | ucs2_thai_520_w2 | ucs2 | |
386| 672 | utf16_croatian_ci | utf16 | |
387| 673 | utf16_myanmar_ci | utf16 | |
388| 674 | utf16_thai_520_w2 | utf16 | |
389| 736 | utf32_croatian_ci | utf32 | |
390| 737 | utf32_myanmar_ci | utf32 | |
391| 738 | utf32_thai_520_w2 | utf32 | |
392| 1025 | big5_chinese_nopad_ci | big5 | |
393| 1027 | dec8_swedisch_nopad_ci | dec8 | |
394| 1028 | cp850_general_nopad_ci | cp850 | |
395| 1030 | hp8_english_nopad_ci | hp8 | |
396| 1031 | koi8r_general_nopad_ci | koi8r | |
397| 1032 | latin1_swedish_nopad_ci | latin1 | |
398| 1033 | latin2_general_nopad_ci | latin2 | |
399| 1034 | swe7_swedish_nopad_ci | swe7 | |
400| 1035 | ascii_general_nopad_ci | ascii | |
401| 1036 | ujis_japanese_nopad_ci | ujis | |
402| 1037 | sjis_japanese_nopad_ci | sjis | |
403| 1040 | hebrew_general_nopad_ci | hebrew | |
404| 1042 | tis620_thai_nopad_ci | tis620 | |
405| 1043 | euckr_korean_nopad_ci | euckr | |
406| 1046 | koi8u_general_nopad_ci | koi8u | |
407| 1048 | gb2312_chinese_nopad_ci | gb2312 | |
408| 1049 | greek_general_nopad_ci | greek | |
409| 1050 | cp1250_general_nopad_ci | cp1250 | |
410| 1052 | gbk_chinese_nopad_ci | gbk | |
411| 1054 | latin5_turkish_nopad_ci | latin5 | |
412| 1056 | armscii8_general_nopad_ci | armscii8 | |
413| 1057 | utf8_general_nopad_ci | utf8 | |
414| 1059 | ucs2_general_nopad_ci | ucs2 | |
415| 1060 | cp866_general_nopad_ci | cp866 | |
416| 1061 | keybcs2_general_nopad_ci | keybcs2 | |
417| 1062 | macce_general_nopad_ci | macce | |
418| 1063 | macroman_general_nopad_ci | macroman | |
419| 1064 | cp852_general_nopad_ci | cp852 | |
420| 1065 | latin7_general_nopad_ci | latin7 | |
421| 1067 | macce_nopad_bin | macce | |
422| 1069 | utf8mb4_general_nopad_ci | utf8mb4 | |
423| 1070 | utf8mb4_general_nopad_bin | utf8mb4 | |
424| 1071 | latin1_nopad_bin | latin1 | |
425| 1074 | cp1251_nopad_bin | cp1251 | |
426| 1075 | cp1251_general_nopad_ci | cp1251 | |
427| 1077 | macroman_nopad_bin | macroman | |
428| 1078 | utf16_general_nopad_ci | utf16 | |
429| 1079 | utf16_nopad_bin | utf16 | |
430| 1080 | utf16le_general_nopad_ci | utf16le | |
431| 1081 | cp1256_general_nopad_ci | cp1256 | |
432| 1082 | cp1257_nopad_bin | cp1257 | |
433| 1083 | cp1257_general_nopad_ci | cp1257 | |
434| 1084 | utf32_general_nopad_ci | utf32 | |
435| 1085 | utf32_nopad_bin | utf32 | |
436| 1086 | utf16le_nopad_bin | utf16le | |
437| 1088 | armscii8_nopad_bin | armscii8 | |
438| 1089 | ascii_nopad_bin | ascii | |
439| 1090 | cp1250_nopad_bin | cp1250 | |
440| 1091 | cp1256_nopad_bin | cp1256 | |
441| 1092 | cp866_nopad_bin | cp866 | |
442| 1093 | dec8_nopad_bin | dec8 | |
443| 1094 | greek_nopad_bin | greek | |
444| 1095 | hebrew_nopad_bin | hebrew | |
445| 1096 | hp8_nopad_bin | hp8 | |
446| 1097 | keybcs2_nopad_bin | keybcs2 | |
447| 1098 | koi8r_nopad_bin | koi8r | |
448| 1099 | koi8u_nopad_bin | koi8u | |
449| 1101 | latin2_nopad_bin | latin2 | |
450| 1102 | latin5_nopad_bin | latin5 | |
451| 1103 | latin7_nopad_bin | latin7 | |
452| 1104 | cp850_nopad_bin | cp850 | |
453| 1105 | cp852_nopad_bin | cp852 | |
454| 1106 | swe7_nopad_bin | swe7 | |
455| 1107 | utf8_nopad_bin | utf8 | |
456| 1108 | big5_nopad_bin | big5 | |
457| 1109 | euckr_nopad_bin | euckr | |
458| 1110 | gb2312_nopad_bin | gb2312 | |
459| 1111 | gbk_nopad_bin | gbk | |
460| 1112 | sjis_nopad_bin | sjis | |
461| 1113 | tis620_nopad_bin | tis620 | |
462| 1114 | ucs2_nopad_bin | ucs2 | |
463| 1115 | ujis_nopad_bin | ujis | |
464| 1116 | geostd8_general_nopad_ci | geostd8 | |
465| 1117 | geostd8_nopad_bin | geostd8 | |
466| 1119 | cp932_japanese_nopad_ci | cp932 | |
467| 1120 | cp932_nopad_bin | cp932 | |
468| 1121 | eucjpms_japanese_nopad_ci | eucjpms | |
469| 1122 | eucjpms_nopad_bin | eucjpms | |
470| 1125 | utf16_unicode_nopad_ci | utf16 | |
471| 1147 | utf16_unicode_520_nopad_ci | utf16 | |
472| 1152 | ucs2_unicode_nopad_ci | ucs2 | |
473| 1174 | ucs2_unicode_520_nopad_ci | ucs2 | |
474| 1184 | utf32_unicode_nopad_ci | utf32 | |
475| 1206 | utf32_unicode_520_nopad_ci | utf32 | |
476| 1216 | utf8_unicode_nopad_ci | utf8 | |
477| 1238 | utf8_unicode_520_nopad_ci | utf8 | |
478| 1248 | utf8mb4_unicode_nopad_ci | utf8mb4 | |
479| 1270 | utf8mb4_unicode_520_nopad_ci | utf8mb4 | |
480+------+------------------------------+----------+---------+
481***** END OF DUMPING mysql_collations *****
482
483***** DUMPING mysql_galera_hostgroups *****
484***** END OF DUMPING mysql_galera_hostgroups *****
485
486***** DUMPING mysql_group_replication_hostgroups *****
487***** END OF DUMPING mysql_group_replication_hostgroups *****
488
489***** DUMPING mysql_query_rules *****
490+---------+--------+----------+------------+--------+-------------+------------+------------+--------+---------------------+---------------+----------------------+--------------+---------+-----------------+-----------------------+-----------+--------------------+---------------+-----------+---------+---------+-------+-------------------+----------------+------------------+-----------+--------+-------------+-----------+---------------------+-----+-------+---------+
491| rule_id | active | username | schemaname | flagIN | client_addr | proxy_addr | proxy_port | digest | match_digest | match_pattern | negate_match_pattern | re_modifiers | flagOUT | replace_pattern | destination_hostgroup | cache_ttl | cache_empty_result | cache_timeout | reconnect | timeout | retries | delay | next_query_flagIN | mirror_flagOUT | mirror_hostgroup | error_msg | OK_msg | sticky_conn | multiplex | gtid_from_hostgroup | log | apply | comment |
492+---------+--------+----------+------------+--------+-------------+------------+------------+--------+---------------------+---------------+----------------------+--------------+---------+-----------------+-----------------------+-----------+--------------------+---------------+-----------+---------+---------+-------+-------------------+----------------+------------------+-----------+--------+-------------+-----------+---------------------+-----+-------+---------+
493| 200 | 1 | root | NULL | 0 | NULL | NULL | NULL | NULL | ^SELECT.*FOR UPDATE | NULL | 0 | CASELESS | NULL | NULL | 10 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 1 | NULL |
494| 201 | 1 | root | NULL | 0 | NULL | NULL | NULL | NULL | ^SELECT | NULL | 0 | CASELESS | NULL | NULL | 11 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 10 | NULL | 1 | NULL |
495+---------+--------+----------+------------+--------+-------------+------------+------------+--------+---------------------+---------------+----------------------+--------------+---------+-----------------+-----------------------+-----------+--------------------+---------------+-----------+---------+---------+-------+-------------------+----------------+------------------+-----------+--------+-------------+-----------+---------------------+-----+-------+---------+
496***** END OF DUMPING mysql_query_rules *****
497
498***** DUMPING mysql_query_rules_fast_routing *****
499***** END OF DUMPING mysql_query_rules_fast_routing *****
500
501***** DUMPING mysql_replication_hostgroups *****
502+------------------+------------------+------------+---------+
503| writer_hostgroup | reader_hostgroup | check_type | comment |
504+------------------+------------------+------------+---------+
505| 10 | 11 | read_only | |
506+------------------+------------------+------------+---------+
507***** END OF DUMPING mysql_replication_hostgroups *****
508
509***** DUMPING mysql_servers *****
510+--------------+-------------+------+-----------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------+
511| hostgroup_id | hostname | port | gtid_port | status | weight | compression | max_connections | max_replication_lag | use_ssl | max_latency_ms | comment |
512+--------------+-------------+------+-----------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------+
513| 11 | 172.16.0.66 | 3306 | 3307 | ONLINE | 1 | 0 | 1000 | 0 | 0 | 0 | |
514| 10 | 172.16.2.95 | 3306 | 3307 | ONLINE | 1 | 0 | 1000 | 0 | 0 | 0 | |
515+--------------+-------------+------+-----------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------+
516***** END OF DUMPING mysql_servers *****
517
518***** DUMPING mysql_users *****
519+----------+-------------------------------------------+--------+---------+-------------------+----------------+---------------+------------------------+--------------+---------+----------+-----------------+---------+
520| username | password | active | use_ssl | default_hostgroup | default_schema | schema_locked | transaction_persistent | fast_forward | backend | frontend | max_connections | comment |
521+----------+-------------------------------------------+--------+---------+-------------------+----------------+---------------+------------------------+--------------+---------+----------+-----------------+---------+
522| root | *AF9E01EA8519CE58E3739F4034EFD3D6B4CA6324 | 1 | 0 | 10 | NULL | 0 | 1 | 0 | 1 | 1 | 10000 | |
523+----------+-------------------------------------------+--------+---------+-------------------+----------------+---------------+------------------------+--------------+---------+----------+-----------------+---------+
524***** END OF DUMPING mysql_users *****
525
526***** DUMPING proxysql_servers *****
527***** END OF DUMPING proxysql_servers *****
528
529***** DUMPING runtime_checksums_values *****
530+-------------------+---------+------------+--------------------+
531| name | version | epoch | checksum |
532+-------------------+---------+------------+--------------------+
533| admin_variables | 0 | 0 | |
534| mysql_query_rules | 1 | 1555540748 | 0x96A5A5183E1B9E6A |
535| mysql_servers | 1 | 1555540748 | 0x4DC01171DBFD81E9 |
536| mysql_users | 1 | 1555540748 | 0x1F79A3CE59298EBD |
537| mysql_variables | 0 | 0 | |
538| proxysql_servers | 1 | 1555540748 | 0x0000000000000000 |
539+-------------------+---------+------------+--------------------+
540***** END OF DUMPING runtime_checksums_values *****
541
542***** DUMPING runtime_global_variables *****
543+-----------------------------------------------------+--------------------+
544| variable_name | variable_value |
545+-----------------------------------------------------+--------------------+
546| admin-admin_credentials | admin:admin |
547| admin-stats_credentials | stats:stats |
548| admin-stats_mysql_connections | 60 |
549| admin-stats_mysql_connection_pool | 60 |
550| admin-stats_mysql_query_cache | 60 |
551| admin-stats_system_cpu | 60 |
552| admin-stats_system_memory | 60 |
553| admin-mysql_ifaces | 0.0.0.0:6032 |
554| admin-telnet_admin_ifaces | (null) |
555| admin-telnet_stats_ifaces | (null) |
556| admin-refresh_interval | 2000 |
557| admin-read_only | false |
558| admin-hash_passwords | true |
559| admin-vacuum_stats | true |
560| admin-version | 2.0.3-29-g00f26d5 |
561| admin-cluster_username | |
562| admin-cluster_password | |
563| admin-cluster_check_interval_ms | 1000 |
564| admin-cluster_check_status_frequency | 10 |
565| admin-cluster_mysql_query_rules_diffs_before_sync | 3 |
566| admin-cluster_mysql_servers_diffs_before_sync | 3 |
567| admin-cluster_mysql_users_diffs_before_sync | 3 |
568| admin-cluster_proxysql_servers_diffs_before_sync | 3 |
569| admin-cluster_mysql_query_rules_save_to_disk | true |
570| admin-cluster_mysql_servers_save_to_disk | true |
571| admin-cluster_mysql_users_save_to_disk | true |
572| admin-cluster_proxysql_servers_save_to_disk | true |
573| admin-checksum_mysql_query_rules | true |
574| admin-checksum_mysql_servers | true |
575| admin-checksum_mysql_users | true |
576| admin-web_enabled | false |
577| admin-web_port | 6080 |
578| mysql-shun_on_failures | 5 |
579| mysql-shun_recovery_time_sec | 10 |
580| mysql-query_retries_on_failure | 1 |
581| mysql-client_multi_statements | true |
582| mysql-connect_retries_on_failure | 10 |
583| mysql-connect_retries_delay | 1 |
584| mysql-connection_delay_multiplex_ms | 0 |
585| mysql-connection_max_age_ms | 0 |
586| mysql-connect_timeout_server | 3000 |
587| mysql-connect_timeout_server_max | 10000 |
588| mysql-eventslog_filename | |
589| mysql-eventslog_filesize | 104857600 |
590| mysql-default_charset | utf8 |
591| mysql-free_connections_pct | 10 |
592| mysql-session_idle_ms | 1000 |
593| mysql-have_ssl | false |
594| mysql-have_compress | true |
595| mysql-client_found_rows | true |
596| mysql-interfaces | 0.0.0.0:6033 |
597| mysql-monitor_enabled | true |
598| mysql-monitor_history | 600000 |
599| mysql-monitor_connect_interval | 60000 |
600| mysql-monitor_connect_timeout | 600 |
601| mysql-monitor_ping_interval | 10000 |
602| mysql-monitor_ping_max_failures | 3 |
603| mysql-monitor_ping_timeout | 1000 |
604| mysql-monitor_read_only_interval | 1500 |
605| mysql-monitor_read_only_timeout | 500 |
606| mysql-monitor_read_only_max_timeout_count | 3 |
607| mysql-monitor_replication_lag_interval | 10000 |
608| mysql-monitor_replication_lag_timeout | 1000 |
609| mysql-monitor_groupreplication_healthcheck_interval | 5000 |
610| mysql-monitor_groupreplication_healthcheck_timeout | 800 |
611| mysql-monitor_galera_healthcheck_interval | 5000 |
612| mysql-monitor_galera_healthcheck_timeout | 800 |
613| mysql-monitor_username | monitor |
614| mysql-monitor_password | monitor |
615| mysql-monitor_replication_lag_use_percona_heartbeat | |
616| mysql-monitor_query_interval | 60000 |
617| mysql-monitor_query_timeout | 100 |
618| mysql-monitor_slave_lag_when_null | 60 |
619| mysql-monitor_threads_min | 8 |
620| mysql-monitor_threads_max | 128 |
621| mysql-monitor_threads_queue_maxsize | 128 |
622| mysql-monitor_wait_timeout | true |
623| mysql-monitor_writer_is_also_reader | true |
624| mysql-max_allowed_packet | 4194304 |
625| mysql-throttle_connections_per_sec_to_hostgroup | 1000000 |
626| mysql-max_transaction_time | 14400000 |
627| mysql-multiplexing | true |
628| mysql-forward_autocommit | false |
629| mysql-enforce_autocommit_on_reads | false |
630| mysql-autocommit_false_not_reusable | false |
631| mysql-autocommit_false_is_transaction | false |
632| mysql-verbose_query_error | false |
633| mysql-hostgroup_manager_verbose | 1 |
634| mysql-binlog_reader_connect_retry_msec | 3000 |
635| mysql-threshold_query_length | 524288 |
636| mysql-threshold_resultset_size | 4194304 |
637| mysql-query_digests_max_digest_length | 2048 |
638| mysql-query_digests_max_query_length | 65000 |
639| mysql-wait_timeout | 28800000 |
640| mysql-throttle_max_bytes_per_second_to_client | 0 |
641| mysql-throttle_ratio_server_to_client | 0 |
642| mysql-max_connections | 2048 |
643| mysql-max_stmts_per_connection | 20 |
644| mysql-max_stmts_cache | 10000 |
645| mysql-mirror_max_concurrency | 16 |
646| mysql-mirror_max_queue_length | 32000 |
647| mysql-default_max_latency_ms | 1000 |
648| mysql-default_query_delay | 0 |
649| mysql-default_query_timeout | 36000000 |
650| mysql-query_processor_iterations | 0 |
651| mysql-query_processor_regex | 1 |
652| mysql-reset_connection_algorithm | 2 |
653| mysql-auto_increment_delay_multiplex | 5 |
654| mysql-long_query_time | 1000 |
655| mysql-query_cache_size_MB | 256 |
656| mysql-ping_interval_server_msec | 120000 |
657| mysql-ping_timeout_server | 500 |
658| mysql-default_schema | information_schema |
659| mysql-poll_timeout | 2000 |
660| mysql-poll_timeout_on_failure | 100 |
661| mysql-server_capabilities | 569899 |
662| mysql-server_version | 5.5.30 |
663| mysql-kill_backend_connection_when_disconnect | true |
664| mysql-sessions_sort | true |
665| mysql-session_idle_show_processlist | true |
666| mysql-commands_stats | true |
667| mysql-query_digests | true |
668| mysql-query_digests_lowercase | false |
669| mysql-query_digests_normalize_digest_text | false |
670| mysql-query_digests_track_hostname | false |
671| mysql-servers_stats | true |
672| mysql-default_reconnect | true |
673| mysql-ssl_p2s_ca | |
674| mysql-ssl_p2s_cert | |
675| mysql-ssl_p2s_key | |
676| mysql-ssl_p2s_cipher | |
677| mysql-stacksize | 1048576 |
678| mysql-threads | 4 |
679| mysql-init_connect | |
680| mysql-ldap_user_variable | |
681| mysql-add_ldap_user_comment | |
682| mysql-default_sql_mode | |
683| mysql-default_time_zone | SYSTEM |
684| mysql-connpoll_reset_queue_length | 50 |
685| mysql-stats_time_backend_query | false |
686| mysql-stats_time_query_processor | false |
687| mysql-query_cache_stores_empty_result | true |
688+-----------------------------------------------------+--------------------+
689***** END OF DUMPING runtime_global_variables *****
690
691***** DUMPING runtime_mysql_galera_hostgroups *****
692***** END OF DUMPING runtime_mysql_galera_hostgroups *****
693
694***** DUMPING runtime_mysql_group_replication_hostgroups *****
695***** END OF DUMPING runtime_mysql_group_replication_hostgroups *****
696
697***** DUMPING runtime_mysql_query_rules *****
698+---------+--------+----------+------------+--------+-------------+------------+------------+--------+---------------------+---------------+----------------------+--------------+---------+-----------------+-----------------------+-----------+--------------------+---------------+-----------+---------+---------+-------+-------------------+----------------+------------------+-----------+--------+-------------+-----------+---------------------+-----+-------+---------+
699| rule_id | active | username | schemaname | flagIN | client_addr | proxy_addr | proxy_port | digest | match_digest | match_pattern | negate_match_pattern | re_modifiers | flagOUT | replace_pattern | destination_hostgroup | cache_ttl | cache_empty_result | cache_timeout | reconnect | timeout | retries | delay | next_query_flagIN | mirror_flagOUT | mirror_hostgroup | error_msg | OK_msg | sticky_conn | multiplex | gtid_from_hostgroup | log | apply | comment |
700+---------+--------+----------+------------+--------+-------------+------------+------------+--------+---------------------+---------------+----------------------+--------------+---------+-----------------+-----------------------+-----------+--------------------+---------------+-----------+---------+---------+-------+-------------------+----------------+------------------+-----------+--------+-------------+-----------+---------------------+-----+-------+---------+
701| 200 | 1 | root | NULL | 0 | NULL | NULL | NULL | NULL | ^SELECT.*FOR UPDATE | NULL | 0 | CASELESS | NULL | NULL | 10 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 1 | NULL |
702| 201 | 1 | root | NULL | 0 | NULL | NULL | NULL | NULL | ^SELECT | NULL | 0 | CASELESS | NULL | NULL | 11 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 10 | NULL | 1 | NULL |
703+---------+--------+----------+------------+--------+-------------+------------+------------+--------+---------------------+---------------+----------------------+--------------+---------+-----------------+-----------------------+-----------+--------------------+---------------+-----------+---------+---------+-------+-------------------+----------------+------------------+-----------+--------+-------------+-----------+---------------------+-----+-------+---------+
704***** END OF DUMPING runtime_mysql_query_rules *****
705
706***** DUMPING runtime_mysql_query_rules_fast_routing *****
707***** END OF DUMPING runtime_mysql_query_rules_fast_routing *****
708
709***** DUMPING runtime_mysql_replication_hostgroups *****
710+------------------+------------------+------------+---------+
711| writer_hostgroup | reader_hostgroup | check_type | comment |
712+------------------+------------------+------------+---------+
713| 10 | 11 | read_only | |
714+------------------+------------------+------------+---------+
715***** END OF DUMPING runtime_mysql_replication_hostgroups *****
716
717***** DUMPING runtime_mysql_servers *****
718+--------------+-------------+------+-----------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------+
719| hostgroup_id | hostname | port | gtid_port | status | weight | compression | max_connections | max_replication_lag | use_ssl | max_latency_ms | comment |
720+--------------+-------------+------+-----------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------+
721| 11 | 172.16.0.66 | 3306 | 3307 | ONLINE | 1 | 0 | 1000 | 0 | 0 | 0 | |
722| 10 | 172.16.2.95 | 3306 | 3307 | ONLINE | 1 | 0 | 1000 | 0 | 0 | 0 | |
723+--------------+-------------+------+-----------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------+
724***** END OF DUMPING runtime_mysql_servers *****
725
726***** DUMPING runtime_mysql_users *****
727+----------+-------------------------------------------+--------+---------+-------------------+----------------+---------------+------------------------+--------------+---------+----------+-----------------+---------+
728| username | password | active | use_ssl | default_hostgroup | default_schema | schema_locked | transaction_persistent | fast_forward | backend | frontend | max_connections | comment |
729+----------+-------------------------------------------+--------+---------+-------------------+----------------+---------------+------------------------+--------------+---------+----------+-----------------+---------+
730| root | *AF9E01EA8519CE58E3739F4034EFD3D6B4CA6324 | 1 | 0 | 10 | | 0 | 1 | 0 | 0 | 1 | 10000 | |
731| root | *AF9E01EA8519CE58E3739F4034EFD3D6B4CA6324 | 1 | 0 | 10 | | 0 | 1 | 0 | 1 | 0 | 10000 | |
732+----------+-------------------------------------------+--------+---------+-------------------+----------------+---------------+------------------------+--------------+---------+----------+-----------------+---------+
733***** END OF DUMPING runtime_mysql_users *****
734
735***** DUMPING runtime_proxysql_servers *****
736***** END OF DUMPING runtime_proxysql_servers *****
737
738***** DUMPING runtime_scheduler *****
739***** END OF DUMPING runtime_scheduler *****
740
741***** DUMPING scheduler *****
742***** END OF DUMPING scheduler *****
743
744............ END OF DUMPING MAIN DATABASE ............
745
746............ DUMPING STATS DATABASE ............
747***** DUMPING stats.global_variables *****
748+-----------------------------------------------------+--------------------+
749| variable_name | variable_value |
750+-----------------------------------------------------+--------------------+
751| mysql-shun_on_failures | 5 |
752| mysql-shun_recovery_time_sec | 10 |
753| mysql-query_retries_on_failure | 1 |
754| mysql-client_multi_statements | true |
755| mysql-connect_retries_delay | 1 |
756| mysql-connection_delay_multiplex_ms | 0 |
757| mysql-connection_max_age_ms | 0 |
758| mysql-connect_timeout_server_max | 10000 |
759| mysql-eventslog_filename | |
760| mysql-eventslog_filesize | 104857600 |
761| mysql-default_charset | utf8 |
762| mysql-free_connections_pct | 10 |
763| mysql-session_idle_ms | 1000 |
764| mysql-have_ssl | false |
765| mysql-client_found_rows | true |
766| mysql-monitor_enabled | true |
767| mysql-monitor_connect_timeout | 600 |
768| mysql-monitor_ping_max_failures | 3 |
769| mysql-monitor_ping_timeout | 1000 |
770| mysql-monitor_read_only_max_timeout_count | 3 |
771| mysql-monitor_replication_lag_interval | 10000 |
772| mysql-monitor_replication_lag_timeout | 1000 |
773| mysql-monitor_groupreplication_healthcheck_interval | 5000 |
774| mysql-monitor_groupreplication_healthcheck_timeout | 800 |
775| mysql-monitor_galera_healthcheck_interval | 5000 |
776| mysql-monitor_galera_healthcheck_timeout | 800 |
777| mysql-monitor_replication_lag_use_percona_heartbeat | |
778| mysql-monitor_query_interval | 60000 |
779| mysql-monitor_query_timeout | 100 |
780| mysql-monitor_slave_lag_when_null | 60 |
781| mysql-monitor_threads_min | 8 |
782| mysql-monitor_threads_max | 128 |
783| mysql-monitor_threads_queue_maxsize | 128 |
784| mysql-monitor_wait_timeout | true |
785| mysql-monitor_writer_is_also_reader | true |
786| mysql-max_allowed_packet | 4194304 |
787| mysql-throttle_connections_per_sec_to_hostgroup | 1000000 |
788| mysql-max_transaction_time | 14400000 |
789| mysql-multiplexing | true |
790| mysql-forward_autocommit | false |
791| mysql-enforce_autocommit_on_reads | false |
792| mysql-autocommit_false_not_reusable | false |
793| mysql-autocommit_false_is_transaction | false |
794| mysql-verbose_query_error | false |
795| mysql-hostgroup_manager_verbose | 1 |
796| mysql-binlog_reader_connect_retry_msec | 3000 |
797| mysql-threshold_query_length | 524288 |
798| mysql-threshold_resultset_size | 4194304 |
799| mysql-query_digests_max_digest_length | 2048 |
800| mysql-query_digests_max_query_length | 65000 |
801| mysql-wait_timeout | 28800000 |
802| mysql-throttle_max_bytes_per_second_to_client | 0 |
803| mysql-throttle_ratio_server_to_client | 0 |
804| mysql-max_stmts_per_connection | 20 |
805| mysql-max_stmts_cache | 10000 |
806| mysql-mirror_max_concurrency | 16 |
807| mysql-mirror_max_queue_length | 32000 |
808| mysql-default_max_latency_ms | 1000 |
809| mysql-query_processor_iterations | 0 |
810| mysql-query_processor_regex | 1 |
811| mysql-reset_connection_algorithm | 2 |
812| mysql-auto_increment_delay_multiplex | 5 |
813| mysql-long_query_time | 1000 |
814| mysql-query_cache_size_MB | 256 |
815| mysql-poll_timeout_on_failure | 100 |
816| mysql-server_capabilities | 569867 |
817| mysql-kill_backend_connection_when_disconnect | true |
818| mysql-session_idle_show_processlist | true |
819| mysql-query_digests | true |
820| mysql-query_digests_lowercase | false |
821| mysql-query_digests_normalize_digest_text | false |
822| mysql-query_digests_track_hostname | false |
823| mysql-servers_stats | true |
824| mysql-default_reconnect | true |
825| mysql-ssl_p2s_ca | |
826| mysql-ssl_p2s_cert | |
827| mysql-ssl_p2s_key | |
828| mysql-ssl_p2s_cipher | |
829| mysql-init_connect | |
830| mysql-ldap_user_variable | |
831| mysql-add_ldap_user_comment | |
832| mysql-default_sql_mode | |
833| mysql-default_time_zone | SYSTEM |
834| mysql-connpoll_reset_queue_length | 50 |
835| mysql-stats_time_backend_query | false |
836| mysql-stats_time_query_processor | false |
837| mysql-query_cache_stores_empty_result | true |
838| admin-stats_credentials | stats:stats |
839| admin-stats_mysql_connections | 60 |
840| admin-stats_mysql_connection_pool | 60 |
841| admin-stats_mysql_query_cache | 60 |
842| admin-stats_system_cpu | 60 |
843| admin-stats_system_memory | 60 |
844| admin-telnet_admin_ifaces | (null) |
845| admin-telnet_stats_ifaces | (null) |
846| admin-refresh_interval | 2000 |
847| admin-read_only | false |
848| admin-hash_passwords | true |
849| admin-vacuum_stats | true |
850| admin-version | 2.0.3-29-g00f26d5 |
851| admin-cluster_username | |
852| admin-cluster_password | |
853| admin-cluster_check_interval_ms | 1000 |
854| admin-cluster_check_status_frequency | 10 |
855| admin-cluster_mysql_query_rules_diffs_before_sync | 3 |
856| admin-cluster_mysql_servers_diffs_before_sync | 3 |
857| admin-cluster_mysql_users_diffs_before_sync | 3 |
858| admin-cluster_proxysql_servers_diffs_before_sync | 3 |
859| admin-cluster_mysql_query_rules_save_to_disk | true |
860| admin-cluster_mysql_servers_save_to_disk | true |
861| admin-cluster_mysql_users_save_to_disk | true |
862| admin-cluster_proxysql_servers_save_to_disk | true |
863| admin-checksum_mysql_query_rules | true |
864| admin-checksum_mysql_servers | true |
865| admin-checksum_mysql_users | true |
866| admin-web_enabled | false |
867| admin-web_port | 6080 |
868| admin-admin_credentials | admin:admin |
869| admin-mysql_ifaces | 0.0.0.0:6032 |
870| mysql-threads | 4 |
871| mysql-max_connections | 2048 |
872| mysql-default_query_delay | 0 |
873| mysql-default_query_timeout | 36000000 |
874| mysql-have_compress | true |
875| mysql-poll_timeout | 2000 |
876| mysql-interfaces | 0.0.0.0:6033 |
877| mysql-default_schema | information_schema |
878| mysql-stacksize | 1048576 |
879| mysql-server_version | 5.5.30 |
880| mysql-connect_timeout_server | 3000 |
881| mysql-monitor_username | monitor |
882| mysql-monitor_password | monitor |
883| mysql-monitor_history | 600000 |
884| mysql-monitor_connect_interval | 60000 |
885| mysql-monitor_ping_interval | 10000 |
886| mysql-monitor_read_only_interval | 1500 |
887| mysql-monitor_read_only_timeout | 500 |
888| mysql-ping_interval_server_msec | 120000 |
889| mysql-ping_timeout_server | 500 |
890| mysql-commands_stats | true |
891| mysql-sessions_sort | true |
892| mysql-connect_retries_on_failure | 10 |
893+-----------------------------------------------------+--------------------+
894***** END OF DUMPING stats.global_variables *****
895
896***** DUMPING stats.stats_memory_metrics *****
897+------------------------------+----------------+
898| Variable_Name | Variable_Value |
899+------------------------------+----------------+
900| SQLite3_memory_bytes | 2875016 |
901| jemalloc_resident | 16048128 |
902| jemalloc_active | 12521472 |
903| jemalloc_allocated | 10230272 |
904| jemalloc_mapped | 52428800 |
905| jemalloc_metadata | 4233984 |
906| jemalloc_retained | 0 |
907| Auth_memory | 706 |
908| query_digest_memory | 1814 |
909| mysql_query_rules_memory | 8065 |
910| stack_memory_mysql_threads | 33554432 |
911| stack_memory_admin_threads | 8388608 |
912| stack_memory_cluster_threads | 0 |
913+------------------------------+----------------+
914***** END OF DUMPING stats.stats_memory_metrics *****
915
916***** DUMPING stats.stats_mysql_commands_counters *****
917+-------------------+---------------+-----------+-----------+-----------+---------+---------+----------+----------+-----------+-----------+--------+--------+---------+----------+
918| Command | Total_Time_us | Total_cnt | cnt_100us | cnt_500us | cnt_1ms | cnt_5ms | cnt_10ms | cnt_50ms | cnt_100ms | cnt_500ms | cnt_1s | cnt_5s | cnt_10s | cnt_INFs |
919+-------------------+---------------+-----------+-----------+-----------+---------+---------+----------+----------+-----------+-----------+--------+--------+---------+----------+
920| ALTER_TABLE | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
921| ALTER_VIEW | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
922| ANALYZE_TABLE | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
923| BEGIN | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
924| CALL | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
925| CHANGE_MASTER | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
926| COMMIT | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
927| CREATE_DATABASE | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
928| CREATE_INDEX | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
929| CREATE_TABLE | 242026 | 3 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 1 | 0 | 0 | 0 | 0 |
930| CREATE_TEMPORARY | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
931| CREATE_TRIGGER | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
932| CREATE_USER | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
933| CREATE_VIEW | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
934| DEALLOCATE | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
935| DELETE | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
936| DESCRIBE | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
937| DROP_DATABASE | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
938| DROP_INDEX | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
939| DROP_TABLE | 79473 | 3 | 0 | 0 | 0 | 0 | 0 | 3 | 0 | 0 | 0 | 0 | 0 | 0 |
940| DROP_TRIGGER | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
941| DROP_USER | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
942| DROP_VIEW | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
943| GRANT | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
944| EXECUTE | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
945| EXPLAIN | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
946| FLUSH | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
947| INSERT | 3200233 | 45 | 0 | 0 | 0 | 2 | 13 | 10 | 7 | 13 | 0 | 0 | 0 | 0 |
948| KILL | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
949| LOAD | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
950| LOCK_TABLE | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
951| OPTIMIZE | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
952| PREPARE | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
953| PURGE | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
954| RENAME_TABLE | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
955| RESET_MASTER | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
956| RESET_SLAVE | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
957| REPLACE | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
958| REVOKE | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
959| ROLLBACK | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
960| SAVEPOINT | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
961| SELECT | 182068 | 532 | 0 | 481 | 49 | 0 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
962| SELECT_FOR_UPDATE | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
963| SET | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
964| SHOW_TABLE_STATUS | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
965| START_TRANSACTION | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
966| TRUNCATE_TABLE | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
967| UNLOCK_TABLES | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
968| UPDATE | 1962837 | 146 | 0 | 0 | 0 | 59 | 30 | 55 | 2 | 0 | 0 | 0 | 0 | 0 |
969| USE | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
970| SHOW | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
971| UNKNOWN | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
972+-------------------+---------------+-----------+-----------+-----------+---------+---------+----------+----------+-----------+-----------+--------+--------+---------+----------+
973***** END OF DUMPING stats.stats_mysql_commands_counters *****
974
975***** DUMPING stats.stats_mysql_connection_pool *****
976+-----------+-------------+----------+--------+----------+----------+--------+---------+-------------+---------+-------------------+-----------------+-----------------+------------+
977| hostgroup | srv_host | srv_port | status | ConnUsed | ConnFree | ConnOK | ConnERR | MaxConnUsed | Queries | Queries_GTID_sync | Bytes_data_sent | Bytes_data_recv | Latency_us |
978+-----------+-------------+----------+--------+----------+----------+--------+---------+-------------+---------+-------------------+-----------------+-----------------+------------+
979| 11 | 172.16.0.66 | 3306 | ONLINE | 0 | 1 | 0 | 0 | 1 | 170 | 170 | 8427 | 658 | 284 |
980| 10 | 172.16.2.95 | 3306 | ONLINE | 0 | 1 | 0 | 0 | 1 | 65 | 5 | 4720 | 0 | 215 |
981+-----------+-------------+----------+--------+----------+----------+--------+---------+-------------+---------+-------------------+-----------------+-----------------+------------+
982***** END OF DUMPING stats.stats_mysql_connection_pool *****
983
984***** DUMPING stats.stats_mysql_connection_pool_reset *****
985+-----------+-------------+----------+--------+----------+----------+--------+---------+-------------+---------+-------------------+-----------------+-----------------+------------+
986| hostgroup | srv_host | srv_port | status | ConnUsed | ConnFree | ConnOK | ConnERR | MaxConnUsed | Queries | Queries_GTID_sync | Bytes_data_sent | Bytes_data_recv | Latency_us |
987+-----------+-------------+----------+--------+----------+----------+--------+---------+-------------+---------+-------------------+-----------------+-----------------+------------+
988| 11 | 172.16.0.66 | 3306 | ONLINE | 0 | 1 | 0 | 0 | 1 | 170 | 170 | 8427 | 658 | 284 |
989| 10 | 172.16.2.95 | 3306 | ONLINE | 0 | 1 | 0 | 0 | 1 | 65 | 5 | 4720 | 0 | 215 |
990+-----------+-------------+----------+--------+----------+----------+--------+---------+-------------+---------+-------------------+-----------------+-----------------+------------+
991***** END OF DUMPING stats.stats_mysql_connection_pool_reset *****
992
993***** DUMPING stats.stats_mysql_errors *****
994***** END OF DUMPING stats.stats_mysql_errors *****
995
996***** DUMPING stats.stats_mysql_errors_reset *****
997***** END OF DUMPING stats.stats_mysql_errors_reset *****
998
999***** DUMPING stats.stats_mysql_global *****
1000+-----------------------------------------+----------------+
1001| Variable_Name | Variable_Value |
1002+-----------------------------------------+----------------+
1003| ProxySQL_Uptime | 463 |
1004| Active_Transactions | 0 |
1005| Client_Connections_aborted | 0 |
1006| Client_Connections_connected | 1 |
1007| Client_Connections_created | 3 |
1008| Server_Connections_aborted | 0 |
1009| Server_Connections_connected | 2 |
1010| Server_Connections_created | 2 |
1011| Server_Connections_delayed | 0 |
1012| Client_Connections_non_idle | 1 |
1013| Queries_backends_bytes_recv | 2043 |
1014| Queries_backends_bytes_sent | 40878 |
1015| Queries_frontends_bytes_recv | 44830 |
1016| Queries_frontends_bytes_sent | 48350 |
1017| Query_Processor_time_nsec | 0 |
1018| Backend_query_time_nsec | 0 |
1019| mysql_backend_buffers_bytes | 0 |
1020| mysql_frontend_buffers_bytes | 65536 |
1021| mysql_session_internal_bytes | 14024 |
1022| Com_autocommit | 0 |
1023| Com_autocommit_filtered | 0 |
1024| Com_commit | 0 |
1025| Com_commit_filtered | 0 |
1026| Com_rollback | 0 |
1027| Com_rollback_filtered | 0 |
1028| Com_backend_change_user | 0 |
1029| Com_backend_init_db | 0 |
1030| Com_backend_set_names | 2 |
1031| Com_frontend_init_db | 0 |
1032| Com_frontend_set_names | 0 |
1033| Com_frontend_use_db | 0 |
1034| Com_backend_stmt_prepare | 0 |
1035| Com_backend_stmt_execute | 0 |
1036| Com_backend_stmt_close | 0 |
1037| Com_frontend_stmt_prepare | 0 |
1038| Com_frontend_stmt_execute | 0 |
1039| Com_frontend_stmt_close | 0 |
1040| Mirror_concurrency | 0 |
1041| Mirror_queue_length | 0 |
1042| Questions | 737 |
1043| Slow_queries | 0 |
1044| GTID_consistent_queries | 553 |
1045| GTID_session_collected | 737 |
1046| Servers_table_version | 1 |
1047| MySQL_Thread_Workers | 4 |
1048| Access_Denied_Wrong_Password | 0 |
1049| Access_Denied_Max_Connections | 0 |
1050| Access_Denied_Max_User_Connections | 0 |
1051| MySQL_Monitor_Workers | 2 |
1052| MySQL_Monitor_Workers_Aux | 0 |
1053| MySQL_Monitor_Workers_Started | 2 |
1054| MySQL_Monitor_connect_check_OK | 16 |
1055| MySQL_Monitor_connect_check_ERR | 0 |
1056| MySQL_Monitor_ping_check_OK | 94 |
1057| MySQL_Monitor_ping_check_ERR | 0 |
1058| MySQL_Monitor_read_only_check_OK | 620 |
1059| MySQL_Monitor_read_only_check_ERR | 0 |
1060| MySQL_Monitor_replication_lag_check_OK | 0 |
1061| MySQL_Monitor_replication_lag_check_ERR | 0 |
1062| ConnPool_get_conn_immediate | 0 |
1063| ConnPool_get_conn_success | 680 |
1064| ConnPool_get_conn_failure | 0 |
1065| generated_error_packets | 0 |
1066| max_connect_timeouts | 0 |
1067| mysql_unexpected_frontend_com_quit | 0 |
1068| mysql_unexpected_frontend_packets | 0 |
1069| mysql_killed_backend_connections | 0 |
1070| mysql_killed_backend_queries | 0 |
1071| MyHGM_myconnpoll_get | 680 |
1072| MyHGM_myconnpoll_get_ok | 680 |
1073| MyHGM_myconnpoll_push | 684 |
1074| MyHGM_myconnpoll_destroy | 0 |
1075| MyHGM_myconnpoll_reset | 0 |
1076| SQLite3_memory_bytes | 2726608 |
1077| ConnPool_memory_bytes | 142832 |
1078| Stmt_Client_Active_Total | 0 |
1079| Stmt_Client_Active_Unique | 0 |
1080| Stmt_Server_Active_Total | 0 |
1081| Stmt_Server_Active_Unique | 0 |
1082| Stmt_Max_Stmt_id | 1 |
1083| Stmt_Cached | 0 |
1084| Query_Cache_Memory_bytes | 0 |
1085| Query_Cache_count_GET | 0 |
1086| Query_Cache_count_GET_OK | 0 |
1087| Query_Cache_count_SET | 0 |
1088| Query_Cache_bytes_IN | 0 |
1089| Query_Cache_bytes_OUT | 0 |
1090| Query_Cache_Purged | 0 |
1091| Query_Cache_Entries | 0 |
1092+-----------------------------------------+----------------+
1093***** END OF DUMPING stats.stats_mysql_global *****
1094
1095***** DUMPING stats.stats_mysql_gtid_executed *****
1096+-------------+------+----------------------------------------------+--------+
1097| hostname | port | gtid_executed | events |
1098+-------------+------+----------------------------------------------+--------+
1099| 172.16.2.95 | 3306 | da1bb000-5c9c-11e9-9ee7-00163efabac0:1-42980 | 199 |
1100| 172.16.0.66 | 3306 | da1bb000-5c9c-11e9-9ee7-00163efabac0:1-42980 | 199 |
1101+-------------+------+----------------------------------------------+--------+
1102***** END OF DUMPING stats.stats_mysql_gtid_executed *****
1103
1104***** DUMPING stats.stats_mysql_prepared_statements_info *****
1105***** END OF DUMPING stats.stats_mysql_prepared_statements_info *****
1106
1107***** DUMPING stats.stats_mysql_processlist *****
1108+----------+-----------+------+------+-----------+----------+-----------+------------+------------+----------+----------+---------+---------+------+--------------+
1109| ThreadID | SessionID | user | db | cli_host | cli_port | hostgroup | l_srv_host | l_srv_port | srv_host | srv_port | command | time_ms | info | status_flags |
1110+----------+-----------+------+------+-----------+----------+-----------+------------+------------+----------+----------+---------+---------+------+--------------+
1111| 0 | 102 | root | test | 127.0.0.1 | 49220 | 11 | | | | | Sleep | 0 | | |
1112+----------+-----------+------+------+-----------+----------+-----------+------------+------------+----------+----------+---------+---------+------+--------------+
1113***** END OF DUMPING stats.stats_mysql_processlist *****
1114
1115***** DUMPING stats.stats_mysql_query_digest *****
1116+-----------+------------+----------+----------------+--------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+------------+------------+------------+----------+----------+----------+
1117| hostgroup | schemaname | username | client_address | digest | digest_text | count_star | first_seen | last_seen | sum_time | min_time | max_time |
1118+-----------+------------+----------+----------------+--------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+------------+------------+------------+----------+----------+----------+
1119| 11 | test | root | | 0x869A81B2AE83431F | SELECT i FROM joinit WHERE t = ? AND i = ? | 95 | 1555541186 | 1555541211 | 42968 | 223 | 677 |
1120| 10 | test | root | | 0x92FC0B0F9F916A47 | UPDATE joinit SET t = ? WHERE i = ? | 48 | 1555541186 | 1555541211 | 701448 | 2732 | 54967 |
1121| 11 | test | root | | 0x9B65D8F9B12E2326 | SELECT i FROM joinit WHERE i = ? | 74 | 1555541186 | 1555541211 | 16506 | 141 | 431 |
1122| 11 | test | root | | 0x837785298A10154B | SELECT MAX(i) FROM joinit | 1 | 1555541184 | 1555541184 | 716 | 716 | 716 |
1123| 10 | test | root | | 0x73ECE4DA4FCFFEB4 | INSERT INTO test.joinit SELECT NULL, uuid(), time(?), (FLOOR( ? + RAND( ) *? )) FROM test.joinit; | 14 | 1555541183 | 1555541184 | 1217309 | 4878 | 346755 |
1124| 10 | test | root | | 0x4C3A40F1B0C4126A | INSERT INTO test.joinit VALUES (NULL, uuid(), time(?), (FLOOR( ? + RAND( ) *? ))); | 1 | 1555541183 | 1555541183 | 26979 | 26979 | 26979 |
1125| 10 | test | root | | 0x654FA45D6B2AA716 | CREATE TABLE IF NOT EXISTS `test`.`joinit` ( `i` bigint(?) NOT NULL AUTO_INCREMENT, `s` char(?) DEFAULT NULL, `t` datetime NOT NULL, `g` bigint(?) NOT NULL, KEY(`i`, `t`), PRIMARY KEY(`i`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; | 1 | 1555541183 | 1555541183 | 59607 | 59607 | 59607 |
1126| 10 | test | root | | 0x2C7732A79C6CB9E6 | DROP TABLE IF EXISTS joinit | 1 | 1555541183 | 1555541183 | 19909 | 19909 | 19909 |
1127+-----------+------------+----------+----------------+--------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+------------+------------+------------+----------+----------+----------+
1128***** END OF DUMPING stats.stats_mysql_query_digest *****
1129
1130***** DUMPING stats.stats_mysql_query_digest_reset *****
1131+-----------+------------+----------+----------------+--------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+------------+------------+------------+----------+----------+----------+
1132| hostgroup | schemaname | username | client_address | digest | digest_text | count_star | first_seen | last_seen | sum_time | min_time | max_time |
1133+-----------+------------+----------+----------------+--------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+------------+------------+------------+----------+----------+----------+
1134| 11 | test | root | | 0x869A81B2AE83431F | SELECT i FROM joinit WHERE t = ? AND i = ? | 95 | 1555541186 | 1555541211 | 42968 | 223 | 677 |
1135| 10 | test | root | | 0x92FC0B0F9F916A47 | UPDATE joinit SET t = ? WHERE i = ? | 48 | 1555541186 | 1555541211 | 701448 | 2732 | 54967 |
1136| 11 | test | root | | 0x9B65D8F9B12E2326 | SELECT i FROM joinit WHERE i = ? | 74 | 1555541186 | 1555541211 | 16506 | 141 | 431 |
1137| 11 | test | root | | 0x837785298A10154B | SELECT MAX(i) FROM joinit | 1 | 1555541184 | 1555541184 | 716 | 716 | 716 |
1138| 10 | test | root | | 0x73ECE4DA4FCFFEB4 | INSERT INTO test.joinit SELECT NULL, uuid(), time(?), (FLOOR( ? + RAND( ) *? )) FROM test.joinit; | 14 | 1555541183 | 1555541184 | 1217309 | 4878 | 346755 |
1139| 10 | test | root | | 0x4C3A40F1B0C4126A | INSERT INTO test.joinit VALUES (NULL, uuid(), time(?), (FLOOR( ? + RAND( ) *? ))); | 1 | 1555541183 | 1555541183 | 26979 | 26979 | 26979 |
1140| 10 | test | root | | 0x654FA45D6B2AA716 | CREATE TABLE IF NOT EXISTS `test`.`joinit` ( `i` bigint(?) NOT NULL AUTO_INCREMENT, `s` char(?) DEFAULT NULL, `t` datetime NOT NULL, `g` bigint(?) NOT NULL, KEY(`i`, `t`), PRIMARY KEY(`i`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; | 1 | 1555541183 | 1555541183 | 59607 | 59607 | 59607 |
1141| 10 | test | root | | 0x2C7732A79C6CB9E6 | DROP TABLE IF EXISTS joinit | 1 | 1555541183 | 1555541183 | 19909 | 19909 | 19909 |
1142+-----------+------------+----------+----------------+--------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+------------+------------+------------+----------+----------+----------+
1143***** END OF DUMPING stats.stats_mysql_query_digest_reset *****
1144
1145***** DUMPING stats.stats_mysql_query_rules *****
1146+---------+------+
1147| rule_id | hits |
1148+---------+------+
1149| 200 | 0 |
1150| 201 | 532 |
1151+---------+------+
1152***** END OF DUMPING stats.stats_mysql_query_rules *****
1153
1154***** DUMPING stats.stats_mysql_users *****
1155+----------+----------------------+--------------------------+
1156| username | frontend_connections | frontend_max_connections |
1157+----------+----------------------+--------------------------+
1158| root | 1 | 10000 |
1159+----------+----------------------+--------------------------+
1160***** END OF DUMPING stats.stats_mysql_users *****
1161
1162***** DUMPING stats.stats_proxysql_servers_checksums *****
1163***** END OF DUMPING stats.stats_proxysql_servers_checksums *****
1164
1165***** DUMPING stats.stats_proxysql_servers_metrics *****
1166***** END OF DUMPING stats.stats_proxysql_servers_metrics *****
1167
1168***** DUMPING stats.stats_proxysql_servers_status *****
1169***** END OF DUMPING stats.stats_proxysql_servers_status *****
1170
1171............ END OF DUMPING STATS DATABASE ............
1172
1173............ DUMPING MONITOR DATABASE ............
1174***** DUMPING monitor.mysql_server_connect_log *****
1175+-------------+------+------------------+-------------------------+---------------+
1176| hostname | port | time_start_us | connect_success_time_us | connect_error |
1177+-------------+------+------------------+-------------------------+---------------+
1178| 172.16.2.95 | 3306 | 1555540748214267 | 3937 | NULL |
1179| 172.16.0.66 | 3306 | 1555540748910882 | 727 | NULL |
1180| 172.16.0.66 | 3306 | 1555540808212311 | 937 | NULL |
1181| 172.16.2.95 | 3306 | 1555540809311959 | 1231 | NULL |
1182| 172.16.2.95 | 3306 | 1555540868212359 | 1146 | NULL |
1183| 172.16.0.66 | 3306 | 1555540869313581 | 746 | NULL |
1184| 172.16.0.66 | 3306 | 1555540928212497 | 855 | NULL |
1185| 172.16.2.95 | 3306 | 1555540929286425 | 876 | NULL |
1186| 172.16.0.66 | 3306 | 1555540988212620 | 898 | NULL |
1187| 172.16.2.95 | 3306 | 1555540989148268 | 1065 | NULL |
1188| 172.16.2.95 | 3306 | 1555541048212749 | 1189 | NULL |
1189| 172.16.0.66 | 3306 | 1555541049241638 | 754 | NULL |
1190| 172.16.2.95 | 3306 | 1555541108212927 | 929 | NULL |
1191| 172.16.0.66 | 3306 | 1555541109123691 | 825 | NULL |
1192| 172.16.0.66 | 3306 | 1555541168213071 | 823 | NULL |
1193| 172.16.2.95 | 3306 | 1555541168948974 | 954 | NULL |
1194+-------------+------+------------------+-------------------------+---------------+
1195***** END OF DUMPING monitor.mysql_server_connect_log *****
1196
1197***** DUMPING monitor.mysql_server_galera_log *****
1198***** END OF DUMPING monitor.mysql_server_galera_log *****
1199
1200***** DUMPING monitor.mysql_server_group_replication_log *****
1201***** END OF DUMPING monitor.mysql_server_group_replication_log *****
1202
1203***** DUMPING monitor.mysql_server_ping_log *****
1204+-------------+------+------------------+----------------------+------------+
1205| hostname | port | time_start_us | ping_success_time_us | ping_error |
1206+-------------+------+------------------+----------------------+------------+
1207| 172.16.0.66 | 3306 | 1555540748215933 | 106 | NULL |
1208| 172.16.2.95 | 3306 | 1555540748327713 | 221 | NULL |
1209| 172.16.0.66 | 3306 | 1555540758214606 | 263 | NULL |
1210| 172.16.2.95 | 3306 | 1555540758348072 | 221 | NULL |
1211| 172.16.0.66 | 3306 | 1555540768213183 | 406 | NULL |
1212| 172.16.2.95 | 3306 | 1555540768390286 | 244 | NULL |
1213| 172.16.0.66 | 3306 | 1555540778214987 | 245 | NULL |
1214| 172.16.2.95 | 3306 | 1555540778323316 | 199 | NULL |
1215| 172.16.2.95 | 3306 | 1555540788213404 | 208 | NULL |
1216| 172.16.0.66 | 3306 | 1555540788381138 | 189 | NULL |
1217| 172.16.0.66 | 3306 | 1555540798213574 | 230 | NULL |
1218| 172.16.2.95 | 3306 | 1555540798320673 | 270 | NULL |
1219| 172.16.2.95 | 3306 | 1555540808213646 | 188 | NULL |
1220| 172.16.0.66 | 3306 | 1555540808351595 | 205 | NULL |
1221| 172.16.2.95 | 3306 | 1555540818215569 | 199 | NULL |
1222| 172.16.0.66 | 3306 | 1555540818389038 | 253 | NULL |
1223| 172.16.2.95 | 3306 | 1555540828215677 | 211 | NULL |
1224| 172.16.0.66 | 3306 | 1555540828332793 | 285 | NULL |
1225| 172.16.2.95 | 3306 | 1555540838214141 | 251 | NULL |
1226| 172.16.0.66 | 3306 | 1555540838332902 | 196 | NULL |
1227| 172.16.2.95 | 3306 | 1555540848214166 | 136 | NULL |
1228| 172.16.0.66 | 3306 | 1555540848374686 | 225 | NULL |
1229| 172.16.2.95 | 3306 | 1555540858214338 | 197 | NULL |
1230| 172.16.0.66 | 3306 | 1555540858404215 | 194 | NULL |
1231| 172.16.0.66 | 3306 | 1555540868214453 | 196 | NULL |
1232| 172.16.2.95 | 3306 | 1555540868363879 | 196 | NULL |
1233| 172.16.2.95 | 3306 | 1555540878214601 | 193 | NULL |
1234| 172.16.0.66 | 3306 | 1555540878385073 | 195 | NULL |
1235| 172.16.0.66 | 3306 | 1555540888214712 | 198 | NULL |
1236| 172.16.2.95 | 3306 | 1555540888340042 | 198 | NULL |
1237| 172.16.2.95 | 3306 | 1555540898214842 | 212 | NULL |
1238| 172.16.0.66 | 3306 | 1555540898382033 | 190 | NULL |
1239| 172.16.0.66 | 3306 | 1555540908214962 | 193 | NULL |
1240| 172.16.2.95 | 3306 | 1555540908378938 | 195 | NULL |
1241| 172.16.0.66 | 3306 | 1555540918215099 | 195 | NULL |
1242| 172.16.2.95 | 3306 | 1555540918402587 | 204 | NULL |
1243| 172.16.0.66 | 3306 | 1555540928215184 | 197 | NULL |
1244| 172.16.2.95 | 3306 | 1555540928321463 | 190 | NULL |
1245| 172.16.2.95 | 3306 | 1555540938215311 | 197 | NULL |
1246| 172.16.0.66 | 3306 | 1555540938383826 | 262 | NULL |
1247| 172.16.0.66 | 3306 | 1555540948215443 | 197 | NULL |
1248| 172.16.2.95 | 3306 | 1555540948367733 | 198 | NULL |
1249| 172.16.0.66 | 3306 | 1555540958215514 | 194 | NULL |
1250| 172.16.2.95 | 3306 | 1555540958327758 | 207 | NULL |
1251| 172.16.2.95 | 3306 | 1555540968215633 | 210 | NULL |
1252| 172.16.0.66 | 3306 | 1555540968341142 | 196 | NULL |
1253| 172.16.0.66 | 3306 | 1555540978215762 | 230 | NULL |
1254| 172.16.2.95 | 3306 | 1555540978322420 | 203 | NULL |
1255| 172.16.0.66 | 3306 | 1555540988215886 | 193 | NULL |
1256| 172.16.2.95 | 3306 | 1555540988376639 | 223 | NULL |
1257| 172.16.2.95 | 3306 | 1555540998216047 | 209 | NULL |
1258| 172.16.0.66 | 3306 | 1555540998338153 | 214 | NULL |
1259| 172.16.0.66 | 3306 | 1555541008216185 | 197 | NULL |
1260| 172.16.2.95 | 3306 | 1555541008408693 | 256 | NULL |
1261| 172.16.0.66 | 3306 | 1555541018216302 | 194 | NULL |
1262| 172.16.2.95 | 3306 | 1555541018369951 | 158 | NULL |
1263| 172.16.0.66 | 3306 | 1555541028216433 | 204 | NULL |
1264| 172.16.2.95 | 3306 | 1555541028399909 | 192 | NULL |
1265| 172.16.2.95 | 3306 | 1555541038216561 | 194 | NULL |
1266| 172.16.0.66 | 3306 | 1555541038317021 | 193 | NULL |
1267| 172.16.2.95 | 3306 | 1555541048216667 | 213 | NULL |
1268| 172.16.0.66 | 3306 | 1555541048338660 | 207 | NULL |
1269| 172.16.2.95 | 3306 | 1555541058216815 | 195 | NULL |
1270| 172.16.0.66 | 3306 | 1555541058399880 | 198 | NULL |
1271| 172.16.0.66 | 3306 | 1555541068216972 | 193 | NULL |
1272| 172.16.2.95 | 3306 | 1555541068332284 | 197 | NULL |
1273| 172.16.0.66 | 3306 | 1555541078217113 | 200 | NULL |
1274| 172.16.2.95 | 3306 | 1555541078368806 | 196 | NULL |
1275| 172.16.0.66 | 3306 | 1555541088217210 | 194 | NULL |
1276| 172.16.2.95 | 3306 | 1555541088375156 | 196 | NULL |
1277| 172.16.0.66 | 3306 | 1555541098217335 | 204 | NULL |
1278| 172.16.2.95 | 3306 | 1555541098402264 | 194 | NULL |
1279| 172.16.0.66 | 3306 | 1555541108217413 | 197 | NULL |
1280| 172.16.2.95 | 3306 | 1555541108347031 | 141 | NULL |
1281| 172.16.2.95 | 3306 | 1555541118217546 | 193 | NULL |
1282| 172.16.0.66 | 3306 | 1555541118377645 | 230 | NULL |
1283| 172.16.0.66 | 3306 | 1555541128217654 | 224 | NULL |
1284| 172.16.2.95 | 3306 | 1555541128368453 | 195 | NULL |
1285| 172.16.2.95 | 3306 | 1555541138217890 | 209 | NULL |
1286| 172.16.0.66 | 3306 | 1555541138345630 | 211 | NULL |
1287| 172.16.2.95 | 3306 | 1555541148217982 | 192 | NULL |
1288| 172.16.0.66 | 3306 | 1555541148372179 | 194 | NULL |
1289| 172.16.0.66 | 3306 | 1555541158218085 | 196 | NULL |
1290| 172.16.2.95 | 3306 | 1555541158410565 | 155 | NULL |
1291| 172.16.2.95 | 3306 | 1555541168218161 | 208 | NULL |
1292| 172.16.0.66 | 3306 | 1555541168409486 | 192 | NULL |
1293| 172.16.2.95 | 3306 | 1555541178218288 | 237 | NULL |
1294| 172.16.0.66 | 3306 | 1555541178323204 | 250 | NULL |
1295| 172.16.2.95 | 3306 | 1555541188218400 | 233 | NULL |
1296| 172.16.0.66 | 3306 | 1555541188416320 | 208 | NULL |
1297| 172.16.0.66 | 3306 | 1555541198218594 | 219 | NULL |
1298| 172.16.2.95 | 3306 | 1555541198397126 | 214 | NULL |
1299| 172.16.0.66 | 3306 | 1555541208218721 | 426 | NULL |
1300| 172.16.2.95 | 3306 | 1555541208352445 | 199 | NULL |
1301+-------------+------+------------------+----------------------+------------+
1302***** END OF DUMPING monitor.mysql_server_ping_log *****
1303
1304***** DUMPING monitor.mysql_server_read_only_log *****
1305+-------------+------+------------------+-----------------+-----------+-------+
1306| hostname | port | time_start_us | success_time_us | read_only | error |
1307+-------------+------+------------------+-----------------+-----------+-------+
1308| 172.16.0.66 | 3306 | 1555540748218366 | 286 | 1 | NULL |
1309| 172.16.2.95 | 3306 | 1555540748229716 | 226 | 0 | NULL |
1310| 172.16.2.95 | 3306 | 1555540749713986 | 321 | 0 | NULL |
1311| 172.16.0.66 | 3306 | 1555540749735792 | 391 | 1 | NULL |
1312| 172.16.0.66 | 3306 | 1555540751214185 | 377 | 1 | NULL |
1313| 172.16.2.95 | 3306 | 1555540751237474 | 324 | 0 | NULL |
1314| 172.16.2.95 | 3306 | 1555540752714312 | 364 | 0 | NULL |
1315| 172.16.0.66 | 3306 | 1555540752743356 | 296 | 1 | NULL |
1316| 172.16.2.95 | 3306 | 1555540754214825 | 326 | 0 | NULL |
1317| 172.16.0.66 | 3306 | 1555540754236515 | 322 | 1 | NULL |
1318| 172.16.2.95 | 3306 | 1555540755715018 | 366 | 0 | NULL |
1319| 172.16.0.66 | 3306 | 1555540755737555 | 282 | 1 | NULL |
1320| 172.16.2.95 | 3306 | 1555540757214685 | 372 | 0 | NULL |
1321| 172.16.0.66 | 3306 | 1555540757230786 | 281 | 1 | NULL |
1322| 172.16.0.66 | 3306 | 1555540758714810 | 367 | 1 | NULL |
1323| 172.16.2.95 | 3306 | 1555540758744081 | 330 | 0 | NULL |
1324| 172.16.0.66 | 3306 | 1555540760215047 | 295 | 1 | NULL |
1325| 172.16.2.95 | 3306 | 1555540760237683 | 462 | 0 | NULL |
1326| 172.16.0.66 | 3306 | 1555540761715141 | 364 | 1 | NULL |
1327| 172.16.2.95 | 3306 | 1555540761738976 | 217 | 0 | NULL |
1328| 172.16.2.95 | 3306 | 1555540763215264 | 356 | 0 | NULL |
1329| 172.16.0.66 | 3306 | 1555540763240627 | 357 | 1 | NULL |
1330| 172.16.2.95 | 3306 | 1555540764715371 | 349 | 0 | NULL |
1331| 172.16.0.66 | 3306 | 1555540764734911 | 286 | 1 | NULL |
1332| 172.16.0.66 | 3306 | 1555540766215441 | 280 | 1 | NULL |
1333| 172.16.2.95 | 3306 | 1555540766243868 | 409 | 0 | NULL |
1334| 172.16.2.95 | 3306 | 1555540767715540 | 308 | 0 | NULL |
1335| 172.16.0.66 | 3306 | 1555540767743706 | 513 | 1 | NULL |
1336| 172.16.0.66 | 3306 | 1555540769215710 | 329 | 1 | NULL |
1337| 172.16.2.95 | 3306 | 1555540769233835 | 328 | 0 | NULL |
1338| 172.16.0.66 | 3306 | 1555540770716299 | 347 | 1 | NULL |
1339| 172.16.2.95 | 3306 | 1555540770733264 | 339 | 0 | NULL |
1340| 172.16.2.95 | 3306 | 1555540772216405 | 315 | 0 | NULL |
1341| 172.16.0.66 | 3306 | 1555540772239559 | 310 | 1 | NULL |
1342| 172.16.0.66 | 3306 | 1555540773716523 | 392 | 1 | NULL |
1343| 172.16.2.95 | 3306 | 1555540773731989 | 234 | 0 | NULL |
1344| 172.16.0.66 | 3306 | 1555540775216211 | 347 | 1 | NULL |
1345| 172.16.2.95 | 3306 | 1555540775232931 | 285 | 0 | NULL |
1346| 172.16.2.95 | 3306 | 1555540776716342 | 357 | 0 | NULL |
1347| 172.16.0.66 | 3306 | 1555540776735821 | 278 | 1 | NULL |
1348| 172.16.2.95 | 3306 | 1555540778216349 | 251 | 0 | NULL |
1349| 172.16.0.66 | 3306 | 1555540778235505 | 345 | 1 | NULL |
1350| 172.16.0.66 | 3306 | 1555540779716609 | 473 | 1 | NULL |
1351| 172.16.2.95 | 3306 | 1555540779734272 | 361 | 0 | NULL |
1352| 172.16.2.95 | 3306 | 1555540781216692 | 268 | 0 | NULL |
1353| 172.16.0.66 | 3306 | 1555540781242100 | 327 | 1 | NULL |
1354| 172.16.2.95 | 3306 | 1555540782716793 | 282 | 0 | NULL |
1355| 172.16.0.66 | 3306 | 1555540782736586 | 397 | 1 | NULL |
1356| 172.16.2.95 | 3306 | 1555540784216929 | 317 | 0 | NULL |
1357| 172.16.0.66 | 3306 | 1555540784245363 | 352 | 1 | NULL |
1358| 172.16.2.95 | 3306 | 1555540785717065 | 269 | 0 | NULL |
1359| 172.16.0.66 | 3306 | 1555540785741848 | 353 | 1 | NULL |
1360| 172.16.0.66 | 3306 | 1555540787217167 | 295 | 1 | NULL |
1361| 172.16.2.95 | 3306 | 1555540787238206 | 303 | 0 | NULL |
1362| 172.16.2.95 | 3306 | 1555540788717275 | 275 | 0 | NULL |
1363| 172.16.0.66 | 3306 | 1555540788741345 | 347 | 1 | NULL |
1364| 172.16.0.66 | 3306 | 1555540790217340 | 196 | 1 | NULL |
1365| 172.16.2.95 | 3306 | 1555540790235989 | 343 | 0 | NULL |
1366| 172.16.2.95 | 3306 | 1555540791717604 | 354 | 0 | NULL |
1367| 172.16.0.66 | 3306 | 1555540791736392 | 377 | 1 | NULL |
1368| 172.16.2.95 | 3306 | 1555540793217741 | 388 | 0 | NULL |
1369| 172.16.0.66 | 3306 | 1555540793238056 | 412 | 1 | NULL |
1370| 172.16.2.95 | 3306 | 1555540794717853 | 319 | 0 | NULL |
1371| 172.16.0.66 | 3306 | 1555540794741156 | 365 | 1 | NULL |
1372| 172.16.0.66 | 3306 | 1555540796217908 | 289 | 1 | NULL |
1373| 172.16.2.95 | 3306 | 1555540796238248 | 361 | 0 | NULL |
1374| 172.16.2.95 | 3306 | 1555540797718029 | 289 | 0 | NULL |
1375| 172.16.0.66 | 3306 | 1555540797735790 | 368 | 1 | NULL |
1376| 172.16.2.95 | 3306 | 1555540799218167 | 286 | 0 | NULL |
1377| 172.16.0.66 | 3306 | 1555540799235775 | 298 | 1 | NULL |
1378| 172.16.0.66 | 3306 | 1555540800718309 | 289 | 1 | NULL |
1379| 172.16.2.95 | 3306 | 1555540800743934 | 351 | 0 | NULL |
1380| 172.16.2.95 | 3306 | 1555540802218485 | 326 | 0 | NULL |
1381| 172.16.0.66 | 3306 | 1555540802244438 | 243 | 1 | NULL |
1382| 172.16.2.95 | 3306 | 1555540803718598 | 318 | 0 | NULL |
1383| 172.16.0.66 | 3306 | 1555540803748094 | 292 | 1 | NULL |
1384| 172.16.2.95 | 3306 | 1555540805218698 | 289 | 0 | NULL |
1385| 172.16.0.66 | 3306 | 1555540805236635 | 318 | 1 | NULL |
1386| 172.16.2.95 | 3306 | 1555540806718806 | 307 | 0 | NULL |
1387| 172.16.0.66 | 3306 | 1555540806748036 | 285 | 1 | NULL |
1388| 172.16.0.66 | 3306 | 1555540808218897 | 268 | 1 | NULL |
1389| 172.16.2.95 | 3306 | 1555540808245327 | 273 | 0 | NULL |
1390| 172.16.2.95 | 3306 | 1555540809719060 | 270 | 0 | NULL |
1391| 172.16.0.66 | 3306 | 1555540809741665 | 464 | 1 | NULL |
1392| 172.16.0.66 | 3306 | 1555540811219549 | 315 | 1 | NULL |
1393| 172.16.2.95 | 3306 | 1555540811237437 | 361 | 0 | NULL |
1394| 172.16.2.95 | 3306 | 1555540812719667 | 252 | 0 | NULL |
1395| 172.16.0.66 | 3306 | 1555540812738190 | 356 | 1 | NULL |
1396| 172.16.2.95 | 3306 | 1555540814219809 | 297 | 0 | NULL |
1397| 172.16.0.66 | 3306 | 1555540814240072 | 323 | 1 | NULL |
1398| 172.16.0.66 | 3306 | 1555540815719909 | 294 | 1 | NULL |
1399| 172.16.2.95 | 3306 | 1555540815748621 | 390 | 0 | NULL |
1400| 172.16.2.95 | 3306 | 1555540817220062 | 259 | 0 | NULL |
1401| 172.16.0.66 | 3306 | 1555540817244841 | 325 | 1 | NULL |
1402| 172.16.2.95 | 3306 | 1555540818719776 | 269 | 0 | NULL |
1403| 172.16.0.66 | 3306 | 1555540818747582 | 387 | 1 | NULL |
1404| 172.16.2.95 | 3306 | 1555540820219911 | 252 | 0 | NULL |
1405| 172.16.0.66 | 3306 | 1555540820249438 | 370 | 1 | NULL |
1406| 172.16.2.95 | 3306 | 1555540821720452 | 268 | 0 | NULL |
1407| 172.16.0.66 | 3306 | 1555540821745804 | 343 | 1 | NULL |
1408| 172.16.2.95 | 3306 | 1555540823220555 | 334 | 0 | NULL |
1409| 172.16.0.66 | 3306 | 1555540823241921 | 338 | 1 | NULL |
1410| 172.16.2.95 | 3306 | 1555540824720676 | 313 | 0 | NULL |
1411| 172.16.0.66 | 3306 | 1555540824744530 | 463 | 1 | NULL |
1412| 172.16.0.66 | 3306 | 1555540826220740 | 306 | 1 | NULL |
1413| 172.16.2.95 | 3306 | 1555540826236523 | 388 | 0 | NULL |
1414| 172.16.2.95 | 3306 | 1555540827720504 | 294 | 0 | NULL |
1415| 172.16.0.66 | 3306 | 1555540827739026 | 376 | 1 | NULL |
1416| 172.16.2.95 | 3306 | 1555540829220592 | 299 | 0 | NULL |
1417| 172.16.0.66 | 3306 | 1555540829236623 | 386 | 1 | NULL |
1418| 172.16.2.95 | 3306 | 1555540830720730 | 368 | 0 | NULL |
1419| 172.16.0.66 | 3306 | 1555540830749787 | 361 | 1 | NULL |
1420| 172.16.2.95 | 3306 | 1555540832220906 | 380 | 0 | NULL |
1421| 172.16.0.66 | 3306 | 1555540832242496 | 412 | 1 | NULL |
1422| 172.16.2.95 | 3306 | 1555540833721081 | 383 | 0 | NULL |
1423| 172.16.0.66 | 3306 | 1555540833748067 | 405 | 1 | NULL |
1424| 172.16.0.66 | 3306 | 1555540835221184 | 353 | 1 | NULL |
1425| 172.16.2.95 | 3306 | 1555540835236547 | 342 | 0 | NULL |
1426| 172.16.2.95 | 3306 | 1555540836721269 | 299 | 0 | NULL |
1427| 172.16.0.66 | 3306 | 1555540836745474 | 362 | 1 | NULL |
1428| 172.16.2.95 | 3306 | 1555540838221443 | 362 | 0 | NULL |
1429| 172.16.0.66 | 3306 | 1555540838248008 | 300 | 1 | NULL |
1430| 172.16.0.66 | 3306 | 1555540839721456 | 245 | 1 | NULL |
1431| 172.16.2.95 | 3306 | 1555540839741328 | 322 | 0 | NULL |
1432| 172.16.2.95 | 3306 | 1555540841221563 | 247 | 0 | NULL |
1433| 172.16.0.66 | 3306 | 1555540841244704 | 244 | 1 | NULL |
1434| 172.16.2.95 | 3306 | 1555540842721689 | 263 | 0 | NULL |
1435| 172.16.0.66 | 3306 | 1555540842739219 | 242 | 1 | NULL |
1436| 172.16.2.95 | 3306 | 1555540844221847 | 402 | 0 | NULL |
1437| 172.16.0.66 | 3306 | 1555540844239007 | 283 | 1 | NULL |
1438| 172.16.2.95 | 3306 | 1555540845721998 | 292 | 0 | NULL |
1439| 172.16.0.66 | 3306 | 1555540845740029 | 270 | 1 | NULL |
1440| 172.16.2.95 | 3306 | 1555540847222079 | 241 | 0 | NULL |
1441| 172.16.0.66 | 3306 | 1555540847248731 | 243 | 1 | NULL |
1442| 172.16.2.95 | 3306 | 1555540848722170 | 242 | 0 | NULL |
1443| 172.16.0.66 | 3306 | 1555540848750877 | 246 | 1 | NULL |
1444| 172.16.0.66 | 3306 | 1555540850222314 | 259 | 1 | NULL |
1445| 172.16.2.95 | 3306 | 1555540850245066 | 256 | 0 | NULL |
1446| 172.16.0.66 | 3306 | 1555540851722473 | 336 | 1 | NULL |
1447| 172.16.2.95 | 3306 | 1555540851738906 | 319 | 0 | NULL |
1448| 172.16.2.95 | 3306 | 1555540853222600 | 358 | 0 | NULL |
1449| 172.16.0.66 | 3306 | 1555540853237960 | 299 | 1 | NULL |
1450| 172.16.0.66 | 3306 | 1555540854722809 | 347 | 1 | NULL |
1451| 172.16.2.95 | 3306 | 1555540854750315 | 353 | 0 | NULL |
1452| 172.16.2.95 | 3306 | 1555540856222883 | 418 | 0 | NULL |
1453| 172.16.0.66 | 3306 | 1555540856253053 | 313 | 1 | NULL |
1454| 172.16.0.66 | 3306 | 1555540857722969 | 264 | 1 | NULL |
1455| 172.16.2.95 | 3306 | 1555540857741752 | 272 | 0 | NULL |
1456| 172.16.2.95 | 3306 | 1555540859223119 | 263 | 0 | NULL |
1457| 172.16.0.66 | 3306 | 1555540859240983 | 257 | 1 | NULL |
1458| 172.16.0.66 | 3306 | 1555540860723266 | 307 | 1 | NULL |
1459| 172.16.2.95 | 3306 | 1555540860743471 | 333 | 0 | NULL |
1460| 172.16.2.95 | 3306 | 1555540862223399 | 354 | 0 | NULL |
1461| 172.16.0.66 | 3306 | 1555540862241431 | 274 | 1 | NULL |
1462| 172.16.2.95 | 3306 | 1555540863723516 | 388 | 0 | NULL |
1463| 172.16.0.66 | 3306 | 1555540863748875 | 330 | 1 | NULL |
1464| 172.16.2.95 | 3306 | 1555540865223587 | 371 | 0 | NULL |
1465| 172.16.0.66 | 3306 | 1555540865242231 | 305 | 1 | NULL |
1466| 172.16.0.66 | 3306 | 1555540866723656 | 349 | 1 | NULL |
1467| 172.16.2.95 | 3306 | 1555540866744965 | 327 | 0 | NULL |
1468| 172.16.0.66 | 3306 | 1555540868223756 | 253 | 1 | NULL |
1469| 172.16.2.95 | 3306 | 1555540868245734 | 275 | 0 | NULL |
1470| 172.16.2.95 | 3306 | 1555540869723901 | 259 | 0 | NULL |
1471| 172.16.0.66 | 3306 | 1555540869747298 | 256 | 1 | NULL |
1472| 172.16.2.95 | 3306 | 1555540871224071 | 275 | 0 | NULL |
1473| 172.16.0.66 | 3306 | 1555540871251199 | 268 | 1 | NULL |
1474| 172.16.0.66 | 3306 | 1555540872724292 | 309 | 1 | NULL |
1475| 172.16.2.95 | 3306 | 1555540872754194 | 324 | 0 | NULL |
1476| 172.16.2.95 | 3306 | 1555540874224305 | 277 | 0 | NULL |
1477| 172.16.0.66 | 3306 | 1555540874240447 | 268 | 1 | NULL |
1478| 172.16.2.95 | 3306 | 1555540875724402 | 259 | 0 | NULL |
1479| 172.16.0.66 | 3306 | 1555540875747214 | 257 | 1 | NULL |
1480| 172.16.0.66 | 3306 | 1555540877224544 | 274 | 1 | NULL |
1481| 172.16.2.95 | 3306 | 1555540877251875 | 314 | 0 | NULL |
1482| 172.16.0.66 | 3306 | 1555540878724689 | 285 | 1 | NULL |
1483| 172.16.2.95 | 3306 | 1555540878750575 | 287 | 0 | NULL |
1484| 172.16.0.66 | 3306 | 1555540880224817 | 262 | 1 | NULL |
1485| 172.16.2.95 | 3306 | 1555540880244305 | 254 | 0 | NULL |
1486| 172.16.2.95 | 3306 | 1555540881725002 | 259 | 0 | NULL |
1487| 172.16.0.66 | 3306 | 1555540881750557 | 269 | 1 | NULL |
1488| 172.16.2.95 | 3306 | 1555540883225198 | 359 | 0 | NULL |
1489| 172.16.0.66 | 3306 | 1555540883254621 | 351 | 1 | NULL |
1490| 172.16.0.66 | 3306 | 1555540884725259 | 276 | 1 | NULL |
1491| 172.16.2.95 | 3306 | 1555540884750798 | 318 | 0 | NULL |
1492| 172.16.2.95 | 3306 | 1555540886225318 | 268 | 0 | NULL |
1493| 172.16.0.66 | 3306 | 1555540886253403 | 267 | 1 | NULL |
1494| 172.16.0.66 | 3306 | 1555540887725471 | 267 | 1 | NULL |
1495| 172.16.2.95 | 3306 | 1555540887752132 | 268 | 0 | NULL |
1496| 172.16.2.95 | 3306 | 1555540889225560 | 242 | 0 | NULL |
1497| 172.16.0.66 | 3306 | 1555540889249035 | 276 | 1 | NULL |
1498| 172.16.2.95 | 3306 | 1555540890725740 | 375 | 0 | NULL |
1499| 172.16.0.66 | 3306 | 1555540890745150 | 313 | 1 | NULL |
1500| 172.16.2.95 | 3306 | 1555540892225886 | 339 | 0 | NULL |
1501| 172.16.0.66 | 3306 | 1555540892242698 | 300 | 1 | NULL |
1502| 172.16.2.95 | 3306 | 1555540893726095 | 379 | 0 | NULL |
1503| 172.16.0.66 | 3306 | 1555540893751714 | 338 | 1 | NULL |
1504| 172.16.2.95 | 3306 | 1555540895226203 | 390 | 0 | NULL |
1505| 172.16.0.66 | 3306 | 1555540895248913 | 326 | 1 | NULL |
1506| 172.16.0.66 | 3306 | 1555540896726285 | 322 | 1 | NULL |
1507| 172.16.2.95 | 3306 | 1555540896750292 | 343 | 0 | NULL |
1508| 172.16.2.95 | 3306 | 1555540898226340 | 276 | 0 | NULL |
1509| 172.16.0.66 | 3306 | 1555540898256326 | 281 | 1 | NULL |
1510| 172.16.2.95 | 3306 | 1555540899726556 | 377 | 0 | NULL |
1511| 172.16.0.66 | 3306 | 1555540899745884 | 312 | 1 | NULL |
1512| 172.16.0.66 | 3306 | 1555540901226621 | 295 | 1 | NULL |
1513| 172.16.2.95 | 3306 | 1555540901250582 | 321 | 0 | NULL |
1514| 172.16.2.95 | 3306 | 1555540902726710 | 260 | 0 | NULL |
1515| 172.16.0.66 | 3306 | 1555540902749313 | 262 | 1 | NULL |
1516| 172.16.2.95 | 3306 | 1555540904226866 | 316 | 0 | NULL |
1517| 172.16.0.66 | 3306 | 1555540904244628 | 329 | 1 | NULL |
1518| 172.16.2.95 | 3306 | 1555540905727014 | 261 | 0 | NULL |
1519| 172.16.0.66 | 3306 | 1555540905748974 | 257 | 1 | NULL |
1520| 172.16.0.66 | 3306 | 1555540907227152 | 258 | 1 | NULL |
1521| 172.16.2.95 | 3306 | 1555540907252439 | 257 | 0 | NULL |
1522| 172.16.0.66 | 3306 | 1555540908727294 | 257 | 1 | NULL |
1523| 172.16.2.95 | 3306 | 1555540908744666 | 292 | 0 | NULL |
1524| 172.16.0.66 | 3306 | 1555540910227411 | 258 | 1 | NULL |
1525| 172.16.2.95 | 3306 | 1555540910245091 | 261 | 0 | NULL |
1526| 172.16.2.95 | 3306 | 1555540911727522 | 261 | 0 | NULL |
1527| 172.16.0.66 | 3306 | 1555540911746566 | 270 | 1 | NULL |
1528| 172.16.0.66 | 3306 | 1555540913227708 | 309 | 1 | NULL |
1529| 172.16.2.95 | 3306 | 1555540913244251 | 294 | 0 | NULL |
1530| 172.16.2.95 | 3306 | 1555540914727760 | 384 | 0 | NULL |
1531| 172.16.0.66 | 3306 | 1555540914750571 | 355 | 1 | NULL |
1532| 172.16.0.66 | 3306 | 1555540916227839 | 267 | 1 | NULL |
1533| 172.16.2.95 | 3306 | 1555540916248112 | 271 | 0 | NULL |
1534| 172.16.0.66 | 3306 | 1555540917728027 | 261 | 1 | NULL |
1535| 172.16.2.95 | 3306 | 1555540917758022 | 256 | 0 | NULL |
1536| 172.16.0.66 | 3306 | 1555540919228167 | 259 | 1 | NULL |
1537| 172.16.2.95 | 3306 | 1555540919252232 | 259 | 0 | NULL |
1538| 172.16.0.66 | 3306 | 1555540920728286 | 293 | 1 | NULL |
1539| 172.16.2.95 | 3306 | 1555540920748980 | 304 | 0 | NULL |
1540| 172.16.0.66 | 3306 | 1555540922228444 | 349 | 1 | NULL |
1541| 172.16.2.95 | 3306 | 1555540922251940 | 326 | 0 | NULL |
1542| 172.16.0.66 | 3306 | 1555540923728486 | 337 | 1 | NULL |
1543| 172.16.2.95 | 3306 | 1555540923751077 | 360 | 0 | NULL |
1544| 172.16.2.95 | 3306 | 1555540925228622 | 368 | 0 | NULL |
1545| 172.16.0.66 | 3306 | 1555540925251979 | 305 | 1 | NULL |
1546| 172.16.0.66 | 3306 | 1555540926728810 | 348 | 1 | NULL |
1547| 172.16.2.95 | 3306 | 1555540926745726 | 375 | 0 | NULL |
1548| 172.16.0.66 | 3306 | 1555540928228877 | 266 | 1 | NULL |
1549| 172.16.2.95 | 3306 | 1555540928251667 | 314 | 0 | NULL |
1550| 172.16.0.66 | 3306 | 1555540929728967 | 262 | 1 | NULL |
1551| 172.16.2.95 | 3306 | 1555540929751068 | 257 | 0 | NULL |
1552| 172.16.0.66 | 3306 | 1555540931229093 | 259 | 1 | NULL |
1553| 172.16.2.95 | 3306 | 1555540931254521 | 274 | 0 | NULL |
1554| 172.16.0.66 | 3306 | 1555540932729240 | 284 | 1 | NULL |
1555| 172.16.2.95 | 3306 | 1555540932758738 | 310 | 0 | NULL |
1556| 172.16.2.95 | 3306 | 1555540934229310 | 313 | 0 | NULL |
1557| 172.16.0.66 | 3306 | 1555540934249004 | 296 | 1 | NULL |
1558| 172.16.0.66 | 3306 | 1555540935729512 | 261 | 1 | NULL |
1559| 172.16.2.95 | 3306 | 1555540935748080 | 263 | 0 | NULL |
1560| 172.16.0.66 | 3306 | 1555540937229597 | 302 | 1 | NULL |
1561| 172.16.2.95 | 3306 | 1555540937253897 | 318 | 0 | NULL |
1562| 172.16.0.66 | 3306 | 1555540938729697 | 259 | 1 | NULL |
1563| 172.16.2.95 | 3306 | 1555540938753899 | 261 | 0 | NULL |
1564| 172.16.0.66 | 3306 | 1555540940229822 | 328 | 1 | NULL |
1565| 172.16.2.95 | 3306 | 1555540940255140 | 274 | 0 | NULL |
1566| 172.16.2.95 | 3306 | 1555540941729956 | 263 | 0 | NULL |
1567| 172.16.0.66 | 3306 | 1555540941759206 | 261 | 1 | NULL |
1568| 172.16.2.95 | 3306 | 1555540943230183 | 375 | 0 | NULL |
1569| 172.16.0.66 | 3306 | 1555540943253628 | 355 | 1 | NULL |
1570| 172.16.2.95 | 3306 | 1555540944730307 | 396 | 0 | NULL |
1571| 172.16.0.66 | 3306 | 1555540944754540 | 335 | 1 | NULL |
1572| 172.16.0.66 | 3306 | 1555540946230343 | 262 | 1 | NULL |
1573| 172.16.2.95 | 3306 | 1555540946253773 | 348 | 0 | NULL |
1574| 172.16.2.95 | 3306 | 1555540947730432 | 261 | 0 | NULL |
1575| 172.16.0.66 | 3306 | 1555540947749737 | 275 | 1 | NULL |
1576| 172.16.0.66 | 3306 | 1555540949230582 | 271 | 1 | NULL |
1577| 172.16.2.95 | 3306 | 1555540949259763 | 274 | 0 | NULL |
1578| 172.16.2.95 | 3306 | 1555540950730728 | 317 | 0 | NULL |
1579| 172.16.0.66 | 3306 | 1555540950746975 | 286 | 1 | NULL |
1580| 172.16.0.66 | 3306 | 1555540952230833 | 263 | 1 | NULL |
1581| 172.16.2.95 | 3306 | 1555540952250718 | 274 | 0 | NULL |
1582| 172.16.0.66 | 3306 | 1555540953731045 | 308 | 1 | NULL |
1583| 172.16.2.95 | 3306 | 1555540953760083 | 346 | 0 | NULL |
1584| 172.16.2.95 | 3306 | 1555540955231148 | 325 | 0 | NULL |
1585| 172.16.0.66 | 3306 | 1555540955254653 | 324 | 1 | NULL |
1586| 172.16.2.95 | 3306 | 1555540956731250 | 322 | 0 | NULL |
1587| 172.16.0.66 | 3306 | 1555540956756623 | 334 | 1 | NULL |
1588| 172.16.0.66 | 3306 | 1555540958231353 | 258 | 1 | NULL |
1589| 172.16.2.95 | 3306 | 1555540958249148 | 268 | 0 | NULL |
1590| 172.16.0.66 | 3306 | 1555540959731493 | 318 | 1 | NULL |
1591| 172.16.2.95 | 3306 | 1555540959759513 | 317 | 0 | NULL |
1592| 172.16.2.95 | 3306 | 1555540961231571 | 297 | 0 | NULL |
1593| 172.16.0.66 | 3306 | 1555540961260005 | 263 | 1 | NULL |
1594| 172.16.0.66 | 3306 | 1555540962731697 | 265 | 1 | NULL |
1595| 172.16.2.95 | 3306 | 1555540962752382 | 267 | 0 | NULL |
1596| 172.16.0.66 | 3306 | 1555540964231815 | 263 | 1 | NULL |
1597| 172.16.2.95 | 3306 | 1555540964253021 | 266 | 0 | NULL |
1598| 172.16.0.66 | 3306 | 1555540965731946 | 260 | 1 | NULL |
1599| 172.16.2.95 | 3306 | 1555540965757429 | 260 | 0 | NULL |
1600| 172.16.0.66 | 3306 | 1555540967232159 | 260 | 1 | NULL |
1601| 172.16.2.95 | 3306 | 1555540967259326 | 259 | 0 | NULL |
1602| 172.16.2.95 | 3306 | 1555540968732241 | 260 | 0 | NULL |
1603| 172.16.0.66 | 3306 | 1555540968750219 | 258 | 1 | NULL |
1604| 172.16.2.95 | 3306 | 1555540970232359 | 261 | 0 | NULL |
1605| 172.16.0.66 | 3306 | 1555540970253013 | 262 | 1 | NULL |
1606| 172.16.0.66 | 3306 | 1555540971732521 | 270 | 1 | NULL |
1607| 172.16.2.95 | 3306 | 1555540971752426 | 275 | 0 | NULL |
1608| 172.16.0.66 | 3306 | 1555540973232610 | 303 | 1 | NULL |
1609| 172.16.2.95 | 3306 | 1555540973251333 | 263 | 0 | NULL |
1610| 172.16.2.95 | 3306 | 1555540974732728 | 282 | 0 | NULL |
1611| 172.16.0.66 | 3306 | 1555540974762207 | 270 | 1 | NULL |
1612| 172.16.2.95 | 3306 | 1555540976232970 | 325 | 0 | NULL |
1613| 172.16.0.66 | 3306 | 1555540976256830 | 308 | 1 | NULL |
1614| 172.16.2.95 | 3306 | 1555540977733055 | 263 | 0 | NULL |
1615| 172.16.0.66 | 3306 | 1555540977758525 | 260 | 1 | NULL |
1616| 172.16.0.66 | 3306 | 1555540979233156 | 258 | 1 | NULL |
1617| 172.16.2.95 | 3306 | 1555540979255557 | 270 | 0 | NULL |
1618| 172.16.0.66 | 3306 | 1555540980733306 | 308 | 1 | NULL |
1619| 172.16.2.95 | 3306 | 1555540980759738 | 319 | 0 | NULL |
1620| 172.16.2.95 | 3306 | 1555540982233437 | 277 | 0 | NULL |
1621| 172.16.0.66 | 3306 | 1555540982254951 | 267 | 1 | NULL |
1622| 172.16.2.95 | 3306 | 1555540983733593 | 361 | 0 | NULL |
1623| 172.16.0.66 | 3306 | 1555540983762016 | 299 | 1 | NULL |
1624| 172.16.0.66 | 3306 | 1555540985233715 | 296 | 1 | NULL |
1625| 172.16.2.95 | 3306 | 1555540985253132 | 305 | 0 | NULL |
1626| 172.16.2.95 | 3306 | 1555540986733786 | 332 | 0 | NULL |
1627| 172.16.0.66 | 3306 | 1555540986759959 | 300 | 1 | NULL |
1628| 172.16.0.66 | 3306 | 1555540988233888 | 257 | 1 | NULL |
1629| 172.16.2.95 | 3306 | 1555540988261522 | 278 | 0 | NULL |
1630| 172.16.2.95 | 3306 | 1555540989734037 | 262 | 0 | NULL |
1631| 172.16.0.66 | 3306 | 1555540989757193 | 279 | 1 | NULL |
1632| 172.16.0.66 | 3306 | 1555540991234229 | 268 | 1 | NULL |
1633| 172.16.2.95 | 3306 | 1555540991255653 | 328 | 0 | NULL |
1634| 172.16.2.95 | 3306 | 1555540992734299 | 265 | 0 | NULL |
1635| 172.16.0.66 | 3306 | 1555540992754449 | 331 | 1 | NULL |
1636| 172.16.0.66 | 3306 | 1555540994234417 | 289 | 1 | NULL |
1637| 172.16.2.95 | 3306 | 1555540994251119 | 313 | 0 | NULL |
1638| 172.16.0.66 | 3306 | 1555540995734524 | 287 | 1 | NULL |
1639| 172.16.2.95 | 3306 | 1555540995751229 | 302 | 0 | NULL |
1640| 172.16.0.66 | 3306 | 1555540997234649 | 291 | 1 | NULL |
1641| 172.16.2.95 | 3306 | 1555540997257474 | 373 | 0 | NULL |
1642| 172.16.2.95 | 3306 | 1555540998734765 | 319 | 0 | NULL |
1643| 172.16.0.66 | 3306 | 1555540998760559 | 405 | 1 | NULL |
1644| 172.16.2.95 | 3306 | 1555541000234920 | 218 | 0 | NULL |
1645| 172.16.0.66 | 3306 | 1555541000264921 | 363 | 1 | NULL |
1646| 172.16.2.95 | 3306 | 1555541001735079 | 260 | 0 | NULL |
1647| 172.16.0.66 | 3306 | 1555541001759122 | 376 | 1 | NULL |
1648| 172.16.0.66 | 3306 | 1555541003235184 | 305 | 1 | NULL |
1649| 172.16.2.95 | 3306 | 1555541003256557 | 425 | 0 | NULL |
1650| 172.16.0.66 | 3306 | 1555541004735302 | 311 | 1 | NULL |
1651| 172.16.2.95 | 3306 | 1555541004760129 | 363 | 0 | NULL |
1652| 172.16.0.66 | 3306 | 1555541006235406 | 259 | 1 | NULL |
1653| 172.16.2.95 | 3306 | 1555541006253276 | 369 | 0 | NULL |
1654| 172.16.0.66 | 3306 | 1555541007735529 | 256 | 1 | NULL |
1655| 172.16.2.95 | 3306 | 1555541007760061 | 363 | 0 | NULL |
1656| 172.16.2.95 | 3306 | 1555541009235644 | 454 | 0 | NULL |
1657| 172.16.0.66 | 3306 | 1555541009257743 | 370 | 1 | NULL |
1658| 172.16.2.95 | 3306 | 1555541010735776 | 313 | 0 | NULL |
1659| 172.16.0.66 | 3306 | 1555541010761155 | 401 | 1 | NULL |
1660| 172.16.2.95 | 3306 | 1555541012235965 | 316 | 0 | NULL |
1661| 172.16.0.66 | 3306 | 1555541012264210 | 344 | 1 | NULL |
1662| 172.16.2.95 | 3306 | 1555541013736101 | 315 | 0 | NULL |
1663| 172.16.0.66 | 3306 | 1555541013763040 | 369 | 1 | NULL |
1664| 172.16.0.66 | 3306 | 1555541015236211 | 322 | 1 | NULL |
1665| 172.16.2.95 | 3306 | 1555541015265911 | 378 | 0 | NULL |
1666| 172.16.0.66 | 3306 | 1555541016736296 | 311 | 1 | NULL |
1667| 172.16.2.95 | 3306 | 1555541016757440 | 374 | 0 | NULL |
1668| 172.16.2.95 | 3306 | 1555541018236443 | 389 | 0 | NULL |
1669| 172.16.0.66 | 3306 | 1555541018255044 | 257 | 1 | NULL |
1670| 172.16.2.95 | 3306 | 1555541019736538 | 456 | 0 | NULL |
1671| 172.16.0.66 | 3306 | 1555541019756713 | 396 | 1 | NULL |
1672| 172.16.0.66 | 3306 | 1555541021236703 | 306 | 1 | NULL |
1673| 172.16.2.95 | 3306 | 1555541021261851 | 323 | 0 | NULL |
1674| 172.16.0.66 | 3306 | 1555541022736816 | 274 | 1 | NULL |
1675| 172.16.2.95 | 3306 | 1555541022761600 | 356 | 0 | NULL |
1676| 172.16.2.95 | 3306 | 1555541024236949 | 345 | 0 | NULL |
1677| 172.16.0.66 | 3306 | 1555541024257843 | 379 | 1 | NULL |
1678| 172.16.0.66 | 3306 | 1555541025737078 | 309 | 1 | NULL |
1679| 172.16.2.95 | 3306 | 1555541025764065 | 372 | 0 | NULL |
1680| 172.16.2.95 | 3306 | 1555541027237193 | 330 | 0 | NULL |
1681| 172.16.0.66 | 3306 | 1555541027254951 | 385 | 1 | NULL |
1682| 172.16.0.66 | 3306 | 1555541028737298 | 262 | 1 | NULL |
1683| 172.16.2.95 | 3306 | 1555541028754215 | 257 | 0 | NULL |
1684| 172.16.2.95 | 3306 | 1555541030237458 | 255 | 0 | NULL |
1685| 172.16.0.66 | 3306 | 1555541030263181 | 256 | 1 | NULL |
1686| 172.16.0.66 | 3306 | 1555541031737597 | 306 | 1 | NULL |
1687| 172.16.2.95 | 3306 | 1555541031767076 | 308 | 0 | NULL |
1688| 172.16.2.95 | 3306 | 1555541033237697 | 314 | 0 | NULL |
1689| 172.16.0.66 | 3306 | 1555541033263435 | 285 | 1 | NULL |
1690| 172.16.2.95 | 3306 | 1555541034737824 | 317 | 0 | NULL |
1691| 172.16.0.66 | 3306 | 1555541034767716 | 295 | 1 | NULL |
1692| 172.16.2.95 | 3306 | 1555541036237953 | 267 | 0 | NULL |
1693| 172.16.0.66 | 3306 | 1555541036261614 | 271 | 1 | NULL |
1694| 172.16.2.95 | 3306 | 1555541037738080 | 256 | 0 | NULL |
1695| 172.16.0.66 | 3306 | 1555541037754164 | 255 | 1 | NULL |
1696| 172.16.0.66 | 3306 | 1555541039238215 | 266 | 1 | NULL |
1697| 172.16.2.95 | 3306 | 1555541039259053 | 271 | 0 | NULL |
1698| 172.16.2.95 | 3306 | 1555541040738324 | 294 | 0 | NULL |
1699| 172.16.0.66 | 3306 | 1555541040765744 | 292 | 1 | NULL |
1700| 172.16.2.95 | 3306 | 1555541042238428 | 430 | 0 | NULL |
1701| 172.16.0.66 | 3306 | 1555541042265359 | 267 | 1 | NULL |
1702| 172.16.2.95 | 3306 | 1555541043738507 | 321 | 0 | NULL |
1703| 172.16.0.66 | 3306 | 1555541043762520 | 297 | 1 | NULL |
1704| 172.16.0.66 | 3306 | 1555541045238721 | 294 | 1 | NULL |
1705| 172.16.2.95 | 3306 | 1555541045263174 | 308 | 0 | NULL |
1706| 172.16.0.66 | 3306 | 1555541046738804 | 291 | 1 | NULL |
1707| 172.16.2.95 | 3306 | 1555541046761355 | 301 | 0 | NULL |
1708| 172.16.2.95 | 3306 | 1555541048238894 | 272 | 0 | NULL |
1709| 172.16.0.66 | 3306 | 1555541048256009 | 301 | 1 | NULL |
1710| 172.16.2.95 | 3306 | 1555541049739033 | 261 | 0 | NULL |
1711| 172.16.0.66 | 3306 | 1555541049769213 | 268 | 1 | NULL |
1712| 172.16.2.95 | 3306 | 1555541051239186 | 257 | 0 | NULL |
1713| 172.16.0.66 | 3306 | 1555541051262539 | 281 | 1 | NULL |
1714| 172.16.2.95 | 3306 | 1555541052739279 | 278 | 0 | NULL |
1715| 172.16.0.66 | 3306 | 1555541052767696 | 279 | 1 | NULL |
1716| 172.16.0.66 | 3306 | 1555541054239437 | 276 | 1 | NULL |
1717| 172.16.2.95 | 3306 | 1555541054268135 | 262 | 0 | NULL |
1718| 172.16.2.95 | 3306 | 1555541055739539 | 276 | 0 | NULL |
1719| 172.16.0.66 | 3306 | 1555541055760911 | 272 | 1 | NULL |
1720| 172.16.2.95 | 3306 | 1555541057239654 | 298 | 0 | NULL |
1721| 172.16.0.66 | 3306 | 1555541057254899 | 269 | 1 | NULL |
1722| 172.16.0.66 | 3306 | 1555541058739785 | 260 | 1 | NULL |
1723| 172.16.2.95 | 3306 | 1555541058756120 | 257 | 0 | NULL |
1724| 172.16.0.66 | 3306 | 1555541060239908 | 259 | 1 | NULL |
1725| 172.16.2.95 | 3306 | 1555541060263657 | 296 | 0 | NULL |
1726| 172.16.0.66 | 3306 | 1555541061740103 | 281 | 1 | NULL |
1727| 172.16.2.95 | 3306 | 1555541061757903 | 295 | 0 | NULL |
1728| 172.16.0.66 | 3306 | 1555541063240216 | 290 | 1 | NULL |
1729| 172.16.2.95 | 3306 | 1555541063263849 | 311 | 0 | NULL |
1730| 172.16.0.66 | 3306 | 1555541064740308 | 273 | 1 | NULL |
1731| 172.16.2.95 | 3306 | 1555541064757415 | 287 | 0 | NULL |
1732| 172.16.0.66 | 3306 | 1555541066240437 | 283 | 1 | NULL |
1733| 172.16.2.95 | 3306 | 1555541066265282 | 288 | 0 | NULL |
1734| 172.16.0.66 | 3306 | 1555541067740592 | 291 | 1 | NULL |
1735| 172.16.2.95 | 3306 | 1555541067761446 | 258 | 0 | NULL |
1736| 172.16.2.95 | 3306 | 1555541069240731 | 262 | 0 | NULL |
1737| 172.16.0.66 | 3306 | 1555541069269608 | 298 | 1 | NULL |
1738| 172.16.2.95 | 3306 | 1555541070740836 | 268 | 0 | NULL |
1739| 172.16.0.66 | 3306 | 1555541070767912 | 259 | 1 | NULL |
1740| 172.16.0.66 | 3306 | 1555541072241004 | 225 | 1 | NULL |
1741| 172.16.2.95 | 3306 | 1555541072256739 | 269 | 0 | NULL |
1742| 172.16.2.95 | 3306 | 1555541073741151 | 344 | 0 | NULL |
1743| 172.16.0.66 | 3306 | 1555541073762026 | 296 | 1 | NULL |
1744| 172.16.0.66 | 3306 | 1555541075241243 | 276 | 1 | NULL |
1745| 172.16.2.95 | 3306 | 1555541075264614 | 326 | 0 | NULL |
1746| 172.16.0.66 | 3306 | 1555541076741373 | 292 | 1 | NULL |
1747| 172.16.2.95 | 3306 | 1555541076768599 | 348 | 0 | NULL |
1748| 172.16.2.95 | 3306 | 1555541078241472 | 261 | 0 | NULL |
1749| 172.16.0.66 | 3306 | 1555541078262586 | 289 | 1 | NULL |
1750| 172.16.0.66 | 3306 | 1555541079741631 | 296 | 1 | NULL |
1751| 172.16.2.95 | 3306 | 1555541079759296 | 268 | 0 | NULL |
1752| 172.16.0.66 | 3306 | 1555541081241742 | 272 | 1 | NULL |
1753| 172.16.2.95 | 3306 | 1555541081262166 | 259 | 0 | NULL |
1754| 172.16.2.95 | 3306 | 1555541082741845 | 258 | 0 | NULL |
1755| 172.16.0.66 | 3306 | 1555541082757149 | 257 | 1 | NULL |
1756| 172.16.2.95 | 3306 | 1555541084242053 | 301 | 0 | NULL |
1757| 172.16.0.66 | 3306 | 1555541084260596 | 318 | 1 | NULL |
1758| 172.16.0.66 | 3306 | 1555541085742137 | 261 | 1 | NULL |
1759| 172.16.2.95 | 3306 | 1555541085759515 | 271 | 0 | NULL |
1760| 172.16.2.95 | 3306 | 1555541087242315 | 269 | 0 | NULL |
1761| 172.16.0.66 | 3306 | 1555541087263532 | 289 | 1 | NULL |
1762| 172.16.0.66 | 3306 | 1555541088742423 | 257 | 1 | NULL |
1763| 172.16.2.95 | 3306 | 1555541088772378 | 260 | 0 | NULL |
1764| 172.16.2.95 | 3306 | 1555541090242521 | 294 | 0 | NULL |
1765| 172.16.0.66 | 3306 | 1555541090271956 | 264 | 1 | NULL |
1766| 172.16.0.66 | 3306 | 1555541091742653 | 308 | 1 | NULL |
1767| 172.16.2.95 | 3306 | 1555541091764803 | 284 | 0 | NULL |
1768| 172.16.2.95 | 3306 | 1555541093242802 | 316 | 0 | NULL |
1769| 172.16.0.66 | 3306 | 1555541093260066 | 295 | 1 | NULL |
1770| 172.16.2.95 | 3306 | 1555541094743010 | 348 | 0 | NULL |
1771| 172.16.0.66 | 3306 | 1555541094760392 | 317 | 1 | NULL |
1772| 172.16.0.66 | 3306 | 1555541096243085 | 260 | 1 | NULL |
1773| 172.16.2.95 | 3306 | 1555541096267168 | 272 | 0 | NULL |
1774| 172.16.0.66 | 3306 | 1555541097743194 | 256 | 1 | NULL |
1775| 172.16.2.95 | 3306 | 1555541097761106 | 266 | 0 | NULL |
1776| 172.16.2.95 | 3306 | 1555541099243280 | 256 | 0 | NULL |
1777| 172.16.0.66 | 3306 | 1555541099259883 | 257 | 1 | NULL |
1778| 172.16.2.95 | 3306 | 1555541100743452 | 351 | 0 | NULL |
1779| 172.16.0.66 | 3306 | 1555541100766797 | 305 | 1 | NULL |
1780| 172.16.0.66 | 3306 | 1555541102243571 | 357 | 1 | NULL |
1781| 172.16.2.95 | 3306 | 1555541102262301 | 370 | 0 | NULL |
1782| 172.16.2.95 | 3306 | 1555541103743657 | 387 | 0 | NULL |
1783| 172.16.0.66 | 3306 | 1555541103761688 | 319 | 1 | NULL |
1784| 172.16.2.95 | 3306 | 1555541105243819 | 363 | 0 | NULL |
1785| 172.16.0.66 | 3306 | 1555541105259686 | 351 | 1 | NULL |
1786| 172.16.0.66 | 3306 | 1555541106743987 | 314 | 1 | NULL |
1787| 172.16.2.95 | 3306 | 1555541106761288 | 349 | 0 | NULL |
1788| 172.16.0.66 | 3306 | 1555541108244021 | 257 | 1 | NULL |
1789| 172.16.2.95 | 3306 | 1555541108269146 | 266 | 0 | NULL |
1790| 172.16.0.66 | 3306 | 1555541109744184 | 258 | 1 | NULL |
1791| 172.16.2.95 | 3306 | 1555541109770728 | 265 | 0 | NULL |
1792| 172.16.0.66 | 3306 | 1555541111244290 | 255 | 1 | NULL |
1793| 172.16.2.95 | 3306 | 1555541111271552 | 271 | 0 | NULL |
1794| 172.16.2.95 | 3306 | 1555541112744491 | 293 | 0 | NULL |
1795| 172.16.0.66 | 3306 | 1555541112770454 | 276 | 1 | NULL |
1796| 172.16.0.66 | 3306 | 1555541114244581 | 280 | 1 | NULL |
1797| 172.16.2.95 | 3306 | 1555541114272440 | 242 | 0 | NULL |
1798| 172.16.0.66 | 3306 | 1555541115744714 | 291 | 1 | NULL |
1799| 172.16.2.95 | 3306 | 1555541115774425 | 293 | 0 | NULL |
1800| 172.16.2.95 | 3306 | 1555541117244825 | 261 | 0 | NULL |
1801| 172.16.0.66 | 3306 | 1555541117273600 | 271 | 1 | NULL |
1802| 172.16.0.66 | 3306 | 1555541118744965 | 255 | 1 | NULL |
1803| 172.16.2.95 | 3306 | 1555541118764688 | 260 | 0 | NULL |
1804| 172.16.0.66 | 3306 | 1555541120245131 | 256 | 1 | NULL |
1805| 172.16.2.95 | 3306 | 1555541120270533 | 282 | 0 | NULL |
1806| 172.16.0.66 | 3306 | 1555541121745284 | 281 | 1 | NULL |
1807| 172.16.2.95 | 3306 | 1555541121762778 | 293 | 0 | NULL |
1808| 172.16.0.66 | 3306 | 1555541123245370 | 282 | 1 | NULL |
1809| 172.16.2.95 | 3306 | 1555541123264374 | 300 | 0 | NULL |
1810| 172.16.0.66 | 3306 | 1555541124745483 | 353 | 1 | NULL |
1811| 172.16.2.95 | 3306 | 1555541124761070 | 369 | 0 | NULL |
1812| 172.16.0.66 | 3306 | 1555541126245666 | 359 | 1 | NULL |
1813| 172.16.2.95 | 3306 | 1555541126274796 | 363 | 0 | NULL |
1814| 172.16.0.66 | 3306 | 1555541127745694 | 262 | 1 | NULL |
1815| 172.16.2.95 | 3306 | 1555541127775744 | 234 | 0 | NULL |
1816| 172.16.2.95 | 3306 | 1555541129245881 | 257 | 0 | NULL |
1817| 172.16.0.66 | 3306 | 1555541129263210 | 258 | 1 | NULL |
1818| 172.16.2.95 | 3306 | 1555541130746060 | 342 | 0 | NULL |
1819| 172.16.0.66 | 3306 | 1555541130768668 | 337 | 1 | NULL |
1820| 172.16.0.66 | 3306 | 1555541132246173 | 255 | 1 | NULL |
1821| 172.16.2.95 | 3306 | 1555541132262266 | 262 | 0 | NULL |
1822| 172.16.2.95 | 3306 | 1555541133746331 | 395 | 0 | NULL |
1823| 172.16.0.66 | 3306 | 1555541133768678 | 357 | 1 | NULL |
1824| 172.16.2.95 | 3306 | 1555541135246424 | 374 | 0 | NULL |
1825| 172.16.0.66 | 3306 | 1555541135276031 | 316 | 1 | NULL |
1826| 172.16.0.66 | 3306 | 1555541136746528 | 381 | 1 | NULL |
1827| 172.16.2.95 | 3306 | 1555541136768326 | 364 | 0 | NULL |
1828| 172.16.2.95 | 3306 | 1555541138246556 | 328 | 0 | NULL |
1829| 172.16.0.66 | 3306 | 1555541138267580 | 327 | 1 | NULL |
1830| 172.16.2.95 | 3306 | 1555541139746709 | 312 | 0 | NULL |
1831| 172.16.0.66 | 3306 | 1555541139776182 | 283 | 1 | NULL |
1832| 172.16.2.95 | 3306 | 1555541141246818 | 261 | 0 | NULL |
1833| 172.16.0.66 | 3306 | 1555541141268460 | 270 | 1 | NULL |
1834| 172.16.0.66 | 3306 | 1555541142747093 | 342 | 1 | NULL |
1835| 172.16.2.95 | 3306 | 1555541142770088 | 368 | 0 | NULL |
1836| 172.16.0.66 | 3306 | 1555541144247199 | 331 | 1 | NULL |
1837| 172.16.2.95 | 3306 | 1555541144270266 | 386 | 0 | NULL |
1838| 172.16.0.66 | 3306 | 1555541145747317 | 312 | 1 | NULL |
1839| 172.16.2.95 | 3306 | 1555541145769620 | 345 | 0 | NULL |
1840| 172.16.0.66 | 3306 | 1555541147247388 | 258 | 1 | NULL |
1841| 172.16.2.95 | 3306 | 1555541147275804 | 261 | 0 | NULL |
1842| 172.16.2.95 | 3306 | 1555541148747480 | 255 | 0 | NULL |
1843| 172.16.0.66 | 3306 | 1555541148777090 | 256 | 1 | NULL |
1844| 172.16.0.66 | 3306 | 1555541150247601 | 277 | 1 | NULL |
1845| 172.16.2.95 | 3306 | 1555541150277275 | 257 | 0 | NULL |
1846| 172.16.2.95 | 3306 | 1555541151747762 | 288 | 0 | NULL |
1847| 172.16.0.66 | 3306 | 1555541151767777 | 260 | 1 | NULL |
1848| 172.16.0.66 | 3306 | 1555541153247985 | 335 | 1 | NULL |
1849| 172.16.2.95 | 3306 | 1555541153273584 | 445 | 0 | NULL |
1850| 172.16.2.95 | 3306 | 1555541154748089 | 348 | 0 | NULL |
1851| 172.16.0.66 | 3306 | 1555541154775447 | 304 | 1 | NULL |
1852| 172.16.2.95 | 3306 | 1555541156248155 | 273 | 0 | NULL |
1853| 172.16.0.66 | 3306 | 1555541156274339 | 264 | 1 | NULL |
1854| 172.16.2.95 | 3306 | 1555541157748346 | 254 | 0 | NULL |
1855| 172.16.0.66 | 3306 | 1555541157770375 | 255 | 1 | NULL |
1856| 172.16.2.95 | 3306 | 1555541159248405 | 256 | 0 | NULL |
1857| 172.16.0.66 | 3306 | 1555541159268699 | 257 | 1 | NULL |
1858| 172.16.2.95 | 3306 | 1555541160748662 | 402 | 0 | NULL |
1859| 172.16.0.66 | 3306 | 1555541160775789 | 327 | 1 | NULL |
1860| 172.16.0.66 | 3306 | 1555541162248757 | 364 | 1 | NULL |
1861| 172.16.2.95 | 3306 | 1555541162277262 | 356 | 0 | NULL |
1862| 172.16.0.66 | 3306 | 1555541163748973 | 334 | 1 | NULL |
1863| 172.16.2.95 | 3306 | 1555541163776149 | 353 | 0 | NULL |
1864| 172.16.2.95 | 3306 | 1555541165249002 | 384 | 0 | NULL |
1865| 172.16.0.66 | 3306 | 1555541165265937 | 323 | 1 | NULL |
1866| 172.16.2.95 | 3306 | 1555541166749086 | 303 | 0 | NULL |
1867| 172.16.0.66 | 3306 | 1555541166772500 | 322 | 1 | NULL |
1868| 172.16.0.66 | 3306 | 1555541168249218 | 261 | 1 | NULL |
1869| 172.16.2.95 | 3306 | 1555541168270344 | 288 | 0 | NULL |
1870| 172.16.0.66 | 3306 | 1555541169749373 | 257 | 1 | NULL |
1871| 172.16.2.95 | 3306 | 1555541169771501 | 396 | 0 | NULL |
1872| 172.16.0.66 | 3306 | 1555541171249429 | 256 | 1 | NULL |
1873| 172.16.2.95 | 3306 | 1555541171275981 | 319 | 0 | NULL |
1874| 172.16.2.95 | 3306 | 1555541172749540 | 372 | 0 | NULL |
1875| 172.16.0.66 | 3306 | 1555541172769419 | 394 | 1 | NULL |
1876| 172.16.0.66 | 3306 | 1555541174249727 | 311 | 1 | NULL |
1877| 172.16.2.95 | 3306 | 1555541174278447 | 382 | 0 | NULL |
1878| 172.16.0.66 | 3306 | 1555541175749827 | 255 | 1 | NULL |
1879| 172.16.2.95 | 3306 | 1555541175777832 | 318 | 0 | NULL |
1880| 172.16.0.66 | 3306 | 1555541177249995 | 256 | 1 | NULL |
1881| 172.16.2.95 | 3306 | 1555541177270425 | 352 | 0 | NULL |
1882| 172.16.0.66 | 3306 | 1555541178750101 | 285 | 1 | NULL |
1883| 172.16.2.95 | 3306 | 1555541178774668 | 407 | 0 | NULL |
1884| 172.16.2.95 | 3306 | 1555541180250235 | 325 | 0 | NULL |
1885| 172.16.0.66 | 3306 | 1555541180272627 | 390 | 1 | NULL |
1886| 172.16.2.95 | 3306 | 1555541181750351 | 263 | 0 | NULL |
1887| 172.16.0.66 | 3306 | 1555541181773120 | 356 | 1 | NULL |
1888| 172.16.0.66 | 3306 | 1555541183250478 | 327 | 1 | NULL |
1889| 172.16.2.95 | 3306 | 1555541183276870 | 378 | 0 | NULL |
1890| 172.16.0.66 | 3306 | 1555541184750691 | 342 | 1 | NULL |
1891| 172.16.2.95 | 3306 | 1555541184768060 | 284 | 0 | NULL |
1892| 172.16.0.66 | 3306 | 1555541186250823 | 584 | 1 | NULL |
1893| 172.16.2.95 | 3306 | 1555541186276395 | 569 | 0 | NULL |
1894| 172.16.0.66 | 3306 | 1555541187750938 | 378 | 1 | NULL |
1895| 172.16.2.95 | 3306 | 1555541187779921 | 282 | 0 | NULL |
1896| 172.16.0.66 | 3306 | 1555541189251011 | 349 | 1 | NULL |
1897| 172.16.2.95 | 3306 | 1555541189274703 | 337 | 0 | NULL |
1898| 172.16.2.95 | 3306 | 1555541190751276 | 372 | 0 | NULL |
1899| 172.16.0.66 | 3306 | 1555541190772915 | 286 | 1 | NULL |
1900| 172.16.2.95 | 3306 | 1555541192251219 | 363 | 0 | NULL |
1901| 172.16.0.66 | 3306 | 1555541192274224 | 319 | 1 | NULL |
1902| 172.16.0.66 | 3306 | 1555541193751445 | 390 | 1 | NULL |
1903| 172.16.2.95 | 3306 | 1555541193781232 | 338 | 0 | NULL |
1904| 172.16.0.66 | 3306 | 1555541195251610 | 390 | 1 | NULL |
1905| 172.16.2.95 | 3306 | 1555541195278208 | 299 | 0 | NULL |
1906| 172.16.2.95 | 3306 | 1555541196751652 | 389 | 0 | NULL |
1907| 172.16.0.66 | 3306 | 1555541196779133 | 283 | 1 | NULL |
1908| 172.16.0.66 | 3306 | 1555541198251709 | 283 | 1 | NULL |
1909| 172.16.2.95 | 3306 | 1555541198275548 | 345 | 0 | NULL |
1910| 172.16.2.95 | 3306 | 1555541199752015 | 327 | 0 | NULL |
1911| 172.16.0.66 | 3306 | 1555541199780902 | 292 | 1 | NULL |
1912| 172.16.2.95 | 3306 | 1555541201252103 | 274 | 0 | NULL |
1913| 172.16.0.66 | 3306 | 1555541201278687 | 279 | 1 | NULL |
1914| 172.16.2.95 | 3306 | 1555541202752152 | 311 | 0 | NULL |
1915| 172.16.0.66 | 3306 | 1555541202768292 | 283 | 1 | NULL |
1916| 172.16.0.66 | 3306 | 1555541204252262 | 190 | 1 | NULL |
1917| 172.16.2.95 | 3306 | 1555541204276885 | 314 | 0 | NULL |
1918| 172.16.2.95 | 3306 | 1555541205752409 | 299 | 0 | NULL |
1919| 172.16.0.66 | 3306 | 1555541205777136 | 301 | 1 | NULL |
1920| 172.16.0.66 | 3306 | 1555541207252539 | 464 | 1 | NULL |
1921| 172.16.2.95 | 3306 | 1555541207278987 | 333 | 0 | NULL |
1922| 172.16.2.95 | 3306 | 1555541208752612 | 383 | 0 | NULL |
1923| 172.16.0.66 | 3306 | 1555541208775491 | 315 | 1 | NULL |
1924| 172.16.2.95 | 3306 | 1555541210252705 | 315 | 0 | NULL |
1925| 172.16.0.66 | 3306 | 1555541210271229 | 278 | 1 | NULL |
1926| 172.16.2.95 | 3306 | 1555541211753085 | 324 | 0 | NULL |
1927| 172.16.0.66 | 3306 | 1555541211770033 | 296 | 1 | NULL |
1928+-------------+------+------------------+-----------------+-----------+-------+
1929***** END OF DUMPING monitor.mysql_server_read_only_log *****
1930
1931***** DUMPING monitor.mysql_server_replication_lag_log *****
1932***** END OF DUMPING monitor.mysql_server_replication_lag_log *****
1933
1934............ END OF DUMPING MONITOR DATABASE ............
1935
1936............ DUMPING HOST PRIORITY FILE ............
1937cat: /var/lib/proxysql/host_priority.conf: No such file or directory
1938............ END OF DUMPING HOST PRIORITY FILE ............
1939
1940............ DUMPING PROXYSQL ADMIN CNF FILE ............
1941# proxysql admin interface credentials.
1942export PROXYSQL_DATADIR='/var/lib/proxysql'
1943export PROXYSQL_USERNAME='admin'
1944export PROXYSQL_PASSWORD='admin'
1945export PROXYSQL_HOSTNAME='localhost'
1946export PROXYSQL_PORT='6032'
1947
1948# PXC admin credentials for connecting to pxc-cluster-node.
1949export CLUSTER_USERNAME='root'
1950export CLUSTER_PASSWORD='sekret'
1951export CLUSTER_HOSTNAME='172.16.0.66'
1952export CLUSTER_PORT='3306'
1953
1954# proxysql monitoring user. proxysql admin script will create this user in pxc to monitor pxc-nodes.
1955export MONITOR_USERNAME='monitor'
1956export MONITOR_PASSWORD='monit0r'
1957
1958# Application user to connect to pxc-node through proxysql
1959export CLUSTER_APP_USERNAME='proxysql_user'
1960export CLUSTER_APP_PASSWORD='passw0rd'
1961
1962# ProxySQL read/write hostgroup
1963export WRITE_HOSTGROUP_ID='10'
1964export READ_HOSTGROUP_ID='11'
1965
1966# ProxySQL read/write configuration mode.
1967export MODE="singlewrite"
1968
1969# Writer-is-reader configuration
1970export WRITER_IS_READER="ondemand"
1971
1972# max_connections default (used only when INSERTing a new mysql_servers entry)
1973export MAX_CONNECTIONS="1000"
1974
1975............ END OF DUMPING PROXYSQL ADMIN CNF FILE ............