Advertisement
Guest User

SHOW GLOBAL STATUS

a guest
Nov 30th, 2020
399
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 10.75 KB | None | 0 0
  1. "Aborted_clients","6"
  2. "Aborted_connects","12007"
  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","9878117991"
  8. "Bytes_sent","134767640537"
  9. "Com_admin_commands","2543"
  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","512"
  19. "Com_alter_tablespace","0"
  20. "Com_alter_user","0"
  21. "Com_analyze","0"
  22. "Com_begin","302"
  23. "Com_binlog","0"
  24. "Com_call_procedure","0"
  25. "Com_change_db","580807"
  26. "Com_change_master","0"
  27. "Com_change_repl_filter","0"
  28. "Com_check","93"
  29. "Com_checksum","0"
  30. "Com_commit","302"
  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","596"
  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","123483"
  44. "Com_delete_multi","1122"
  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","132"
  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","613475"
  67. "Com_insert_select","45"
  68. "Com_install_plugin","0"
  69. "Com_kill","0"
  70. "Com_load","0"
  71. "Com_lock_tables","72"
  72. "Com_optimize","2"
  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","22"
  79. "Com_rename_user","0"
  80. "Com_repair","0"
  81. "Com_replace","138143"
  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","18327133"
  91. "Com_set_option","1251885"
  92. "Com_signal","0"
  93. "Com_show_binlog_events","0"
  94. "Com_show_binlogs","0"
  95. "Com_show_charsets","0"
  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","445"
  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","652913"
  110. "Com_show_function_code","0"
  111. "Com_show_function_status","3"
  112. "Com_show_grants","6"
  113. "Com_show_keys","0"
  114. "Com_show_master_status","0"
  115. "Com_show_open_tables","2"
  116. "Com_show_plugins","0"
  117. "Com_show_privileges","0"
  118. "Com_show_procedure_code","0"
  119. "Com_show_procedure_status","3"
  120. "Com_show_processlist","827"
  121. "Com_show_profile","621"
  122. "Com_show_profiles","21"
  123. "Com_show_relaylog_events","0"
  124. "Com_show_slave_hosts","0"
  125. "Com_show_slave_status","0"
  126. "Com_show_status","478466"
  127. "Com_show_storage_engines","0"
  128. "Com_show_table_status","2"
  129. "Com_show_tables","39126"
  130. "Com_show_triggers","2"
  131. "Com_show_variables","2118"
  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","495091"
  140. "Com_stmt_close","495091"
  141. "Com_stmt_fetch","0"
  142. "Com_stmt_prepare","495091"
  143. "Com_stmt_reset","0"
  144. "Com_stmt_send_long_data","1653"
  145. "Com_truncate","486"
  146. "Com_uninstall_plugin","0"
  147. "Com_unlock_tables","72"
  148. "Com_update","1187899"
  149. "Com_update_multi","26"
  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","2892"
  160. "Connection_errors_peer_address","0"
  161. "Connection_errors_select","0"
  162. "Connection_errors_tcpwrap","0"
  163. "Connections","654020"
  164. "Created_tmp_disk_tables","1341546"
  165. "Created_tmp_files","24499"
  166. "Created_tmp_tables","1531462"
  167. "Delayed_errors","0"
  168. "Delayed_insert_threads","0"
  169. "Delayed_writes","0"
  170. "Flush_commands","1"
  171. "Handler_commit","20289035"
  172. "Handler_delete","536241"
  173. "Handler_discover","0"
  174. "Handler_external_lock","54214310"
  175. "Handler_mrr_init","0"
  176. "Handler_prepare","0"
  177. "Handler_read_first","5842316"
  178. "Handler_read_key","434970991"
  179. "Handler_read_last","12728"
  180. "Handler_read_next","927393057"
  181. "Handler_read_prev","189617"
  182. "Handler_read_rnd","117105884"
  183. "Handler_read_rnd_next","2660057548"
  184. "Handler_rollback","1296"
  185. "Handler_savepoint","0"
  186. "Handler_savepoint_rollback","0"
  187. "Handler_update","11423065"
  188. "Handler_write","15396564"
  189. "Innodb_buffer_pool_dump_status","Dumping of buffer pool not started"
  190. "Innodb_buffer_pool_load_status","Buffer pool(s) load completed at 201127 10:54:24"
  191. "Innodb_buffer_pool_resize_status",""
  192. "Innodb_buffer_pool_pages_data","90852"
  193. "Innodb_buffer_pool_bytes_data","1488519168"
  194. "Innodb_buffer_pool_pages_dirty","1333"
  195. "Innodb_buffer_pool_bytes_dirty","21839872"
  196. "Innodb_buffer_pool_pages_flushed","2821484"
  197. "Innodb_buffer_pool_pages_free","36493"
  198. "Innodb_buffer_pool_pages_misc","3711"
  199. "Innodb_buffer_pool_pages_total","131056"
  200. "Innodb_buffer_pool_read_ahead_rnd","0"
  201. "Innodb_buffer_pool_read_ahead","2267"
  202. "Innodb_buffer_pool_read_ahead_evicted","0"
  203. "Innodb_buffer_pool_read_requests","4517590996"
  204. "Innodb_buffer_pool_reads","62471"
  205. "Innodb_buffer_pool_wait_free","0"
  206. "Innodb_buffer_pool_write_requests","90634853"
  207. "Innodb_data_fsyncs","2689916"
  208. "Innodb_data_pending_fsyncs","1"
  209. "Innodb_data_pending_reads","0"
  210. "Innodb_data_pending_writes","0"
  211. "Innodb_data_read","1063178752"
  212. "Innodb_data_reads","75926"
  213. "Innodb_data_writes","5038932"
  214. "Innodb_data_written","89175010816"
  215. "Innodb_dblwr_pages_written","1985610"
  216. "Innodb_dblwr_writes","221647"
  217. "Innodb_log_waits","0"
  218. "Innodb_log_write_requests","17453738"
  219. "Innodb_log_writes","1946862"
  220. "Innodb_os_log_fsyncs","1985658"
  221. "Innodb_os_log_pending_fsyncs","0"
  222. "Innodb_os_log_pending_writes","0"
  223. "Innodb_os_log_written","10462659072"
  224. "Innodb_page_size","16384"
  225. "Innodb_pages_created","29037"
  226. "Innodb_pages_read","64886"
  227. "Innodb_pages_written","2821508"
  228. "Innodb_row_lock_current_waits","0"
  229. "Innodb_row_lock_time","3783740"
  230. "Innodb_row_lock_time_avg","431"
  231. "Innodb_row_lock_time_max","51004"
  232. "Innodb_row_lock_waits","8763"
  233. "Innodb_rows_deleted","532521"
  234. "Innodb_rows_inserted","26616067"
  235. "Innodb_rows_read","3771090432"
  236. "Innodb_rows_updated","1719459"
  237. "Innodb_num_open_files","1000"
  238. "Innodb_truncated_status_writes","0"
  239. "Innodb_available_undo_logs","128"
  240. "Key_blocks_not_flushed","0"
  241. "Key_blocks_unused","8286"
  242. "Key_blocks_used","127"
  243. "Key_read_requests","98097"
  244. "Key_reads","25494"
  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","26"
  252. "Max_used_connections_time","2020-11-27 12:37:41"
  253. "Not_flushed_delayed_rows","0"
  254. "Ongoing_anonymous_transaction_count","0"
  255. "Open_files","0"
  256. "Open_streams","0"
  257. "Open_table_definitions","15451"
  258. "Open_tables","993"
  259. "Opened_files","46833"
  260. "Opened_table_definitions","17086"
  261. "Opened_tables","5271412"
  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","234404"
  266. "Performance_schema_file_classes_lost","0"
  267. "Performance_schema_file_handles_lost","0"
  268. "Performance_schema_file_instances_lost","514"
  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","0"
  294. "Qcache_free_memory","0"
  295. "Qcache_hits","0"
  296. "Qcache_inserts","0"
  297. "Qcache_lowmem_prunes","0"
  298. "Qcache_not_cached","0"
  299. "Qcache_queries_in_cache","0"
  300. "Qcache_total_blocks","0"
  301. "Queries","25037545"
  302. "Questions","23566357"
  303. "Rsa_public_key" "-----BEGIN PUBLIC KEY-----
  304. MIIBIjANBgkqhkiG9w0BAQEFAAOCAQ8AMIIBCgKCAQEA0PXpupNXgDpEhNxv0n7U
  305. Qfvv9wUO6MjjDWVQi9ARRngbFKiF6MW8JeE5f1EFIbxRNxNdhH+aVun/s0LUlPJk
  306. jQXvQRRbC8bl5uXpIJSeUPdLnuEWbUnGIL2iAOsh+fWbfdRfJYnuMgnywwHhpYI1
  307. t44pcAEOcxOyY70V52eDWaQ6qqh7p6lvuvKTGrKOXifjOZwhccPOwJMgEa20K4CN
  308. KpgA9AUmiQsr/4Gvs8vPV5EjE8OrmgpDAy47JHmCnrLuFbkfzMcpvDpQVrAzViNp
  309. uSgYrR1f6HK0gsKDuQK4Q0HMvTmmlUjpZhswkWmqORUzSo5dEK0xLv/jXB7ukZ+q
  310. kwIDAQAB
  311. -----END PUBLIC KEY-----
  312. "
  313. "Select_full_join","58661"
  314. "Select_full_range_join","13285"
  315. "Select_range","2130485"
  316. "Select_range_check","1791"
  317. "Select_scan","4480575"
  318. "Slave_open_temp_tables","0"
  319. "Slow_launch_threads","0"
  320. "Slow_queries","0"
  321. "Sort_merge_passes","12437"
  322. "Sort_range","2399323"
  323. "Sort_rows","124060494"
  324. "Sort_scan","1590536"
  325. "Ssl_accept_renegotiates","0"
  326. "Ssl_accepts","0"
  327. "Ssl_callback_cache_hits","0"
  328. "Ssl_cipher",""
  329. "Ssl_cipher_list",""
  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","0"
  335. "Ssl_finished_accepts","0"
  336. "Ssl_finished_connects","0"
  337. "Ssl_server_not_after","Dec 3 06:03:52 2029 GMT"
  338. "Ssl_server_not_before","Dec 6 06:03:52 2019 GMT"
  339. "Ssl_session_cache_hits","0"
  340. "Ssl_session_cache_misses","0"
  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","0"
  348. "Ssl_verify_mode","0"
  349. "Ssl_version",""
  350. "Table_locks_immediate","3053"
  351. "Table_locks_waited","0"
  352. "Table_open_cache_hits","23504604"
  353. "Table_open_cache_misses","5271405"
  354. "Table_open_cache_overflows","5269803"
  355. "Tc_log_max_pages_used","0"
  356. "Tc_log_page_size","0"
  357. "Tc_log_page_waits","0"
  358. "Threads_cached","17"
  359. "Threads_connected","10"
  360. "Threads_created","27"
  361. "Threads_running","7"
  362. "Uptime","247990"
  363. "Uptime_since_flush_status","247990"
  364.  
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement