Advertisement
rei4u2005

show global status 190710_1415

Jul 10th, 2019
105
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 10.32 KB | None | 0 0
  1. "Variable_name" "Value"
  2. "Aborted_clients" "642"
  3. "Aborted_connects" "7"
  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" "737565496"
  9. "Bytes_sent" "10555914829"
  10. "Com_admin_commands" "16"
  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" "3"
  20. "Com_alter_tablespace" "0"
  21. "Com_alter_user" "0"
  22. "Com_analyze" "0"
  23. "Com_begin" "12341"
  24. "Com_binlog" "0"
  25. "Com_call_procedure" "572"
  26. "Com_change_db" "116"
  27. "Com_change_master" "0"
  28. "Com_change_repl_filter" "0"
  29. "Com_check" "0"
  30. "Com_checksum" "0"
  31. "Com_commit" "11298"
  32. "Com_create_db" "0"
  33. "Com_create_event" "0"
  34. "Com_create_function" "0"
  35. "Com_create_index" "0"
  36. "Com_create_procedure" "4"
  37. "Com_create_server" "0"
  38. "Com_create_table" "9"
  39. "Com_create_trigger" "47"
  40. "Com_create_udf" "0"
  41. "Com_create_user" "0"
  42. "Com_create_view" "43"
  43. "Com_dealloc_sql" "0"
  44. "Com_delete" "2993"
  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" "5"
  52. "Com_drop_server" "0"
  53. "Com_drop_table" "3"
  54. "Com_drop_trigger" "47"
  55. "Com_drop_user" "0"
  56. "Com_drop_view" "10"
  57. "Com_empty_query" "0"
  58. "Com_execute_sql" "0"
  59. "Com_explain_other" "0"
  60. "Com_flush" "2"
  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" "80344"
  68. "Com_insert_select" "1872"
  69. "Com_install_plugin" "0"
  70. "Com_kill" "1"
  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" "56"
  89. "Com_rollback_to_savepoint" "0"
  90. "Com_savepoint" "0"
  91. "Com_select" "691289"
  92. "Com_set_option" "4165"
  93. "Com_signal" "0"
  94. "Com_show_binlog_events" "0"
  95. "Com_show_binlogs" "0"
  96. "Com_show_charsets" "8"
  97. "Com_show_collations" "6"
  98. "Com_show_create_db" "1"
  99. "Com_show_create_event" "10"
  100. "Com_show_create_func" "147"
  101. "Com_show_create_proc" "846"
  102. "Com_show_create_table" "35665"
  103. "Com_show_create_trigger" "96"
  104. "Com_show_databases" "57"
  105. "Com_show_engine_logs" "0"
  106. "Com_show_engine_mutex" "0"
  107. "Com_show_engine_status" "17"
  108. "Com_show_events" "0"
  109. "Com_show_errors" "0"
  110. "Com_show_fields" "7735"
  111. "Com_show_function_code" "0"
  112. "Com_show_function_status" "0"
  113. "Com_show_grants" "0"
  114. "Com_show_keys" "1163"
  115. "Com_show_master_status" "1"
  116. "Com_show_open_tables" "5406"
  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" "5411"
  122. "Com_show_profile" "0"
  123. "Com_show_profiles" "104"
  124. "Com_show_relaylog_events" "0"
  125. "Com_show_slave_hosts" "4"
  126. "Com_show_slave_status" "4"
  127. "Com_show_status" "1325"
  128. "Com_show_storage_engines" "4"
  129. "Com_show_table_status" "574"
  130. "Com_show_tables" "305"
  131. "Com_show_triggers" "286"
  132. "Com_show_variables" "69"
  133. "Com_show_warnings" "7"
  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" "18"
  141. "Com_stmt_close" "36"
  142. "Com_stmt_fetch" "0"
  143. "Com_stmt_prepare" "36"
  144. "Com_stmt_reset" "0"
  145. "Com_stmt_send_long_data" "0"
  146. "Com_truncate" "3"
  147. "Com_uninstall_plugin" "0"
  148. "Com_unlock_tables" "0"
  149. "Com_update" "28475"
  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" "2550"
  165. "Created_tmp_disk_tables" "75179"
  166. "Created_tmp_files" "88013"
  167. "Created_tmp_tables" "973067"
  168. "Delayed_errors" "0"
  169. "Delayed_insert_threads" "0"
  170. "Delayed_writes" "0"
  171. "Flush_commands" "2"
  172. "Handler_commit" "770969"
  173. "Handler_delete" "48616"
  174. "Handler_discover" "0"
  175. "Handler_external_lock" "6620622"
  176. "Handler_mrr_init" "0"
  177. "Handler_prepare" "0"
  178. "Handler_read_first" "789351"
  179. "Handler_read_key" "31866315103"
  180. "Handler_read_last" "7832"
  181. "Handler_read_next" "26337648791"
  182. "Handler_read_prev" "323312909"
  183. "Handler_read_rnd" "1498766050"
  184. "Handler_read_rnd_next" "35821533110"
  185. "Handler_rollback" "209"
  186. "Handler_savepoint" "0"
  187. "Handler_savepoint_rollback" "0"
  188. "Handler_update" "1618012958"
  189. "Handler_write" "6665900206"
  190. "Innodb_buffer_pool_dump_status" "Dumping of buffer pool not started"
  191. "Innodb_buffer_pool_load_status" "Buffer pool(s) load completed at 190709 12:51:51"
  192. "Innodb_buffer_pool_resize_status" ""
  193. "Innodb_buffer_pool_pages_data" "179378"
  194. "Innodb_buffer_pool_bytes_data" "2938929152"
  195. "Innodb_buffer_pool_pages_dirty" "198"
  196. "Innodb_buffer_pool_bytes_dirty" "3244032"
  197. "Innodb_buffer_pool_pages_flushed" "1887288"
  198. "Innodb_buffer_pool_pages_free" "126293"
  199. "Innodb_buffer_pool_pages_misc" "21969"
  200. "Innodb_buffer_pool_pages_total" "327640"
  201. "Innodb_buffer_pool_read_ahead_rnd" "0"
  202. "Innodb_buffer_pool_read_ahead" "43393"
  203. "Innodb_buffer_pool_read_ahead_evicted" "0"
  204. "Innodb_buffer_pool_read_requests" "76564740422"
  205. "Innodb_buffer_pool_reads" "83528"
  206. "Innodb_buffer_pool_wait_free" "0"
  207. "Innodb_buffer_pool_write_requests" "281037804"
  208. "Innodb_data_fsyncs" "118937"
  209. "Innodb_data_pending_fsyncs" "0"
  210. "Innodb_data_pending_reads" "0"
  211. "Innodb_data_pending_writes" "0"
  212. "Innodb_data_read" "2118881792"
  213. "Innodb_data_reads" "131463"
  214. "Innodb_data_writes" "1933586"
  215. "Innodb_data_written" "31012570624"
  216. "Innodb_dblwr_pages_written" "0"
  217. "Innodb_dblwr_writes" "0"
  218. "Innodb_log_waits" "0"
  219. "Innodb_log_write_requests" "111678"
  220. "Innodb_log_writes" "36675"
  221. "Innodb_os_log_fsyncs" "43532"
  222. "Innodb_os_log_pending_fsyncs" "0"
  223. "Innodb_os_log_pending_writes" "0"
  224. "Innodb_os_log_written" "93993472"
  225. "Innodb_page_size" "16384"
  226. "Innodb_pages_created" "50079"
  227. "Innodb_pages_read" "129322"
  228. "Innodb_pages_written" "1887311"
  229. "Innodb_row_lock_current_waits" "0"
  230. "Innodb_row_lock_time" "109306"
  231. "Innodb_row_lock_time_avg" "10930"
  232. "Innodb_row_lock_time_max" "51004"
  233. "Innodb_row_lock_waits" "10"
  234. "Innodb_rows_deleted" "50768"
  235. "Innodb_rows_inserted" "151079720"
  236. "Innodb_rows_read" "81121259163"
  237. "Innodb_rows_updated" "28597"
  238. "Innodb_num_open_files" "2137"
  239. "Innodb_truncated_status_writes" "0"
  240. "Innodb_available_undo_logs" "128"
  241. "Key_blocks_not_flushed" "0"
  242. "Key_blocks_unused" "8276"
  243. "Key_blocks_used" "18"
  244. "Key_read_requests" "6610"
  245. "Key_reads" "43"
  246. "Key_write_requests" "16"
  247. "Key_writes" "16"
  248. "Locked_connects" "0"
  249. "Max_execution_time_exceeded" "0"
  250. "Max_execution_time_set" "26"
  251. "Max_execution_time_set_failed" "0"
  252. "Max_used_connections" "141"
  253. "Max_used_connections_time" "2019-07-10 09:56:01"
  254. "Not_flushed_delayed_rows" "0"
  255. "Ongoing_anonymous_transaction_count" "0"
  256. "Open_files" "7"
  257. "Open_streams" "0"
  258. "Open_table_definitions" "1584"
  259. "Open_tables" "2368"
  260. "Opened_files" "337907"
  261. "Opened_table_definitions" "100630"
  262. "Opened_tables" "234241"
  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" "63894"
  267. "Performance_schema_file_classes_lost" "0"
  268. "Performance_schema_file_handles_lost" "0"
  269. "Performance_schema_file_instances_lost" "64"
  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" "2509"
  295. "Qcache_free_memory" "54742944"
  296. "Qcache_hits" "3286609"
  297. "Qcache_inserts" "230526"
  298. "Qcache_lowmem_prunes" "0"
  299. "Qcache_not_cached" "447065"
  300. "Qcache_queries_in_cache" "7414"
  301. "Qcache_total_blocks" "18143"
  302. "Queries" "4645123"
  303. "Questions" "4101103"
  304. "Select_full_join" "40093"
  305. "Select_full_range_join" "9"
  306. "Select_range" "740"
  307. "Select_range_check" "0"
  308. "Select_scan" "926688"
  309. "Slave_open_temp_tables" "0"
  310. "Slow_launch_threads" "0"
  311. "Slow_queries" "0"
  312. "Sort_merge_passes" "89257"
  313. "Sort_range" "5272"
  314. "Sort_rows" "1583762500"
  315. "Sort_scan" "585715"
  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" "3129"
  342. "Table_locks_waited" "0"
  343. "Table_open_cache_hits" "3598084"
  344. "Table_open_cache_misses" "234239"
  345. "Table_open_cache_overflows" "229414"
  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" "139"
  351. "Threads_created" "318"
  352. "Threads_running" "7"
  353. "Uptime" "91568"
  354. "Uptime_since_flush_status" "91568"
  355. "validate_password_dictionary_file_last_parsed" "2019-07-09 12:51:50"
  356. "validate_password_dictionary_file_words_count" "0"
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement