API tools faq
paste
Advertisement
roozgar

SHOW GLOBAL STATUS;

roozgar
Jun 15th, 2019
171
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 13.46 KB | None | 0 0
raw download clone embed print report
  1. Variable_name Value
  2. Aborted_clients 30
  3. Aborted_connects 0
  4. Access_denied_errors 0
  5. Acl_column_grants 0
  6. Acl_database_grants 4
  7. Acl_function_grants 0
  8. Acl_procedure_grants 0
  9. Acl_proxy_users 1
  10. Acl_role_grants 0
  11. Acl_roles 0
  12. Acl_table_grants 0
  13. Acl_users 6
  14. Aria_pagecache_blocks_not_flushed 0
  15. Aria_pagecache_blocks_unused 15706
  16. Aria_pagecache_blocks_used 2
  17. Aria_pagecache_read_requests 951
  18. Aria_pagecache_reads 79
  19. Aria_pagecache_write_requests 150
  20. Aria_pagecache_writes 0
  21. Aria_transaction_log_syncs 0
  22. Binlog_commits 1105073
  23. Binlog_group_commits 1075804
  24. Binlog_group_commit_trigger_count 0
  25. Binlog_group_commit_trigger_lock_wait 0
  26. Binlog_group_commit_trigger_timeout 0
  27. Binlog_snapshot_file mysql-bin.000014
  28. Binlog_snapshot_position 87434984
  29. Binlog_bytes_written 2234921041
  30. Binlog_cache_disk_use 61
  31. Binlog_cache_use 1104960
  32. Binlog_stmt_cache_disk_use 0
  33. Binlog_stmt_cache_use 0
  34. Busy_time 0
  35. Bytes_received 2595524009
  36. Bytes_sent 10762195277
  37. Com_admin_commands 0
  38. Com_alter_db 0
  39. Com_alter_db_upgrade 0
  40. Com_alter_event 0
  41. Com_alter_function 0
  42. Com_alter_procedure 0
  43. Com_alter_server 0
  44. Com_alter_table 0
  45. Com_alter_tablespace 0
  46. Com_analyze 0
  47. Com_assign_to_keycache 0
  48. Com_begin 0
  49. Com_binlog 0
  50. Com_call_procedure 0
  51. Com_change_db 19
  52. Com_change_master 0
  53. Com_check 0
  54. Com_checksum 0
  55. Com_commit 0
  56. Com_compound_sql 0
  57. Com_create_db 0
  58. Com_create_event 0
  59. Com_create_function 0
  60. Com_create_index 0
  61. Com_create_procedure 0
  62. Com_create_role 0
  63. Com_create_server 0
  64. Com_create_table 0
  65. Com_create_temporary_table 0
  66. Com_create_trigger 0
  67. Com_create_udf 0
  68. Com_create_user 0
  69. Com_create_view 0
  70. Com_dealloc_sql 0
  71. Com_delete 41052
  72. Com_delete_multi 0
  73. Com_do 0
  74. Com_drop_db 0
  75. Com_drop_event 0
  76. Com_drop_function 0
  77. Com_drop_index 0
  78. Com_drop_procedure 0
  79. Com_drop_role 0
  80. Com_drop_server 0
  81. Com_drop_table 0
  82. Com_drop_temporary_table 0
  83. Com_drop_trigger 0
  84. Com_drop_user 0
  85. Com_drop_view 0
  86. Com_empty_query 0
  87. Com_execute_sql 0
  88. Com_flush 0
  89. Com_get_diagnostics 0
  90. Com_grant 0
  91. Com_grant_role 0
  92. Com_ha_close 0
  93. Com_ha_open 0
  94. Com_ha_read 0
  95. Com_help 0
  96. Com_insert 850101
  97. Com_insert_select 0
  98. Com_install_plugin 0
  99. Com_kill 0
  100. Com_load 0
  101. Com_lock_tables 0
  102. Variable_name Value
  103. Com_optimize 0
  104. Com_preload_keys 0
  105. Com_prepare_sql 0
  106. Com_purge 0
  107. Com_purge_before_date 0
  108. Com_release_savepoint 0
  109. Com_rename_table 0
  110. Com_rename_user 0
  111. Com_repair 0
  112. Com_replace 1
  113. Com_replace_select 0
  114. Com_reset 0
  115. Com_resignal 0
  116. Com_revoke 0
  117. Com_revoke_all 0
  118. Com_revoke_role 0
  119. Com_rollback 0
  120. Com_rollback_to_savepoint 0
  121. Com_savepoint 0
  122. Com_select 3406557
  123. Com_set_option 1646966
  124. Com_show_authors 0
  125. Com_show_binlog_events 0
  126. Com_show_binlogs 0
  127. Com_show_charsets 0
  128. Com_show_collations 0
  129. Com_show_contributors 0
  130. Com_show_create_db 0
  131. Com_show_create_event 0
  132. Com_show_create_func 0
  133. Com_show_create_proc 0
  134. Com_show_create_table 1
  135. Com_show_create_trigger 0
  136. Com_show_databases 0
  137. Com_show_engine_logs 0
  138. Com_show_engine_mutex 0
  139. Com_show_engine_status 0
  140. Com_show_errors 0
  141. Com_show_events 0
  142. Com_show_explain 0
  143. Com_show_fields 47
  144. Com_show_function_status 0
  145. Com_show_generic 0
  146. Com_show_grants 0
  147. Com_show_keys 46
  148. Com_show_master_status 5
  149. Com_show_open_tables 0
  150. Com_show_plugins 0
  151. Com_show_privileges 0
  152. Com_show_procedure_status 0
  153. Com_show_processlist 0
  154. Com_show_profile 0
  155. Com_show_profiles 0
  156. Com_show_relaylog_events 0
  157. Com_show_slave_hosts 0
  158. Com_show_slave_status 5
  159. Com_show_status 1
  160. Com_show_storage_engines 0
  161. Com_show_table_status 0
  162. Com_show_tables 830
  163. Com_show_triggers 0
  164. Com_show_variables 48
  165. Com_show_warnings 11
  166. Com_shutdown 0
  167. Com_signal 0
  168. Com_start_all_slaves 0
  169. Com_start_slave 0
  170. Com_stmt_close 0
  171. Com_stmt_execute 0
  172. Com_stmt_fetch 0
  173. Com_stmt_prepare 0
  174. Com_stmt_reprepare 0
  175. Com_stmt_reset 0
  176. Com_stmt_send_long_data 0
  177. Com_stop_all_slaves 0
  178. Com_stop_slave 0
  179. Com_truncate 10
  180. Com_uninstall_plugin 0
  181. Com_unlock_tables 0
  182. Com_update 213919
  183. Com_update_multi 0
  184. Com_xa_commit 0
  185. Com_xa_end 0
  186. Com_xa_prepare 0
  187. Com_xa_recover 0
  188. Com_xa_rollback 0
  189. Com_xa_start 0
  190. Compression OFF
  191. Connection_errors_accept 0
  192. Connection_errors_internal 0
  193. Connection_errors_max_connections 0
  194. Connection_errors_peer_address 0
  195. Connection_errors_select 0
  196. Connection_errors_tcpwrap 0
  197. Connections 1646533
  198. Cpu_time 0
  199. Created_tmp_disk_tables 95
  200. Created_tmp_files 7
  201. Created_tmp_tables 2724
  202. Delayed_errors 0
  203. Variable_name Value
  204. Delayed_insert_threads 0
  205. Delayed_writes 0
  206. Delete_scan 41052
  207. Empty_queries 626611
  208. Executed_events 0
  209. Executed_triggers 0
  210. Feature_delay_key_write 0
  211. Feature_dynamic_columns 0
  212. Feature_fulltext 0
  213. Feature_gis 0
  214. Feature_locale 436
  215. Feature_subquery 31733
  216. Feature_timezone 0
  217. Feature_trigger 0
  218. Feature_xml 0
  219. Flush_commands 1
  220. Handler_commit 3834737
  221. Handler_delete 30850
  222. Handler_discover 0
  223. Handler_external_lock 0
  224. Handler_icp_attempts 0
  225. Handler_icp_match 0
  226. Handler_mrr_init 0
  227. Handler_mrr_key_refills 0
  228. Handler_mrr_rowid_refills 0
  229. Handler_prepare 2158884
  230. Handler_read_first 75
  231. Handler_read_key 66140124
  232. Handler_read_last 172853
  233. Handler_read_next 354295
  234. Handler_read_prev 18979067
  235. Handler_read_retry 0
  236. Handler_read_rnd 170632
  237. Handler_read_rnd_deleted 10
  238. Handler_read_rnd_next 1088920414
  239. Handler_rollback 1
  240. Handler_savepoint 0
  241. Handler_savepoint_rollback 0
  242. Handler_tmp_update 0
  243. Handler_tmp_write 231481
  244. Handler_update 214332
  245. Handler_write 23123520
  246. Innodb_available_undo_logs 128
  247. Innodb_background_log_sync 231559
  248. Innodb_buffer_pool_bytes_data 3030974464
  249. Innodb_buffer_pool_bytes_dirty 22003712
  250. Innodb_buffer_pool_dump_status Dumping buffer pool(s) not yet started
  251. Innodb_buffer_pool_load_status Loading buffer pool(s) not yet started
  252. Innodb_buffer_pool_pages_data 184996
  253. Innodb_buffer_pool_pages_dirty 1343
  254. Innodb_buffer_pool_pages_flushed 1265082
  255. Innodb_buffer_pool_pages_free 1125655
  256. Innodb_buffer_pool_pages_lru_flushed 0
  257. Innodb_buffer_pool_pages_made_not_young 0
  258. Innodb_buffer_pool_pages_made_young 1695
  259. Innodb_buffer_pool_pages_misc 49
  260. Innodb_buffer_pool_pages_old 67880
  261. Innodb_buffer_pool_pages_total 1310700
  262. Innodb_buffer_pool_read_ahead 128
  263. Innodb_buffer_pool_read_ahead_evicted 0
  264. Innodb_buffer_pool_read_ahead_rnd 0
  265. Innodb_buffer_pool_read_requests 1441945629
  266. Innodb_buffer_pool_reads 7161
  267. Innodb_buffer_pool_wait_free 0
  268. Innodb_buffer_pool_write_requests 98923659
  269. Innodb_checkpoint_age 16951958
  270. Innodb_checkpoint_max_age 80826164
  271. Innodb_data_fsyncs 1210564
  272. Innodb_data_pending_fsyncs 0
  273. Innodb_data_pending_reads 0
  274. Innodb_data_pending_writes 0
  275. Innodb_data_read 147558912
  276. Innodb_data_reads 9153
  277. Innodb_data_writes 2362729
  278. Innodb_data_written 3472271872
  279. Innodb_dblwr_pages_written 1265107
  280. Innodb_dblwr_writes 69781
  281. Innodb_deadlocks 0
  282. Innodb_have_atomic_builtins ON
  283. Innodb_history_list_length 29
  284. Innodb_ibuf_discarded_delete_marks 0
  285. Innodb_ibuf_discarded_deletes 0
  286. Innodb_ibuf_discarded_inserts 0
  287. Innodb_ibuf_free_list 72
  288. Innodb_ibuf_merged_delete_marks 0
  289. Innodb_ibuf_merged_deletes 0
  290. Innodb_ibuf_merged_inserts 3841
  291. Innodb_ibuf_merges 1592
  292. Innodb_ibuf_segment_size 74
  293. Innodb_ibuf_size 1
  294. Innodb_log_waits 0
  295. Innodb_log_write_requests 9296249
  296. Innodb_log_writes 986666
  297. Innodb_lsn_current 9342511991
  298. Innodb_lsn_flushed 9342511957
  299. Innodb_lsn_last_checkpoint 9325560033
  300. Innodb_master_thread_active_loops 61843
  301. Innodb_master_thread_idle_loops 169826
  302. Innodb_max_trx_id 14943666
  303. Innodb_mem_adaptive_hash 340798880
  304. Variable_name Value
  305. Innodb_mem_dictionary 85169968
  306. Innodb_mem_total 891289600
  307. Innodb_mutex_os_waits 684434
  308. Innodb_mutex_spin_rounds 21556941
  309. Innodb_mutex_spin_waits 2009489
  310. Innodb_oldest_view_low_limit_trx_id 0
  311. Innodb_os_log_fsyncs 1023124
  312. Innodb_os_log_pending_fsyncs 0
  313. Innodb_os_log_pending_writes 0
  314. Innodb_os_log_written 4946993152
  315. Innodb_page_size 16384
  316. Innodb_pages_created 176115
  317. Innodb_pages_read 8881
  318. Innodb_pages0_read 141
  319. Innodb_pages_written 1265085
  320. Innodb_purge_trx_id 14943663
  321. Innodb_purge_undo_no 0
  322. Innodb_read_views_memory 8713096
  323. Innodb_row_lock_current_waits 0
  324. Innodb_row_lock_time 8920
  325. Innodb_row_lock_time_avg 33
  326. Innodb_row_lock_time_max 418
  327. Innodb_row_lock_waits 263
  328. Innodb_rows_deleted 30850
  329. Innodb_rows_inserted 23123519
  330. Innodb_rows_read 1168241937
  331. Innodb_rows_updated 214332
  332. Innodb_system_rows_deleted 0
  333. Innodb_system_rows_inserted 0
  334. Innodb_system_rows_read 0
  335. Innodb_system_rows_updated 0
  336. Innodb_s_lock_os_waits 64002
  337. Innodb_s_lock_spin_rounds 2158950
  338. Innodb_s_lock_spin_waits 106427
  339. Innodb_truncated_status_writes 0
  340. Innodb_x_lock_os_waits 115621
  341. Innodb_x_lock_spin_rounds 6967062
  342. Innodb_x_lock_spin_waits 806684
  343. Innodb_page_compression_saved 0
  344. Innodb_page_compression_trim_sect512 0
  345. Innodb_page_compression_trim_sect1024 0
  346. Innodb_page_compression_trim_sect2048 0
  347. Innodb_page_compression_trim_sect4096 0
  348. Innodb_page_compression_trim_sect8192 0
  349. Innodb_page_compression_trim_sect16384 0
  350. Innodb_page_compression_trim_sect32768 0
  351. Innodb_num_index_pages_written 1007116
  352. Innodb_num_non_index_pages_written 1355604
  353. Innodb_num_pages_page_compressed 0
  354. Innodb_num_page_compressed_trim_op 0
  355. Innodb_num_page_compressed_trim_op_saved 0
  356. Innodb_num_pages_page_decompressed 0
  357. Innodb_num_pages_page_compression_error 0
  358. Innodb_num_pages_encrypted 0
  359. Innodb_num_pages_decrypted 0
  360. Innodb_have_lz4 OFF
  361. Innodb_have_lzo OFF
  362. Innodb_have_lzma OFF
  363. Innodb_have_bzip2 OFF
  364. Innodb_have_snappy OFF
  365. Innodb_defragment_compression_failures 0
  366. Innodb_defragment_failures 0
  367. Innodb_defragment_count 0
  368. Innodb_onlineddl_rowlog_rows 0
  369. Innodb_onlineddl_rowlog_pct_used 0
  370. Innodb_onlineddl_pct_progress 0
  371. Innodb_secondary_index_triggered_cluster_reads 1431671
  372. Innodb_secondary_index_triggered_cluster_reads_avo... 0
  373. Innodb_buffered_aio_submitted 0
  374. Innodb_encryption_rotation_pages_read_from_cache 0
  375. Innodb_encryption_rotation_pages_read_from_disk 0
  376. Innodb_encryption_rotation_pages_modified 0
  377. Innodb_encryption_rotation_pages_flushed 0
  378. Innodb_encryption_rotation_estimated_iops 0
  379. Innodb_encryption_key_rotation_list_length 0
  380. Innodb_encryption_n_merge_blocks_encrypted 0
  381. Innodb_encryption_n_merge_blocks_decrypted 0
  382. Innodb_encryption_n_rowlog_blocks_encrypted 0
  383. Innodb_encryption_n_rowlog_blocks_decrypted 0
  384. Innodb_scrub_background_page_reorganizations 0
  385. Innodb_scrub_background_page_splits 0
  386. Innodb_scrub_background_page_split_failures_underf... 0
  387. Innodb_scrub_background_page_split_failures_out_of... 0
  388. Innodb_scrub_background_page_split_failures_missin... 0
  389. Innodb_scrub_background_page_split_failures_unknow... 0
  390. Innodb_encryption_num_key_requests 0
  391. Key_blocks_not_flushed 0
  392. Key_blocks_unused 428676
  393. Key_blocks_used 0
  394. Key_blocks_warm 0
  395. Key_read_requests 0
  396. Key_reads 0
  397. Key_write_requests 0
  398. Key_writes 0
  399. Last_query_cost 0
  400. Master_gtid_wait_count 0
  401. Master_gtid_wait_time 0
  402. Master_gtid_wait_timeouts 0
  403. Max_statement_time_exceeded 0
  404. Max_used_connections 930
  405. Variable_name Value
  406. Memory_used 751312768
  407. Not_flushed_delayed_rows 0
  408. Open_files 25
  409. Open_streams 0
  410. Open_table_definitions 70
  411. Open_tables 122
  412. Opened_files 529
  413. Opened_plugin_libraries 0
  414. Opened_table_definitions 79
  415. Opened_tables 213
  416. Opened_views 0
  417. Performance_schema_accounts_lost 0
  418. Performance_schema_cond_classes_lost 0
  419. Performance_schema_cond_instances_lost 0
  420. Performance_schema_digest_lost 0
  421. Performance_schema_file_classes_lost 0
  422. Performance_schema_file_handles_lost 0
  423. Performance_schema_file_instances_lost 0
  424. Performance_schema_hosts_lost 0
  425. Performance_schema_locker_lost 0
  426. Performance_schema_mutex_classes_lost 0
  427. Performance_schema_mutex_instances_lost 0
  428. Performance_schema_rwlock_classes_lost 0
  429. Performance_schema_rwlock_instances_lost 0
  430. Performance_schema_session_connect_attrs_lost 0
  431. Performance_schema_socket_classes_lost 0
  432. Performance_schema_socket_instances_lost 0
  433. Performance_schema_stage_classes_lost 0
  434. Performance_schema_statement_classes_lost 0
  435. Performance_schema_table_handles_lost 0
  436. Performance_schema_table_instances_lost 0
  437. Performance_schema_thread_classes_lost 0
  438. Performance_schema_thread_instances_lost 0
  439. Performance_schema_users_lost 0
  440. Prepared_stmt_count 0
  441. Qcache_free_blocks 102
  442. Qcache_free_memory 65876608
  443. Qcache_hits 1779196
  444. Qcache_inserts 990985
  445. Qcache_lowmem_prunes 0
  446. Qcache_not_cached 636351
  447. Qcache_queries_in_cache 433
  448. Qcache_total_blocks 1037
  449. Queries 7805507
  450. Questions 7805507
  451. Rows_read 1168236233
  452. Rows_sent 76475548
  453. Rows_tmp_read 229345
  454. Rpl_status AUTH_MASTER
  455. Select_full_join 0
  456. Select_full_range_join 0
  457. Select_range 1698
  458. Select_range_check 0
  459. Select_scan 269879
  460. Slave_connections 0
  461. Slave_heartbeat_period 0
  462. Slave_open_temp_tables 0
  463. Slave_received_heartbeats 0
  464. Slave_retried_transactions 0
  465. Slave_running OFF
  466. Slave_skipped_errors 0
  467. Slaves_connected 0
  468. Slaves_running 0
  469. Slow_launch_threads 0
  470. Slow_queries 0
  471. Sort_merge_passes 0
  472. Sort_priority_queue_sorts 114
  473. Sort_range 75
  474. Sort_rows 747
  475. Sort_scan 140
  476. Ssl_accept_renegotiates 0
  477. Ssl_accepts 0
  478. Ssl_callback_cache_hits 0
  479. Ssl_cipher
  480. Ssl_cipher_list
  481. Ssl_client_connects 0
  482. Ssl_connect_renegotiates 0
  483. Ssl_ctx_verify_depth 0
  484. Ssl_ctx_verify_mode 0
  485. Ssl_default_timeout 0
  486. Ssl_finished_accepts 0
  487. Ssl_finished_connects 0
  488. Ssl_server_not_after
  489. Ssl_server_not_before
  490. Ssl_session_cache_hits 0
  491. Ssl_session_cache_misses 0
  492. Ssl_session_cache_mode NONE
  493. Ssl_session_cache_overflows 0
  494. Ssl_session_cache_size 0
  495. Ssl_session_cache_timeouts 0
  496. Ssl_sessions_reused 0
  497. Ssl_used_session_cache_entries 0
  498. Ssl_verify_depth 0
  499. Ssl_verify_mode 0
  500. Ssl_version
  501. Subquery_cache_hit 0
  502. Subquery_cache_miss 0
  503. Syncs 15
  504. Table_locks_immediate 3253731
  505. Table_locks_waited 0
  506. Variable_name Value
  507. Tc_log_max_pages_used 0
  508. Tc_log_page_size 0
  509. Tc_log_page_waits 0
  510. Threadpool_idle_threads 0
  511. Threadpool_threads 8
  512. Threads_cached 0
  513. Threads_connected 3
  514. Threads_created 746
  515. Threads_running 1
  516. Update_scan 169837
  517. Uptime 235306
  518. Uptime_since_flush_status 235306
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!