rei4u2005

SHOW GLOBAL STATUS

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