Advertisement
Guest User

SHOW GLOBAL STATUS;

a guest
Aug 10th, 2018
72
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 13.67 KB | None | 0 0
  1. Variable_name Value
  2. Aborted_clients 0
  3. Aborted_connects 13111
  4. Access_denied_errors 12901
  5. Acl_column_grants 0
  6. Acl_database_grants 5
  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 7
  14. Aria_pagecache_blocks_not_flushed 0
  15. Aria_pagecache_blocks_unused 15706
  16. Aria_pagecache_blocks_used 691
  17. Aria_pagecache_read_requests 278541969
  18. Aria_pagecache_reads 16782973
  19. Aria_pagecache_write_requests 76350401
  20. Aria_pagecache_writes 0
  21. Aria_transaction_log_syncs 0
  22. Binlog_commits 0
  23. Binlog_group_commits 0
  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
  28. Binlog_snapshot_position 0
  29. Binlog_bytes_written 0
  30. Binlog_cache_disk_use 0
  31. Binlog_cache_use 0
  32. Binlog_stmt_cache_disk_use 0
  33. Binlog_stmt_cache_use 0
  34. Busy_time 0.000000
  35. Bytes_received 21325230085
  36. Bytes_sent 842497947823
  37. Com_admin_commands 1569
  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 1
  45. Com_alter_tablespace 0
  46. Com_analyze 0
  47. Com_assign_to_keycache 0
  48. Com_begin 273
  49. Com_binlog 0
  50. Com_call_procedure 0
  51. Com_change_db 294334
  52. Com_change_master 0
  53. Com_check 0
  54. Com_checksum 0
  55. Com_commit 273
  56. Com_compound_sql 0
  57. Com_create_db 1
  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 19
  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 902155
  72. Com_delete_multi 16
  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 32
  89. Com_get_diagnostics 0
  90. Com_grant 1
  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 1475794
  97. Com_insert_select 8
  98. Com_install_plugin 0
  99. Com_kill 0
  100. Com_load 0
  101. Com_lock_tables 109
  102. Com_optimize 0
  103. Com_preload_keys 0
  104. Com_prepare_sql 0
  105. Com_purge 0
  106. Com_purge_before_date 0
  107. Com_release_savepoint 0
  108. Com_rename_table 0
  109. Com_rename_user 0
  110. Com_repair 0
  111. Com_replace 823
  112. Com_replace_select 0
  113. Com_reset 0
  114. Com_resignal 0
  115. Com_revoke 0
  116. Com_revoke_all 0
  117. Com_revoke_role 0
  118. Com_rollback 0
  119. Com_rollback_to_savepoint 0
  120. Com_savepoint 0
  121. Com_select 58493862
  122. Com_set_option 553624
  123. Com_show_authors 0
  124. Com_show_binlog_events 0
  125. Com_show_binlogs 0
  126. Com_show_charsets 8
  127. Com_show_collations 0
  128. Com_show_contributors 0
  129. Com_show_create_db 53
  130. Com_show_create_event 0
  131. Com_show_create_func 0
  132. Com_show_create_proc 0
  133. Com_show_create_table 9074
  134. Com_show_create_trigger 0
  135. Com_show_databases 139
  136. Com_show_engine_logs 0
  137. Com_show_engine_mutex 0
  138. Com_show_engine_status 0
  139. Com_show_errors 0
  140. Com_show_events 2
  141. Com_show_explain 0
  142. Com_show_fields 246923
  143. Com_show_function_status 4
  144. Com_show_generic 0
  145. Com_show_grants 0
  146. Com_show_keys 3136
  147. Com_show_master_status 0
  148. Com_show_open_tables 0
  149. Com_show_plugins 0
  150. Com_show_privileges 0
  151. Com_show_procedure_status 4
  152. Com_show_processlist 0
  153. Com_show_profile 0
  154. Com_show_profiles 0
  155. Com_show_relaylog_events 0
  156. Com_show_slave_hosts 0
  157. Com_show_slave_status 0
  158. Com_show_status 3
  159. Com_show_storage_engines 0
  160. Com_show_table_status 669
  161. Com_show_tables 166
  162. Com_show_triggers 4
  163. Com_show_variables 531
  164. Com_show_warnings 0
  165. Com_shutdown 0
  166. Com_signal 0
  167. Com_start_all_slaves 0
  168. Com_start_slave 0
  169. Com_stmt_close 2
  170. Com_stmt_execute 2
  171. Com_stmt_fetch 0
  172. Com_stmt_prepare 2
  173. Com_stmt_reprepare 0
  174. Com_stmt_reset 0
  175. Com_stmt_send_long_data 0
  176. Com_stop_all_slaves 0
  177. Com_stop_slave 0
  178. Com_truncate 2
  179. Com_uninstall_plugin 0
  180. Com_unlock_tables 109
  181. Com_update 269876
  182. Com_update_multi 18
  183. Com_xa_commit 0
  184. Com_xa_end 0
  185. Com_xa_prepare 0
  186. Com_xa_recover 0
  187. Com_xa_rollback 0
  188. Com_xa_start 0
  189. Compression ON
  190. Connection_errors_accept 0
  191. Connection_errors_internal 0
  192. Connection_errors_max_connections 0
  193. Connection_errors_peer_address 2
  194. Connection_errors_select 0
  195. Connection_errors_tcpwrap 0
  196. Connections 303642
  197. Cpu_time 0.000000
  198. Created_tmp_disk_tables 17887832
  199. Created_tmp_files 234
  200. Created_tmp_tables 19436364
  201. Delayed_errors 0
  202. Delayed_insert_threads 0
  203. Delayed_writes 0
  204. Delete_scan 237923
  205. Empty_queries 11824169
  206. Executed_events 0
  207. Executed_triggers 0
  208. Feature_delay_key_write 0
  209. Feature_dynamic_columns 0
  210. Feature_fulltext 666
  211. Feature_gis 1
  212. Feature_locale 0
  213. Feature_subquery 1414166
  214. Feature_timezone 66
  215. Feature_trigger 0
  216. Feature_xml 0
  217. Flush_commands 1
  218. Handler_commit 59938113
  219. Handler_delete 1541171
  220. Handler_discover 0
  221. Handler_external_lock 0
  222. Handler_icp_attempts 48920349174
  223. Handler_icp_match 48920213645
  224. Handler_mrr_init 0
  225. Handler_mrr_key_refills 0
  226. Handler_mrr_rowid_refills 0
  227. Handler_prepare 0
  228. Handler_read_first 2256508
  229. Handler_read_key 533392697
  230. Handler_read_last 5500
  231. Handler_read_next 151008329763
  232. Handler_read_prev 8603316013
  233. Handler_read_retry 0
  234. Handler_read_rnd 185140679
  235. Handler_read_rnd_deleted 10941880
  236. Handler_read_rnd_next 703386895308
  237. Handler_rollback 41885
  238. Handler_savepoint 0
  239. Handler_savepoint_rollback 0
  240. Handler_tmp_update 32049139
  241. Handler_tmp_write 72802268
  242. Handler_update 1325264
  243. Handler_write 3344485
  244. Innodb_available_undo_logs 128
  245. Innodb_background_log_sync 685780
  246. Innodb_buffer_pool_bytes_data 29789503488
  247. Innodb_buffer_pool_bytes_dirty 0
  248. Innodb_buffer_pool_dump_status Dumping buffer pool(s) not yet started
  249. Innodb_buffer_pool_load_status Loading buffer pool(s) not yet started
  250. Innodb_buffer_pool_pages_data 1818207
  251. Innodb_buffer_pool_pages_dirty 0
  252. Innodb_buffer_pool_pages_flushed 3599073
  253. Innodb_buffer_pool_pages_free 80302
  254. Innodb_buffer_pool_pages_lru_flushed 0
  255. Innodb_buffer_pool_pages_made_not_young 356598
  256. Innodb_buffer_pool_pages_made_young 1330719
  257. Innodb_buffer_pool_pages_misc 67556
  258. Innodb_buffer_pool_pages_old 671356
  259. Innodb_buffer_pool_pages_total 1966065
  260. Innodb_buffer_pool_read_ahead 940138
  261. Innodb_buffer_pool_read_ahead_evicted 0
  262. Innodb_buffer_pool_read_ahead_rnd 0
  263. Innodb_buffer_pool_read_requests 411195734232
  264. Innodb_buffer_pool_reads 743123
  265. Innodb_buffer_pool_wait_free 0
  266. Innodb_buffer_pool_write_requests 45875014
  267. Innodb_checkpoint_age 0
  268. Innodb_checkpoint_max_age 1738750649
  269. Innodb_data_fsyncs 2507291
  270. Innodb_data_pending_fsyncs 0
  271. Innodb_data_pending_reads 0
  272. Innodb_data_pending_writes 0
  273. Innodb_data_read 27809468928
  274. Innodb_data_reads 1698084
  275. Innodb_data_writes 5733125
  276. Innodb_data_written 124702632448
  277. Innodb_dblwr_pages_written 3599073
  278. Innodb_dblwr_writes 118220
  279. Innodb_deadlocks 0
  280. Innodb_have_atomic_builtins ON
  281. Innodb_history_list_length 52
  282. Innodb_ibuf_discarded_delete_marks 0
  283. Innodb_ibuf_discarded_deletes 0
  284. Innodb_ibuf_discarded_inserts 0
  285. Innodb_ibuf_free_list 167
  286. Innodb_ibuf_merged_delete_marks 67666
  287. Innodb_ibuf_merged_deletes 10964
  288. Innodb_ibuf_merged_inserts 36347
  289. Innodb_ibuf_merges 16662
  290. Innodb_ibuf_segment_size 169
  291. Innodb_ibuf_size 1
  292. Innodb_log_waits 0
  293. Innodb_log_write_requests 13125139
  294. Innodb_log_writes 1886761
  295. Innodb_lsn_current 75916612302
  296. Innodb_lsn_flushed 75916612302
  297. Innodb_lsn_last_checkpoint 75916612302
  298. Innodb_master_thread_active_loops 324184
  299. Innodb_master_thread_idle_loops 361642
  300. Innodb_max_trx_id 95582603
  301. Innodb_mem_adaptive_hash 1616833360
  302. Innodb_mem_dictionary 136224974
  303. Innodb_mem_total 33737932800
  304. Innodb_mutex_os_waits 178402
  305. Innodb_mutex_spin_rounds 278083935
  306. Innodb_mutex_spin_waits 505682686
  307. Innodb_oldest_view_low_limit_trx_id 0
  308. Innodb_os_log_fsyncs 1992479
  309. Innodb_os_log_pending_fsyncs 0
  310. Innodb_os_log_pending_writes 0
  311. Innodb_os_log_written 6714002432
  312. Innodb_page_size 16384
  313. Innodb_pages_created 120862
  314. Innodb_pages_read 1697351
  315. Innodb_pages0_read 725
  316. Innodb_pages_written 3599073
  317. Innodb_purge_trx_id 95582562
  318. Innodb_purge_undo_no 0
  319. Innodb_read_views_memory 512
  320. Innodb_row_lock_current_waits 0
  321. Innodb_row_lock_time 382
  322. Innodb_row_lock_time_avg 2
  323. Innodb_row_lock_time_max 96
  324. Innodb_row_lock_waits 151
  325. Innodb_rows_deleted 1319619
  326. Innodb_rows_inserted 2015717
  327. Innodb_rows_read 862780824384
  328. Innodb_rows_updated 957997
  329. Innodb_system_rows_deleted 0
  330. Innodb_system_rows_inserted 0
  331. Innodb_system_rows_read 34
  332. Innodb_system_rows_updated 0
  333. Innodb_s_lock_os_waits 209612
  334. Innodb_s_lock_spin_rounds 228536293
  335. Innodb_s_lock_spin_waits 55186835
  336. Innodb_truncated_status_writes 0
  337. Innodb_x_lock_os_waits 324088
  338. Innodb_x_lock_spin_rounds 578207842
  339. Innodb_x_lock_spin_waits 59415165
  340. Innodb_page_compression_saved 0
  341. Innodb_page_compression_trim_sect512 0
  342. Innodb_page_compression_trim_sect1024 0
  343. Innodb_page_compression_trim_sect2048 0
  344. Innodb_page_compression_trim_sect4096 0
  345. Innodb_page_compression_trim_sect8192 0
  346. Innodb_page_compression_trim_sect16384 0
  347. Innodb_page_compression_trim_sect32768 0
  348. Innodb_num_index_pages_written 1322137
  349. Innodb_num_non_index_pages_written 4409089
  350. Innodb_num_pages_page_compressed 0
  351. Innodb_num_page_compressed_trim_op 0
  352. Innodb_num_page_compressed_trim_op_saved 0
  353. Innodb_num_pages_page_decompressed 0
  354. Innodb_num_pages_page_compression_error 0
  355. Innodb_num_pages_encrypted 0
  356. Innodb_num_pages_decrypted 0
  357. Innodb_have_lz4 OFF
  358. Innodb_have_lzo OFF
  359. Innodb_have_lzma OFF
  360. Innodb_have_bzip2 OFF
  361. Innodb_have_snappy OFF
  362. Innodb_defragment_compression_failures 0
  363. Innodb_defragment_failures 0
  364. Innodb_defragment_count 0
  365. Innodb_onlineddl_rowlog_rows 0
  366. Innodb_onlineddl_rowlog_pct_used 0
  367. Innodb_onlineddl_pct_progress 0
  368. Innodb_secondary_index_triggered_cluster_reads 78431084459
  369. Innodb_secondary_index_triggered_cluster_reads_avoided 0
  370. Innodb_encryption_rotation_pages_read_from_cache 0
  371. Innodb_encryption_rotation_pages_read_from_disk 0
  372. Innodb_encryption_rotation_pages_modified 0
  373. Innodb_encryption_rotation_pages_flushed 0
  374. Innodb_encryption_rotation_estimated_iops 0
  375. Innodb_encryption_key_rotation_list_length 0
  376. Innodb_scrub_background_page_reorganizations 0
  377. Innodb_scrub_background_page_splits 0
  378. Innodb_scrub_background_page_split_failures_underflow 0
  379. Innodb_scrub_background_page_split_failures_out_of_filespace 0
  380. Innodb_scrub_background_page_split_failures_missing_index 0
  381. Innodb_scrub_background_page_split_failures_unknown 0
  382. Innodb_encryption_num_key_requests 0
  383. Key_blocks_not_flushed 0
  384. Key_blocks_unused 4242501
  385. Key_blocks_used 25
  386. Key_blocks_warm 0
  387. Key_read_requests 1210
  388. Key_reads 25
  389. Key_write_requests 0
  390. Key_writes 0
  391. Last_query_cost 0.000000
  392. Master_gtid_wait_count 0
  393. Master_gtid_wait_time 0
  394. Master_gtid_wait_timeouts 0
  395. Max_statement_time_exceeded 0
  396. Max_used_connections 57
  397. Memory_used 5552192448
  398. Not_flushed_delayed_rows 0
  399. Open_files 84
  400. Open_streams 0
  401. Open_table_definitions 699
  402. Open_tables 2068
  403. Opened_files 71552396
  404. Opened_plugin_libraries 0
  405. Opened_table_definitions 711
  406. Opened_tables 2080
  407. Opened_views 0
  408. Performance_schema_accounts_lost 0
  409. Performance_schema_cond_classes_lost 0
  410. Performance_schema_cond_instances_lost 0
  411. Performance_schema_digest_lost 0
  412. Performance_schema_file_classes_lost 0
  413. Performance_schema_file_handles_lost 0
  414. Performance_schema_file_instances_lost 0
  415. Performance_schema_hosts_lost 0
  416. Performance_schema_locker_lost 0
  417. Performance_schema_mutex_classes_lost 0
  418. Performance_schema_mutex_instances_lost 0
  419. Performance_schema_rwlock_classes_lost 0
  420. Performance_schema_rwlock_instances_lost 0
  421. Performance_schema_session_connect_attrs_lost 0
  422. Performance_schema_socket_classes_lost 0
  423. Performance_schema_socket_instances_lost 0
  424. Performance_schema_stage_classes_lost 0
  425. Performance_schema_statement_classes_lost 0
  426. Performance_schema_table_handles_lost 0
  427. Performance_schema_table_instances_lost 32
  428. Performance_schema_thread_classes_lost 0
  429. Performance_schema_thread_instances_lost 0
  430. Performance_schema_users_lost 0
  431. Prepared_stmt_count 0
  432. Qcache_free_blocks 0
  433. Qcache_free_memory 0
  434. Qcache_hits 0
  435. Qcache_inserts 0
  436. Qcache_lowmem_prunes 0
  437. Qcache_not_cached 0
  438. Qcache_queries_in_cache 0
  439. Qcache_total_blocks 0
  440. Queries 62591795
  441. Questions 62591791
  442. Rows_read 862153265511
  443. Rows_sent 48508749820
  444. Rows_tmp_read 131088318
  445. Rpl_status AUTH_MASTER
  446. Select_full_join 15981913
  447. Select_full_range_join 223
  448. Select_range 19385188
  449. Select_range_check 199
  450. Select_scan 1510902
  451. Slave_connections 0
  452. Slave_heartbeat_period 0.000
  453. Slave_open_temp_tables 0
  454. Slave_received_heartbeats 0
  455. Slave_retried_transactions 0
  456. Slave_running OFF
  457. Slave_skipped_errors 0
  458. Slaves_connected 0
  459. Slaves_running 0
  460. Slow_launch_threads 0
  461. Slow_queries 0
  462. Sort_merge_passes 142
  463. Sort_priority_queue_sorts 170134
  464. Sort_range 882762
  465. Sort_rows 807059824
  466. Sort_scan 18428367
  467. Ssl_accept_renegotiates 0
  468. Ssl_accepts 0
  469. Ssl_callback_cache_hits 0
  470. Ssl_cipher
  471. Ssl_cipher_list
  472. Ssl_client_connects 0
  473. Ssl_connect_renegotiates 0
  474. Ssl_ctx_verify_depth 0
  475. Ssl_ctx_verify_mode 0
  476. Ssl_default_timeout 0
  477. Ssl_finished_accepts 0
  478. Ssl_finished_connects 0
  479. Ssl_server_not_after
  480. Ssl_server_not_before
  481. Ssl_session_cache_hits 0
  482. Ssl_session_cache_misses 0
  483. Ssl_session_cache_mode NONE
  484. Ssl_session_cache_overflows 0
  485. Ssl_session_cache_size 0
  486. Ssl_session_cache_timeouts 0
  487. Ssl_sessions_reused 0
  488. Ssl_used_session_cache_entries 0
  489. Ssl_verify_depth 0
  490. Ssl_verify_mode 0
  491. Ssl_version
  492. Subquery_cache_hit 2912544
  493. Subquery_cache_miss 10120565
  494. Syncs 4
  495. Table_locks_immediate 121841908
  496. Table_locks_waited 1334
  497. Tc_log_max_pages_used 0
  498. Tc_log_page_size 4096
  499. Tc_log_page_waits 0
  500. Threadpool_idle_threads 0
  501. Threadpool_threads 0
  502. Threads_cached 6
  503. Threads_connected 2
  504. Threads_created 3081
  505. Threads_running 1
  506. Update_scan 2130
  507. Uptime 687019
  508. Uptime_since_flush_status 687019
  509. wsrep_cluster_conf_id 18446744073709551615
  510. wsrep_cluster_size 0
  511. wsrep_cluster_state_uuid
  512. wsrep_cluster_status Disconnected
  513. wsrep_connected OFF
  514. wsrep_local_bf_aborts 0
  515. wsrep_local_index 18446744073709551615
  516. wsrep_provider_name
  517. wsrep_provider_vendor
  518. wsrep_provider_version
  519. wsrep_ready OFF
  520. wsrep_thread_count 0
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement