Advertisement
Pseudofailure

MySQL: SHOW GLOBAL STATUS

Mar 14th, 2023
114
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 10.31 KB | Fixit | 0 0
  1. Aborted_clients, 0
  2. Aborted_connects, 1
  3. Binlog_cache_disk_use, 0
  4. Binlog_cache_use, 0
  5. Binlog_stmt_cache_disk_use, 0
  6. Binlog_stmt_cache_use, 0
  7. Bytes_received, 5690
  8. Bytes_sent, 1391215
  9. Com_admin_commands, 9
  10. Com_assign_to_keycache, 0
  11. Com_alter_db, 0
  12. Com_alter_db_upgrade, 0
  13. Com_alter_event, 0
  14. Com_alter_function, 0
  15. Com_alter_instance, 0
  16. Com_alter_procedure, 0
  17. Com_alter_server, 0
  18. Com_alter_table, 0
  19. Com_alter_tablespace, 0
  20. Com_alter_user, 0
  21. Com_analyze, 0
  22. Com_begin, 0
  23. Com_binlog, 0
  24. Com_call_procedure, 0
  25. Com_change_db, 6
  26. Com_change_master, 0
  27. Com_change_repl_filter, 0
  28. Com_check, 0
  29. Com_checksum, 0
  30. Com_commit, 0
  31. Com_create_db, 0
  32. Com_create_event, 0
  33. Com_create_function, 0
  34. Com_create_index, 0
  35. Com_create_procedure, 0
  36. Com_create_server, 0
  37. Com_create_table, 0
  38. Com_create_trigger, 0
  39. Com_create_udf, 0
  40. Com_create_user, 0
  41. Com_create_view, 0
  42. Com_dealloc_sql, 0
  43. Com_delete, 0
  44. Com_delete_multi, 0
  45. Com_do, 0
  46. Com_drop_db, 0
  47. Com_drop_event, 0
  48. Com_drop_function, 0
  49. Com_drop_index, 0
  50. Com_drop_procedure, 0
  51. Com_drop_server, 0
  52. Com_drop_table, 0
  53. Com_drop_trigger, 0
  54. Com_drop_user, 0
  55. Com_drop_view, 0
  56. Com_empty_query, 0
  57. Com_execute_sql, 0
  58. Com_explain_other, 0
  59. Com_flush, 0
  60. Com_get_diagnostics, 0
  61. Com_grant, 0
  62. Com_ha_close, 0
  63. Com_ha_open, 0
  64. Com_ha_read, 0
  65. Com_help, 0
  66. Com_insert, 0
  67. Com_insert_select, 0
  68. Com_install_plugin, 0
  69. Com_kill, 0
  70. Com_load, 0
  71. Com_lock_tables, 0
  72. Com_optimize, 0
  73. Com_preload_keys, 0
  74. Com_prepare_sql, 0
  75. Com_purge, 0
  76. Com_purge_before_date, 0
  77. Com_release_savepoint, 0
  78. Com_rename_table, 0
  79. Com_rename_user, 0
  80. Com_repair, 0
  81. Com_replace, 0
  82. Com_replace_select, 0
  83. Com_reset, 0
  84. Com_resignal, 0
  85. Com_revoke, 0
  86. Com_revoke_all, 0
  87. Com_rollback, 0
  88. Com_rollback_to_savepoint, 0
  89. Com_savepoint, 0
  90. Com_select, 13
  91. Com_set_option, 15
  92. Com_signal, 0
  93. Com_show_binlog_events, 0
  94. Com_show_binlogs, 0
  95. Com_show_charsets, 4
  96. Com_show_collations, 0
  97. Com_show_create_db, 0
  98. Com_show_create_event, 0
  99. Com_show_create_func, 0
  100. Com_show_create_proc, 0
  101. Com_show_create_table, 0
  102. Com_show_create_trigger, 0
  103. Com_show_databases, 0
  104. Com_show_engine_logs, 0
  105. Com_show_engine_mutex, 0
  106. Com_show_engine_status, 0
  107. Com_show_events, 0
  108. Com_show_errors, 0
  109. Com_show_fields, 0
  110. Com_show_function_code, 0
  111. Com_show_function_status, 0
  112. Com_show_grants, 0
  113. Com_show_keys, 0
  114. Com_show_master_status, 0
  115. Com_show_open_tables, 0
  116. Com_show_plugins, 1
  117. Com_show_privileges, 0
  118. Com_show_procedure_code, 0
  119. Com_show_procedure_status, 0
  120. Com_show_processlist, 0
  121. Com_show_profile, 0
  122. Com_show_profiles, 0
  123. Com_show_relaylog_events, 0
  124. Com_show_slave_hosts, 0
  125. Com_show_slave_status, 0
  126. Com_show_status, 120
  127. Com_show_storage_engines, 0
  128. Com_show_table_status, 0
  129. Com_show_tables, 0
  130. Com_show_triggers, 0
  131. Com_show_variables, 3
  132. Com_show_warnings, 0
  133. Com_show_create_user, 0
  134. Com_shutdown, 0
  135. Com_slave_start, 0
  136. Com_slave_stop, 0
  137. Com_group_replication_start, 0
  138. Com_group_replication_stop, 0
  139. Com_stmt_execute, 0
  140. Com_stmt_close, 0
  141. Com_stmt_fetch, 0
  142. Com_stmt_prepare, 0
  143. Com_stmt_reset, 0
  144. Com_stmt_send_long_data, 0
  145. Com_truncate, 0
  146. Com_uninstall_plugin, 0
  147. Com_unlock_tables, 0
  148. Com_update, 0
  149. Com_update_multi, 0
  150. Com_xa_commit, 0
  151. Com_xa_end, 0
  152. Com_xa_prepare, 0
  153. Com_xa_recover, 0
  154. Com_xa_rollback, 0
  155. Com_xa_start, 0
  156. Com_stmt_reprepare, 0
  157. Connection_errors_accept, 0
  158. Connection_errors_internal, 0
  159. Connection_errors_max_connections, 0
  160. Connection_errors_peer_address, 0
  161. Connection_errors_select, 0
  162. Connection_errors_tcpwrap, 0
  163. Connections, 7
  164. Created_tmp_disk_tables, 1
  165. Created_tmp_files, 6
  166. Created_tmp_tables, 128
  167. Delayed_errors, 0
  168. Delayed_insert_threads, 0
  169. Delayed_writes, 0
  170. Flush_commands, 1
  171. Handler_commit, 5
  172. Handler_delete, 0
  173. Handler_discover, 0
  174. Handler_external_lock, 303
  175. Handler_mrr_init, 0
  176. Handler_prepare, 0
  177. Handler_read_first, 9
  178. Handler_read_key, 7
  179. Handler_read_last, 0
  180. Handler_read_next, 2
  181. Handler_read_prev, 0
  182. Handler_read_rnd, 0
  183. Handler_read_rnd_next, 87834
  184. Handler_rollback, 0
  185. Handler_savepoint, 0
  186. Handler_savepoint_rollback, 0
  187. Handler_update, 0
  188. Handler_write, 43839
  189. Innodb_buffer_pool_dump_status, Dumping of buffer pool not started
  190. Innodb_buffer_pool_load_status, Buffer pool(s) load completed at 230314 22:27:25
  191. Innodb_buffer_pool_resize_status,
  192. Innodb_buffer_pool_pages_data, 557
  193. Innodb_buffer_pool_bytes_data, 9125888
  194. Innodb_buffer_pool_pages_dirty, 0
  195. Innodb_buffer_pool_bytes_dirty, 0
  196. Innodb_buffer_pool_pages_flushed, 39
  197. Innodb_buffer_pool_pages_free, 7630
  198. Innodb_buffer_pool_pages_misc, 4
  199. Innodb_buffer_pool_pages_total, 8191
  200. Innodb_buffer_pool_read_ahead_rnd, 0
  201. Innodb_buffer_pool_read_ahead, 0
  202. Innodb_buffer_pool_read_ahead_evicted, 0
  203. Innodb_buffer_pool_read_requests, 3843
  204. Innodb_buffer_pool_reads, 523
  205. Innodb_buffer_pool_wait_free, 0
  206. Innodb_buffer_pool_write_requests, 345
  207. Innodb_data_fsyncs, 7
  208. Innodb_data_pending_fsyncs, 0
  209. Innodb_data_pending_reads, 0
  210. Innodb_data_pending_writes, 0
  211. Innodb_data_read, 8638976
  212. Innodb_data_reads, 571
  213. Innodb_data_writes, 56
  214. Innodb_data_written, 673792
  215. Innodb_dblwr_pages_written, 2
  216. Innodb_dblwr_writes, 1
  217. Innodb_log_waits, 0
  218. Innodb_log_write_requests, 0
  219. Innodb_log_writes, 2
  220. Innodb_os_log_fsyncs, 4
  221. Innodb_os_log_pending_fsyncs, 0
  222. Innodb_os_log_pending_writes, 0
  223. Innodb_os_log_written, 1024
  224. Innodb_page_size, 16384
  225. Innodb_pages_created, 35
  226. Innodb_pages_read, 522
  227. Innodb_pages_written, 39
  228. Innodb_row_lock_current_waits, 0
  229. Innodb_row_lock_time, 0
  230. Innodb_row_lock_time_avg, 0
  231. Innodb_row_lock_time_max, 0
  232. Innodb_row_lock_waits, 0
  233. Innodb_rows_deleted, 0
  234. Innodb_rows_inserted, 44
  235. Innodb_rows_read, 52
  236. Innodb_rows_updated, 0
  237. Innodb_num_open_files, 40
  238. Innodb_truncated_status_writes, 0
  239. Innodb_available_undo_logs, 128
  240. Key_blocks_not_flushed, 0
  241. Key_blocks_unused, 6698
  242. Key_blocks_used, 3
  243. Key_read_requests, 6
  244. Key_reads, 3
  245. Key_write_requests, 0
  246. Key_writes, 0
  247. Locked_connects, 0
  248. Max_execution_time_exceeded, 0
  249. Max_execution_time_set, 0
  250. Max_execution_time_set_failed, 0
  251. Max_used_connections, 4
  252. Max_used_connections_time, 2023-03-14 22:30:24
  253. Not_flushed_delayed_rows, 0
  254. Ongoing_anonymous_transaction_count, 0
  255. Open_files, 0
  256. Open_streams, 0
  257. Open_table_definitions, 106
  258. Open_tables, 1
  259. Opened_files, 144
  260. Opened_table_definitions, 106
  261. Opened_tables, 240
  262. Performance_schema_accounts_lost, 0
  263. Performance_schema_cond_classes_lost, 0
  264. Performance_schema_cond_instances_lost, 0
  265. Performance_schema_digest_lost, 0
  266. Performance_schema_file_classes_lost, 0
  267. Performance_schema_file_handles_lost, 0
  268. Performance_schema_file_instances_lost, 0
  269. Performance_schema_hosts_lost, 0
  270. Performance_schema_index_stat_lost, 0
  271. Performance_schema_locker_lost, 0
  272. Performance_schema_memory_classes_lost, 0
  273. Performance_schema_metadata_lock_lost, 0
  274. Performance_schema_mutex_classes_lost, 0
  275. Performance_schema_mutex_instances_lost, 0
  276. Performance_schema_nested_statement_lost, 0
  277. Performance_schema_prepared_statements_lost, 0
  278. Performance_schema_program_lost, 0
  279. Performance_schema_rwlock_classes_lost, 0
  280. Performance_schema_rwlock_instances_lost, 0
  281. Performance_schema_session_connect_attrs_lost, 0
  282. Performance_schema_socket_classes_lost, 0
  283. Performance_schema_socket_instances_lost, 0
  284. Performance_schema_stage_classes_lost, 0
  285. Performance_schema_statement_classes_lost, 0
  286. Performance_schema_table_handles_lost, 0
  287. Performance_schema_table_instances_lost, 0
  288. Performance_schema_table_lock_stat_lost, 0
  289. Performance_schema_thread_classes_lost, 0
  290. Performance_schema_thread_instances_lost, 0
  291. Performance_schema_users_lost, 0
  292. Prepared_stmt_count, 0
  293. Qcache_free_blocks, 1
  294. Qcache_free_memory, 1031832
  295. Qcache_hits, 0
  296. Qcache_inserts, 0
  297. Qcache_lowmem_prunes, 0
  298. Qcache_not_cached, 13
  299. Qcache_queries_in_cache, 0
  300. Qcache_total_blocks, 1
  301. Queries, 172
  302. Questions, 162
  303. Rsa_public_key, -----BEGIN PUBLIC KEY-----
  304. MIIBIjANBgkqhkiG9w0BAQEFAAOCAQ8AMIIBCgKCAQEAouNPxnnm37hqSk0+h1Ff
  305. W0ABYh9Pf9dC7kUGnKUcEPHlptUiz71RwzRLAoxljWqx2BCnGR+ttqpFLqvqInu5
  306. WLngB/mAiIn9kJyfu3KRaWec1WuT3yav/JrYQ7ij3U1TArvBCCfsNdbPFxriYm1J
  307. oaW1JRvexLMOykBpDAVw4LhythR0TnxqpHbkcU2XBkBgWQP4hCW3Ac1q9HMkOyn5
  308. +qsACttnRgTL/jESKZCaRWd2YkvPpRMxqpl5AnVhfivKBLYWehTLN1GVWlwVyHUC
  309. MfeFc3ogQ32vE456v1uHErBzYrcMprdV5UonNKuZ36TxqF1Ac+ZklV44dggGDRQL
  310. QQIDAQAB
  311. -----END PUBLIC KEY-----
  312.  
  313. Select_full_join, 2
  314. Select_full_range_join, 0
  315. Select_range, 0
  316. Select_range_check, 0
  317. Select_scan, 257
  318. Slave_open_temp_tables, 0
  319. Slow_launch_threads, 0
  320. Slow_queries, 0
  321. Sort_merge_passes, 0
  322. Sort_range, 0
  323. Sort_rows, 0
  324. Sort_scan, 0
  325. Ssl_accept_renegotiates, 0
  326. Ssl_accepts, 5
  327. Ssl_callback_cache_hits, 0
  328. Ssl_cipher, DHE-RSA-AES128-GCM-SHA256
  329. Ssl_cipher_list, ECDHE-ECDSA-AES128-GCM-SHA256:ECDHE-ECDSA-AES256-GCM-SHA384:ECDHE-RSA-AES128-GCM-SHA256:ECDHE-RSA-AES256-GCM-SHA384:ECDHE-ECDSA-AES128-SHA256:ECDHE-RSA-AES128-SHA256:ECDHE-ECDSA-AES256-SHA384:ECDHE-RSA-AES256-SHA384:DHE-RSA-AES128-GCM-SHA256:DHE-DSS-AES128-GCM-SHA256:DHE-RSA-AES128-SHA256:DHE-DSS-AES128-SHA256:DHE-DSS-AES256-GCM-SHA384:DHE-RSA-AES256-SHA256:DHE-DSS-AES256-SHA256:ECDHE-RSA-AES128-SHA:ECDHE-ECDSA-AES128-SHA:ECDHE-RSA-AES256-SHA:ECDHE-ECDSA-AES256-SHA:DHE-DSS-AES128-SHA:DHE-RSA-AES128-SHA:DHE-RSA-AES256-SHA:AES128-GCM-SHA256:DH-DSS-AES128-GCM-SHA256:ECDH-ECDSA-AES128-GCM-SHA256:AES256-GCM-SHA384:DH-DSS-AES256-GCM-SHA384:ECDH-ECDSA-AES256-GCM-SHA384:AES128-SHA256:DH-DSS-AES128-SHA256:ECDH-ECDSA-AES128-SHA256:AES256-SHA256:DH-DSS-AES256-SHA256:ECDH-ECDSA-AES256-SHA384:AES128-SHA:DH-DSS-AES128-SHA:ECDH-ECDSA-AES128-SHA:AES256-SHA:DH-DSS-AES256-SHA:ECDH-ECDSA-AES256-SHA:DHE-RSA-AES256-GCM-SHA384:DH-RSA-AES128-GCM-SHA256:ECDH-RSA-AES128-GCM-SHA256:DH-RSA-AES256-GCM-SHA384:ECDH-RSA-AES256-GCM-SHA384:
  330. Ssl_client_connects, 0
  331. Ssl_connect_renegotiates, 0
  332. Ssl_ctx_verify_depth, 18446744073709551615
  333. Ssl_ctx_verify_mode, 5
  334. Ssl_default_timeout, 7200
  335. Ssl_finished_accepts, 5
  336. Ssl_finished_connects, 0
  337. Ssl_server_not_after, Feb 23 18:00:00 2029 GMT
  338. Ssl_server_not_before, Feb 26 18:00:00 2019 GMT
  339. Ssl_session_cache_hits, 0
  340. Ssl_session_cache_misses, 5
  341. Ssl_session_cache_mode, SERVER
  342. Ssl_session_cache_overflows, 0
  343. Ssl_session_cache_size, 128
  344. Ssl_session_cache_timeouts, 0
  345. Ssl_sessions_reused, 0
  346. Ssl_used_session_cache_entries, 0
  347. Ssl_verify_depth, 18446744073709551615
  348. Ssl_verify_mode, 5
  349. Ssl_version, TLSv1.2
  350. Table_locks_immediate, 142
  351. Table_locks_waited, 0
  352. Table_open_cache_hits, 0
  353. Table_open_cache_misses, 240
  354. Table_open_cache_overflows, 232
  355. Tc_log_max_pages_used, 0
  356. Tc_log_page_size, 0
  357. Tc_log_page_waits, 0
  358. Threads_cached, 0
  359. Threads_connected, 4
  360. Threads_created, 4
  361. Threads_running, 1
  362. Uptime, 530
  363. Uptime_since_flush_status, 530
  364.  
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement