Advertisement
Guest User

Show Global Status

a guest
Nov 22nd, 2018
277
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 9.46 KB | None | 0 0
  1. "Variable_name","Value"
  2. "Aborted_clients",23
  3. "Aborted_connects",3
  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",2654826425
  9. "Bytes_sent",12818294645
  10. "Com_admin_commands",7160
  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",184505
  24. "Com_binlog",0
  25. "Com_call_procedure",0
  26. "Com_change_db",226682
  27. "Com_change_master",0
  28. "Com_change_repl_filter",0
  29. "Com_check",0
  30. "Com_checksum",0
  31. "Com_commit",184505
  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",0
  43. "Com_dealloc_sql",0
  44. "Com_delete",82391
  45. "Com_delete_multi",1
  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",0
  57. "Com_empty_query",0
  58. "Com_execute_sql",0
  59. "Com_explain_other",0
  60. "Com_flush",3
  61. "Com_get_diagnostics",0
  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",551314
  68. "Com_insert_select",0
  69. "Com_install_plugin",0
  70. "Com_kill",0
  71. "Com_load",0
  72. "Com_lock_tables",0
  73. "Com_optimize",9
  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",0
  89. "Com_rollback_to_savepoint",0
  90. "Com_savepoint",0
  91. "Com_select",3024863
  92. "Com_set_option",453763
  93. "Com_signal",0
  94. "Com_show_binlog_events",0
  95. "Com_show_binlogs",0
  96. "Com_show_charsets",4
  97. "Com_show_collations",6
  98. "Com_show_create_db",0
  99. "Com_show_create_event",0
  100. "Com_show_create_func",0
  101. "Com_show_create_proc",0
  102. "Com_show_create_table",144
  103. "Com_show_create_trigger",0
  104. "Com_show_databases",16
  105. "Com_show_engine_logs",0
  106. "Com_show_engine_mutex",0
  107. "Com_show_engine_status",0
  108. "Com_show_events",3
  109. "Com_show_errors",0
  110. "Com_show_fields",315
  111. "Com_show_function_code",0
  112. "Com_show_function_status",6
  113. "Com_show_grants",4
  114. "Com_show_keys",67
  115. "Com_show_master_status",0
  116. "Com_show_open_tables",0
  117. "Com_show_plugins",11
  118. "Com_show_privileges",1
  119. "Com_show_procedure_code",0
  120. "Com_show_procedure_status",6
  121. "Com_show_processlist",0
  122. "Com_show_profile",0
  123. "Com_show_profiles",0
  124. "Com_show_relaylog_events",0
  125. "Com_show_slave_hosts",0
  126. "Com_show_slave_status",5
  127. "Com_show_status",17135
  128. "Com_show_storage_engines",6
  129. "Com_show_table_status",142
  130. "Com_show_tables",13
  131. "Com_show_triggers",66
  132. "Com_show_variables",108
  133. "Com_show_warnings",0
  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",4269449
  141. "Com_stmt_close",4269449
  142. "Com_stmt_fetch",0
  143. "Com_stmt_prepare",4269449
  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",158134
  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",226699
  165. "Created_tmp_disk_tables",36904
  166. "Created_tmp_files",243
  167. "Created_tmp_tables",58933
  168. "Delayed_errors",0
  169. "Delayed_insert_threads",0
  170. "Delayed_writes",0
  171. "Flush_commands",1
  172. "Handler_commit",4000428
  173. "Handler_delete",85775
  174. "Handler_discover",0
  175. "Handler_external_lock",8085461
  176. "Handler_mrr_init",0
  177. "Handler_prepare",0
  178. "Handler_read_first",396773
  179. "Handler_read_key",521740828
  180. "Handler_read_last",676
  181. "Handler_read_next",2565938256
  182. "Handler_read_prev",9441343
  183. "Handler_read_rnd",2764281
  184. "Handler_read_rnd_next",16469674524
  185. "Handler_rollback",9
  186. "Handler_savepoint",0
  187. "Handler_savepoint_rollback",0
  188. "Handler_update",199345065
  189. "Handler_write",33067527
  190. "Innodb_buffer_pool_dump_status","Dumping of buffer pool not started"
  191. "Innodb_buffer_pool_load_status","Buffer pool(s) load completed at 181119 20:07:26"
  192. "Innodb_buffer_pool_resize_status",""
  193. "Innodb_buffer_pool_pages_data",704229
  194. "Innodb_buffer_pool_bytes_data",11538087936
  195. "Innodb_buffer_pool_pages_dirty",0
  196. "Innodb_buffer_pool_bytes_dirty",0
  197. "Innodb_buffer_pool_pages_flushed",3919379
  198. "Innodb_buffer_pool_pages_free",79058
  199. "Innodb_buffer_pool_pages_misc",3097
  200. "Innodb_buffer_pool_pages_total",786384
  201. "Innodb_buffer_pool_read_ahead_rnd",0
  202. "Innodb_buffer_pool_read_ahead",96164
  203. "Innodb_buffer_pool_read_ahead_evicted",0
  204. "Innodb_buffer_pool_read_requests",23535206252
  205. "Innodb_buffer_pool_reads",330174
  206. "Innodb_buffer_pool_wait_free",0
  207. "Innodb_buffer_pool_write_requests",1305990135
  208. "Innodb_data_fsyncs",1555149
  209. "Innodb_data_pending_fsyncs",0
  210. "Innodb_data_pending_reads",0
  211. "Innodb_data_pending_writes",0
  212. "Innodb_data_read",7032066560
  213. "Innodb_data_reads",429780
  214. "Innodb_data_writes",5196287
  215. "Innodb_data_written",85597844992
  216. "Innodb_dblwr_pages_written",1002499
  217. "Innodb_dblwr_writes",308586
  218. "Innodb_log_waits",0
  219. "Innodb_log_write_requests",5155479
  220. "Innodb_log_writes",829769
  221. "Innodb_os_log_fsyncs",878129
  222. "Innodb_os_log_pending_fsyncs",0
  223. "Innodb_os_log_pending_writes",0
  224. "Innodb_os_log_written",3615030272
  225. "Innodb_page_size",16384
  226. "Innodb_pages_created",275031
  227. "Innodb_pages_read",429198
  228. "Innodb_pages_written",4006253
  229. "Innodb_row_lock_current_waits",0
  230. "Innodb_row_lock_time",182
  231. "Innodb_row_lock_time_avg",22
  232. "Innodb_row_lock_time_max",163
  233. "Innodb_row_lock_waits",8
  234. "Innodb_rows_deleted",115201
  235. "Innodb_rows_inserted",782128718
  236. "Innodb_rows_read",19228637890
  237. "Innodb_rows_updated",158388
  238. "Innodb_num_open_files",80
  239. "Innodb_truncated_status_writes",0
  240. "Innodb_available_undo_logs",128
  241. "Key_blocks_not_flushed",0
  242. "Key_blocks_unused",6689
  243. "Key_blocks_used",9
  244. "Key_read_requests",106
  245. "Key_reads",12
  246. "Key_write_requests",0
  247. "Key_writes",0
  248. "Locked_connects",0
  249. "Max_execution_time_exceeded",0
  250. "Max_execution_time_set",0
  251. "Max_execution_time_set_failed",0
  252. "Max_used_connections",19
  253. "Max_used_connections_time","2018-11-22 13:59:12"
  254. "Not_flushed_delayed_rows",0
  255. "Ongoing_anonymous_transaction_count",0
  256. "Open_files",23
  257. "Open_streams",0
  258. "Open_table_definitions",277
  259. "Open_tables",1066
  260. "Opened_files",1479
  261. "Opened_table_definitions",304
  262. "Opened_tables",1368
  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",9
  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",0
  295. "Qcache_free_memory",0
  296. "Qcache_hits",0
  297. "Qcache_inserts",0
  298. "Qcache_lowmem_prunes",0
  299. "Qcache_not_cached",0
  300. "Qcache_queries_in_cache",0
  301. "Qcache_total_blocks",0
  302. "Queries",13656946
  303. "Questions",5110880
  304. "Select_full_join",11
  305. "Select_full_range_join",0
  306. "Select_range",34979
  307. "Select_range_check",0
  308. "Select_scan",398285
  309. "Slave_open_temp_tables",0
  310. "Slow_launch_threads",0
  311. "Slow_queries",378
  312. "Sort_merge_passes",427
  313. "Sort_range",377
  314. "Sort_rows",2766345
  315. "Sort_scan",77427
  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",17415
  342. "Table_locks_waited",0
  343. "Table_open_cache_hits",8067392
  344. "Table_open_cache_misses",1368
  345. "Table_open_cache_overflows",138
  346. "Tc_log_max_pages_used",0
  347. "Tc_log_page_size",0
  348. "Tc_log_page_waits",0
  349. "Threads_cached",7
  350. "Threads_connected",12
  351. "Threads_created",21
  352. "Threads_running",1
  353. "Uptime",247693
  354. "Uptime_since_flush_status",247693
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement