API tools faq
paste
Shodan76

Untitled

Shodan76
Jun 11th, 2020
87
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 8.79 KB | None | 0 0
raw download clone embed print report
  1.  
  2. Admin> select * from stats_mysql_global;
  3. +---------------------------------------------+----------------+
  4. | Variable_Name | Variable_Value |
  5. +---------------------------------------------+----------------+
  6. | ProxySQL_Uptime | 667175 |
  7. | Active_Transactions | 0 |
  8. | Client_Connections_aborted | 40 |
  9. | Client_Connections_connected | 132 |
  10. | Client_Connections_created | 3872 |
  11. | Server_Connections_aborted | 0 |
  12. | Server_Connections_connected | 0 |
  13. | Server_Connections_created | 0 |
  14. | Server_Connections_delayed | 0 |
  15. | Client_Connections_non_idle | 132 |
  16. | Queries_backends_bytes_recv | 0 |
  17. | Queries_backends_bytes_sent | 0 |
  18. | Queries_frontends_bytes_recv | 153675 |
  19. | Queries_frontends_bytes_sent | 308583 |
  20. | Query_Processor_time_nsec | 0 |
  21. | Backend_query_time_nsec | 0 |
  22. | mysql_backend_buffers_bytes | 0 |
  23. | mysql_frontend_buffers_bytes | 8650752 |
  24. | mysql_session_internal_bytes | 308736 |
  25. | Com_autocommit | 0 |
  26. | Com_autocommit_filtered | 0 |
  27. | Com_commit | 0 |
  28. | Com_commit_filtered | 0 |
  29. | Com_rollback | 0 |
  30. | Com_rollback_filtered | 0 |
  31. | Com_backend_change_user | 0 |
  32. | Com_backend_init_db | 0 |
  33. | Com_backend_set_names | 0 |
  34. | Com_frontend_init_db | 0 |
  35. | Com_frontend_set_names | 0 |
  36. | Com_frontend_use_db | 0 |
  37. | Com_backend_stmt_prepare | 0 |
  38. | Com_backend_stmt_execute | 0 |
  39. | Com_backend_stmt_close | 0 |
  40. | Com_frontend_stmt_prepare | 0 |
  41. | Com_frontend_stmt_execute | 0 |
  42. | Com_frontend_stmt_close | 0 |
  43. | Mirror_concurrency | 0 |
  44. | Mirror_queue_length | 0 |
  45. | Questions | 0 |
  46. | Selects_for_update__autocommit0 | 0 |
  47. | Slow_queries | 0 |
  48. | GTID_consistent_queries | 0 |
  49. | GTID_session_collected | 0 |
  50. | Servers_table_version | 1 |
  51. | MySQL_Thread_Workers | 4 |
  52. | Access_Denied_Wrong_Password | 38 |
  53. | Access_Denied_Max_Connections | 0 |
  54. | Access_Denied_Max_User_Connections | 0 |
  55. | MySQL_Monitor_Workers | 2 |
  56. | MySQL_Monitor_Workers_Aux | 0 |
  57. | MySQL_Monitor_Workers_Started | 2 |
  58. | MySQL_Monitor_connect_check_OK | 11108 |
  59. | MySQL_Monitor_connect_check_ERR | 1 |
  60. | MySQL_Monitor_ping_check_OK | 166616 |
  61. | MySQL_Monitor_ping_check_ERR | 176 |
  62. | MySQL_Monitor_read_only_check_OK | 0 |
  63. | MySQL_Monitor_read_only_check_ERR | 0 |
  64. | MySQL_Monitor_replication_lag_check_OK | 0 |
  65. | MySQL_Monitor_replication_lag_check_ERR | 133295 |
  66. | ConnPool_get_conn_latency_awareness | 0 |
  67. | ConnPool_get_conn_immediate | 0 |
  68. | ConnPool_get_conn_success | 0 |
  69. | ConnPool_get_conn_failure | 0 |
  70. | generated_error_packets | 38 |
  71. | max_connect_timeouts | 0 |
  72. | backend_lagging_during_query | 0 |
  73. | backend_offline_during_query | 0 |
  74. | queries_with_max_lag_ms | 0 |
  75. | queries_with_max_lag_ms__delayed | 0 |
  76. | queries_with_max_lag_ms__total_wait_time_us | 0 |
  77. | mysql_unexpected_frontend_com_quit | 0 |
  78. | Client_Connections_hostgroup_locked | 0 |
  79. | hostgroup_locked_set_cmds | 0 |
  80. | hostgroup_locked_queries | 0 |
  81. | mysql_unexpected_frontend_packets | 0 |
  82. | aws_aurora_replicas_skipped_during_query | 0 |
  83. | automatic_detected_sql_injection | 0 |
  84. | whitelisted_sqli_fingerprint | 0 |
  85. | mysql_killed_backend_connections | 0 |
  86. | mysql_killed_backend_queries | 0 |
  87. | MyHGM_myconnpoll_get | 0 |
  88. | MyHGM_myconnpoll_get_ok | 0 |
  89. | MyHGM_myconnpoll_push | 0 |
  90. | MyHGM_myconnpoll_destroy | 0 |
  91. | MyHGM_myconnpoll_reset | 0 |
  92. | SQLite3_memory_bytes | 4870896 |
  93. | ConnPool_memory_bytes | 368 |
  94. | Stmt_Client_Active_Total | 0 |
  95. | Stmt_Client_Active_Unique | 0 |
  96. | Stmt_Server_Active_Total | 0 |
  97. | Stmt_Server_Active_Unique | 0 |
  98. | Stmt_Max_Stmt_id | 1 |
  99. | Stmt_Cached | 0 |
  100. | Query_Cache_Memory_bytes | 0 |
  101. | Query_Cache_count_GET | 0 |
  102. | Query_Cache_count_GET_OK | 0 |
  103. | Query_Cache_count_SET | 0 |
  104. | Query_Cache_bytes_IN | 0 |
  105. | Query_Cache_bytes_OUT | 0 |
  106. | Query_Cache_Purged | 0 |
  107. | Query_Cache_Entries | 0 |
  108. +---------------------------------------------+----------------+
  109.  
  110. Admin> select * from stats_memory_metrics;
  111. +------------------------------+----------------+
  112. | Variable_Name | Variable_Value |
  113. +------------------------------+----------------+
  114. | SQLite3_memory_bytes | 4866792 |
  115. | jemalloc_resident | 55971840 |
  116. | jemalloc_active | 39952384 |
  117. | jemalloc_allocated | 33949680 |
  118. | jemalloc_mapped | 91983872 |
  119. | jemalloc_metadata | 4293496 |
  120. | jemalloc_retained | 83128320 |
  121. | Auth_memory | 4280 |
  122. | query_digest_memory | 0 |
  123. | mysql_query_rules_memory | 12690 |
  124. | mysql_firewall_users_table | 0 |
  125. | mysql_firewall_users_config | 0 |
  126. | mysql_firewall_rules_table | 0 |
  127. | mysql_firewall_rules_config | 329 |
  128. | stack_memory_mysql_threads | 67108864 |
  129. | stack_memory_admin_threads | 8388608 |
  130. | stack_memory_cluster_threads | 0 |
  131. +------------------------------+----------------+
  132.  
  133. Admin> select * from stats_mysql_connection_pool\G
  134. *************************** 1. row ***************************
  135. hostgroup: 10
  136. srv_host: 10.160.160.35
  137. srv_port: 3306
  138. status: ONLINE
  139. ConnUsed: 0
  140. ConnFree: 0
  141. ConnOK: 0
  142. ConnERR: 0
  143. MaxConnUsed: 0
  144. Queries: 0
  145. Queries_GTID_sync: 0
  146. Bytes_data_sent: 0
  147. Bytes_data_recv: 0
  148. Latency_us: 142
  149. *************************** 2. row ***************************
  150. hostgroup: 11
  151. srv_host: 10.160.160.36
  152. srv_port: 3306
  153. status: SHUNNED
  154. ConnUsed: 0
  155. ConnFree: 0
  156. ConnOK: 0
  157. ConnERR: 0
  158. MaxConnUsed: 0
  159. Queries: 0
  160. Queries_GTID_sync: 0
  161. Bytes_data_sent: 0
  162. Bytes_data_recv: 0
  163. Latency_us: 176
Add Comment
Please, Sign In to add comment
Public Pastes
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!