API tools faq
paste
Advertisement
Guest User

GLOBAL STATUS

a guest
Mar 27th, 2020
353
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 8.98 KB | None | 0 0
raw download clone embed print report
  1. Variable_name Value
  2. Aborted_clients 0
  3. Aborted_connects 63
  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 2479026167
  9. Bytes_sent 18868673646
  10. Com_admin_commands 4232
  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 1816
  20. Com_alter_tablespace 0
  21. Com_alter_user 5
  22. Com_analyze 0
  23. Com_begin 97678
  24. Com_binlog 0
  25. Com_call_procedure 0
  26. Com_change_db 67007
  27. Com_change_master 0
  28. Com_change_repl_filter 0
  29. Com_check 93
  30. Com_checksum 0
  31. Com_commit 97528
  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 91
  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 36542
  45. Com_delete_multi 346
  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 91
  54. Com_drop_trigger 0
  55. Com_drop_user 1
  56. Com_drop_view 0
  57. Com_empty_query 0
  58. Com_execute_sql 0
  59. Com_explain_other 0
  60. Com_flush 1
  61. Com_get_diagnostics 0
  62. Com_grant 2
  63. Com_ha_close 0
  64. Com_ha_open 0
  65. Com_ha_read 0
  66. Com_help 0
  67. Com_insert 121849
  68. Com_insert_select 2454
  69. Com_install_plugin 0
  70. Com_kill 0
  71. Com_load 0
  72. Com_lock_tables 69
  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 150
  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 11436
  90. Com_savepoint 150
  91. Com_select 7922384
  92. Com_set_option 326909
  93. Com_signal 0
  94. Com_show_binlog_events 0
  95. Com_show_binlogs 1
  96. Com_show_charsets 0
  97. Com_show_collations 0
  98. Com_show_create_db 75
  99. Com_show_create_event 0
  100. Com_show_create_func 2
  101. Com_show_create_proc 0
  102. Com_show_create_table 7994
  103. Com_show_create_trigger 2
  104. Com_show_databases 11
  105. Com_show_engine_logs 0
  106. Com_show_engine_mutex 0
  107. Com_show_engine_status 24
  108. Com_show_events 75
  109. Com_show_errors 0
  110. Com_show_fields 30671
  111. Com_show_function_code 0
  112. Com_show_function_status 75
  113. Com_show_grants 828
  114. Com_show_keys 11
  115. Com_show_master_status 1
  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 75
  121. Com_show_processlist 845
  122. Com_show_profile 0
  123. Com_show_profiles 0
  124. Com_show_relaylog_events 0
  125. Com_show_slave_hosts 4
  126. Com_show_slave_status 5
  127. Com_show_status 16779
  128. Com_show_storage_engines 4
  129. Com_show_table_status 12084
  130. Com_show_tables 1689
  131. Com_show_triggers 5719
  132. Com_show_variables 4555
  133. Com_show_warnings 16
  134. Com_show_create_user 821
  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 713594
  141. Com_stmt_close 713594
  142. Com_stmt_fetch 0
  143. Com_stmt_prepare 713594
  144. Com_stmt_reset 0
  145. Com_stmt_send_long_data 37
  146. Com_truncate 137
  147. Com_uninstall_plugin 0
  148. Com_unlock_tables 219
  149. Com_update 94788
  150. Com_update_multi 3340
  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 152799
  165. Created_tmp_disk_tables 789774
  166. Created_tmp_files 1806
  167. Created_tmp_tables 1422159
  168. Delayed_errors 0
  169. Delayed_insert_threads 0
  170. Delayed_writes 0
  171. Flush_commands 1
  172. Handler_commit 5789387
  173. Handler_delete 783179
  174. Handler_discover 0
  175. Handler_external_lock 28027953
  176. Handler_mrr_init 0
  177. Handler_prepare 0
  178. Handler_read_first 2409650
  179. Handler_read_key 149478850
  180. Handler_read_last 44414
  181. Handler_read_next 212414010
  182. Handler_read_prev 716590
  183. Handler_read_rnd 34605681
  184. Handler_read_rnd_next 27644368180
  185. Handler_rollback 159
  186. Handler_savepoint 150
  187. Handler_savepoint_rollback 11436
  188. Handler_update 556101
  189. Handler_write 24346997
  190. Innodb_buffer_pool_dump_status Dumping of buffer pool not started
  191. Innodb_buffer_pool_load_status Buffer pool(s) load completed at 200324 9:58:09
  192. Innodb_buffer_pool_resize_status
  193. Innodb_buffer_pool_pages_data 74196
  194. Innodb_buffer_pool_bytes_data 1215627264
  195. Innodb_buffer_pool_pages_dirty 0
  196. Innodb_buffer_pool_bytes_dirty 0
  197. Innodb_buffer_pool_pages_flushed 684416
  198. Innodb_buffer_pool_pages_free 1102876
  199. Innodb_buffer_pool_pages_misc 2432
  200. Innodb_buffer_pool_pages_total 1179504
  201. Innodb_buffer_pool_read_ahead_rnd 0
  202. Innodb_buffer_pool_read_ahead 21675
  203. Innodb_buffer_pool_read_ahead_evicted 0
  204. Innodb_buffer_pool_read_requests 3983274619
  205. Innodb_buffer_pool_reads 50266
  206. Innodb_buffer_pool_wait_free 0
  207. Innodb_buffer_pool_write_requests 30470460
  208. Innodb_data_fsyncs 486628
  209. Innodb_data_pending_fsyncs 0
  210. Innodb_data_pending_reads 0
  211. Innodb_data_pending_writes 0
  212. Innodb_data_read 1189794304
  213. Innodb_data_reads 77829
  214. Innodb_data_writes 1076916
  215. Innodb_data_written 20489559040
  216. Innodb_dblwr_pages_written 529526
  217. Innodb_dblwr_writes 144524
  218. Innodb_log_waits 0
  219. Innodb_log_write_requests 766738
  220. Innodb_log_writes 207632
  221. Innodb_os_log_fsyncs 114977
  222. Innodb_os_log_pending_fsyncs 0
  223. Innodb_os_log_pending_writes 0
  224. Innodb_os_log_written 580173312
  225. Innodb_page_size 16384
  226. Innodb_pages_created 2196
  227. Innodb_pages_read 72614
  228. Innodb_pages_written 684416
  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 1
  234. Innodb_rows_deleted 772520
  235. Innodb_rows_inserted 11901162
  236. Innodb_rows_read 27628164275
  237. Innodb_rows_updated 144295
  238. Innodb_num_open_files 5206
  239. Innodb_truncated_status_writes 0
  240. Innodb_available_undo_logs 128
  241. Key_blocks_not_flushed 0
  242. Key_blocks_unused 213196
  243. Key_blocks_used 1798
  244. Key_read_requests 27489421
  245. Key_reads 9947
  246. Key_write_requests 76731
  247. Key_writes 45424
  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 128
  253. Max_used_connections_time 2020-03-26 13:06:41
  254. Not_flushed_delayed_rows 0
  255. Ongoing_anonymous_transaction_count 0
  256. Open_files 1834
  257. Open_streams 0
  258. Open_table_definitions 6511
  259. Open_tables 7408
  260. Opened_files 103798
  261. Opened_table_definitions 8645
  262. Opened_tables 455578
  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 190682
  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 10451647
  303. Questions 9007651
  304. Rsa_public_key -----BEGIN PUBLIC KEY----------END PUBLIC KEY-----\n
  305. Select_full_join 19962
  306. Select_full_range_join 84849
  307. Select_range 818738
  308. Select_range_check 7606
  309. Select_scan 1428764
  310. Slave_open_temp_tables 0
  311. Slow_launch_threads 0
  312. Slow_queries 1387
  313. Sort_merge_passes 900
  314. Sort_range 907369
  315. Sort_rows 37467832
  316. Sort_scan 1334445
  317. Ssl_accept_renegotiates 0
  318. Ssl_accepts 0
  319. Ssl_callback_cache_hits 0
  320. Ssl_cipher
  321. Ssl_cipher_list
  322. Ssl_client_connects 0
  323. Ssl_connect_renegotiates 0
  324. Ssl_ctx_verify_depth 18446744073709551615
  325. Ssl_ctx_verify_mode 5
  326. Ssl_default_timeout 0
  327. Ssl_finished_accepts 0
  328. Ssl_finished_connects 0
  329. Ssl_server_not_after Jan 31 12:11:31 2030 GMT
  330. Ssl_server_not_before Feb 3 12:11:31 2020 GMT
  331. Ssl_session_cache_hits 0
  332. Ssl_session_cache_misses 0
  333. Ssl_session_cache_mode SERVER
  334. Ssl_session_cache_overflows 0
  335. Ssl_session_cache_size 128
  336. Ssl_session_cache_timeouts 0
  337. Ssl_sessions_reused 0
  338. Ssl_used_session_cache_entries 0
  339. Ssl_verify_depth 0
  340. Ssl_verify_mode 0
  341. Ssl_version
  342. Table_locks_immediate 2820668
  343. Table_locks_waited 205
  344. Table_open_cache_hits 14634100
  345. Table_open_cache_misses 455487
  346. Table_open_cache_overflows 443831
  347. Tc_log_max_pages_used 0
  348. Tc_log_page_size 0
  349. Tc_log_page_waits 0
  350. Threads_cached 8
  351. Threads_connected 2
  352. Threads_created 261
  353. Threads_running 1
  354. Uptime 253512
  355. Uptime_since_flush_status 253512
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
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!