API tools faq
paste
tkiran

SHow Global Status

tkiran
Apr 16th, 2019
198
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 9.16 KB | None | 0 0
raw download clone embed print report
  1. Variable_name Value
  2. Aborted_clients 2030
  3. Aborted_connects 1697
  4. Binlog_cache_disk_use 194002
  5. Binlog_cache_use 1654315689
  6. Binlog_stmt_cache_disk_use 0
  7. Binlog_stmt_cache_use 42777
  8. Bytes_received 1207444608164
  9. Bytes_sent 1178830987920
  10. Com_admin_commands 42848
  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 19
  20. Com_alter_tablespace 0
  21. Com_alter_user 0
  22. Com_analyze 0
  23. Com_begin 1649854499
  24. Com_binlog 0
  25. Com_call_procedure 7430426
  26. Com_change_db 480
  27. Com_change_master 0
  28. Com_change_repl_filter 0
  29. Com_check 0
  30. Com_checksum 0
  31. Com_commit 1660237104
  32. Com_create_db 0
  33. Com_create_event 0
  34. Com_create_function 0
  35. Com_create_index 0
  36. Com_create_procedure 112
  37. Com_create_server 0
  38. Com_create_table 21263
  39. Com_create_trigger 0
  40. Com_create_udf 0
  41. Com_create_user 0
  42. Com_create_view 0
  43. Com_dealloc_sql 28086
  44. Com_delete 1643709242
  45. Com_delete_multi 0
  46. Com_do 1648
  47. Com_drop_db 0
  48. Com_drop_event 0
  49. Com_drop_function 0
  50. Com_drop_index 0
  51. Com_drop_procedure 112
  52. Com_drop_server 0
  53. Com_drop_table 21231
  54. Com_drop_trigger 0
  55. Com_drop_user 0
  56. Com_drop_view 0
  57. Com_empty_query 0
  58. Com_execute_sql 30496
  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 2193033569
  68. Com_insert_select 221
  69. Com_install_plugin 0
  70. Com_kill 62
  71. Com_load 571
  72. Com_lock_tables 0
  73. Com_optimize 0
  74. Com_preload_keys 0
  75. Com_prepare_sql 30496
  76. Com_purge 0
  77. Com_purge_before_date 0
  78. Com_release_savepoint 0
  79. Com_rename_table 36
  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 760459
  89. Com_rollback_to_savepoint 0
  90. Com_savepoint 0
  91. Com_select 15138927
  92. Com_set_option 15196134
  93. Com_signal 3296
  94. Com_show_binlog_events 0
  95. Com_show_binlogs 0
  96. Com_show_charsets 9
  97. Com_show_collations 9
  98. Com_show_create_db 17
  99. Com_show_create_event 0
  100. Com_show_create_func 0
  101. Com_show_create_proc 7420630
  102. Com_show_create_table 306
  103. Com_show_create_trigger 0
  104. Com_show_databases 173
  105. Com_show_engine_logs 0
  106. Com_show_engine_mutex 0
  107. Com_show_engine_status 8
  108. Com_show_events 0
  109. Com_show_errors 0
  110. Com_show_fields 401
  111. Com_show_function_code 0
  112. Com_show_function_status 3
  113. Com_show_grants 0
  114. Com_show_keys 311
  115. Com_show_master_status 0
  116. Com_show_open_tables 0
  117. Com_show_plugins 6
  118. Com_show_privileges 0
  119. Com_show_procedure_code 0
  120. Com_show_procedure_status 3
  121. Com_show_processlist 66
  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 5853
  127. Com_show_status 13112
  128. Com_show_storage_engines 2
  129. Com_show_table_status 24
  130. Com_show_tables 6816269
  131. Com_show_triggers 3
  132. Com_show_variables 175
  133. Com_show_warnings 66374
  134. Com_show_create_user 0
  135. Com_shutdown 0
  136. Com_slave_start 1
  137. Com_slave_stop 1
  138. Com_group_replication_start 0
  139. Com_group_replication_stop 0
  140. Com_stmt_execute 30496
  141. Com_stmt_close 30394
  142. Com_stmt_fetch 0
  143. Com_stmt_prepare 30496
  144. Com_stmt_reset 0
  145. Com_stmt_send_long_data 0
  146. Com_truncate 31
  147. Com_uninstall_plugin 0
  148. Com_unlock_tables 0
  149. Com_update 372855165
  150. Com_update_multi 571
  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 102836
  165. Created_tmp_disk_tables 7367
  166. Created_tmp_files 1479
  167. Created_tmp_tables 6919004
  168. Delayed_errors 0
  169. Delayed_insert_threads 0
  170. Delayed_writes 0
  171. Flush_commands 1
  172. Handler_commit 11731588940
  173. Handler_delete 1652805180
  174. Handler_discover 0
  175. Handler_external_lock 8443987310
  176. Handler_mrr_init 0
  177. Handler_prepare 11721843044
  178. Handler_read_first 3047324
  179. Handler_read_key 65092878917
  180. Handler_read_last 19
  181. Handler_read_next 135374255742
  182. Handler_read_prev 7473
  183. Handler_read_rnd 2447736103
  184. Handler_read_rnd_next 59639535162
  185. Handler_rollback 502
  186. Handler_savepoint 0
  187. Handler_savepoint_rollback 0
  188. Handler_update 7752066271
  189. Handler_write 3358929993
  190. Innodb_buffer_pool_dump_status Dumping of buffer pool not started
  191. Innodb_buffer_pool_load_status Buffer pool(s) load completed at 190316 13:55:48
  192. Innodb_buffer_pool_resize_status
  193. Innodb_buffer_pool_pages_data 4509817
  194. Innodb_buffer_pool_bytes_data 73888841728
  195. Innodb_buffer_pool_pages_dirty 17452
  196. Innodb_buffer_pool_bytes_dirty 285933568
  197. Innodb_buffer_pool_pages_flushed 513074244
  198. Innodb_buffer_pool_pages_free 8186
  199. Innodb_buffer_pool_pages_misc 68957
  200. Innodb_buffer_pool_pages_total 4586960
  201. Innodb_buffer_pool_read_ahead_rnd 0
  202. Innodb_buffer_pool_read_ahead 6049256
  203. Innodb_buffer_pool_read_ahead_evicted 1186
  204. Innodb_buffer_pool_read_requests 667160594258
  205. Innodb_buffer_pool_reads 1006346347
  206. Innodb_buffer_pool_wait_free 27847
  207. Innodb_buffer_pool_write_requests 70508958855
  208. Innodb_data_fsyncs 84301188
  209. Innodb_data_pending_fsyncs 0
  210. Innodb_data_pending_reads 0
  211. Innodb_data_pending_writes 0
  212. Innodb_data_read 16726834041344
  213. Innodb_data_reads 1021065993
  214. Innodb_data_writes 2209248332
  215. Innodb_data_written 24742420625920
  216. Innodb_dblwr_pages_written 510446736
  217. Innodb_dblwr_writes 29374160
  218. Innodb_log_waits 0
  219. Innodb_log_write_requests 12154971307
  220. Innodb_log_writes 1662275231
  221. Innodb_os_log_fsyncs 5670451
  222. Innodb_os_log_pending_fsyncs 0
  223. Innodb_os_log_pending_writes 0
  224. Innodb_os_log_written 7973352303616
  225. Innodb_page_size 16384
  226. Innodb_pages_created 78483818
  227. Innodb_pages_read 1021090541
  228. Innodb_pages_written 513083786
  229. Innodb_row_lock_current_waits 0
  230. Innodb_row_lock_time 899544
  231. Innodb_row_lock_time_avg 4
  232. Innodb_row_lock_time_max 51833
  233. Innodb_row_lock_waits 216337
  234. Innodb_rows_deleted 1652805070
  235. Innodb_rows_inserted 3409429148
  236. Innodb_rows_read 199698891177
  237. Innodb_rows_updated 1725560750
  238. Innodb_num_open_files 577
  239. Innodb_truncated_status_writes 0
  240. Innodb_available_undo_logs 128
  241. Key_blocks_not_flushed 0
  242. Key_blocks_unused 857349
  243. Key_blocks_used 19
  244. Key_read_requests 207781694
  245. Key_reads 19
  246. Key_write_requests 444
  247. Key_writes 444
  248. Locked_connects 0
  249. Max_execution_time_exceeded 0
  250. Max_execution_time_set 16
  251. Max_execution_time_set_failed 0
  252. Max_used_connections 357
  253. Max_used_connections_time 43553
  254. Not_flushed_delayed_rows 0
  255. Ongoing_anonymous_transaction_count 1
  256. Open_files 236
  257. Open_streams 0
  258. Open_table_definitions 995
  259. Open_tables 4129
  260. Opened_files 280839
  261. Opened_table_definitions 43568
  262. Opened_tables 25485
  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 22301927
  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 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 5936481203
  303. Questions 59444814
  304. Select_full_join 995
  305. Select_full_range_join 0
  306. Select_range 7448074
  307. Select_range_check 6
  308. Select_scan 7124788
  309. Slave_open_temp_tables 0
  310. Slow_launch_threads 0
  311. Slow_queries 1492
  312. Sort_merge_passes 175
  313. Sort_range 944410
  314. Sort_rows 20850327
  315. Sort_scan 550486
  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 Oct 6 15:03:37 2027 GMT
  329. Ssl_server_not_before Nov 27 15:03:37 2017 GMT
  330. Ssl_session_cache_hits 0
  331. Ssl_session_cache_misses 0
  332. Ssl_session_cache_mode Unknown
  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 7447527
  342. Table_locks_waited 0
  343. Table_open_cache_hits 4220853991
  344. Table_open_cache_misses 25476
  345. Table_open_cache_overflows 0
  346. Tc_log_max_pages_used 0
  347. Tc_log_page_size 0
  348. Tc_log_page_waits 0
  349. Threads_cached 315
  350. Threads_connected 42
  351. Threads_created 357
  352. Threads_running 3
  353. Uptime 2602600
  354. Uptime_since_flush_status 2602600
  355. validate_password_dictionary_file_last_parsed 43541
  356. validate_password_dictionary_file_words_count 0
Add Comment
Please, Sign In to add comment
Public Pastes
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!