Skip to content

Instantly share code, notes, and snippets.

@altmannmarcelo

altmannmarcelo/proxysql-status

Created April 17, 2019 22:47
Show Gist options
  • Save altmannmarcelo/b6d1a6f3704caed4084ab9d5560f87a1 to your computer and use it in GitHub Desktop.
Save altmannmarcelo/b6d1a6f3704caed4084ab9d5560f87a1 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
proxysql-status
............ DUMPING MAIN DATABASE ............
***** DUMPING global_variables *****
+-----------------------------------------------------+--------------------+
| variable_name | variable_value |
+-----------------------------------------------------+--------------------+
| mysql-shun_on_failures | 5 |
| mysql-shun_recovery_time_sec | 10 |
| mysql-query_retries_on_failure | 1 |
| mysql-client_multi_statements | true |
| mysql-connect_retries_delay | 1 |
| mysql-connection_delay_multiplex_ms | 0 |
| mysql-connection_max_age_ms | 0 |
| mysql-connect_timeout_server_max | 10000 |
| mysql-eventslog_filename | |
| mysql-eventslog_filesize | 104857600 |
| mysql-default_charset | utf8 |
| mysql-free_connections_pct | 10 |
| mysql-session_idle_ms | 1000 |
| mysql-have_ssl | false |
| mysql-client_found_rows | true |
| mysql-monitor_enabled | true |
| mysql-monitor_connect_timeout | 600 |
| mysql-monitor_ping_max_failures | 3 |
| mysql-monitor_ping_timeout | 1000 |
| mysql-monitor_read_only_max_timeout_count | 3 |
| mysql-monitor_replication_lag_interval | 10000 |
| mysql-monitor_replication_lag_timeout | 1000 |
| mysql-monitor_groupreplication_healthcheck_interval | 5000 |
| mysql-monitor_groupreplication_healthcheck_timeout | 800 |
| mysql-monitor_galera_healthcheck_interval | 5000 |
| mysql-monitor_galera_healthcheck_timeout | 800 |
| mysql-monitor_replication_lag_use_percona_heartbeat | |
| mysql-monitor_query_interval | 60000 |
| mysql-monitor_query_timeout | 100 |
| mysql-monitor_slave_lag_when_null | 60 |
| mysql-monitor_threads_min | 8 |
| mysql-monitor_threads_max | 128 |
| mysql-monitor_threads_queue_maxsize | 128 |
| mysql-monitor_wait_timeout | true |
| mysql-monitor_writer_is_also_reader | true |
| mysql-max_allowed_packet | 4194304 |
| mysql-throttle_connections_per_sec_to_hostgroup | 1000000 |
| mysql-max_transaction_time | 14400000 |
| mysql-multiplexing | true |
| mysql-forward_autocommit | false |
| mysql-enforce_autocommit_on_reads | false |
| mysql-autocommit_false_not_reusable | false |
| mysql-autocommit_false_is_transaction | false |
| mysql-verbose_query_error | false |
| mysql-hostgroup_manager_verbose | 1 |
| mysql-binlog_reader_connect_retry_msec | 3000 |
| mysql-threshold_query_length | 524288 |
| mysql-threshold_resultset_size | 4194304 |
| mysql-query_digests_max_digest_length | 2048 |
| mysql-query_digests_max_query_length | 65000 |
| mysql-wait_timeout | 28800000 |
| mysql-throttle_max_bytes_per_second_to_client | 0 |
| mysql-throttle_ratio_server_to_client | 0 |
| mysql-max_stmts_per_connection | 20 |
| mysql-max_stmts_cache | 10000 |
| mysql-mirror_max_concurrency | 16 |
| mysql-mirror_max_queue_length | 32000 |
| mysql-default_max_latency_ms | 1000 |
| mysql-query_processor_iterations | 0 |
| mysql-query_processor_regex | 1 |
| mysql-reset_connection_algorithm | 2 |
| mysql-auto_increment_delay_multiplex | 5 |
| mysql-long_query_time | 1000 |
| mysql-query_cache_size_MB | 256 |
| mysql-poll_timeout_on_failure | 100 |
| mysql-server_capabilities | 569867 |
| mysql-kill_backend_connection_when_disconnect | true |
| mysql-session_idle_show_processlist | true |
| mysql-query_digests | true |
| mysql-query_digests_lowercase | false |
| mysql-query_digests_normalize_digest_text | false |
| mysql-query_digests_track_hostname | false |
| mysql-servers_stats | true |
| mysql-default_reconnect | true |
| mysql-ssl_p2s_ca | |
| mysql-ssl_p2s_cert | |
| mysql-ssl_p2s_key | |
| mysql-ssl_p2s_cipher | |
| mysql-init_connect | |
| mysql-ldap_user_variable | |
| mysql-add_ldap_user_comment | |
| mysql-default_sql_mode | |
| mysql-default_time_zone | SYSTEM |
| mysql-connpoll_reset_queue_length | 50 |
| mysql-stats_time_backend_query | false |
| mysql-stats_time_query_processor | false |
| mysql-query_cache_stores_empty_result | true |
| admin-stats_credentials | stats:stats |
| admin-stats_mysql_connections | 60 |
| admin-stats_mysql_connection_pool | 60 |
| admin-stats_mysql_query_cache | 60 |
| admin-stats_system_cpu | 60 |
| admin-stats_system_memory | 60 |
| admin-telnet_admin_ifaces | (null) |
| admin-telnet_stats_ifaces | (null) |
| admin-refresh_interval | 2000 |
| admin-read_only | false |
| admin-hash_passwords | true |
| admin-vacuum_stats | true |
| admin-version | 2.0.3-29-g00f26d5 |
| admin-cluster_username | |
| admin-cluster_password | |
| admin-cluster_check_interval_ms | 1000 |
| admin-cluster_check_status_frequency | 10 |
| admin-cluster_mysql_query_rules_diffs_before_sync | 3 |
| admin-cluster_mysql_servers_diffs_before_sync | 3 |
| admin-cluster_mysql_users_diffs_before_sync | 3 |
| admin-cluster_proxysql_servers_diffs_before_sync | 3 |
| admin-cluster_mysql_query_rules_save_to_disk | true |
| admin-cluster_mysql_servers_save_to_disk | true |
| admin-cluster_mysql_users_save_to_disk | true |
| admin-cluster_proxysql_servers_save_to_disk | true |
| admin-checksum_mysql_query_rules | true |
| admin-checksum_mysql_servers | true |
| admin-checksum_mysql_users | true |
| admin-web_enabled | false |
| admin-web_port | 6080 |
| admin-admin_credentials | admin:admin |
| admin-mysql_ifaces | 0.0.0.0:6032 |
| mysql-threads | 4 |
| mysql-max_connections | 2048 |
| mysql-default_query_delay | 0 |
| mysql-default_query_timeout | 36000000 |
| mysql-have_compress | true |
| mysql-poll_timeout | 2000 |
| mysql-interfaces | 0.0.0.0:6033 |
| mysql-default_schema | information_schema |
| mysql-stacksize | 1048576 |
| mysql-server_version | 5.5.30 |
| mysql-connect_timeout_server | 3000 |
| mysql-monitor_username | monitor |
| mysql-monitor_password | monitor |
| mysql-monitor_history | 600000 |
| mysql-monitor_connect_interval | 60000 |
| mysql-monitor_ping_interval | 10000 |
| mysql-monitor_read_only_interval | 1500 |
| mysql-monitor_read_only_timeout | 500 |
| mysql-ping_interval_server_msec | 120000 |
| mysql-ping_timeout_server | 500 |
| mysql-commands_stats | true |
| mysql-sessions_sort | true |
| mysql-connect_retries_on_failure | 10 |
+-----------------------------------------------------+--------------------+
***** END OF DUMPING global_variables *****
***** DUMPING mysql_collations *****
+------+------------------------------+----------+---------+
| Id | Collation | Charset | Default |
+------+------------------------------+----------+---------+
| 1 | big5_chinese_ci | big5 | Yes |
| 2 | latin2_czech_cs | latin2 | Yes |
| 3 | dec8_swedisch_ci | dec8 | Yes |
| 4 | cp850_general_ci | cp850 | Yes |
| 5 | latin1_german_ci | latin1 | Yes |
| 6 | hp8_english_ci | hp8 | Yes |
| 7 | koi8r_general_ci | koi8r | Yes |
| 8 | latin1_swedish_ci | latin1 | |
| 9 | latin2_general_ci | latin2 | |
| 10 | swe7_swedish_ci | swe7 | Yes |
| 11 | ascii_general_ci | ascii | Yes |
| 12 | ujis_japanese_ci | ujis | Yes |
| 13 | sjis_japanese_ci | sjis | Yes |
| 14 | cp1251_bulgarian_ci | cp1251 | Yes |
| 15 | latin1_danish_ci | latin1 | |
| 16 | hebrew_general_ci | hebrew | Yes |
| 17 | filename | filename | Yes |
| 18 | tis620_thai_ci | tis620 | Yes |
| 19 | euckr_korean_ci | euckr | Yes |
| 20 | latin7_estonian_cs | latin7 | Yes |
| 21 | latin2_hungarian_ci | latin2 | |
| 22 | koi8u_general_ci | koi8u | Yes |
| 23 | cp1251_ukrainian_ci | cp1251 | |
| 24 | gb2312_chinese_ci | gb2312 | Yes |
| 25 | greek_general_ci | greek | Yes |
| 26 | cp1250_general_ci | cp1250 | Yes |
| 27 | latin2_croatian_ci | latin2 | |
| 28 | gbk_chinese_ci | gbk | Yes |
| 29 | cp1257_lithunian_ci | cp1257 | Yes |
| 30 | latin5_turkish_ci | latin5 | Yes |
| 31 | latin1_german2_ci | latin1 | |
| 32 | armscii8_general_ci | armscii8 | Yes |
| 33 | utf8_general_ci | utf8 | Yes |
| 34 | cp1250_czech_cs | cp1250 | |
| 35 | ucs2_general_ci | ucs2 | Yes |
| 36 | cp866_general_ci | cp866 | Yes |
| 37 | keybcs2_general_ci | keybcs2 | Yes |
| 38 | macce_general_ci | macce | Yes |
| 39 | macroman_general_ci | macroman | Yes |
| 40 | cp852_general_ci | cp852 | Yes |
| 41 | latin7_general_ci | latin7 | |
| 42 | latin7_general_cs | latin7 | |
| 43 | macce_bin | macce | |
| 44 | cp1250_croatian_ci | cp1250 | |
| 45 | utf8mb4_general_ci | utf8mb4 | Yes |
| 46 | utf8mb4_bin | utf8mb4 | |
| 47 | latin1_bin | latin1 | |
| 48 | latin1_general_ci | latin1 | |
| 49 | latin1_general_cs | latin1 | |
| 50 | cp1251_bin | cp1251 | |
| 51 | cp1251_general_ci | cp1251 | |
| 52 | cp1251_general_cs | cp1251 | |
| 53 | macroman_bin | macroman | |
| 54 | utf16_general_ci | utf16 | Yes |
| 55 | utf16_bin | utf16 | |
| 56 | utf16_general_ci | utf16le | Yes |
| 57 | cp1256_general_ci | cp1256 | Yes |
| 58 | cp1257_bin | cp1257 | |
| 59 | cp1257_general_ci | cp1257 | |
| 60 | utf32_general_ci | utf32 | Yes |
| 61 | utf32_bin | utf32 | |
| 62 | utf16_bin | utf16le | |
| 63 | binary | binary | Yes |
| 64 | armscii8_bin | armscii8 | |
| 65 | ascii_bin | ascii | |
| 66 | cp1250_bin | cp1250 | |
| 67 | cp1256_bin | cp1256 | |
| 68 | cp866_bin | cp866 | |
| 69 | dec8_bin | dec8 | |
| 70 | greek_bin | greek | |
| 71 | hebrew_bin | hebrew | |
| 72 | hp8_bin | hp8 | |
| 73 | keybcs2_bin | keybcs2 | |
| 74 | koi8r_bin | koi8r | |
| 75 | koi8u_bin | koi8u | |
| 77 | latin2_bin | latin2 | |
| 78 | latin5_bin | latin5 | |
| 79 | latin7_bin | latin7 | |
| 80 | cp850_bin | cp850 | |
| 81 | cp852_bin | cp852 | |
| 82 | swe7_bin | swe7 | |
| 83 | utf8_bin | utf8 | |
| 84 | big5_bin | big5 | |
| 85 | euckr_bin | euckr | |
| 86 | gb2312_bin | gb2312 | |
| 87 | gbk_bin | gbk | |
| 88 | sjis_bin | sjis | |
| 89 | tis620_bin | tis620 | |
| 90 | ucs2_bin | ucs2 | |
| 91 | ujis_bin | ujis | |
| 92 | geostd8_general_ci | geostd8 | Yes |
| 93 | geostd8_bin | geostd8 | |
| 94 | latin1_spanish_ci | latin1 | |
| 95 | cp932_japanese_ci | cp932 | Yes |
| 96 | cp932_bin | cp932 | |
| 97 | eucjpms_japanese_ci | eucjpms | Yes |
| 98 | eucjpms_bin | eucjpms | |
| 99 | cp1250_polish_ci | cp1250 | |
| 101 | utf16_unicode_ci | utf16 | |
| 102 | utf16_icelandic_ci | utf16 | |
| 103 | utf16_latvian_ci | utf16 | |
| 104 | utf16_romanian_ci | utf16 | |
| 105 | utf16_slovenian_ci | utf16 | |
| 106 | utf16_polish_ci | utf16 | |
| 107 | utf16_estonian_ci | utf16 | |
| 108 | utf16_spanish_ci | utf16 | |
| 109 | utf16_swedish_ci | utf16 | |
| 110 | utf16_turkish_ci | utf16 | |
| 111 | utf16_czech_ci | utf16 | |
| 112 | utf16_danish_ci | utf16 | |
| 113 | utf16_lithunian_ci | utf16 | |
| 114 | utf16_slovak_ci | utf16 | |
| 115 | utf16_spanish2_ci | utf16 | |
| 116 | utf16_roman_ci | utf16 | |
| 117 | utf16_persian_ci | utf16 | |
| 118 | utf16_esperanto_ci | utf16 | |
| 119 | utf8_spanish_ci | utf8 | |
| 120 | utf16_sinhala_ci | utf16 | |
| 121 | utf16_german2_ci | utf16 | |
| 122 | utf16_croatian_mysql561_ci | utf16 | |
| 123 | utf16_unicode_520_ci | utf16 | |
| 124 | utf16_vietnamese_ci | utf16 | |
| 128 | ucs2_unicode_ci | ucs2 | |
| 129 | ucs2_icelandic_ci | ucs2 | |
| 130 | ucs2_latvian_ci | ucs2 | |
| 131 | ucs2_romanian_ci | ucs2 | |
| 132 | ucs2_slovenian_ci | ucs2 | |
| 133 | ucs2_polish_ci | ucs2 | |
| 134 | ucs2_estonian_ci | ucs2 | |
| 135 | ucs2_spanish_ci | ucs2 | |
| 136 | ucs2_swedish_ci | ucs2 | |
| 137 | ucs2_turkish_ci | ucs2 | |
| 138 | ucs2_czech_ci | ucs2 | |
| 139 | ucs2_danish_ci | ucs2 | |
| 140 | ucs2_lithunian_ci | ucs2 | |
| 141 | ucs2_slovak_ci | ucs2 | |
| 142 | ucs2_spanish2_ci | ucs2 | |
| 143 | ucs2_roman_ci | ucs2 | |
| 144 | ucs2_persian_ci | ucs2 | |
| 145 | ucs2_esperanto_ci | ucs2 | |
| 146 | ucs2_hungarian_ci | ucs2 | |
| 147 | ucs2_sinhala_ci | ucs2 | |
| 148 | ucs2_german2_ci | ucs2 | |
| 149 | ucs2_croatian_ci | ucs2 | |
| 150 | ucs2_unicode_520_ci | ucs2 | |
| 151 | ucs2_vietnamese_ci | ucs2 | |
| 159 | ucs2_general_mysql500_ci | ucs2 | |
| 160 | utf32_unicode_ci | utf32 | |
| 161 | utf32_icelandic_ci | utf32 | |
| 162 | utf32_latvian_ci | utf32 | |
| 163 | utf32_romanian_ci | utf32 | |
| 164 | utf32_slovenian_ci | utf32 | |
| 165 | utf32_polish_ci | utf32 | |
| 166 | utf32_estonian_ci | utf32 | |
| 167 | utf32_spanish_ci | utf32 | |
| 168 | utf32_swedish_ci | utf32 | |
| 169 | utf32_turkish_ci | utf32 | |
| 170 | utf32_czech_ci | utf32 | |
| 171 | utf32_danish_ci | utf32 | |
| 172 | utf32_lithunian_ci | utf32 | |
| 173 | utf32_slovak_ci | utf32 | |
| 174 | utf32_spanish_ci | utf32 | |
| 175 | utf32_roman_ci | utf32 | |
| 176 | utf32_persian_ci | utf32 | |
| 177 | utf32_esperanto_ci | utf32 | |
| 178 | utf32_hungarian_ci | utf32 | |
| 179 | utf32_sinhala_ci | utf32 | |
| 180 | utf32_german2_ci | utf32 | |
| 181 | utf32_croatian_mysql561_ci | utf32 | |
| 182 | utf32_unicode_520_ci | utf32 | |
| 183 | utf32_vietnamese_ci | utf32 | |
| 192 | utf8_unicode_ci | utf8 | |
| 193 | utf8_icelandic_ci | utf8 | |
| 194 | utf8_latvian_ci | utf8 | |
| 195 | utf8_romanian_ci | utf8 | |
| 196 | utf8_slovenian_ci | utf8 | |
| 197 | utf8_polish_ci | utf8 | |
| 198 | utf8_estonian_ci | utf8 | |
| 199 | utf8_spanish_ci | utf8 | |
| 200 | utf8_swedish_ci | utf8 | |
| 201 | utf8_turkish_ci | utf8 | |
| 202 | utf8_czech_ci | utf8 | |
| 203 | utf8_danish_ci | utf8 | |
| 204 | utf8_lithunian_ci | utf8 | |
| 205 | utf8_slovak_ci | utf8 | |
| 206 | utf8_spanish2_ci | utf8 | |
| 207 | utf8_roman_ci | utf8 | |
| 208 | utf8_persian_ci | utf8 | |
| 209 | utf8_esperanto_ci | utf8 | |
| 210 | utf8_hungarian_ci | utf8 | |
| 211 | utf8_sinhala_ci | utf8 | |
| 212 | utf8_german_ci | utf8 | |
| 213 | utf8_croatian_ci | utf8 | |
| 214 | utf8_unicode_520_ci | utf8 | |
| 215 | utf8_vietnamese_ci | utf8 | |
| 223 | utf8_general_mysql500_ci | utf8 | |
| 224 | utf8mb4_unicode_ci | utf8mb4 | |
| 225 | utf8mb4_icelandic_ci | utf8mb4 | |
| 226 | utf8mb4_latvian_ci | utf8mb4 | |
| 227 | utf8mb4_romanian_ci | utf8mb4 | |
| 228 | utf8mb4_slovenian_ci | utf8mb4 | |
| 229 | utf8mb4_polish_ci | utf8mb4 | |
| 230 | utf8mb4_estonian_ci | utf8mb4 | |
| 231 | utf8mb4_spanish_ci | utf8mb4 | |
| 232 | utf8mb4_swedish_ci | utf8mb4 | |
| 233 | utf8mb4_turkish_ci | utf8mb4 | |
| 234 | utf8mb4_czech_ci | utf8mb4 | |
| 235 | utf8mb4_danish_ci | utf8mb4 | |
| 236 | utf8mb4_lithuanian_ci | utf8mb4 | |
| 237 | utf8mb4_slovak_ci | utf8mb4 | |
| 238 | utf8mb4_spanish2_ci | utf8mb4 | |
| 239 | utf8mb4_roman_ci | utf8mb4 | |
| 240 | utf8mb4_persian_ci | utf8mb4 | |
| 241 | utf8mb4_esperanto_ci | utf8mb4 | |
| 242 | utf8mb4_hungarian_ci | utf8mb4 | |
| 243 | utf8mb4_sinhala_ci | utf8mb4 | |
| 244 | utf8mb4_german2_ci | utf8mb4 | |
| 245 | utf8mb4_croatian_mysql561_ci | utf8mb4 | |
| 246 | utf8mb4_unicode_520_ci | utf8mb4 | |
| 247 | utf8mb4_vietnamese_ci | utf8mb4 | |
| 254 | utf8_general_cs | utf8 | |
| 255 | utf8mb4_0900_ai_ci | utf8mb4 | |
| 576 | utf8_croatian_ci | utf8 | |
| 577 | utf8_myanmar_ci | utf8 | |
| 578 | utf8_thai_520_w2 | utf8 | |
| 608 | utf8mb4_croatian_ci | utf8mb4 | |
| 609 | utf8mb4_myanmar_ci | utf8mb4 | |
| 610 | utf8mb4_thai_520_w2 | utf8mb4 | |
| 640 | ucs2_croatian_ci | ucs2 | |
| 641 | ucs2_myanmar_ci | ucs2 | |
| 642 | ucs2_thai_520_w2 | ucs2 | |
| 672 | utf16_croatian_ci | utf16 | |
| 673 | utf16_myanmar_ci | utf16 | |
| 674 | utf16_thai_520_w2 | utf16 | |
| 736 | utf32_croatian_ci | utf32 | |
| 737 | utf32_myanmar_ci | utf32 | |
| 738 | utf32_thai_520_w2 | utf32 | |
| 1025 | big5_chinese_nopad_ci | big5 | |
| 1027 | dec8_swedisch_nopad_ci | dec8 | |
| 1028 | cp850_general_nopad_ci | cp850 | |
| 1030 | hp8_english_nopad_ci | hp8 | |
| 1031 | koi8r_general_nopad_ci | koi8r | |
| 1032 | latin1_swedish_nopad_ci | latin1 | |
| 1033 | latin2_general_nopad_ci | latin2 | |
| 1034 | swe7_swedish_nopad_ci | swe7 | |
| 1035 | ascii_general_nopad_ci | ascii | |
| 1036 | ujis_japanese_nopad_ci | ujis | |
| 1037 | sjis_japanese_nopad_ci | sjis | |
| 1040 | hebrew_general_nopad_ci | hebrew | |
| 1042 | tis620_thai_nopad_ci | tis620 | |
| 1043 | euckr_korean_nopad_ci | euckr | |
| 1046 | koi8u_general_nopad_ci | koi8u | |
| 1048 | gb2312_chinese_nopad_ci | gb2312 | |
| 1049 | greek_general_nopad_ci | greek | |
| 1050 | cp1250_general_nopad_ci | cp1250 | |
| 1052 | gbk_chinese_nopad_ci | gbk | |
| 1054 | latin5_turkish_nopad_ci | latin5 | |
| 1056 | armscii8_general_nopad_ci | armscii8 | |
| 1057 | utf8_general_nopad_ci | utf8 | |
| 1059 | ucs2_general_nopad_ci | ucs2 | |
| 1060 | cp866_general_nopad_ci | cp866 | |
| 1061 | keybcs2_general_nopad_ci | keybcs2 | |
| 1062 | macce_general_nopad_ci | macce | |
| 1063 | macroman_general_nopad_ci | macroman | |
| 1064 | cp852_general_nopad_ci | cp852 | |
| 1065 | latin7_general_nopad_ci | latin7 | |
| 1067 | macce_nopad_bin | macce | |
| 1069 | utf8mb4_general_nopad_ci | utf8mb4 | |
| 1070 | utf8mb4_general_nopad_bin | utf8mb4 | |
| 1071 | latin1_nopad_bin | latin1 | |
| 1074 | cp1251_nopad_bin | cp1251 | |
| 1075 | cp1251_general_nopad_ci | cp1251 | |
| 1077 | macroman_nopad_bin | macroman | |
| 1078 | utf16_general_nopad_ci | utf16 | |
| 1079 | utf16_nopad_bin | utf16 | |
| 1080 | utf16le_general_nopad_ci | utf16le | |
| 1081 | cp1256_general_nopad_ci | cp1256 | |
| 1082 | cp1257_nopad_bin | cp1257 | |
| 1083 | cp1257_general_nopad_ci | cp1257 | |
| 1084 | utf32_general_nopad_ci | utf32 | |
| 1085 | utf32_nopad_bin | utf32 | |
| 1086 | utf16le_nopad_bin | utf16le | |
| 1088 | armscii8_nopad_bin | armscii8 | |
| 1089 | ascii_nopad_bin | ascii | |
| 1090 | cp1250_nopad_bin | cp1250 | |
| 1091 | cp1256_nopad_bin | cp1256 | |
| 1092 | cp866_nopad_bin | cp866 | |
| 1093 | dec8_nopad_bin | dec8 | |
| 1094 | greek_nopad_bin | greek | |
| 1095 | hebrew_nopad_bin | hebrew | |
| 1096 | hp8_nopad_bin | hp8 | |
| 1097 | keybcs2_nopad_bin | keybcs2 | |
| 1098 | koi8r_nopad_bin | koi8r | |
| 1099 | koi8u_nopad_bin | koi8u | |
| 1101 | latin2_nopad_bin | latin2 | |
| 1102 | latin5_nopad_bin | latin5 | |
| 1103 | latin7_nopad_bin | latin7 | |
| 1104 | cp850_nopad_bin | cp850 | |
| 1105 | cp852_nopad_bin | cp852 | |
| 1106 | swe7_nopad_bin | swe7 | |
| 1107 | utf8_nopad_bin | utf8 | |
| 1108 | big5_nopad_bin | big5 | |
| 1109 | euckr_nopad_bin | euckr | |
| 1110 | gb2312_nopad_bin | gb2312 | |
| 1111 | gbk_nopad_bin | gbk | |
| 1112 | sjis_nopad_bin | sjis | |
| 1113 | tis620_nopad_bin | tis620 | |
| 1114 | ucs2_nopad_bin | ucs2 | |
| 1115 | ujis_nopad_bin | ujis | |
| 1116 | geostd8_general_nopad_ci | geostd8 | |
| 1117 | geostd8_nopad_bin | geostd8 | |
| 1119 | cp932_japanese_nopad_ci | cp932 | |
| 1120 | cp932_nopad_bin | cp932 | |
| 1121 | eucjpms_japanese_nopad_ci | eucjpms | |
| 1122 | eucjpms_nopad_bin | eucjpms | |
| 1125 | utf16_unicode_nopad_ci | utf16 | |
| 1147 | utf16_unicode_520_nopad_ci | utf16 | |
| 1152 | ucs2_unicode_nopad_ci | ucs2 | |
| 1174 | ucs2_unicode_520_nopad_ci | ucs2 | |
| 1184 | utf32_unicode_nopad_ci | utf32 | |
| 1206 | utf32_unicode_520_nopad_ci | utf32 | |
| 1216 | utf8_unicode_nopad_ci | utf8 | |
| 1238 | utf8_unicode_520_nopad_ci | utf8 | |
| 1248 | utf8mb4_unicode_nopad_ci | utf8mb4 | |
| 1270 | utf8mb4_unicode_520_nopad_ci | utf8mb4 | |
+------+------------------------------+----------+---------+
***** END OF DUMPING mysql_collations *****
***** DUMPING mysql_galera_hostgroups *****
***** END OF DUMPING mysql_galera_hostgroups *****
***** DUMPING mysql_group_replication_hostgroups *****
***** END OF DUMPING mysql_group_replication_hostgroups *****
***** DUMPING mysql_query_rules *****
+---------+--------+----------+------------+--------+-------------+------------+------------+--------+---------------------+---------------+----------------------+--------------+---------+-----------------+-----------------------+-----------+--------------------+---------------+-----------+---------+---------+-------+-------------------+----------------+------------------+-----------+--------+-------------+-----------+---------------------+-----+-------+---------+
| 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 |
+---------+--------+----------+------------+--------+-------------+------------+------------+--------+---------------------+---------------+----------------------+--------------+---------+-----------------+-----------------------+-----------+--------------------+---------------+-----------+---------+---------+-------+-------------------+----------------+------------------+-----------+--------+-------------+-----------+---------------------+-----+-------+---------+
| 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 |
| 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 |
+---------+--------+----------+------------+--------+-------------+------------+------------+--------+---------------------+---------------+----------------------+--------------+---------+-----------------+-----------------------+-----------+--------------------+---------------+-----------+---------+---------+-------+-------------------+----------------+------------------+-----------+--------+-------------+-----------+---------------------+-----+-------+---------+
***** END OF DUMPING mysql_query_rules *****
***** DUMPING mysql_query_rules_fast_routing *****
***** END OF DUMPING mysql_query_rules_fast_routing *****
***** DUMPING mysql_replication_hostgroups *****
+------------------+------------------+------------+---------+
| writer_hostgroup | reader_hostgroup | check_type | comment |
+------------------+------------------+------------+---------+
| 10 | 11 | read_only | |
+------------------+------------------+------------+---------+
***** END OF DUMPING mysql_replication_hostgroups *****
***** DUMPING mysql_servers *****
+--------------+-------------+------+-----------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------+
| hostgroup_id | hostname | port | gtid_port | status | weight | compression | max_connections | max_replication_lag | use_ssl | max_latency_ms | comment |
+--------------+-------------+------+-----------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------+
| 11 | 172.16.0.66 | 3306 | 3307 | ONLINE | 1 | 0 | 1000 | 0 | 0 | 0 | |
| 10 | 172.16.2.95 | 3306 | 3307 | ONLINE | 1 | 0 | 1000 | 0 | 0 | 0 | |
+--------------+-------------+------+-----------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------+
***** END OF DUMPING mysql_servers *****
***** DUMPING mysql_users *****
+----------+-------------------------------------------+--------+---------+-------------------+----------------+---------------+------------------------+--------------+---------+----------+-----------------+---------+
| username | password | active | use_ssl | default_hostgroup | default_schema | schema_locked | transaction_persistent | fast_forward | backend | frontend | max_connections | comment |
+----------+-------------------------------------------+--------+---------+-------------------+----------------+---------------+------------------------+--------------+---------+----------+-----------------+---------+
| root | *AF9E01EA8519CE58E3739F4034EFD3D6B4CA6324 | 1 | 0 | 10 | NULL | 0 | 1 | 0 | 1 | 1 | 10000 | |
+----------+-------------------------------------------+--------+---------+-------------------+----------------+---------------+------------------------+--------------+---------+----------+-----------------+---------+
***** END OF DUMPING mysql_users *****
***** DUMPING proxysql_servers *****
***** END OF DUMPING proxysql_servers *****
***** DUMPING runtime_checksums_values *****
+-------------------+---------+------------+--------------------+
| name | version | epoch | checksum |
+-------------------+---------+------------+--------------------+
| admin_variables | 0 | 0 | |
| mysql_query_rules | 1 | 1555540748 | 0x96A5A5183E1B9E6A |
| mysql_servers | 1 | 1555540748 | 0x4DC01171DBFD81E9 |
| mysql_users | 1 | 1555540748 | 0x1F79A3CE59298EBD |
| mysql_variables | 0 | 0 | |
| proxysql_servers | 1 | 1555540748 | 0x0000000000000000 |
+-------------------+---------+------------+--------------------+
***** END OF DUMPING runtime_checksums_values *****
***** DUMPING runtime_global_variables *****
+-----------------------------------------------------+--------------------+
| variable_name | variable_value |
+-----------------------------------------------------+--------------------+
| admin-admin_credentials | admin:admin |
| admin-stats_credentials | stats:stats |
| admin-stats_mysql_connections | 60 |
| admin-stats_mysql_connection_pool | 60 |
| admin-stats_mysql_query_cache | 60 |
| admin-stats_system_cpu | 60 |
| admin-stats_system_memory | 60 |
| admin-mysql_ifaces | 0.0.0.0:6032 |
| admin-telnet_admin_ifaces | (null) |
| admin-telnet_stats_ifaces | (null) |
| admin-refresh_interval | 2000 |
| admin-read_only | false |
| admin-hash_passwords | true |
| admin-vacuum_stats | true |
| admin-version | 2.0.3-29-g00f26d5 |
| admin-cluster_username | |
| admin-cluster_password | |
| admin-cluster_check_interval_ms | 1000 |
| admin-cluster_check_status_frequency | 10 |
| admin-cluster_mysql_query_rules_diffs_before_sync | 3 |
| admin-cluster_mysql_servers_diffs_before_sync | 3 |
| admin-cluster_mysql_users_diffs_before_sync | 3 |
| admin-cluster_proxysql_servers_diffs_before_sync | 3 |
| admin-cluster_mysql_query_rules_save_to_disk | true |
| admin-cluster_mysql_servers_save_to_disk | true |
| admin-cluster_mysql_users_save_to_disk | true |
| admin-cluster_proxysql_servers_save_to_disk | true |
| admin-checksum_mysql_query_rules | true |
| admin-checksum_mysql_servers | true |
| admin-checksum_mysql_users | true |
| admin-web_enabled | false |
| admin-web_port | 6080 |
| mysql-shun_on_failures | 5 |
| mysql-shun_recovery_time_sec | 10 |
| mysql-query_retries_on_failure | 1 |
| mysql-client_multi_statements | true |
| mysql-connect_retries_on_failure | 10 |
| mysql-connect_retries_delay | 1 |
| mysql-connection_delay_multiplex_ms | 0 |
| mysql-connection_max_age_ms | 0 |
| mysql-connect_timeout_server | 3000 |
| mysql-connect_timeout_server_max | 10000 |
| mysql-eventslog_filename | |
| mysql-eventslog_filesize | 104857600 |
| mysql-default_charset | utf8 |
| mysql-free_connections_pct | 10 |
| mysql-session_idle_ms | 1000 |
| mysql-have_ssl | false |
| mysql-have_compress | true |
| mysql-client_found_rows | true |
| mysql-interfaces | 0.0.0.0:6033 |
| mysql-monitor_enabled | true |
| mysql-monitor_history | 600000 |
| mysql-monitor_connect_interval | 60000 |
| mysql-monitor_connect_timeout | 600 |
| mysql-monitor_ping_interval | 10000 |
| mysql-monitor_ping_max_failures | 3 |
| mysql-monitor_ping_timeout | 1000 |
| mysql-monitor_read_only_interval | 1500 |
| mysql-monitor_read_only_timeout | 500 |
| mysql-monitor_read_only_max_timeout_count | 3 |
| mysql-monitor_replication_lag_interval | 10000 |
| mysql-monitor_replication_lag_timeout | 1000 |
| mysql-monitor_groupreplication_healthcheck_interval | 5000 |
| mysql-monitor_groupreplication_healthcheck_timeout | 800 |
| mysql-monitor_galera_healthcheck_interval | 5000 |
| mysql-monitor_galera_healthcheck_timeout | 800 |
| mysql-monitor_username | monitor |
| mysql-monitor_password | monitor |
| mysql-monitor_replication_lag_use_percona_heartbeat | |
| mysql-monitor_query_interval | 60000 |
| mysql-monitor_query_timeout | 100 |
| mysql-monitor_slave_lag_when_null | 60 |
| mysql-monitor_threads_min | 8 |
| mysql-monitor_threads_max | 128 |
| mysql-monitor_threads_queue_maxsize | 128 |
| mysql-monitor_wait_timeout | true |
| mysql-monitor_writer_is_also_reader | true |
| mysql-max_allowed_packet | 4194304 |
| mysql-throttle_connections_per_sec_to_hostgroup | 1000000 |
| mysql-max_transaction_time | 14400000 |
| mysql-multiplexing | true |
| mysql-forward_autocommit | false |
| mysql-enforce_autocommit_on_reads | false |
| mysql-autocommit_false_not_reusable | false |
| mysql-autocommit_false_is_transaction | false |
| mysql-verbose_query_error | false |
| mysql-hostgroup_manager_verbose | 1 |
| mysql-binlog_reader_connect_retry_msec | 3000 |
| mysql-threshold_query_length | 524288 |
| mysql-threshold_resultset_size | 4194304 |
| mysql-query_digests_max_digest_length | 2048 |
| mysql-query_digests_max_query_length | 65000 |
| mysql-wait_timeout | 28800000 |
| mysql-throttle_max_bytes_per_second_to_client | 0 |
| mysql-throttle_ratio_server_to_client | 0 |
| mysql-max_connections | 2048 |
| mysql-max_stmts_per_connection | 20 |
| mysql-max_stmts_cache | 10000 |
| mysql-mirror_max_concurrency | 16 |
| mysql-mirror_max_queue_length | 32000 |
| mysql-default_max_latency_ms | 1000 |
| mysql-default_query_delay | 0 |
| mysql-default_query_timeout | 36000000 |
| mysql-query_processor_iterations | 0 |
| mysql-query_processor_regex | 1 |
| mysql-reset_connection_algorithm | 2 |
| mysql-auto_increment_delay_multiplex | 5 |
| mysql-long_query_time | 1000 |
| mysql-query_cache_size_MB | 256 |
| mysql-ping_interval_server_msec | 120000 |
| mysql-ping_timeout_server | 500 |
| mysql-default_schema | information_schema |
| mysql-poll_timeout | 2000 |
| mysql-poll_timeout_on_failure | 100 |
| mysql-server_capabilities | 569899 |
| mysql-server_version | 5.5.30 |
| mysql-kill_backend_connection_when_disconnect | true |
| mysql-sessions_sort | true |
| mysql-session_idle_show_processlist | true |
| mysql-commands_stats | true |
| mysql-query_digests | true |
| mysql-query_digests_lowercase | false |
| mysql-query_digests_normalize_digest_text | false |
| mysql-query_digests_track_hostname | false |
| mysql-servers_stats | true |
| mysql-default_reconnect | true |
| mysql-ssl_p2s_ca | |
| mysql-ssl_p2s_cert | |
| mysql-ssl_p2s_key | |
| mysql-ssl_p2s_cipher | |
| mysql-stacksize | 1048576 |
| mysql-threads | 4 |
| mysql-init_connect | |
| mysql-ldap_user_variable | |
| mysql-add_ldap_user_comment | |
| mysql-default_sql_mode | |
| mysql-default_time_zone | SYSTEM |
| mysql-connpoll_reset_queue_length | 50 |
| mysql-stats_time_backend_query | false |
| mysql-stats_time_query_processor | false |
| mysql-query_cache_stores_empty_result | true |
+-----------------------------------------------------+--------------------+
***** END OF DUMPING runtime_global_variables *****
***** DUMPING runtime_mysql_galera_hostgroups *****
***** END OF DUMPING runtime_mysql_galera_hostgroups *****
***** DUMPING runtime_mysql_group_replication_hostgroups *****
***** END OF DUMPING runtime_mysql_group_replication_hostgroups *****
***** DUMPING runtime_mysql_query_rules *****
+---------+--------+----------+------------+--------+-------------+------------+------------+--------+---------------------+---------------+----------------------+--------------+---------+-----------------+-----------------------+-----------+--------------------+---------------+-----------+---------+---------+-------+-------------------+----------------+------------------+-----------+--------+-------------+-----------+---------------------+-----+-------+---------+
| 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 |
+---------+--------+----------+------------+--------+-------------+------------+------------+--------+---------------------+---------------+----------------------+--------------+---------+-----------------+-----------------------+-----------+--------------------+---------------+-----------+---------+---------+-------+-------------------+----------------+------------------+-----------+--------+-------------+-----------+---------------------+-----+-------+---------+
| 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 |
| 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 |
+---------+--------+----------+------------+--------+-------------+------------+------------+--------+---------------------+---------------+----------------------+--------------+---------+-----------------+-----------------------+-----------+--------------------+---------------+-----------+---------+---------+-------+-------------------+----------------+------------------+-----------+--------+-------------+-----------+---------------------+-----+-------+---------+
***** END OF DUMPING runtime_mysql_query_rules *****
***** DUMPING runtime_mysql_query_rules_fast_routing *****
***** END OF DUMPING runtime_mysql_query_rules_fast_routing *****
***** DUMPING runtime_mysql_replication_hostgroups *****
+------------------+------------------+------------+---------+
| writer_hostgroup | reader_hostgroup | check_type | comment |
+------------------+------------------+------------+---------+
| 10 | 11 | read_only | |
+------------------+------------------+------------+---------+
***** END OF DUMPING runtime_mysql_replication_hostgroups *****
***** DUMPING runtime_mysql_servers *****
+--------------+-------------+------+-----------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------+
| hostgroup_id | hostname | port | gtid_port | status | weight | compression | max_connections | max_replication_lag | use_ssl | max_latency_ms | comment |
+--------------+-------------+------+-----------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------+
| 11 | 172.16.0.66 | 3306 | 3307 | ONLINE | 1 | 0 | 1000 | 0 | 0 | 0 | |
| 10 | 172.16.2.95 | 3306 | 3307 | ONLINE | 1 | 0 | 1000 | 0 | 0 | 0 | |
+--------------+-------------+------+-----------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------+
***** END OF DUMPING runtime_mysql_servers *****
***** DUMPING runtime_mysql_users *****
+----------+-------------------------------------------+--------+---------+-------------------+----------------+---------------+------------------------+--------------+---------+----------+-----------------+---------+
| username | password | active | use_ssl | default_hostgroup | default_schema | schema_locked | transaction_persistent | fast_forward | backend | frontend | max_connections | comment |
+----------+-------------------------------------------+--------+---------+-------------------+----------------+---------------+------------------------+--------------+---------+----------+-----------------+---------+
| root | *AF9E01EA8519CE58E3739F4034EFD3D6B4CA6324 | 1 | 0 | 10 | | 0 | 1 | 0 | 0 | 1 | 10000 | |
| root | *AF9E01EA8519CE58E3739F4034EFD3D6B4CA6324 | 1 | 0 | 10 | | 0 | 1 | 0 | 1 | 0 | 10000 | |
+----------+-------------------------------------------+--------+---------+-------------------+----------------+---------------+------------------------+--------------+---------+----------+-----------------+---------+
***** END OF DUMPING runtime_mysql_users *****
***** DUMPING runtime_proxysql_servers *****
***** END OF DUMPING runtime_proxysql_servers *****
***** DUMPING runtime_scheduler *****
***** END OF DUMPING runtime_scheduler *****
***** DUMPING scheduler *****
***** END OF DUMPING scheduler *****
............ END OF DUMPING MAIN DATABASE ............
............ DUMPING STATS DATABASE ............
***** DUMPING stats.global_variables *****
+-----------------------------------------------------+--------------------+
| variable_name | variable_value |
+-----------------------------------------------------+--------------------+
| mysql-shun_on_failures | 5 |
| mysql-shun_recovery_time_sec | 10 |
| mysql-query_retries_on_failure | 1 |
| mysql-client_multi_statements | true |
| mysql-connect_retries_delay | 1 |
| mysql-connection_delay_multiplex_ms | 0 |
| mysql-connection_max_age_ms | 0 |
| mysql-connect_timeout_server_max | 10000 |
| mysql-eventslog_filename | |
| mysql-eventslog_filesize | 104857600 |
| mysql-default_charset | utf8 |
| mysql-free_connections_pct | 10 |
| mysql-session_idle_ms | 1000 |
| mysql-have_ssl | false |
| mysql-client_found_rows | true |
| mysql-monitor_enabled | true |
| mysql-monitor_connect_timeout | 600 |
| mysql-monitor_ping_max_failures | 3 |
| mysql-monitor_ping_timeout | 1000 |
| mysql-monitor_read_only_max_timeout_count | 3 |
| mysql-monitor_replication_lag_interval | 10000 |
| mysql-monitor_replication_lag_timeout | 1000 |
| mysql-monitor_groupreplication_healthcheck_interval | 5000 |
| mysql-monitor_groupreplication_healthcheck_timeout | 800 |
| mysql-monitor_galera_healthcheck_interval | 5000 |
| mysql-monitor_galera_healthcheck_timeout | 800 |
| mysql-monitor_replication_lag_use_percona_heartbeat | |
| mysql-monitor_query_interval | 60000 |
| mysql-monitor_query_timeout | 100 |
| mysql-monitor_slave_lag_when_null | 60 |
| mysql-monitor_threads_min | 8 |
| mysql-monitor_threads_max | 128 |
| mysql-monitor_threads_queue_maxsize | 128 |
| mysql-monitor_wait_timeout | true |
| mysql-monitor_writer_is_also_reader | true |
| mysql-max_allowed_packet | 4194304 |
| mysql-throttle_connections_per_sec_to_hostgroup | 1000000 |
| mysql-max_transaction_time | 14400000 |
| mysql-multiplexing | true |
| mysql-forward_autocommit | false |
| mysql-enforce_autocommit_on_reads | false |
| mysql-autocommit_false_not_reusable | false |
| mysql-autocommit_false_is_transaction | false |
| mysql-verbose_query_error | false |
| mysql-hostgroup_manager_verbose | 1 |
| mysql-binlog_reader_connect_retry_msec | 3000 |
| mysql-threshold_query_length | 524288 |
| mysql-threshold_resultset_size | 4194304 |
| mysql-query_digests_max_digest_length | 2048 |
| mysql-query_digests_max_query_length | 65000 |
| mysql-wait_timeout | 28800000 |
| mysql-throttle_max_bytes_per_second_to_client | 0 |
| mysql-throttle_ratio_server_to_client | 0 |
| mysql-max_stmts_per_connection | 20 |
| mysql-max_stmts_cache | 10000 |
| mysql-mirror_max_concurrency | 16 |
| mysql-mirror_max_queue_length | 32000 |
| mysql-default_max_latency_ms | 1000 |
| mysql-query_processor_iterations | 0 |
| mysql-query_processor_regex | 1 |
| mysql-reset_connection_algorithm | 2 |
| mysql-auto_increment_delay_multiplex | 5 |
| mysql-long_query_time | 1000 |
| mysql-query_cache_size_MB | 256 |
| mysql-poll_timeout_on_failure | 100 |
| mysql-server_capabilities | 569867 |
| mysql-kill_backend_connection_when_disconnect | true |
| mysql-session_idle_show_processlist | true |
| mysql-query_digests | true |
| mysql-query_digests_lowercase | false |
| mysql-query_digests_normalize_digest_text | false |
| mysql-query_digests_track_hostname | false |
| mysql-servers_stats | true |
| mysql-default_reconnect | true |
| mysql-ssl_p2s_ca | |
| mysql-ssl_p2s_cert | |
| mysql-ssl_p2s_key | |
| mysql-ssl_p2s_cipher | |
| mysql-init_connect | |
| mysql-ldap_user_variable | |
| mysql-add_ldap_user_comment | |
| mysql-default_sql_mode | |
| mysql-default_time_zone | SYSTEM |
| mysql-connpoll_reset_queue_length | 50 |
| mysql-stats_time_backend_query | false |
| mysql-stats_time_query_processor | false |
| mysql-query_cache_stores_empty_result | true |
| admin-stats_credentials | stats:stats |
| admin-stats_mysql_connections | 60 |
| admin-stats_mysql_connection_pool | 60 |
| admin-stats_mysql_query_cache | 60 |
| admin-stats_system_cpu | 60 |
| admin-stats_system_memory | 60 |
| admin-telnet_admin_ifaces | (null) |
| admin-telnet_stats_ifaces | (null) |
| admin-refresh_interval | 2000 |
| admin-read_only | false |
| admin-hash_passwords | true |
| admin-vacuum_stats | true |
| admin-version | 2.0.3-29-g00f26d5 |
| admin-cluster_username | |
| admin-cluster_password | |
| admin-cluster_check_interval_ms | 1000 |
| admin-cluster_check_status_frequency | 10 |
| admin-cluster_mysql_query_rules_diffs_before_sync | 3 |
| admin-cluster_mysql_servers_diffs_before_sync | 3 |
| admin-cluster_mysql_users_diffs_before_sync | 3 |
| admin-cluster_proxysql_servers_diffs_before_sync | 3 |
| admin-cluster_mysql_query_rules_save_to_disk | true |
| admin-cluster_mysql_servers_save_to_disk | true |
| admin-cluster_mysql_users_save_to_disk | true |
| admin-cluster_proxysql_servers_save_to_disk | true |
| admin-checksum_mysql_query_rules | true |
| admin-checksum_mysql_servers | true |
| admin-checksum_mysql_users | true |
| admin-web_enabled | false |
| admin-web_port | 6080 |
| admin-admin_credentials | admin:admin |
| admin-mysql_ifaces | 0.0.0.0:6032 |
| mysql-threads | 4 |
| mysql-max_connections | 2048 |
| mysql-default_query_delay | 0 |
| mysql-default_query_timeout | 36000000 |
| mysql-have_compress | true |
| mysql-poll_timeout | 2000 |
| mysql-interfaces | 0.0.0.0:6033 |
| mysql-default_schema | information_schema |
| mysql-stacksize | 1048576 |
| mysql-server_version | 5.5.30 |
| mysql-connect_timeout_server | 3000 |
| mysql-monitor_username | monitor |
| mysql-monitor_password | monitor |
| mysql-monitor_history | 600000 |
| mysql-monitor_connect_interval | 60000 |
| mysql-monitor_ping_interval | 10000 |
| mysql-monitor_read_only_interval | 1500 |
| mysql-monitor_read_only_timeout | 500 |
| mysql-ping_interval_server_msec | 120000 |
| mysql-ping_timeout_server | 500 |
| mysql-commands_stats | true |
| mysql-sessions_sort | true |
| mysql-connect_retries_on_failure | 10 |
+-----------------------------------------------------+--------------------+
***** END OF DUMPING stats.global_variables *****
***** DUMPING stats.stats_memory_metrics *****
+------------------------------+----------------+
| Variable_Name | Variable_Value |
+------------------------------+----------------+
| SQLite3_memory_bytes | 2875016 |
| jemalloc_resident | 16048128 |
| jemalloc_active | 12521472 |
| jemalloc_allocated | 10230272 |
| jemalloc_mapped | 52428800 |
| jemalloc_metadata | 4233984 |
| jemalloc_retained | 0 |
| Auth_memory | 706 |
| query_digest_memory | 1814 |
| mysql_query_rules_memory | 8065 |
| stack_memory_mysql_threads | 33554432 |
| stack_memory_admin_threads | 8388608 |
| stack_memory_cluster_threads | 0 |
+------------------------------+----------------+
***** END OF DUMPING stats.stats_memory_metrics *****
***** DUMPING stats.stats_mysql_commands_counters *****
+-------------------+---------------+-----------+-----------+-----------+---------+---------+----------+----------+-----------+-----------+--------+--------+---------+----------+
| 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 |
+-------------------+---------------+-----------+-----------+-----------+---------+---------+----------+----------+-----------+-----------+--------+--------+---------+----------+
| ALTER_TABLE | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| ALTER_VIEW | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| ANALYZE_TABLE | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| BEGIN | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| CALL | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| CHANGE_MASTER | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| COMMIT | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| CREATE_DATABASE | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| CREATE_INDEX | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| CREATE_TABLE | 242026 | 3 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 1 | 0 | 0 | 0 | 0 |
| CREATE_TEMPORARY | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| CREATE_TRIGGER | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| CREATE_USER | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| CREATE_VIEW | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| DEALLOCATE | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| DELETE | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| DESCRIBE | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| DROP_DATABASE | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| DROP_INDEX | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| DROP_TABLE | 79473 | 3 | 0 | 0 | 0 | 0 | 0 | 3 | 0 | 0 | 0 | 0 | 0 | 0 |
| DROP_TRIGGER | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| DROP_USER | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| DROP_VIEW | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| GRANT | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| EXECUTE | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| EXPLAIN | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| FLUSH | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| INSERT | 3200233 | 45 | 0 | 0 | 0 | 2 | 13 | 10 | 7 | 13 | 0 | 0 | 0 | 0 |
| KILL | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| LOAD | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| LOCK_TABLE | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| OPTIMIZE | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| PREPARE | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| PURGE | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| RENAME_TABLE | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| RESET_MASTER | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| RESET_SLAVE | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| REPLACE | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| REVOKE | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| ROLLBACK | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| SAVEPOINT | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| SELECT | 182068 | 532 | 0 | 481 | 49 | 0 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| SELECT_FOR_UPDATE | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| SET | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| SHOW_TABLE_STATUS | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| START_TRANSACTION | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| TRUNCATE_TABLE | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| UNLOCK_TABLES | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| UPDATE | 1962837 | 146 | 0 | 0 | 0 | 59 | 30 | 55 | 2 | 0 | 0 | 0 | 0 | 0 |
| USE | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| SHOW | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| UNKNOWN | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
+-------------------+---------------+-----------+-----------+-----------+---------+---------+----------+----------+-----------+-----------+--------+--------+---------+----------+
***** END OF DUMPING stats.stats_mysql_commands_counters *****
***** DUMPING stats.stats_mysql_connection_pool *****
+-----------+-------------+----------+--------+----------+----------+--------+---------+-------------+---------+-------------------+-----------------+-----------------+------------+
| hostgroup | srv_host | srv_port | status | ConnUsed | ConnFree | ConnOK | ConnERR | MaxConnUsed | Queries | Queries_GTID_sync | Bytes_data_sent | Bytes_data_recv | Latency_us |
+-----------+-------------+----------+--------+----------+----------+--------+---------+-------------+---------+-------------------+-----------------+-----------------+------------+
| 11 | 172.16.0.66 | 3306 | ONLINE | 0 | 1 | 0 | 0 | 1 | 170 | 170 | 8427 | 658 | 284 |
| 10 | 172.16.2.95 | 3306 | ONLINE | 0 | 1 | 0 | 0 | 1 | 65 | 5 | 4720 | 0 | 215 |
+-----------+-------------+----------+--------+----------+----------+--------+---------+-------------+---------+-------------------+-----------------+-----------------+------------+
***** END OF DUMPING stats.stats_mysql_connection_pool *****
***** DUMPING stats.stats_mysql_connection_pool_reset *****
+-----------+-------------+----------+--------+----------+----------+--------+---------+-------------+---------+-------------------+-----------------+-----------------+------------+
| hostgroup | srv_host | srv_port | status | ConnUsed | ConnFree | ConnOK | ConnERR | MaxConnUsed | Queries | Queries_GTID_sync | Bytes_data_sent | Bytes_data_recv | Latency_us |
+-----------+-------------+----------+--------+----------+----------+--------+---------+-------------+---------+-------------------+-----------------+-----------------+------------+
| 11 | 172.16.0.66 | 3306 | ONLINE | 0 | 1 | 0 | 0 | 1 | 170 | 170 | 8427 | 658 | 284 |
| 10 | 172.16.2.95 | 3306 | ONLINE | 0 | 1 | 0 | 0 | 1 | 65 | 5 | 4720 | 0 | 215 |
+-----------+-------------+----------+--------+----------+----------+--------+---------+-------------+---------+-------------------+-----------------+-----------------+------------+
***** END OF DUMPING stats.stats_mysql_connection_pool_reset *****
***** DUMPING stats.stats_mysql_errors *****
***** END OF DUMPING stats.stats_mysql_errors *****
***** DUMPING stats.stats_mysql_errors_reset *****
***** END OF DUMPING stats.stats_mysql_errors_reset *****
***** DUMPING stats.stats_mysql_global *****
+-----------------------------------------+----------------+
| Variable_Name | Variable_Value |
+-----------------------------------------+----------------+
| ProxySQL_Uptime | 463 |
| Active_Transactions | 0 |
| Client_Connections_aborted | 0 |
| Client_Connections_connected | 1 |
| Client_Connections_created | 3 |
| Server_Connections_aborted | 0 |
| Server_Connections_connected | 2 |
| Server_Connections_created | 2 |
| Server_Connections_delayed | 0 |
| Client_Connections_non_idle | 1 |
| Queries_backends_bytes_recv | 2043 |
| Queries_backends_bytes_sent | 40878 |
| Queries_frontends_bytes_recv | 44830 |
| Queries_frontends_bytes_sent | 48350 |
| Query_Processor_time_nsec | 0 |
| Backend_query_time_nsec | 0 |
| mysql_backend_buffers_bytes | 0 |
| mysql_frontend_buffers_bytes | 65536 |
| mysql_session_internal_bytes | 14024 |
| Com_autocommit | 0 |
| Com_autocommit_filtered | 0 |
| Com_commit | 0 |
| Com_commit_filtered | 0 |
| Com_rollback | 0 |
| Com_rollback_filtered | 0 |
| Com_backend_change_user | 0 |
| Com_backend_init_db | 0 |
| Com_backend_set_names | 2 |
| Com_frontend_init_db | 0 |
| Com_frontend_set_names | 0 |
| Com_frontend_use_db | 0 |
| Com_backend_stmt_prepare | 0 |
| Com_backend_stmt_execute | 0 |
| Com_backend_stmt_close | 0 |
| Com_frontend_stmt_prepare | 0 |
| Com_frontend_stmt_execute | 0 |
| Com_frontend_stmt_close | 0 |
| Mirror_concurrency | 0 |
| Mirror_queue_length | 0 |
| Questions | 737 |
| Slow_queries | 0 |
| GTID_consistent_queries | 553 |
| GTID_session_collected | 737 |
| Servers_table_version | 1 |
| MySQL_Thread_Workers | 4 |
| Access_Denied_Wrong_Password | 0 |
| Access_Denied_Max_Connections | 0 |
| Access_Denied_Max_User_Connections | 0 |
| MySQL_Monitor_Workers | 2 |
| MySQL_Monitor_Workers_Aux | 0 |
| MySQL_Monitor_Workers_Started | 2 |
| MySQL_Monitor_connect_check_OK | 16 |
| MySQL_Monitor_connect_check_ERR | 0 |
| MySQL_Monitor_ping_check_OK | 94 |
| MySQL_Monitor_ping_check_ERR | 0 |
| MySQL_Monitor_read_only_check_OK | 620 |
| MySQL_Monitor_read_only_check_ERR | 0 |
| MySQL_Monitor_replication_lag_check_OK | 0 |
| MySQL_Monitor_replication_lag_check_ERR | 0 |
| ConnPool_get_conn_immediate | 0 |
| ConnPool_get_conn_success | 680 |
| ConnPool_get_conn_failure | 0 |
| generated_error_packets | 0 |
| max_connect_timeouts | 0 |
| mysql_unexpected_frontend_com_quit | 0 |
| mysql_unexpected_frontend_packets | 0 |
| mysql_killed_backend_connections | 0 |
| mysql_killed_backend_queries | 0 |
| MyHGM_myconnpoll_get | 680 |
| MyHGM_myconnpoll_get_ok | 680 |
| MyHGM_myconnpoll_push | 684 |
| MyHGM_myconnpoll_destroy | 0 |
| MyHGM_myconnpoll_reset | 0 |
| SQLite3_memory_bytes | 2726608 |
| ConnPool_memory_bytes | 142832 |
| Stmt_Client_Active_Total | 0 |
| Stmt_Client_Active_Unique | 0 |
| Stmt_Server_Active_Total | 0 |
| Stmt_Server_Active_Unique | 0 |
| Stmt_Max_Stmt_id | 1 |
| Stmt_Cached | 0 |
| Query_Cache_Memory_bytes | 0 |
| Query_Cache_count_GET | 0 |
| Query_Cache_count_GET_OK | 0 |
| Query_Cache_count_SET | 0 |
| Query_Cache_bytes_IN | 0 |
| Query_Cache_bytes_OUT | 0 |
| Query_Cache_Purged | 0 |
| Query_Cache_Entries | 0 |
+-----------------------------------------+----------------+
***** END OF DUMPING stats.stats_mysql_global *****
***** DUMPING stats.stats_mysql_gtid_executed *****
+-------------+------+----------------------------------------------+--------+
| hostname | port | gtid_executed | events |
+-------------+------+----------------------------------------------+--------+
| 172.16.2.95 | 3306 | da1bb000-5c9c-11e9-9ee7-00163efabac0:1-42980 | 199 |
| 172.16.0.66 | 3306 | da1bb000-5c9c-11e9-9ee7-00163efabac0:1-42980 | 199 |
+-------------+------+----------------------------------------------+--------+
***** END OF DUMPING stats.stats_mysql_gtid_executed *****
***** DUMPING stats.stats_mysql_prepared_statements_info *****
***** END OF DUMPING stats.stats_mysql_prepared_statements_info *****
***** DUMPING stats.stats_mysql_processlist *****
+----------+-----------+------+------+-----------+----------+-----------+------------+------------+----------+----------+---------+---------+------+--------------+
| 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 |
+----------+-----------+------+------+-----------+----------+-----------+------------+------------+----------+----------+---------+---------+------+--------------+
| 0 | 102 | root | test | 127.0.0.1 | 49220 | 11 | | | | | Sleep | 0 | | |
+----------+-----------+------+------+-----------+----------+-----------+------------+------------+----------+----------+---------+---------+------+--------------+
***** END OF DUMPING stats.stats_mysql_processlist *****
***** DUMPING stats.stats_mysql_query_digest *****
+-----------+------------+----------+----------------+--------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+------------+------------+------------+----------+----------+----------+
| hostgroup | schemaname | username | client_address | digest | digest_text | count_star | first_seen | last_seen | sum_time | min_time | max_time |
+-----------+------------+----------+----------------+--------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+------------+------------+------------+----------+----------+----------+
| 11 | test | root | | 0x869A81B2AE83431F | SELECT i FROM joinit WHERE t = ? AND i = ? | 95 | 1555541186 | 1555541211 | 42968 | 223 | 677 |
| 10 | test | root | | 0x92FC0B0F9F916A47 | UPDATE joinit SET t = ? WHERE i = ? | 48 | 1555541186 | 1555541211 | 701448 | 2732 | 54967 |
| 11 | test | root | | 0x9B65D8F9B12E2326 | SELECT i FROM joinit WHERE i = ? | 74 | 1555541186 | 1555541211 | 16506 | 141 | 431 |
| 11 | test | root | | 0x837785298A10154B | SELECT MAX(i) FROM joinit | 1 | 1555541184 | 1555541184 | 716 | 716 | 716 |
| 10 | test | root | | 0x73ECE4DA4FCFFEB4 | INSERT INTO test.joinit SELECT NULL, uuid(), time(?), (FLOOR( ? + RAND( ) *? )) FROM test.joinit; | 14 | 1555541183 | 1555541184 | 1217309 | 4878 | 346755 |
| 10 | test | root | | 0x4C3A40F1B0C4126A | INSERT INTO test.joinit VALUES (NULL, uuid(), time(?), (FLOOR( ? + RAND( ) *? ))); | 1 | 1555541183 | 1555541183 | 26979 | 26979 | 26979 |
| 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 |
| 10 | test | root | | 0x2C7732A79C6CB9E6 | DROP TABLE IF EXISTS joinit | 1 | 1555541183 | 1555541183 | 19909 | 19909 | 19909 |
+-----------+------------+----------+----------------+--------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+------------+------------+------------+----------+----------+----------+
***** END OF DUMPING stats.stats_mysql_query_digest *****
***** DUMPING stats.stats_mysql_query_digest_reset *****
+-----------+------------+----------+----------------+--------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+------------+------------+------------+----------+----------+----------+
| hostgroup | schemaname | username | client_address | digest | digest_text | count_star | first_seen | last_seen | sum_time | min_time | max_time |
+-----------+------------+----------+----------------+--------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+------------+------------+------------+----------+----------+----------+
| 11 | test | root | | 0x869A81B2AE83431F | SELECT i FROM joinit WHERE t = ? AND i = ? | 95 | 1555541186 | 1555541211 | 42968 | 223 | 677 |
| 10 | test | root | | 0x92FC0B0F9F916A47 | UPDATE joinit SET t = ? WHERE i = ? | 48 | 1555541186 | 1555541211 | 701448 | 2732 | 54967 |
| 11 | test | root | | 0x9B65D8F9B12E2326 | SELECT i FROM joinit WHERE i = ? | 74 | 1555541186 | 1555541211 | 16506 | 141 | 431 |
| 11 | test | root | | 0x837785298A10154B | SELECT MAX(i) FROM joinit | 1 | 1555541184 | 1555541184 | 716 | 716 | 716 |
| 10 | test | root | | 0x73ECE4DA4FCFFEB4 | INSERT INTO test.joinit SELECT NULL, uuid(), time(?), (FLOOR( ? + RAND( ) *? )) FROM test.joinit; | 14 | 1555541183 | 1555541184 | 1217309 | 4878 | 346755 |
| 10 | test | root | | 0x4C3A40F1B0C4126A | INSERT INTO test.joinit VALUES (NULL, uuid(), time(?), (FLOOR( ? + RAND( ) *? ))); | 1 | 1555541183 | 1555541183 | 26979 | 26979 | 26979 |
| 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 |
| 10 | test | root | | 0x2C7732A79C6CB9E6 | DROP TABLE IF EXISTS joinit | 1 | 1555541183 | 1555541183 | 19909 | 19909 | 19909 |
+-----------+------------+----------+----------------+--------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+------------+------------+------------+----------+----------+----------+
***** END OF DUMPING stats.stats_mysql_query_digest_reset *****
***** DUMPING stats.stats_mysql_query_rules *****
+---------+------+
| rule_id | hits |
+---------+------+
| 200 | 0 |
| 201 | 532 |
+---------+------+
***** END OF DUMPING stats.stats_mysql_query_rules *****
***** DUMPING stats.stats_mysql_users *****
+----------+----------------------+--------------------------+
| username | frontend_connections | frontend_max_connections |
+----------+----------------------+--------------------------+
| root | 1 | 10000 |
+----------+----------------------+--------------------------+
***** END OF DUMPING stats.stats_mysql_users *****
***** DUMPING stats.stats_proxysql_servers_checksums *****
***** END OF DUMPING stats.stats_proxysql_servers_checksums *****
***** DUMPING stats.stats_proxysql_servers_metrics *****
***** END OF DUMPING stats.stats_proxysql_servers_metrics *****
***** DUMPING stats.stats_proxysql_servers_status *****
***** END OF DUMPING stats.stats_proxysql_servers_status *****
............ END OF DUMPING STATS DATABASE ............
............ DUMPING MONITOR DATABASE ............
***** DUMPING monitor.mysql_server_connect_log *****
+-------------+------+------------------+-------------------------+---------------+
| hostname | port | time_start_us | connect_success_time_us | connect_error |
+-------------+------+------------------+-------------------------+---------------+
| 172.16.2.95 | 3306 | 1555540748214267 | 3937 | NULL |
| 172.16.0.66 | 3306 | 1555540748910882 | 727 | NULL |
| 172.16.0.66 | 3306 | 1555540808212311 | 937 | NULL |
| 172.16.2.95 | 3306 | 1555540809311959 | 1231 | NULL |
| 172.16.2.95 | 3306 | 1555540868212359 | 1146 | NULL |
| 172.16.0.66 | 3306 | 1555540869313581 | 746 | NULL |
| 172.16.0.66 | 3306 | 1555540928212497 | 855 | NULL |
| 172.16.2.95 | 3306 | 1555540929286425 | 876 | NULL |
| 172.16.0.66 | 3306 | 1555540988212620 | 898 | NULL |
| 172.16.2.95 | 3306 | 1555540989148268 | 1065 | NULL |
| 172.16.2.95 | 3306 | 1555541048212749 | 1189 | NULL |
| 172.16.0.66 | 3306 | 1555541049241638 | 754 | NULL |
| 172.16.2.95 | 3306 | 1555541108212927 | 929 | NULL |
| 172.16.0.66 | 3306 | 1555541109123691 | 825 | NULL |
| 172.16.0.66 | 3306 | 1555541168213071 | 823 | NULL |
| 172.16.2.95 | 3306 | 1555541168948974 | 954 | NULL |
+-------------+------+------------------+-------------------------+---------------+
***** END OF DUMPING monitor.mysql_server_connect_log *****
***** DUMPING monitor.mysql_server_galera_log *****
***** END OF DUMPING monitor.mysql_server_galera_log *****
***** DUMPING monitor.mysql_server_group_replication_log *****
***** END OF DUMPING monitor.mysql_server_group_replication_log *****
***** DUMPING monitor.mysql_server_ping_log *****
+-------------+------+------------------+----------------------+------------+
| hostname | port | time_start_us | ping_success_time_us | ping_error |
+-------------+------+------------------+----------------------+------------+
| 172.16.0.66 | 3306 | 1555540748215933 | 106 | NULL |
| 172.16.2.95 | 3306 | 1555540748327713 | 221 | NULL |
| 172.16.0.66 | 3306 | 1555540758214606 | 263 | NULL |
| 172.16.2.95 | 3306 | 1555540758348072 | 221 | NULL |
| 172.16.0.66 | 3306 | 1555540768213183 | 406 | NULL |
| 172.16.2.95 | 3306 | 1555540768390286 | 244 | NULL |
| 172.16.0.66 | 3306 | 1555540778214987 | 245 | NULL |
| 172.16.2.95 | 3306 | 1555540778323316 | 199 | NULL |
| 172.16.2.95 | 3306 | 1555540788213404 | 208 | NULL |
| 172.16.0.66 | 3306 | 1555540788381138 | 189 | NULL |
| 172.16.0.66 | 3306 | 1555540798213574 | 230 | NULL |
| 172.16.2.95 | 3306 | 1555540798320673 | 270 | NULL |
| 172.16.2.95 | 3306 | 1555540808213646 | 188 | NULL |
| 172.16.0.66 | 3306 | 1555540808351595 | 205 | NULL |
| 172.16.2.95 | 3306 | 1555540818215569 | 199 | NULL |
| 172.16.0.66 | 3306 | 1555540818389038 | 253 | NULL |
| 172.16.2.95 | 3306 | 1555540828215677 | 211 | NULL |
| 172.16.0.66 | 3306 | 1555540828332793 | 285 | NULL |
| 172.16.2.95 | 3306 | 1555540838214141 | 251 | NULL |
| 172.16.0.66 | 3306 | 1555540838332902 | 196 | NULL |
| 172.16.2.95 | 3306 | 1555540848214166 | 136 | NULL |
| 172.16.0.66 | 3306 | 1555540848374686 | 225 | NULL |
| 172.16.2.95 | 3306 | 1555540858214338 | 197 | NULL |
| 172.16.0.66 | 3306 | 1555540858404215 | 194 | NULL |
| 172.16.0.66 | 3306 | 1555540868214453 | 196 | NULL |
| 172.16.2.95 | 3306 | 1555540868363879 | 196 | NULL |
| 172.16.2.95 | 3306 | 1555540878214601 | 193 | NULL |
| 172.16.0.66 | 3306 | 1555540878385073 | 195 | NULL |
| 172.16.0.66 | 3306 | 1555540888214712 | 198 | NULL |
| 172.16.2.95 | 3306 | 1555540888340042 | 198 | NULL |
| 172.16.2.95 | 3306 | 1555540898214842 | 212 | NULL |
| 172.16.0.66 | 3306 | 1555540898382033 | 190 | NULL |
| 172.16.0.66 | 3306 | 1555540908214962 | 193 | NULL |
| 172.16.2.95 | 3306 | 1555540908378938 | 195 | NULL |
| 172.16.0.66 | 3306 | 1555540918215099 | 195 | NULL |
| 172.16.2.95 | 3306 | 1555540918402587 | 204 | NULL |
| 172.16.0.66 | 3306 | 1555540928215184 | 197 | NULL |
| 172.16.2.95 | 3306 | 1555540928321463 | 190 | NULL |
| 172.16.2.95 | 3306 | 1555540938215311 | 197 | NULL |
| 172.16.0.66 | 3306 | 1555540938383826 | 262 | NULL |
| 172.16.0.66 | 3306 | 1555540948215443 | 197 | NULL |
| 172.16.2.95 | 3306 | 1555540948367733 | 198 | NULL |
| 172.16.0.66 | 3306 | 1555540958215514 | 194 | NULL |
| 172.16.2.95 | 3306 | 1555540958327758 | 207 | NULL |
| 172.16.2.95 | 3306 | 1555540968215633 | 210 | NULL |
| 172.16.0.66 | 3306 | 1555540968341142 | 196 | NULL |
| 172.16.0.66 | 3306 | 1555540978215762 | 230 | NULL |
| 172.16.2.95 | 3306 | 1555540978322420 | 203 | NULL |
| 172.16.0.66 | 3306 | 1555540988215886 | 193 | NULL |
| 172.16.2.95 | 3306 | 1555540988376639 | 223 | NULL |
| 172.16.2.95 | 3306 | 1555540998216047 | 209 | NULL |
| 172.16.0.66 | 3306 | 1555540998338153 | 214 | NULL |
| 172.16.0.66 | 3306 | 1555541008216185 | 197 | NULL |
| 172.16.2.95 | 3306 | 1555541008408693 | 256 | NULL |
| 172.16.0.66 | 3306 | 1555541018216302 | 194 | NULL |
| 172.16.2.95 | 3306 | 1555541018369951 | 158 | NULL |
| 172.16.0.66 | 3306 | 1555541028216433 | 204 | NULL |
| 172.16.2.95 | 3306 | 1555541028399909 | 192 | NULL |
| 172.16.2.95 | 3306 | 1555541038216561 | 194 | NULL |
| 172.16.0.66 | 3306 | 1555541038317021 | 193 | NULL |
| 172.16.2.95 | 3306 | 1555541048216667 | 213 | NULL |
| 172.16.0.66 | 3306 | 1555541048338660 | 207 | NULL |
| 172.16.2.95 | 3306 | 1555541058216815 | 195 | NULL |
| 172.16.0.66 | 3306 | 1555541058399880 | 198 | NULL |
| 172.16.0.66 | 3306 | 1555541068216972 | 193 | NULL |
| 172.16.2.95 | 3306 | 1555541068332284 | 197 | NULL |
| 172.16.0.66 | 3306 | 1555541078217113 | 200 | NULL |
| 172.16.2.95 | 3306 | 1555541078368806 | 196 | NULL |
| 172.16.0.66 | 3306 | 1555541088217210 | 194 | NULL |
| 172.16.2.95 | 3306 | 1555541088375156 | 196 | NULL |
| 172.16.0.66 | 3306 | 1555541098217335 | 204 | NULL |
| 172.16.2.95 | 3306 | 1555541098402264 | 194 | NULL |
| 172.16.0.66 | 3306 | 1555541108217413 | 197 | NULL |
| 172.16.2.95 | 3306 | 1555541108347031 | 141 | NULL |
| 172.16.2.95 | 3306 | 1555541118217546 | 193 | NULL |
| 172.16.0.66 | 3306 | 1555541118377645 | 230 | NULL |
| 172.16.0.66 | 3306 | 1555541128217654 | 224 | NULL |
| 172.16.2.95 | 3306 | 1555541128368453 | 195 | NULL |
| 172.16.2.95 | 3306 | 1555541138217890 | 209 | NULL |
| 172.16.0.66 | 3306 | 1555541138345630 | 211 | NULL |
| 172.16.2.95 | 3306 | 1555541148217982 | 192 | NULL |
| 172.16.0.66 | 3306 | 1555541148372179 | 194 | NULL |
| 172.16.0.66 | 3306 | 1555541158218085 | 196 | NULL |
| 172.16.2.95 | 3306 | 1555541158410565 | 155 | NULL |
| 172.16.2.95 | 3306 | 1555541168218161 | 208 | NULL |
| 172.16.0.66 | 3306 | 1555541168409486 | 192 | NULL |
| 172.16.2.95 | 3306 | 1555541178218288 | 237 | NULL |
| 172.16.0.66 | 3306 | 1555541178323204 | 250 | NULL |
| 172.16.2.95 | 3306 | 1555541188218400 | 233 | NULL |
| 172.16.0.66 | 3306 | 1555541188416320 | 208 | NULL |
| 172.16.0.66 | 3306 | 1555541198218594 | 219 | NULL |
| 172.16.2.95 | 3306 | 1555541198397126 | 214 | NULL |
| 172.16.0.66 | 3306 | 1555541208218721 | 426 | NULL |
| 172.16.2.95 | 3306 | 1555541208352445 | 199 | NULL |
+-------------+------+------------------+----------------------+------------+
***** END OF DUMPING monitor.mysql_server_ping_log *****
***** DUMPING monitor.mysql_server_read_only_log *****
+-------------+------+------------------+-----------------+-----------+-------+
| hostname | port | time_start_us | success_time_us | read_only | error |
+-------------+------+------------------+-----------------+-----------+-------+
| 172.16.0.66 | 3306 | 1555540748218366 | 286 | 1 | NULL |
| 172.16.2.95 | 3306 | 1555540748229716 | 226 | 0 | NULL |
| 172.16.2.95 | 3306 | 1555540749713986 | 321 | 0 | NULL |
| 172.16.0.66 | 3306 | 1555540749735792 | 391 | 1 | NULL |
| 172.16.0.66 | 3306 | 1555540751214185 | 377 | 1 | NULL |
| 172.16.2.95 | 3306 | 1555540751237474 | 324 | 0 | NULL |
| 172.16.2.95 | 3306 | 1555540752714312 | 364 | 0 | NULL |
| 172.16.0.66 | 3306 | 1555540752743356 | 296 | 1 | NULL |
| 172.16.2.95 | 3306 | 1555540754214825 | 326 | 0 | NULL |
| 172.16.0.66 | 3306 | 1555540754236515 | 322 | 1 | NULL |
| 172.16.2.95 | 3306 | 1555540755715018 | 366 | 0 | NULL |
| 172.16.0.66 | 3306 | 1555540755737555 | 282 | 1 | NULL |
| 172.16.2.95 | 3306 | 1555540757214685 | 372 | 0 | NULL |
| 172.16.0.66 | 3306 | 1555540757230786 | 281 | 1 | NULL |
| 172.16.0.66 | 3306 | 1555540758714810 | 367 | 1 | NULL |
| 172.16.2.95 | 3306 | 1555540758744081 | 330 | 0 | NULL |
| 172.16.0.66 | 3306 | 1555540760215047 | 295 | 1 | NULL |
| 172.16.2.95 | 3306 | 1555540760237683 | 462 | 0 | NULL |
| 172.16.0.66 | 3306 | 1555540761715141 | 364 | 1 | NULL |
| 172.16.2.95 | 3306 | 1555540761738976 | 217 | 0 | NULL |
| 172.16.2.95 | 3306 | 1555540763215264 | 356 | 0 | NULL |
| 172.16.0.66 | 3306 | 1555540763240627 | 357 | 1 | NULL |
| 172.16.2.95 | 3306 | 1555540764715371 | 349 | 0 | NULL |
| 172.16.0.66 | 3306 | 1555540764734911 | 286 | 1 | NULL |
| 172.16.0.66 | 3306 | 1555540766215441 | 280 | 1 | NULL |
| 172.16.2.95 | 3306 | 1555540766243868 | 409 | 0 | NULL |
| 172.16.2.95 | 3306 | 1555540767715540 | 308 | 0 | NULL |
| 172.16.0.66 | 3306 | 1555540767743706 | 513 | 1 | NULL |
| 172.16.0.66 | 3306 | 1555540769215710 | 329 | 1 | NULL |
| 172.16.2.95 | 3306 | 1555540769233835 | 328 | 0 | NULL |
| 172.16.0.66 | 3306 | 1555540770716299 | 347 | 1 | NULL |
| 172.16.2.95 | 3306 | 1555540770733264 | 339 | 0 | NULL |
| 172.16.2.95 | 3306 | 1555540772216405 | 315 | 0 | NULL |
| 172.16.0.66 | 3306 | 1555540772239559 | 310 | 1 | NULL |
| 172.16.0.66 | 3306 | 1555540773716523 | 392 | 1 | NULL |
| 172.16.2.95 | 3306 | 1555540773731989 | 234 | 0 | NULL |
| 172.16.0.66 | 3306 | 1555540775216211 | 347 | 1 | NULL |
| 172.16.2.95 | 3306 | 1555540775232931 | 285 | 0 | NULL |
| 172.16.2.95 | 3306 | 1555540776716342 | 357 | 0 | NULL |
| 172.16.0.66 | 3306 | 1555540776735821 | 278 | 1 | NULL |
| 172.16.2.95 | 3306 | 1555540778216349 | 251 | 0 | NULL |
| 172.16.0.66 | 3306 | 1555540778235505 | 345 | 1 | NULL |
| 172.16.0.66 | 3306 | 1555540779716609 | 473 | 1 | NULL |
| 172.16.2.95 | 3306 | 1555540779734272 | 361 | 0 | NULL |
| 172.16.2.95 | 3306 | 1555540781216692 | 268 | 0 | NULL |
| 172.16.0.66 | 3306 | 1555540781242100 | 327 | 1 | NULL |
| 172.16.2.95 | 3306 | 1555540782716793 | 282 | 0 | NULL |
| 172.16.0.66 | 3306 | 1555540782736586 | 397 | 1 | NULL |
| 172.16.2.95 | 3306 | 1555540784216929 | 317 | 0 | NULL |
| 172.16.0.66 | 3306 | 1555540784245363 | 352 | 1 | NULL |
| 172.16.2.95 | 3306 | 1555540785717065 | 269 | 0 | NULL |
| 172.16.0.66 | 3306 | 1555540785741848 | 353 | 1 | NULL |
| 172.16.0.66 | 3306 | 1555540787217167 | 295 | 1 | NULL |
| 172.16.2.95 | 3306 | 1555540787238206 | 303 | 0 | NULL |
| 172.16.2.95 | 3306 | 1555540788717275 | 275 | 0 | NULL |
| 172.16.0.66 | 3306 | 1555540788741345 | 347 | 1 | NULL |
| 172.16.0.66 | 3306 | 1555540790217340 | 196 | 1 | NULL |
| 172.16.2.95 | 3306 | 1555540790235989 | 343 | 0 | NULL |
| 172.16.2.95 | 3306 | 1555540791717604 | 354 | 0 | NULL |
| 172.16.0.66 | 3306 | 1555540791736392 | 377 | 1 | NULL |
| 172.16.2.95 | 3306 | 1555540793217741 | 388 | 0 | NULL |
| 172.16.0.66 | 3306 | 1555540793238056 | 412 | 1 | NULL |
| 172.16.2.95 | 3306 | 1555540794717853 | 319 | 0 | NULL |
| 172.16.0.66 | 3306 | 1555540794741156 | 365 | 1 | NULL |
| 172.16.0.66 | 3306 | 1555540796217908 | 289 | 1 | NULL |
| 172.16.2.95 | 3306 | 1555540796238248 | 361 | 0 | NULL |
| 172.16.2.95 | 3306 | 1555540797718029 | 289 | 0 | NULL |
| 172.16.0.66 | 3306 | 1555540797735790 | 368 | 1 | NULL |
| 172.16.2.95 | 3306 | 1555540799218167 | 286 | 0 | NULL |
| 172.16.0.66 | 3306 | 1555540799235775 | 298 | 1 | NULL |
| 172.16.0.66 | 3306 | 1555540800718309 | 289 | 1 | NULL |
| 172.16.2.95 | 3306 | 1555540800743934 | 351 | 0 | NULL |
| 172.16.2.95 | 3306 | 1555540802218485 | 326 | 0 | NULL |
| 172.16.0.66 | 3306 | 1555540802244438 | 243 | 1 | NULL |
| 172.16.2.95 | 3306 | 1555540803718598 | 318 | 0 | NULL |
| 172.16.0.66 | 3306 | 1555540803748094 | 292 | 1 | NULL |
| 172.16.2.95 | 3306 | 1555540805218698 | 289 | 0 | NULL |
| 172.16.0.66 | 3306 | 1555540805236635 | 318 | 1 | NULL |
| 172.16.2.95 | 3306 | 1555540806718806 | 307 | 0 | NULL |
| 172.16.0.66 | 3306 | 1555540806748036 | 285 | 1 | NULL |
| 172.16.0.66 | 3306 | 1555540808218897 | 268 | 1 | NULL |
| 172.16.2.95 | 3306 | 1555540808245327 | 273 | 0 | NULL |
| 172.16.2.95 | 3306 | 1555540809719060 | 270 | 0 | NULL |
| 172.16.0.66 | 3306 | 1555540809741665 | 464 | 1 | NULL |
| 172.16.0.66 | 3306 | 1555540811219549 | 315 | 1 | NULL |
| 172.16.2.95 | 3306 | 1555540811237437 | 361 | 0 | NULL |
| 172.16.2.95 | 3306 | 1555540812719667 | 252 | 0 | NULL |
| 172.16.0.66 | 3306 | 1555540812738190 | 356 | 1 | NULL |
| 172.16.2.95 | 3306 | 1555540814219809 | 297 | 0 | NULL |
| 172.16.0.66 | 3306 | 1555540814240072 | 323 | 1 | NULL |
| 172.16.0.66 | 3306 | 1555540815719909 | 294 | 1 | NULL |
| 172.16.2.95 | 3306 | 1555540815748621 | 390 | 0 | NULL |
| 172.16.2.95 | 3306 | 1555540817220062 | 259 | 0 | NULL |
| 172.16.0.66 | 3306 | 1555540817244841 | 325 | 1 | NULL |
| 172.16.2.95 | 3306 | 1555540818719776 | 269 | 0 | NULL |
| 172.16.0.66 | 3306 | 1555540818747582 | 387 | 1 | NULL |
| 172.16.2.95 | 3306 | 1555540820219911 | 252 | 0 | NULL |
| 172.16.0.66 | 3306 | 1555540820249438 | 370 | 1 | NULL |
| 172.16.2.95 | 3306 | 1555540821720452 | 268 | 0 | NULL |
| 172.16.0.66 | 3306 | 1555540821745804 | 343 | 1 | NULL |
| 172.16.2.95 | 3306 | 1555540823220555 | 334 | 0 | NULL |
| 172.16.0.66 | 3306 | 1555540823241921 | 338 | 1 | NULL |
| 172.16.2.95 | 3306 | 1555540824720676 | 313 | 0 | NULL |
| 172.16.0.66 | 3306 | 1555540824744530 | 463 | 1 | NULL |
| 172.16.0.66 | 3306 | 1555540826220740 | 306 | 1 | NULL |
| 172.16.2.95 | 3306 | 1555540826236523 | 388 | 0 | NULL |
| 172.16.2.95 | 3306 | 1555540827720504 | 294 | 0 | NULL |
| 172.16.0.66 | 3306 | 1555540827739026 | 376 | 1 | NULL |
| 172.16.2.95 | 3306 | 1555540829220592 | 299 | 0 | NULL |
| 172.16.0.66 | 3306 | 1555540829236623 | 386 | 1 | NULL |
| 172.16.2.95 | 3306 | 1555540830720730 | 368 | 0 | NULL |
| 172.16.0.66 | 3306 | 1555540830749787 | 361 | 1 | NULL |
| 172.16.2.95 | 3306 | 1555540832220906 | 380 | 0 | NULL |
| 172.16.0.66 | 3306 | 1555540832242496 | 412 | 1 | NULL |
| 172.16.2.95 | 3306 | 1555540833721081 | 383 | 0 | NULL |
| 172.16.0.66 | 3306 | 1555540833748067 | 405 | 1 | NULL |
| 172.16.0.66 | 3306 | 1555540835221184 | 353 | 1 | NULL |
| 172.16.2.95 | 3306 | 1555540835236547 | 342 | 0 | NULL |
| 172.16.2.95 | 3306 | 1555540836721269 | 299 | 0 | NULL |
| 172.16.0.66 | 3306 | 1555540836745474 | 362 | 1 | NULL |
| 172.16.2.95 | 3306 | 1555540838221443 | 362 | 0 | NULL |
| 172.16.0.66 | 3306 | 1555540838248008 | 300 | 1 | NULL |
| 172.16.0.66 | 3306 | 1555540839721456 | 245 | 1 | NULL |
| 172.16.2.95 | 3306 | 1555540839741328 | 322 | 0 | NULL |
| 172.16.2.95 | 3306 | 1555540841221563 | 247 | 0 | NULL |
| 172.16.0.66 | 3306 | 1555540841244704 | 244 | 1 | NULL |
| 172.16.2.95 | 3306 | 1555540842721689 | 263 | 0 | NULL |
| 172.16.0.66 | 3306 | 1555540842739219 | 242 | 1 | NULL |
| 172.16.2.95 | 3306 | 1555540844221847 | 402 | 0 | NULL |
| 172.16.0.66 | 3306 | 1555540844239007 | 283 | 1 | NULL |
| 172.16.2.95 | 3306 | 1555540845721998 | 292 | 0 | NULL |
| 172.16.0.66 | 3306 | 1555540845740029 | 270 | 1 | NULL |
| 172.16.2.95 | 3306 | 1555540847222079 | 241 | 0 | NULL |
| 172.16.0.66 | 3306 | 1555540847248731 | 243 | 1 | NULL |
| 172.16.2.95 | 3306 | 1555540848722170 | 242 | 0 | NULL |
| 172.16.0.66 | 3306 | 1555540848750877 | 246 | 1 | NULL |
| 172.16.0.66 | 3306 | 1555540850222314 | 259 | 1 | NULL |
| 172.16.2.95 | 3306 | 1555540850245066 | 256 | 0 | NULL |
| 172.16.0.66 | 3306 | 1555540851722473 | 336 | 1 | NULL |
| 172.16.2.95 | 3306 | 1555540851738906 | 319 | 0 | NULL |
| 172.16.2.95 | 3306 | 1555540853222600 | 358 | 0 | NULL |
| 172.16.0.66 | 3306 | 1555540853237960 | 299 | 1 | NULL |
| 172.16.0.66 | 3306 | 1555540854722809 | 347 | 1 | NULL |
| 172.16.2.95 | 3306 | 1555540854750315 | 353 | 0 | NULL |
| 172.16.2.95 | 3306 | 1555540856222883 | 418 | 0 | NULL |
| 172.16.0.66 | 3306 | 1555540856253053 | 313 | 1 | NULL |
| 172.16.0.66 | 3306 | 1555540857722969 | 264 | 1 | NULL |
| 172.16.2.95 | 3306 | 1555540857741752 | 272 | 0 | NULL |
| 172.16.2.95 | 3306 | 1555540859223119 | 263 | 0 | NULL |
| 172.16.0.66 | 3306 | 1555540859240983 | 257 | 1 | NULL |
| 172.16.0.66 | 3306 | 1555540860723266 | 307 | 1 | NULL |
| 172.16.2.95 | 3306 | 1555540860743471 | 333 | 0 | NULL |
| 172.16.2.95 | 3306 | 1555540862223399 | 354 | 0 | NULL |
| 172.16.0.66 | 3306 | 1555540862241431 | 274 | 1 | NULL |
| 172.16.2.95 | 3306 | 1555540863723516 | 388 | 0 | NULL |
| 172.16.0.66 | 3306 | 1555540863748875 | 330 | 1 | NULL |
| 172.16.2.95 | 3306 | 1555540865223587 | 371 | 0 | NULL |
| 172.16.0.66 | 3306 | 1555540865242231 | 305 | 1 | NULL |
| 172.16.0.66 | 3306 | 1555540866723656 | 349 | 1 | NULL |
| 172.16.2.95 | 3306 | 1555540866744965 | 327 | 0 | NULL |
| 172.16.0.66 | 3306 | 1555540868223756 | 253 | 1 | NULL |
| 172.16.2.95 | 3306 | 1555540868245734 | 275 | 0 | NULL |
| 172.16.2.95 | 3306 | 1555540869723901 | 259 | 0 | NULL |
| 172.16.0.66 | 3306 | 1555540869747298 | 256 | 1 | NULL |
| 172.16.2.95 | 3306 | 1555540871224071 | 275 | 0 | NULL |
| 172.16.0.66 | 3306 | 1555540871251199 | 268 | 1 | NULL |
| 172.16.0.66 | 3306 | 1555540872724292 | 309 | 1 | NULL |
| 172.16.2.95 | 3306 | 1555540872754194 | 324 | 0 | NULL |
| 172.16.2.95 | 3306 | 1555540874224305 | 277 | 0 | NULL |
| 172.16.0.66 | 3306 | 1555540874240447 | 268 | 1 | NULL |
| 172.16.2.95 | 3306 | 1555540875724402 | 259 | 0 | NULL |
| 172.16.0.66 | 3306 | 1555540875747214 | 257 | 1 | NULL |
| 172.16.0.66 | 3306 | 1555540877224544 | 274 | 1 | NULL |
| 172.16.2.95 | 3306 | 1555540877251875 | 314 | 0 | NULL |
| 172.16.0.66 | 3306 | 1555540878724689 | 285 | 1 | NULL |
| 172.16.2.95 | 3306 | 1555540878750575 | 287 | 0 | NULL |
| 172.16.0.66 | 3306 | 1555540880224817 | 262 | 1 | NULL |
| 172.16.2.95 | 3306 | 1555540880244305 | 254 | 0 | NULL |
| 172.16.2.95 | 3306 | 1555540881725002 | 259 | 0 | NULL |
| 172.16.0.66 | 3306 | 1555540881750557 | 269 | 1 | NULL |
| 172.16.2.95 | 3306 | 1555540883225198 | 359 | 0 | NULL |
| 172.16.0.66 | 3306 | 1555540883254621 | 351 | 1 | NULL |
| 172.16.0.66 | 3306 | 1555540884725259 | 276 | 1 | NULL |
| 172.16.2.95 | 3306 | 1555540884750798 | 318 | 0 | NULL |
| 172.16.2.95 | 3306 | 1555540886225318 | 268 | 0 | NULL |
| 172.16.0.66 | 3306 | 1555540886253403 | 267 | 1 | NULL |
| 172.16.0.66 | 3306 | 1555540887725471 | 267 | 1 | NULL |
| 172.16.2.95 | 3306 | 1555540887752132 | 268 | 0 | NULL |
| 172.16.2.95 | 3306 | 1555540889225560 | 242 | 0 | NULL |
| 172.16.0.66 | 3306 | 1555540889249035 | 276 | 1 | NULL |
| 172.16.2.95 | 3306 | 1555540890725740 | 375 | 0 | NULL |
| 172.16.0.66 | 3306 | 1555540890745150 | 313 | 1 | NULL |
| 172.16.2.95 | 3306 | 1555540892225886 | 339 | 0 | NULL |
| 172.16.0.66 | 3306 | 1555540892242698 | 300 | 1 | NULL |
| 172.16.2.95 | 3306 | 1555540893726095 | 379 | 0 | NULL |
| 172.16.0.66 | 3306 | 1555540893751714 | 338 | 1 | NULL |
| 172.16.2.95 | 3306 | 1555540895226203 | 390 | 0 | NULL |
| 172.16.0.66 | 3306 | 1555540895248913 | 326 | 1 | NULL |
| 172.16.0.66 | 3306 | 1555540896726285 | 322 | 1 | NULL |
| 172.16.2.95 | 3306 | 1555540896750292 | 343 | 0 | NULL |
| 172.16.2.95 | 3306 | 1555540898226340 | 276 | 0 | NULL |
| 172.16.0.66 | 3306 | 1555540898256326 | 281 | 1 | NULL |
| 172.16.2.95 | 3306 | 1555540899726556 | 377 | 0 | NULL |
| 172.16.0.66 | 3306 | 1555540899745884 | 312 | 1 | NULL |
| 172.16.0.66 | 3306 | 1555540901226621 | 295 | 1 | NULL |
| 172.16.2.95 | 3306 | 1555540901250582 | 321 | 0 | NULL |
| 172.16.2.95 | 3306 | 1555540902726710 | 260 | 0 | NULL |
| 172.16.0.66 | 3306 | 1555540902749313 | 262 | 1 | NULL |
| 172.16.2.95 | 3306 | 1555540904226866 | 316 | 0 | NULL |
| 172.16.0.66 | 3306 | 1555540904244628 | 329 | 1 | NULL |
| 172.16.2.95 | 3306 | 1555540905727014 | 261 | 0 | NULL |
| 172.16.0.66 | 3306 | 1555540905748974 | 257 | 1 | NULL |
| 172.16.0.66 | 3306 | 1555540907227152 | 258 | 1 | NULL |
| 172.16.2.95 | 3306 | 1555540907252439 | 257 | 0 | NULL |
| 172.16.0.66 | 3306 | 1555540908727294 | 257 | 1 | NULL |
| 172.16.2.95 | 3306 | 1555540908744666 | 292 | 0 | NULL |
| 172.16.0.66 | 3306 | 1555540910227411 | 258 | 1 | NULL |
| 172.16.2.95 | 3306 | 1555540910245091 | 261 | 0 | NULL |
| 172.16.2.95 | 3306 | 1555540911727522 | 261 | 0 | NULL |
| 172.16.0.66 | 3306 | 1555540911746566 | 270 | 1 | NULL |
| 172.16.0.66 | 3306 | 1555540913227708 | 309 | 1 | NULL |
| 172.16.2.95 | 3306 | 1555540913244251 | 294 | 0 | NULL |
| 172.16.2.95 | 3306 | 1555540914727760 | 384 | 0 | NULL |
| 172.16.0.66 | 3306 | 1555540914750571 | 355 | 1 | NULL |
| 172.16.0.66 | 3306 | 1555540916227839 | 267 | 1 | NULL |
| 172.16.2.95 | 3306 | 1555540916248112 | 271 | 0 | NULL |
| 172.16.0.66 | 3306 | 1555540917728027 | 261 | 1 | NULL |
| 172.16.2.95 | 3306 | 1555540917758022 | 256 | 0 | NULL |
| 172.16.0.66 | 3306 | 1555540919228167 | 259 | 1 | NULL |
| 172.16.2.95 | 3306 | 1555540919252232 | 259 | 0 | NULL |
| 172.16.0.66 | 3306 | 1555540920728286 | 293 | 1 | NULL |
| 172.16.2.95 | 3306 | 1555540920748980 | 304 | 0 | NULL |
| 172.16.0.66 | 3306 | 1555540922228444 | 349 | 1 | NULL |
| 172.16.2.95 | 3306 | 1555540922251940 | 326 | 0 | NULL |
| 172.16.0.66 | 3306 | 1555540923728486 | 337 | 1 | NULL |
| 172.16.2.95 | 3306 | 1555540923751077 | 360 | 0 | NULL |
| 172.16.2.95 | 3306 | 1555540925228622 | 368 | 0 | NULL |
| 172.16.0.66 | 3306 | 1555540925251979 | 305 | 1 | NULL |
| 172.16.0.66 | 3306 | 1555540926728810 | 348 | 1 | NULL |
| 172.16.2.95 | 3306 | 1555540926745726 | 375 | 0 | NULL |
| 172.16.0.66 | 3306 | 1555540928228877 | 266 | 1 | NULL |
| 172.16.2.95 | 3306 | 1555540928251667 | 314 | 0 | NULL |
| 172.16.0.66 | 3306 | 1555540929728967 | 262 | 1 | NULL |
| 172.16.2.95 | 3306 | 1555540929751068 | 257 | 0 | NULL |
| 172.16.0.66 | 3306 | 1555540931229093 | 259 | 1 | NULL |
| 172.16.2.95 | 3306 | 1555540931254521 | 274 | 0 | NULL |
| 172.16.0.66 | 3306 | 1555540932729240 | 284 | 1 | NULL |
| 172.16.2.95 | 3306 | 1555540932758738 | 310 | 0 | NULL |
| 172.16.2.95 | 3306 | 1555540934229310 | 313 | 0 | NULL |
| 172.16.0.66 | 3306 | 1555540934249004 | 296 | 1 | NULL |
| 172.16.0.66 | 3306 | 1555540935729512 | 261 | 1 | NULL |
| 172.16.2.95 | 3306 | 1555540935748080 | 263 | 0 | NULL |
| 172.16.0.66 | 3306 | 1555540937229597 | 302 | 1 | NULL |
| 172.16.2.95 | 3306 | 1555540937253897 | 318 | 0 | NULL |
| 172.16.0.66 | 3306 | 1555540938729697 | 259 | 1 | NULL |
| 172.16.2.95 | 3306 | 1555540938753899 | 261 | 0 | NULL |
| 172.16.0.66 | 3306 | 1555540940229822 | 328 | 1 | NULL |
| 172.16.2.95 | 3306 | 1555540940255140 | 274 | 0 | NULL |
| 172.16.2.95 | 3306 | 1555540941729956 | 263 | 0 | NULL |
| 172.16.0.66 | 3306 | 1555540941759206 | 261 | 1 | NULL |
| 172.16.2.95 | 3306 | 1555540943230183 | 375 | 0 | NULL |
| 172.16.0.66 | 3306 | 1555540943253628 | 355 | 1 | NULL |
| 172.16.2.95 | 3306 | 1555540944730307 | 396 | 0 | NULL |
| 172.16.0.66 | 3306 | 1555540944754540 | 335 | 1 | NULL |
| 172.16.0.66 | 3306 | 1555540946230343 | 262 | 1 | NULL |
| 172.16.2.95 | 3306 | 1555540946253773 | 348 | 0 | NULL |
| 172.16.2.95 | 3306 | 1555540947730432 | 261 | 0 | NULL |
| 172.16.0.66 | 3306 | 1555540947749737 | 275 | 1 | NULL |
| 172.16.0.66 | 3306 | 1555540949230582 | 271 | 1 | NULL |
| 172.16.2.95 | 3306 | 1555540949259763 | 274 | 0 | NULL |
| 172.16.2.95 | 3306 | 1555540950730728 | 317 | 0 | NULL |
| 172.16.0.66 | 3306 | 1555540950746975 | 286 | 1 | NULL |
| 172.16.0.66 | 3306 | 1555540952230833 | 263 | 1 | NULL |
| 172.16.2.95 | 3306 | 1555540952250718 | 274 | 0 | NULL |
| 172.16.0.66 | 3306 | 1555540953731045 | 308 | 1 | NULL |
| 172.16.2.95 | 3306 | 1555540953760083 | 346 | 0 | NULL |
| 172.16.2.95 | 3306 | 1555540955231148 | 325 | 0 | NULL |
| 172.16.0.66 | 3306 | 1555540955254653 | 324 | 1 | NULL |
| 172.16.2.95 | 3306 | 1555540956731250 | 322 | 0 | NULL |
| 172.16.0.66 | 3306 | 1555540956756623 | 334 | 1 | NULL |
| 172.16.0.66 | 3306 | 1555540958231353 | 258 | 1 | NULL |
| 172.16.2.95 | 3306 | 1555540958249148 | 268 | 0 | NULL |
| 172.16.0.66 | 3306 | 1555540959731493 | 318 | 1 | NULL |
| 172.16.2.95 | 3306 | 1555540959759513 | 317 | 0 | NULL |
| 172.16.2.95 | 3306 | 1555540961231571 | 297 | 0 | NULL |
| 172.16.0.66 | 3306 | 1555540961260005 | 263 | 1 | NULL |
| 172.16.0.66 | 3306 | 1555540962731697 | 265 | 1 | NULL |
| 172.16.2.95 | 3306 | 1555540962752382 | 267 | 0 | NULL |
| 172.16.0.66 | 3306 | 1555540964231815 | 263 | 1 | NULL |
| 172.16.2.95 | 3306 | 1555540964253021 | 266 | 0 | NULL |
| 172.16.0.66 | 3306 | 1555540965731946 | 260 | 1 | NULL |
| 172.16.2.95 | 3306 | 1555540965757429 | 260 | 0 | NULL |
| 172.16.0.66 | 3306 | 1555540967232159 | 260 | 1 | NULL |
| 172.16.2.95 | 3306 | 1555540967259326 | 259 | 0 | NULL |
| 172.16.2.95 | 3306 | 1555540968732241 | 260 | 0 | NULL |
| 172.16.0.66 | 3306 | 1555540968750219 | 258 | 1 | NULL |
| 172.16.2.95 | 3306 | 1555540970232359 | 261 | 0 | NULL |
| 172.16.0.66 | 3306 | 1555540970253013 | 262 | 1 | NULL |
| 172.16.0.66 | 3306 | 1555540971732521 | 270 | 1 | NULL |
| 172.16.2.95 | 3306 | 1555540971752426 | 275 | 0 | NULL |
| 172.16.0.66 | 3306 | 1555540973232610 | 303 | 1 | NULL |
| 172.16.2.95 | 3306 | 1555540973251333 | 263 | 0 | NULL |
| 172.16.2.95 | 3306 | 1555540974732728 | 282 | 0 | NULL |
| 172.16.0.66 | 3306 | 1555540974762207 | 270 | 1 | NULL |
| 172.16.2.95 | 3306 | 1555540976232970 | 325 | 0 | NULL |
| 172.16.0.66 | 3306 | 1555540976256830 | 308 | 1 | NULL |
| 172.16.2.95 | 3306 | 1555540977733055 | 263 | 0 | NULL |
| 172.16.0.66 | 3306 | 1555540977758525 | 260 | 1 | NULL |
| 172.16.0.66 | 3306 | 1555540979233156 | 258 | 1 | NULL |
| 172.16.2.95 | 3306 | 1555540979255557 | 270 | 0 | NULL |
| 172.16.0.66 | 3306 | 1555540980733306 | 308 | 1 | NULL |
| 172.16.2.95 | 3306 | 1555540980759738 | 319 | 0 | NULL |
| 172.16.2.95 | 3306 | 1555540982233437 | 277 | 0 | NULL |
| 172.16.0.66 | 3306 | 1555540982254951 | 267 | 1 | NULL |
| 172.16.2.95 | 3306 | 1555540983733593 | 361 | 0 | NULL |
| 172.16.0.66 | 3306 | 1555540983762016 | 299 | 1 | NULL |
| 172.16.0.66 | 3306 | 1555540985233715 | 296 | 1 | NULL |
| 172.16.2.95 | 3306 | 1555540985253132 | 305 | 0 | NULL |
| 172.16.2.95 | 3306 | 1555540986733786 | 332 | 0 | NULL |
| 172.16.0.66 | 3306 | 1555540986759959 | 300 | 1 | NULL |
| 172.16.0.66 | 3306 | 1555540988233888 | 257 | 1 | NULL |
| 172.16.2.95 | 3306 | 1555540988261522 | 278 | 0 | NULL |
| 172.16.2.95 | 3306 | 1555540989734037 | 262 | 0 | NULL |
| 172.16.0.66 | 3306 | 1555540989757193 | 279 | 1 | NULL |
| 172.16.0.66 | 3306 | 1555540991234229 | 268 | 1 | NULL |
| 172.16.2.95 | 3306 | 1555540991255653 | 328 | 0 | NULL |
| 172.16.2.95 | 3306 | 1555540992734299 | 265 | 0 | NULL |
| 172.16.0.66 | 3306 | 1555540992754449 | 331 | 1 | NULL |
| 172.16.0.66 | 3306 | 1555540994234417 | 289 | 1 | NULL |
| 172.16.2.95 | 3306 | 1555540994251119 | 313 | 0 | NULL |
| 172.16.0.66 | 3306 | 1555540995734524 | 287 | 1 | NULL |
| 172.16.2.95 | 3306 | 1555540995751229 | 302 | 0 | NULL |
| 172.16.0.66 | 3306 | 1555540997234649 | 291 | 1 | NULL |
| 172.16.2.95 | 3306 | 1555540997257474 | 373 | 0 | NULL |
| 172.16.2.95 | 3306 | 1555540998734765 | 319 | 0 | NULL |
| 172.16.0.66 | 3306 | 1555540998760559 | 405 | 1 | NULL |
| 172.16.2.95 | 3306 | 1555541000234920 | 218 | 0 | NULL |
| 172.16.0.66 | 3306 | 1555541000264921 | 363 | 1 | NULL |
| 172.16.2.95 | 3306 | 1555541001735079 | 260 | 0 | NULL |
| 172.16.0.66 | 3306 | 1555541001759122 | 376 | 1 | NULL |
| 172.16.0.66 | 3306 | 1555541003235184 | 305 | 1 | NULL |
| 172.16.2.95 | 3306 | 1555541003256557 | 425 | 0 | NULL |
| 172.16.0.66 | 3306 | 1555541004735302 | 311 | 1 | NULL |
| 172.16.2.95 | 3306 | 1555541004760129 | 363 | 0 | NULL |
| 172.16.0.66 | 3306 | 1555541006235406 | 259 | 1 | NULL |
| 172.16.2.95 | 3306 | 1555541006253276 | 369 | 0 | NULL |
| 172.16.0.66 | 3306 | 1555541007735529 | 256 | 1 | NULL |
| 172.16.2.95 | 3306 | 1555541007760061 | 363 | 0 | NULL |
| 172.16.2.95 | 3306 | 1555541009235644 | 454 | 0 | NULL |
| 172.16.0.66 | 3306 | 1555541009257743 | 370 | 1 | NULL |
| 172.16.2.95 | 3306 | 1555541010735776 | 313 | 0 | NULL |
| 172.16.0.66 | 3306 | 1555541010761155 | 401 | 1 | NULL |
| 172.16.2.95 | 3306 | 1555541012235965 | 316 | 0 | NULL |
| 172.16.0.66 | 3306 | 1555541012264210 | 344 | 1 | NULL |
| 172.16.2.95 | 3306 | 1555541013736101 | 315 | 0 | NULL |
| 172.16.0.66 | 3306 | 1555541013763040 | 369 | 1 | NULL |
| 172.16.0.66 | 3306 | 1555541015236211 | 322 | 1 | NULL |
| 172.16.2.95 | 3306 | 1555541015265911 | 378 | 0 | NULL |
| 172.16.0.66 | 3306 | 1555541016736296 | 311 | 1 | NULL |
| 172.16.2.95 | 3306 | 1555541016757440 | 374 | 0 | NULL |
| 172.16.2.95 | 3306 | 1555541018236443 | 389 | 0 | NULL |
| 172.16.0.66 | 3306 | 1555541018255044 | 257 | 1 | NULL |
| 172.16.2.95 | 3306 | 1555541019736538 | 456 | 0 | NULL |
| 172.16.0.66 | 3306 | 1555541019756713 | 396 | 1 | NULL |
| 172.16.0.66 | 3306 | 1555541021236703 | 306 | 1 | NULL |
| 172.16.2.95 | 3306 | 1555541021261851 | 323 | 0 | NULL |
| 172.16.0.66 | 3306 | 1555541022736816 | 274 | 1 | NULL |
| 172.16.2.95 | 3306 | 1555541022761600 | 356 | 0 | NULL |
| 172.16.2.95 | 3306 | 1555541024236949 | 345 | 0 | NULL |
| 172.16.0.66 | 3306 | 1555541024257843 | 379 | 1 | NULL |
| 172.16.0.66 | 3306 | 1555541025737078 | 309 | 1 | NULL |
| 172.16.2.95 | 3306 | 1555541025764065 | 372 | 0 | NULL |
| 172.16.2.95 | 3306 | 1555541027237193 | 330 | 0 | NULL |
| 172.16.0.66 | 3306 | 1555541027254951 | 385 | 1 | NULL |
| 172.16.0.66 | 3306 | 1555541028737298 | 262 | 1 | NULL |
| 172.16.2.95 | 3306 | 1555541028754215 | 257 | 0 | NULL |
| 172.16.2.95 | 3306 | 1555541030237458 | 255 | 0 | NULL |
| 172.16.0.66 | 3306 | 1555541030263181 | 256 | 1 | NULL |
| 172.16.0.66 | 3306 | 1555541031737597 | 306 | 1 | NULL |
| 172.16.2.95 | 3306 | 1555541031767076 | 308 | 0 | NULL |
| 172.16.2.95 | 3306 | 1555541033237697 | 314 | 0 | NULL |
| 172.16.0.66 | 3306 | 1555541033263435 | 285 | 1 | NULL |
| 172.16.2.95 | 3306 | 1555541034737824 | 317 | 0 | NULL |
| 172.16.0.66 | 3306 | 1555541034767716 | 295 | 1 | NULL |
| 172.16.2.95 | 3306 | 1555541036237953 | 267 | 0 | NULL |
| 172.16.0.66 | 3306 | 1555541036261614 | 271 | 1 | NULL |
| 172.16.2.95 | 3306 | 1555541037738080 | 256 | 0 | NULL |
| 172.16.0.66 | 3306 | 1555541037754164 | 255 | 1 | NULL |
| 172.16.0.66 | 3306 | 1555541039238215 | 266 | 1 | NULL |
| 172.16.2.95 | 3306 | 1555541039259053 | 271 | 0 | NULL |
| 172.16.2.95 | 3306 | 1555541040738324 | 294 | 0 | NULL |
| 172.16.0.66 | 3306 | 1555541040765744 | 292 | 1 | NULL |
| 172.16.2.95 | 3306 | 1555541042238428 | 430 | 0 | NULL |
| 172.16.0.66 | 3306 | 1555541042265359 | 267 | 1 | NULL |
| 172.16.2.95 | 3306 | 1555541043738507 | 321 | 0 | NULL |
| 172.16.0.66 | 3306 | 1555541043762520 | 297 | 1 | NULL |
| 172.16.0.66 | 3306 | 1555541045238721 | 294 | 1 | NULL |
| 172.16.2.95 | 3306 | 1555541045263174 | 308 | 0 | NULL |
| 172.16.0.66 | 3306 | 1555541046738804 | 291 | 1 | NULL |
| 172.16.2.95 | 3306 | 1555541046761355 | 301 | 0 | NULL |
| 172.16.2.95 | 3306 | 1555541048238894 | 272 | 0 | NULL |
| 172.16.0.66 | 3306 | 1555541048256009 | 301 | 1 | NULL |
| 172.16.2.95 | 3306 | 1555541049739033 | 261 | 0 | NULL |
| 172.16.0.66 | 3306 | 1555541049769213 | 268 | 1 | NULL |
| 172.16.2.95 | 3306 | 1555541051239186 | 257 | 0 | NULL |
| 172.16.0.66 | 3306 | 1555541051262539 | 281 | 1 | NULL |
| 172.16.2.95 | 3306 | 1555541052739279 | 278 | 0 | NULL |
| 172.16.0.66 | 3306 | 1555541052767696 | 279 | 1 | NULL |
| 172.16.0.66 | 3306 | 1555541054239437 | 276 | 1 | NULL |
| 172.16.2.95 | 3306 | 1555541054268135 | 262 | 0 | NULL |
| 172.16.2.95 | 3306 | 1555541055739539 | 276 | 0 | NULL |
| 172.16.0.66 | 3306 | 1555541055760911 | 272 | 1 | NULL |
| 172.16.2.95 | 3306 | 1555541057239654 | 298 | 0 | NULL |
| 172.16.0.66 | 3306 | 1555541057254899 | 269 | 1 | NULL |
| 172.16.0.66 | 3306 | 1555541058739785 | 260 | 1 | NULL |
| 172.16.2.95 | 3306 | 1555541058756120 | 257 | 0 | NULL |
| 172.16.0.66 | 3306 | 1555541060239908 | 259 | 1 | NULL |
| 172.16.2.95 | 3306 | 1555541060263657 | 296 | 0 | NULL |
| 172.16.0.66 | 3306 | 1555541061740103 | 281 | 1 | NULL |
| 172.16.2.95 | 3306 | 1555541061757903 | 295 | 0 | NULL |
| 172.16.0.66 | 3306 | 1555541063240216 | 290 | 1 | NULL |
| 172.16.2.95 | 3306 | 1555541063263849 | 311 | 0 | NULL |
| 172.16.0.66 | 3306 | 1555541064740308 | 273 | 1 | NULL |
| 172.16.2.95 | 3306 | 1555541064757415 | 287 | 0 | NULL |
| 172.16.0.66 | 3306 | 1555541066240437 | 283 | 1 | NULL |
| 172.16.2.95 | 3306 | 1555541066265282 | 288 | 0 | NULL |
| 172.16.0.66 | 3306 | 1555541067740592 | 291 | 1 | NULL |
| 172.16.2.95 | 3306 | 1555541067761446 | 258 | 0 | NULL |
| 172.16.2.95 | 3306 | 1555541069240731 | 262 | 0 | NULL |
| 172.16.0.66 | 3306 | 1555541069269608 | 298 | 1 | NULL |
| 172.16.2.95 | 3306 | 1555541070740836 | 268 | 0 | NULL |
| 172.16.0.66 | 3306 | 1555541070767912 | 259 | 1 | NULL |
| 172.16.0.66 | 3306 | 1555541072241004 | 225 | 1 | NULL |
| 172.16.2.95 | 3306 | 1555541072256739 | 269 | 0 | NULL |
| 172.16.2.95 | 3306 | 1555541073741151 | 344 | 0 | NULL |
| 172.16.0.66 | 3306 | 1555541073762026 | 296 | 1 | NULL |
| 172.16.0.66 | 3306 | 1555541075241243 | 276 | 1 | NULL |
| 172.16.2.95 | 3306 | 1555541075264614 | 326 | 0 | NULL |
| 172.16.0.66 | 3306 | 1555541076741373 | 292 | 1 | NULL |
| 172.16.2.95 | 3306 | 1555541076768599 | 348 | 0 | NULL |
| 172.16.2.95 | 3306 | 1555541078241472 | 261 | 0 | NULL |
| 172.16.0.66 | 3306 | 1555541078262586 | 289 | 1 | NULL |
| 172.16.0.66 | 3306 | 1555541079741631 | 296 | 1 | NULL |
| 172.16.2.95 | 3306 | 1555541079759296 | 268 | 0 | NULL |
| 172.16.0.66 | 3306 | 1555541081241742 | 272 | 1 | NULL |
| 172.16.2.95 | 3306 | 1555541081262166 | 259 | 0 | NULL |
| 172.16.2.95 | 3306 | 1555541082741845 | 258 | 0 | NULL |
| 172.16.0.66 | 3306 | 1555541082757149 | 257 | 1 | NULL |
| 172.16.2.95 | 3306 | 1555541084242053 | 301 | 0 | NULL |
| 172.16.0.66 | 3306 | 1555541084260596 | 318 | 1 | NULL |
| 172.16.0.66 | 3306 | 1555541085742137 | 261 | 1 | NULL |
| 172.16.2.95 | 3306 | 1555541085759515 | 271 | 0 | NULL |
| 172.16.2.95 | 3306 | 1555541087242315 | 269 | 0 | NULL |
| 172.16.0.66 | 3306 | 1555541087263532 | 289 | 1 | NULL |
| 172.16.0.66 | 3306 | 1555541088742423 | 257 | 1 | NULL |
| 172.16.2.95 | 3306 | 1555541088772378 | 260 | 0 | NULL |
| 172.16.2.95 | 3306 | 1555541090242521 | 294 | 0 | NULL |
| 172.16.0.66 | 3306 | 1555541090271956 | 264 | 1 | NULL |
| 172.16.0.66 | 3306 | 1555541091742653 | 308 | 1 | NULL |
| 172.16.2.95 | 3306 | 1555541091764803 | 284 | 0 | NULL |
| 172.16.2.95 | 3306 | 1555541093242802 | 316 | 0 | NULL |
| 172.16.0.66 | 3306 | 1555541093260066 | 295 | 1 | NULL |
| 172.16.2.95 | 3306 | 1555541094743010 | 348 | 0 | NULL |
| 172.16.0.66 | 3306 | 1555541094760392 | 317 | 1 | NULL |
| 172.16.0.66 | 3306 | 1555541096243085 | 260 | 1 | NULL |
| 172.16.2.95 | 3306 | 1555541096267168 | 272 | 0 | NULL |
| 172.16.0.66 | 3306 | 1555541097743194 | 256 | 1 | NULL |
| 172.16.2.95 | 3306 | 1555541097761106 | 266 | 0 | NULL |
| 172.16.2.95 | 3306 | 1555541099243280 | 256 | 0 | NULL |
| 172.16.0.66 | 3306 | 1555541099259883 | 257 | 1 | NULL |
| 172.16.2.95 | 3306 | 1555541100743452 | 351 | 0 | NULL |
| 172.16.0.66 | 3306 | 1555541100766797 | 305 | 1 | NULL |
| 172.16.0.66 | 3306 | 1555541102243571 | 357 | 1 | NULL |
| 172.16.2.95 | 3306 | 1555541102262301 | 370 | 0 | NULL |
| 172.16.2.95 | 3306 | 1555541103743657 | 387 | 0 | NULL |
| 172.16.0.66 | 3306 | 1555541103761688 | 319 | 1 | NULL |
| 172.16.2.95 | 3306 | 1555541105243819 | 363 | 0 | NULL |
| 172.16.0.66 | 3306 | 1555541105259686 | 351 | 1 | NULL |
| 172.16.0.66 | 3306 | 1555541106743987 | 314 | 1 | NULL |
| 172.16.2.95 | 3306 | 1555541106761288 | 349 | 0 | NULL |
| 172.16.0.66 | 3306 | 1555541108244021 | 257 | 1 | NULL |
| 172.16.2.95 | 3306 | 1555541108269146 | 266 | 0 | NULL |
| 172.16.0.66 | 3306 | 1555541109744184 | 258 | 1 | NULL |
| 172.16.2.95 | 3306 | 1555541109770728 | 265 | 0 | NULL |
| 172.16.0.66 | 3306 | 1555541111244290 | 255 | 1 | NULL |
| 172.16.2.95 | 3306 | 1555541111271552 | 271 | 0 | NULL |
| 172.16.2.95 | 3306 | 1555541112744491 | 293 | 0 | NULL |
| 172.16.0.66 | 3306 | 1555541112770454 | 276 | 1 | NULL |
| 172.16.0.66 | 3306 | 1555541114244581 | 280 | 1 | NULL |
| 172.16.2.95 | 3306 | 1555541114272440 | 242 | 0 | NULL |
| 172.16.0.66 | 3306 | 1555541115744714 | 291 | 1 | NULL |
| 172.16.2.95 | 3306 | 1555541115774425 | 293 | 0 | NULL |
| 172.16.2.95 | 3306 | 1555541117244825 | 261 | 0 | NULL |
| 172.16.0.66 | 3306 | 1555541117273600 | 271 | 1 | NULL |
| 172.16.0.66 | 3306 | 1555541118744965 | 255 | 1 | NULL |
| 172.16.2.95 | 3306 | 1555541118764688 | 260 | 0 | NULL |
| 172.16.0.66 | 3306 | 1555541120245131 | 256 | 1 | NULL |
| 172.16.2.95 | 3306 | 1555541120270533 | 282 | 0 | NULL |
| 172.16.0.66 | 3306 | 1555541121745284 | 281 | 1 | NULL |
| 172.16.2.95 | 3306 | 1555541121762778 | 293 | 0 | NULL |
| 172.16.0.66 | 3306 | 1555541123245370 | 282 | 1 | NULL |
| 172.16.2.95 | 3306 | 1555541123264374 | 300 | 0 | NULL |
| 172.16.0.66 | 3306 | 1555541124745483 | 353 | 1 | NULL |
| 172.16.2.95 | 3306 | 1555541124761070 | 369 | 0 | NULL |
| 172.16.0.66 | 3306 | 1555541126245666 | 359 | 1 | NULL |
| 172.16.2.95 | 3306 | 1555541126274796 | 363 | 0 | NULL |
| 172.16.0.66 | 3306 | 1555541127745694 | 262 | 1 | NULL |
| 172.16.2.95 | 3306 | 1555541127775744 | 234 | 0 | NULL |
| 172.16.2.95 | 3306 | 1555541129245881 | 257 | 0 | NULL |
| 172.16.0.66 | 3306 | 1555541129263210 | 258 | 1 | NULL |
| 172.16.2.95 | 3306 | 1555541130746060 | 342 | 0 | NULL |
| 172.16.0.66 | 3306 | 1555541130768668 | 337 | 1 | NULL |
| 172.16.0.66 | 3306 | 1555541132246173 | 255 | 1 | NULL |
| 172.16.2.95 | 3306 | 1555541132262266 | 262 | 0 | NULL |
| 172.16.2.95 | 3306 | 1555541133746331 | 395 | 0 | NULL |
| 172.16.0.66 | 3306 | 1555541133768678 | 357 | 1 | NULL |
| 172.16.2.95 | 3306 | 1555541135246424 | 374 | 0 | NULL |
| 172.16.0.66 | 3306 | 1555541135276031 | 316 | 1 | NULL |
| 172.16.0.66 | 3306 | 1555541136746528 | 381 | 1 | NULL |
| 172.16.2.95 | 3306 | 1555541136768326 | 364 | 0 | NULL |
| 172.16.2.95 | 3306 | 1555541138246556 | 328 | 0 | NULL |
| 172.16.0.66 | 3306 | 1555541138267580 | 327 | 1 | NULL |
| 172.16.2.95 | 3306 | 1555541139746709 | 312 | 0 | NULL |
| 172.16.0.66 | 3306 | 1555541139776182 | 283 | 1 | NULL |
| 172.16.2.95 | 3306 | 1555541141246818 | 261 | 0 | NULL |
| 172.16.0.66 | 3306 | 1555541141268460 | 270 | 1 | NULL |
| 172.16.0.66 | 3306 | 1555541142747093 | 342 | 1 | NULL |
| 172.16.2.95 | 3306 | 1555541142770088 | 368 | 0 | NULL |
| 172.16.0.66 | 3306 | 1555541144247199 | 331 | 1 | NULL |
| 172.16.2.95 | 3306 | 1555541144270266 | 386 | 0 | NULL |
| 172.16.0.66 | 3306 | 1555541145747317 | 312 | 1 | NULL |
| 172.16.2.95 | 3306 | 1555541145769620 | 345 | 0 | NULL |
| 172.16.0.66 | 3306 | 1555541147247388 | 258 | 1 | NULL |
| 172.16.2.95 | 3306 | 1555541147275804 | 261 | 0 | NULL |
| 172.16.2.95 | 3306 | 1555541148747480 | 255 | 0 | NULL |
| 172.16.0.66 | 3306 | 1555541148777090 | 256 | 1 | NULL |
| 172.16.0.66 | 3306 | 1555541150247601 | 277 | 1 | NULL |
| 172.16.2.95 | 3306 | 1555541150277275 | 257 | 0 | NULL |
| 172.16.2.95 | 3306 | 1555541151747762 | 288 | 0 | NULL |
| 172.16.0.66 | 3306 | 1555541151767777 | 260 | 1 | NULL |
| 172.16.0.66 | 3306 | 1555541153247985 | 335 | 1 | NULL |
| 172.16.2.95 | 3306 | 1555541153273584 | 445 | 0 | NULL |
| 172.16.2.95 | 3306 | 1555541154748089 | 348 | 0 | NULL |
| 172.16.0.66 | 3306 | 1555541154775447 | 304 | 1 | NULL |
| 172.16.2.95 | 3306 | 1555541156248155 | 273 | 0 | NULL |
| 172.16.0.66 | 3306 | 1555541156274339 | 264 | 1 | NULL |
| 172.16.2.95 | 3306 | 1555541157748346 | 254 | 0 | NULL |
| 172.16.0.66 | 3306 | 1555541157770375 | 255 | 1 | NULL |
| 172.16.2.95 | 3306 | 1555541159248405 | 256 | 0 | NULL |
| 172.16.0.66 | 3306 | 1555541159268699 | 257 | 1 | NULL |
| 172.16.2.95 | 3306 | 1555541160748662 | 402 | 0 | NULL |
| 172.16.0.66 | 3306 | 1555541160775789 | 327 | 1 | NULL |
| 172.16.0.66 | 3306 | 1555541162248757 | 364 | 1 | NULL |
| 172.16.2.95 | 3306 | 1555541162277262 | 356 | 0 | NULL |
| 172.16.0.66 | 3306 | 1555541163748973 | 334 | 1 | NULL |
| 172.16.2.95 | 3306 | 1555541163776149 | 353 | 0 | NULL |
| 172.16.2.95 | 3306 | 1555541165249002 | 384 | 0 | NULL |
| 172.16.0.66 | 3306 | 1555541165265937 | 323 | 1 | NULL |
| 172.16.2.95 | 3306 | 1555541166749086 | 303 | 0 | NULL |
| 172.16.0.66 | 3306 | 1555541166772500 | 322 | 1 | NULL |
| 172.16.0.66 | 3306 | 1555541168249218 | 261 | 1 | NULL |
| 172.16.2.95 | 3306 | 1555541168270344 | 288 | 0 | NULL |
| 172.16.0.66 | 3306 | 1555541169749373 | 257 | 1 | NULL |
| 172.16.2.95 | 3306 | 1555541169771501 | 396 | 0 | NULL |
| 172.16.0.66 | 3306 | 1555541171249429 | 256 | 1 | NULL |
| 172.16.2.95 | 3306 | 1555541171275981 | 319 | 0 | NULL |
| 172.16.2.95 | 3306 | 1555541172749540 | 372 | 0 | NULL |
| 172.16.0.66 | 3306 | 1555541172769419 | 394 | 1 | NULL |
| 172.16.0.66 | 3306 | 1555541174249727 | 311 | 1 | NULL |
| 172.16.2.95 | 3306 | 1555541174278447 | 382 | 0 | NULL |
| 172.16.0.66 | 3306 | 1555541175749827 | 255 | 1 | NULL |
| 172.16.2.95 | 3306 | 1555541175777832 | 318 | 0 | NULL |
| 172.16.0.66 | 3306 | 1555541177249995 | 256 | 1 | NULL |
| 172.16.2.95 | 3306 | 1555541177270425 | 352 | 0 | NULL |
| 172.16.0.66 | 3306 | 1555541178750101 | 285 | 1 | NULL |
| 172.16.2.95 | 3306 | 1555541178774668 | 407 | 0 | NULL |
| 172.16.2.95 | 3306 | 1555541180250235 | 325 | 0 | NULL |
| 172.16.0.66 | 3306 | 1555541180272627 | 390 | 1 | NULL |
| 172.16.2.95 | 3306 | 1555541181750351 | 263 | 0 | NULL |
| 172.16.0.66 | 3306 | 1555541181773120 | 356 | 1 | NULL |
| 172.16.0.66 | 3306 | 1555541183250478 | 327 | 1 | NULL |
| 172.16.2.95 | 3306 | 1555541183276870 | 378 | 0 | NULL |
| 172.16.0.66 | 3306 | 1555541184750691 | 342 | 1 | NULL |
| 172.16.2.95 | 3306 | 1555541184768060 | 284 | 0 | NULL |
| 172.16.0.66 | 3306 | 1555541186250823 | 584 | 1 | NULL |
| 172.16.2.95 | 3306 | 1555541186276395 | 569 | 0 | NULL |
| 172.16.0.66 | 3306 | 1555541187750938 | 378 | 1 | NULL |
| 172.16.2.95 | 3306 | 1555541187779921 | 282 | 0 | NULL |
| 172.16.0.66 | 3306 | 1555541189251011 | 349 | 1 | NULL |
| 172.16.2.95 | 3306 | 1555541189274703 | 337 | 0 | NULL |
| 172.16.2.95 | 3306 | 1555541190751276 | 372 | 0 | NULL |
| 172.16.0.66 | 3306 | 1555541190772915 | 286 | 1 | NULL |
| 172.16.2.95 | 3306 | 1555541192251219 | 363 | 0 | NULL |
| 172.16.0.66 | 3306 | 1555541192274224 | 319 | 1 | NULL |
| 172.16.0.66 | 3306 | 1555541193751445 | 390 | 1 | NULL |
| 172.16.2.95 | 3306 | 1555541193781232 | 338 | 0 | NULL |
| 172.16.0.66 | 3306 | 1555541195251610 | 390 | 1 | NULL |
| 172.16.2.95 | 3306 | 1555541195278208 | 299 | 0 | NULL |
| 172.16.2.95 | 3306 | 1555541196751652 | 389 | 0 | NULL |
| 172.16.0.66 | 3306 | 1555541196779133 | 283 | 1 | NULL |
| 172.16.0.66 | 3306 | 1555541198251709 | 283 | 1 | NULL |
| 172.16.2.95 | 3306 | 1555541198275548 | 345 | 0 | NULL |
| 172.16.2.95 | 3306 | 1555541199752015 | 327 | 0 | NULL |
| 172.16.0.66 | 3306 | 1555541199780902 | 292 | 1 | NULL |
| 172.16.2.95 | 3306 | 1555541201252103 | 274 | 0 | NULL |
| 172.16.0.66 | 3306 | 1555541201278687 | 279 | 1 | NULL |
| 172.16.2.95 | 3306 | 1555541202752152 | 311 | 0 | NULL |
| 172.16.0.66 | 3306 | 1555541202768292 | 283 | 1 | NULL |
| 172.16.0.66 | 3306 | 1555541204252262 | 190 | 1 | NULL |
| 172.16.2.95 | 3306 | 1555541204276885 | 314 | 0 | NULL |
| 172.16.2.95 | 3306 | 1555541205752409 | 299 | 0 | NULL |
| 172.16.0.66 | 3306 | 1555541205777136 | 301 | 1 | NULL |
| 172.16.0.66 | 3306 | 1555541207252539 | 464 | 1 | NULL |
| 172.16.2.95 | 3306 | 1555541207278987 | 333 | 0 | NULL |
| 172.16.2.95 | 3306 | 1555541208752612 | 383 | 0 | NULL |
| 172.16.0.66 | 3306 | 1555541208775491 | 315 | 1 | NULL |
| 172.16.2.95 | 3306 | 1555541210252705 | 315 | 0 | NULL |
| 172.16.0.66 | 3306 | 1555541210271229 | 278 | 1 | NULL |
| 172.16.2.95 | 3306 | 1555541211753085 | 324 | 0 | NULL |
| 172.16.0.66 | 3306 | 1555541211770033 | 296 | 1 | NULL |
+-------------+------+------------------+-----------------+-----------+-------+
***** END OF DUMPING monitor.mysql_server_read_only_log *****
***** DUMPING monitor.mysql_server_replication_lag_log *****
***** END OF DUMPING monitor.mysql_server_replication_lag_log *****
............ END OF DUMPING MONITOR DATABASE ............
............ DUMPING HOST PRIORITY FILE ............
cat: /var/lib/proxysql/host_priority.conf: No such file or directory
............ END OF DUMPING HOST PRIORITY FILE ............
............ DUMPING PROXYSQL ADMIN CNF FILE ............
# proxysql admin interface credentials.
export PROXYSQL_DATADIR='/var/lib/proxysql'
export PROXYSQL_USERNAME='admin'
export PROXYSQL_PASSWORD='admin'
export PROXYSQL_HOSTNAME='localhost'
export PROXYSQL_PORT='6032'
# PXC admin credentials for connecting to pxc-cluster-node.
export CLUSTER_USERNAME='root'
export CLUSTER_PASSWORD='sekret'
export CLUSTER_HOSTNAME='172.16.0.66'
export CLUSTER_PORT='3306'
# proxysql monitoring user. proxysql admin script will create this user in pxc to monitor pxc-nodes.
export MONITOR_USERNAME='monitor'
export MONITOR_PASSWORD='monit0r'
# Application user to connect to pxc-node through proxysql
export CLUSTER_APP_USERNAME='proxysql_user'
export CLUSTER_APP_PASSWORD='passw0rd'
# ProxySQL read/write hostgroup
export WRITE_HOSTGROUP_ID='10'
export READ_HOSTGROUP_ID='11'
# ProxySQL read/write configuration mode.
export MODE="singlewrite"
# Writer-is-reader configuration
export WRITER_IS_READER="ondemand"
# max_connections default (used only when INSERTing a new mysql_servers entry)
export MAX_CONNECTIONS="1000"
............ END OF DUMPING PROXYSQL ADMIN CNF FILE ............
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment