API tools faq
paste
Advertisement
Guest User

Untitled

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