Advertisement
Guest User

Show Global Status

a guest
Nov 19th, 2018
194
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 9.27 KB | None | 0 0
  1. "Variable_name","Value"
  2. "Aborted_clients",0
  3. "Aborted_connects",0
  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",861337
  9. "Bytes_sent",6616365
  10. "Com_admin_commands",12
  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",107
  24. "Com_binlog",0
  25. "Com_call_procedure",0
  26. "Com_change_db",326
  27. "Com_change_master",0
  28. "Com_change_repl_filter",0
  29. "Com_check",0
  30. "Com_checksum",0
  31. "Com_commit",107
  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",25
  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",0
  57. "Com_empty_query",0
  58. "Com_execute_sql",0
  59. "Com_explain_other",0
  60. "Com_flush",0
  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",433
  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",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",0
  89. "Com_rollback_to_savepoint",0
  90. "Com_savepoint",0
  91. "Com_select",2309
  92. "Com_set_option",652
  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",0
  101. "Com_show_create_proc",0
  102. "Com_show_create_table",0
  103. "Com_show_create_trigger",0
  104. "Com_show_databases",0
  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",0
  111. "Com_show_function_code",0
  112. "Com_show_function_status",0
  113. "Com_show_grants",0
  114. "Com_show_keys",0
  115. "Com_show_master_status",0
  116. "Com_show_open_tables",0
  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",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",0
  127. "Com_show_status",8
  128. "Com_show_storage_engines",0
  129. "Com_show_table_status",0
  130. "Com_show_tables",0
  131. "Com_show_triggers",0
  132. "Com_show_variables",3
  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",3575
  141. "Com_stmt_close",3575
  142. "Com_stmt_fetch",0
  143. "Com_stmt_prepare",3575
  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",164
  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",328
  165. "Created_tmp_disk_tables",26
  166. "Created_tmp_files",12
  167. "Created_tmp_tables",51
  168. "Delayed_errors",0
  169. "Delayed_insert_threads",0
  170. "Delayed_writes",0
  171. "Flush_commands",1
  172. "Handler_commit",3036
  173. "Handler_delete",24
  174. "Handler_discover",0
  175. "Handler_external_lock",6505
  176. "Handler_mrr_init",0
  177. "Handler_prepare",0
  178. "Handler_read_first",602
  179. "Handler_read_key",6488330
  180. "Handler_read_last",0
  181. "Handler_read_next",5086215
  182. "Handler_read_prev",27
  183. "Handler_read_rnd",89259
  184. "Handler_read_rnd_next",23604403
  185. "Handler_rollback",0
  186. "Handler_savepoint",0
  187. "Handler_savepoint_rollback",0
  188. "Handler_update",6243460
  189. "Handler_write",232111
  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 11:37:33"
  192. "Innodb_buffer_pool_resize_status",""
  193. "Innodb_buffer_pool_pages_data",120936
  194. "Innodb_buffer_pool_bytes_data",1981415424
  195. "Innodb_buffer_pool_pages_dirty",116
  196. "Innodb_buffer_pool_bytes_dirty",1900544
  197. "Innodb_buffer_pool_pages_flushed",2653
  198. "Innodb_buffer_pool_pages_free",665177
  199. "Innodb_buffer_pool_pages_misc",311
  200. "Innodb_buffer_pool_pages_total",786424
  201. "Innodb_buffer_pool_read_ahead_rnd",0
  202. "Innodb_buffer_pool_read_ahead",87380
  203. "Innodb_buffer_pool_read_ahead_evicted",0
  204. "Innodb_buffer_pool_read_requests",31566922
  205. "Innodb_buffer_pool_reads",33117
  206. "Innodb_buffer_pool_wait_free",0
  207. "Innodb_buffer_pool_write_requests",776106
  208. "Innodb_data_fsyncs",2987
  209. "Innodb_data_pending_fsyncs",0
  210. "Innodb_data_pending_reads",0
  211. "Innodb_data_pending_writes",0
  212. "Innodb_data_read",1974522368
  213. "Innodb_data_reads",120589
  214. "Innodb_data_writes",4505
  215. "Innodb_data_written",80838144
  216. "Innodb_dblwr_pages_written",2193
  217. "Innodb_dblwr_writes",736
  218. "Innodb_log_waits",0
  219. "Innodb_log_write_requests",1205
  220. "Innodb_log_writes",857
  221. "Innodb_os_log_fsyncs",1042
  222. "Innodb_os_log_pending_fsyncs",0
  223. "Innodb_os_log_pending_writes",0
  224. "Innodb_os_log_written",1347584
  225. "Innodb_page_size",16384
  226. "Innodb_pages_created",425
  227. "Innodb_pages_read",120511
  228. "Innodb_pages_written",2653
  229. "Innodb_row_lock_current_waits",0
  230. "Innodb_row_lock_time",0
  231. "Innodb_row_lock_time_avg",0
  232. "Innodb_row_lock_time_max",0
  233. "Innodb_row_lock_waits",0
  234. "Innodb_rows_deleted",24
  235. "Innodb_rows_inserted",153927
  236. "Innodb_rows_read",28572000
  237. "Innodb_rows_updated",115695
  238. "Innodb_num_open_files",70
  239. "Innodb_truncated_status_writes",0
  240. "Innodb_available_undo_logs",128
  241. "Key_blocks_not_flushed",0
  242. "Key_blocks_unused",6695
  243. "Key_blocks_used",3
  244. "Key_read_requests",6
  245. "Key_reads",3
  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",5
  253. "Max_used_connections_time","2018-11-19 11:38:15"
  254. "Not_flushed_delayed_rows",0
  255. "Ongoing_anonymous_transaction_count",0
  256. "Open_files",14
  257. "Open_streams",0
  258. "Open_table_definitions",146
  259. "Open_tables",570
  260. "Opened_files",187
  261. "Opened_table_definitions",146
  262. "Opened_tables",580
  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",0
  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",1
  295. "Qcache_free_memory",16760152
  296. "Qcache_hits",0
  297. "Qcache_inserts",0
  298. "Qcache_lowmem_prunes",0
  299. "Qcache_not_cached",2309
  300. "Qcache_queries_in_cache",0
  301. "Qcache_total_blocks",1
  302. "Queries",11621
  303. "Questions",4458
  304. "Select_full_join",0
  305. "Select_full_range_join",0
  306. "Select_range",0
  307. "Select_range_check",0
  308. "Select_scan",615
  309. "Slave_open_temp_tables",0
  310. "Slow_launch_threads",0
  311. "Slow_queries",0
  312. "Sort_merge_passes",11
  313. "Sort_range",6
  314. "Sort_rows",242297
  315. "Sort_scan",54
  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",109
  342. "Table_locks_waited",0
  343. "Table_open_cache_hits",5802
  344. "Table_open_cache_misses",580
  345. "Table_open_cache_overflows",3
  346. "Tc_log_max_pages_used",0
  347. "Tc_log_page_size",0
  348. "Tc_log_page_waits",0
  349. "Threads_cached",3
  350. "Threads_connected",2
  351. "Threads_created",5
  352. "Threads_running",1
  353. "Uptime",641
  354. "Uptime_since_flush_status",641
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement