Advertisement
duronrulez

show global status

Mar 24th, 2020
152
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 12.25 KB | None | 0 0
  1. Aborted_clients 332
  2. Aborted_connects 0
  3. Binlog_snapshot_file mysql-bin.000522
  4. Binlog_snapshot_position 834487251
  5. Binlog_cache_disk_use 6857
  6. Binlog_cache_use 7016808
  7. Binlog_stmt_cache_disk_use 0
  8. Binlog_stmt_cache_use 730
  9. Bytes_received 234605332831
  10. Bytes_sent 1034113061157
  11. Com_admin_commands 854889
  12. Com_assign_to_keycache 0
  13. Com_alter_db 0
  14. Com_alter_db_upgrade 0
  15. Com_alter_event 0
  16. Com_alter_function 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 8197769
  24. Com_binlog 0
  25. Com_call_procedure 106414
  26. Com_change_db 137
  27. Com_change_master 0
  28. Com_check 0
  29. Com_checksum 0
  30. Com_commit 5878741
  31. Com_create_db 0
  32. Com_create_event 0
  33. Com_create_function 0
  34. Com_create_index 0
  35. Com_create_procedure 0
  36. Com_create_server 0
  37. Com_create_table 155
  38. Com_create_trigger 0
  39. Com_create_udf 0
  40. Com_create_user 0
  41. Com_create_view 0
  42. Com_dealloc_sql 0
  43. Com_delete 413037
  44. Com_delete_multi 137592
  45. Com_do 0
  46. Com_drop_db 0
  47. Com_drop_event 0
  48. Com_drop_function 0
  49. Com_drop_index 0
  50. Com_drop_procedure 0
  51. Com_drop_server 0
  52. Com_drop_table 309
  53. Com_drop_trigger 0
  54. Com_drop_user 0
  55. Com_drop_view 0
  56. Com_empty_query 0
  57. Com_execute_sql 0
  58. Com_flush 4
  59. Com_get_diagnostics 0
  60. Com_grant 0
  61. Com_ha_close 0
  62. Com_ha_open 0
  63. Com_ha_read 0
  64. Com_help 0
  65. Com_insert 15287078
  66. Com_insert_select 2317
  67. Com_install_plugin 0
  68. Com_kill 14
  69. Com_load 0
  70. Com_lock_tables 1
  71. Com_lock_tables_for_backup 0
  72. Com_lock_binlog_for_backup 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_purge_archived 0
  79. Com_purge_archived_before_date 0
  80. Com_release_savepoint 0
  81. Com_rename_table 155
  82. Com_rename_user 0
  83. Com_repair 0
  84. Com_replace 2417207
  85. Com_replace_select 0
  86. Com_reset 0
  87. Com_resignal 0
  88. Com_revoke 0
  89. Com_revoke_all 0
  90. Com_rollback 2211653
  91. Com_rollback_to_savepoint 0
  92. Com_savepoint 0
  93. Com_select 182457623
  94. Com_set_option 3953188
  95. Com_signal 0
  96. Com_show_binlog_events 0
  97. Com_show_binlogs 487
  98. Com_show_charsets 0
  99. Com_show_client_statistics 0
  100. Com_show_collations 7
  101. Com_show_create_db 0
  102. Com_show_create_event 0
  103. Com_show_create_func 0
  104. Com_show_create_proc 0
  105. Com_show_create_table 38
  106. Com_show_create_trigger 0
  107. Com_show_databases 15
  108. Com_show_engine_logs 0
  109. Com_show_engine_mutex 0
  110. Com_show_engine_status 143038
  111. Com_show_events 0
  112. Com_show_errors 0
  113. Com_show_fields 18354
  114. Com_show_function_code 0
  115. Com_show_function_status 0
  116. Com_show_grants 6
  117. Com_show_index_statistics 0
  118. Com_show_keys 10486
  119. Com_show_master_status 23
  120. Com_show_open_tables 0
  121. Com_show_plugins 0
  122. Com_show_privileges 0
  123. Com_show_procedure_code 0
  124. Com_show_procedure_status 0
  125. Com_show_processlist 142969
  126. Com_show_profile 0
  127. Com_show_profiles 0
  128. Com_show_relaylog_events 0
  129. Com_show_slave_hosts 3
  130. Com_show_slave_status 499
  131. Com_show_slave_status_nolock 962
  132. Com_show_status 169473
  133. Com_show_storage_engines 484
  134. Com_show_table_statistics 0
  135. Com_show_table_status 75
  136. Com_show_tables 301
  137. Com_show_thread_statistics 0
  138. Com_show_triggers 0
  139. Com_show_user_statistics 0
  140. Com_show_variables 15628
  141. Com_show_warnings 60
  142. Com_slave_start 0
  143. Com_slave_stop 0
  144. Com_stmt_close 0
  145. Com_stmt_execute 0
  146. Com_stmt_fetch 0
  147. Com_stmt_prepare 0
  148. Com_stmt_reprepare 0
  149. Com_stmt_reset 0
  150. Com_stmt_send_long_data 0
  151. Com_truncate 156
  152. Com_uninstall_plugin 0
  153. Com_unlock_binlog 0
  154. Com_unlock_tables 0
  155. Com_update 40196282
  156. Com_update_multi 118467
  157. Com_xa_commit 0
  158. Com_xa_end 0
  159. Com_xa_prepare 0
  160. Com_xa_recover 0
  161. Com_xa_rollback 0
  162. Com_xa_start 0
  163. Compression ON
  164. Connection_errors_accept 0
  165. Connection_errors_internal 0
  166. Connection_errors_max_connections 0
  167. Connection_errors_peer_address 0
  168. Connection_errors_select 0
  169. Connection_errors_tcpwrap 0
  170. Connections 4437295
  171. Created_tmp_disk_tables 4880505
  172. Created_tmp_files 12406
  173. Created_tmp_tables 17211890
  174. Delayed_errors 0
  175. Delayed_insert_threads 0
  176. Delayed_writes 0
  177. Flush_commands 1
  178. Handler_commit 499627209
  179. Handler_delete 3871744
  180. Handler_discover 0
  181. Handler_external_lock 605215501
  182. Handler_mrr_init 0
  183. Handler_prepare 54834359
  184. Handler_read_first 3685341
  185. Handler_read_key 17934122025
  186. Handler_read_last 311454
  187. Handler_read_next 349105456767
  188. Handler_read_prev 5353040744
  189. Handler_read_rnd 9541975516
  190. Handler_read_rnd_next 139481940329
  191. Handler_rollback 4550132
  192. Handler_savepoint 0
  193. Handler_savepoint_rollback 0
  194. Handler_update 281955816
  195. Handler_write 1205782949
  196. Innodb_buffer_pool_dump_status not started
  197. Innodb_buffer_pool_load_status not started
  198. Innodb_background_log_sync 143383
  199. Innodb_buffer_pool_pages_data 1939113
  200. Innodb_buffer_pool_bytes_data 31770427392
  201. Innodb_buffer_pool_pages_dirty 95455
  202. Innodb_buffer_pool_bytes_dirty 1563934720
  203. Innodb_buffer_pool_pages_flushed 5637805
  204. Innodb_buffer_pool_pages_LRU_flushed 0
  205. Innodb_buffer_pool_pages_free 8141
  206. Innodb_buffer_pool_pages_made_not_young 1615065178
  207. Innodb_buffer_pool_pages_made_young 46727289
  208. Innodb_buffer_pool_pages_misc 149890
  209. Innodb_buffer_pool_pages_old 715665
  210. Innodb_buffer_pool_pages_total 2097144
  211. Innodb_buffer_pool_read_ahead_rnd 0
  212. Innodb_buffer_pool_read_ahead 2451696
  213. Innodb_buffer_pool_read_ahead_evicted 0
  214. Innodb_buffer_pool_read_requests 362171746540
  215. Innodb_buffer_pool_reads 49797223
  216. Innodb_buffer_pool_wait_free 0
  217. Innodb_buffer_pool_write_requests 227123752
  218. Innodb_checkpoint_age 206826629
  219. Innodb_checkpoint_max_age 1738750649
  220. Innodb_data_fsyncs 3306449
  221. Innodb_data_pending_fsyncs 0
  222. Innodb_data_pending_reads 0
  223. Innodb_data_pending_writes 0
  224. Innodb_data_read 876819353600
  225. Innodb_data_reads 53518405
  226. Innodb_data_writes 13784399
  227. Innodb_data_written 200876429312
  228. Innodb_dblwr_pages_written 5637805
  229. Innodb_dblwr_writes 714833
  230. Innodb_deadlocks 1
  231. Innodb_have_atomic_builtins ON
  232. Innodb_history_list_length 1159
  233. Innodb_ibuf_discarded_delete_marks 0
  234. Innodb_ibuf_discarded_deletes 0
  235. Innodb_ibuf_discarded_inserts 0
  236. Innodb_ibuf_free_list 156712
  237. Innodb_ibuf_merged_delete_marks 1514242
  238. Innodb_ibuf_merged_deletes 235543
  239. Innodb_ibuf_merged_inserts 2225283
  240. Innodb_ibuf_merges 1602974
  241. Innodb_ibuf_segment_size 156845
  242. Innodb_ibuf_size 132
  243. Innodb_log_waits 0
  244. Innodb_log_write_requests 27593654
  245. Innodb_log_writes 7403188
  246. Innodb_lsn_current 15619570205091
  247. Innodb_lsn_flushed 15619570187208
  248. Innodb_lsn_last_checkpoint 15619363378462
  249. Innodb_master_thread_active_loops 143378
  250. Innodb_master_thread_idle_loops 5
  251. Innodb_max_trx_id 82151113959
  252. Innodb_mem_adaptive_hash 3061339392
  253. Innodb_mem_dictionary 148873095
  254. Innodb_mem_total 35165044736
  255. Innodb_mutex_os_waits 486650
  256. Innodb_mutex_spin_rounds 38036780
  257. Innodb_mutex_spin_waits 23422622
  258. Innodb_oldest_view_low_limit_trx_id 82151113115
  259. Innodb_os_log_fsyncs 171993
  260. Innodb_os_log_pending_fsyncs 0
  261. Innodb_os_log_pending_writes 0
  262. Innodb_os_log_written 16127200768
  263. Innodb_page_size 16384
  264. Innodb_pages_created 220035
  265. Innodb_pages_read 53517294
  266. Innodb_pages_written 5637805
  267. Innodb_purge_trx_id 82151113204
  268. Innodb_purge_undo_no 0
  269. Innodb_row_lock_current_waits 0
  270. Innodb_current_row_locks 0
  271. Innodb_row_lock_time 2574934
  272. Innodb_row_lock_time_avg 122
  273. Innodb_row_lock_time_max 51625
  274. Innodb_row_lock_waits 20978
  275. Innodb_rows_deleted 3871852
  276. Innodb_rows_inserted 13465273
  277. Innodb_rows_read 505375436121
  278. Innodb_rows_updated 5843568
  279. Innodb_num_open_files 1023
  280. Innodb_read_views_memory 7440
  281. Innodb_descriptors_memory 8000
  282. Innodb_s_lock_os_waits 4139131
  283. Innodb_s_lock_spin_rounds 520838387
  284. Innodb_s_lock_spin_waits 163327438
  285. Innodb_truncated_status_writes 0
  286. Innodb_available_undo_logs 128
  287. Innodb_x_lock_os_waits 454080
  288. Innodb_x_lock_spin_rounds 249616249
  289. Innodb_x_lock_spin_waits 11976424
  290. Key_blocks_not_flushed 0
  291. Key_blocks_unused 19963
  292. Key_blocks_used 2660
  293. Key_read_requests 130213371
  294. Key_reads 340
  295. Key_write_requests 47865496
  296. Key_writes 0
  297. Last_query_cost 0.000000
  298. Last_query_partial_plans 0
  299. Max_statement_time_exceeded 0
  300. Max_statement_time_set 0
  301. Max_statement_time_set_failed 0
  302. Max_used_connections 197
  303. Not_flushed_delayed_rows 0
  304. Open_files 8
  305. Open_streams 0
  306. Open_table_definitions 911
  307. Open_tables 1024
  308. Opened_files 19744600
  309. Opened_table_definitions 112734
  310. Opened_tables 61910
  311. Performance_schema_accounts_lost 0
  312. Performance_schema_cond_classes_lost 0
  313. Performance_schema_cond_instances_lost 0
  314. Performance_schema_digest_lost 0
  315. Performance_schema_file_classes_lost 0
  316. Performance_schema_file_handles_lost 0
  317. Performance_schema_file_instances_lost 0
  318. Performance_schema_hosts_lost 0
  319. Performance_schema_locker_lost 0
  320. Performance_schema_mutex_classes_lost 0
  321. Performance_schema_mutex_instances_lost 0
  322. Performance_schema_rwlock_classes_lost 0
  323. Performance_schema_rwlock_instances_lost 0
  324. Performance_schema_session_connect_attrs_lost 0
  325. Performance_schema_socket_classes_lost 0
  326. Performance_schema_socket_instances_lost 0
  327. Performance_schema_stage_classes_lost 0
  328. Performance_schema_statement_classes_lost 0
  329. Performance_schema_table_handles_lost 0
  330. Performance_schema_table_instances_lost 0
  331. Performance_schema_thread_classes_lost 0
  332. Performance_schema_thread_instances_lost 0
  333. Performance_schema_users_lost 0
  334. Prepared_stmt_count 0
  335. Qcache_free_blocks 7289
  336. Qcache_free_memory 24496808
  337. Qcache_hits 366846302
  338. Qcache_inserts 141879824
  339. Qcache_lowmem_prunes 80501088
  340. Qcache_not_cached 40419444
  341. Qcache_queries_in_cache 16616
  342. Qcache_total_blocks 42031
  343. Queries 634675672
  344. Questions 632680020
  345. Rsa_public_key
  346. Select_full_join 1238385
  347. Select_full_range_join 2432389
  348. Select_range 14582049
  349. Select_range_check 369822
  350. Select_scan 10971747
  351. Slave_heartbeat_period 0.000
  352. Slave_last_heartbeat
  353. Slave_open_temp_tables 0
  354. Slave_received_heartbeats 0
  355. Slave_retried_transactions 0
  356. Slave_running OFF
  357. Slow_launch_threads 0
  358. Slow_queries 1704
  359. Sort_merge_passes 5166
  360. Sort_range 21950087
  361. Sort_rows 2246585958
  362. Sort_scan 9337969
  363. Ssl_accept_renegotiates 0
  364. Ssl_accepts 0
  365. Ssl_callback_cache_hits 0
  366. Ssl_cipher
  367. Ssl_cipher_list
  368. Ssl_client_connects 0
  369. Ssl_connect_renegotiates 0
  370. Ssl_ctx_verify_depth 0
  371. Ssl_ctx_verify_mode 0
  372. Ssl_default_timeout 0
  373. Ssl_finished_accepts 0
  374. Ssl_finished_connects 0
  375. Ssl_server_not_after
  376. Ssl_server_not_before
  377. Ssl_session_cache_hits 0
  378. Ssl_session_cache_misses 0
  379. Ssl_session_cache_mode NONE
  380. Ssl_session_cache_overflows 0
  381. Ssl_session_cache_size 0
  382. Ssl_session_cache_timeouts 0
  383. Ssl_sessions_reused 0
  384. Ssl_used_session_cache_entries 0
  385. Ssl_verify_depth 0
  386. Ssl_verify_mode 0
  387. Ssl_version
  388. Table_locks_immediate 299979543
  389. Table_locks_waited 0
  390. Table_open_cache_hits 300038995
  391. Table_open_cache_misses 61910
  392. Table_open_cache_overflows 60328
  393. Tc_log_max_pages_used 0
  394. Tc_log_page_size 0
  395. Tc_log_page_waits 0
  396. Threadpool_idle_threads 0
  397. Threadpool_threads 0
  398. Threads_cached 127
  399. Threads_connected 70
  400. Threads_created 206
  401. Threads_running 4
  402. Uptime 144497
  403. Uptime_since_flush_status 144497
  404. wsrep_local_state_uuid 62bc5e72-204b-11e8-b276-b7cabab93304
  405. wsrep_protocol_version 7
  406. wsrep_last_committed 2429991725
  407. wsrep_replicated 7017198
  408. wsrep_replicated_bytes 5701282293
  409. wsrep_repl_keys 58533552
  410. wsrep_repl_keys_bytes 629976448
  411. wsrep_repl_data_bytes 4622205173
  412. wsrep_repl_other_bytes 0
  413. wsrep_received 225288
  414. wsrep_received_bytes 18897440
  415. wsrep_local_commits 7016370
  416. wsrep_local_cert_failures 56
  417. wsrep_local_replays 0
  418. wsrep_local_send_queue 0
  419. wsrep_local_send_queue_max 22
  420. wsrep_local_send_queue_min 0
  421. wsrep_local_send_queue_avg 0.004206
  422. wsrep_local_recv_queue 0
  423. wsrep_local_recv_queue_max 2980
  424. wsrep_local_recv_queue_min 0
  425. wsrep_local_recv_queue_avg 20.168407
  426. wsrep_local_cached_downto 2423708730
  427. wsrep_flow_control_paused_ns 4896531203
  428. wsrep_flow_control_paused 0.000034
  429. wsrep_flow_control_sent 0
  430. wsrep_flow_control_recv 6
  431. wsrep_cert_deps_distance 104.425597
  432. wsrep_apply_oooe 0.102356
  433. wsrep_apply_oool 0.000050
  434. wsrep_apply_window 1.195600
  435. wsrep_commit_oooe 0.000000
  436. wsrep_commit_oool 0.000007
  437. wsrep_commit_window 1.068046
  438. wsrep_local_state 4
  439. wsrep_local_state_comment Synced
  440. wsrep_cert_index_size 354
  441. wsrep_cert_bucket_count 520252
  442. wsrep_gcache_pool_size 5368710137
  443. wsrep_causal_reads 0
  444. wsrep_cert_interval 1.610215
  445. wsrep_evs_delayed
  446. wsrep_evs_evict_list
  447. wsrep_evs_repl_latency 0.0257/0.0319855/0.0491972/0.00780016/549
  448. wsrep_evs_state OPERATIONAL
  449. wsrep_gcomm_uuid bbd26159-623b-11ea-94c0-97d10bb3f3ad
  450. wsrep_cluster_conf_id 575
  451. wsrep_cluster_size 6
  452. wsrep_cluster_state_uuid 62bc5e72-204b-11e8-b276-b7cabab93304
  453. wsrep_cluster_status Primary
  454. wsrep_connected ON
  455. wsrep_local_bf_aborts 1
  456. wsrep_local_index 4
  457. wsrep_provider_name Galera
  458. wsrep_provider_vendor Codership Oy <info@codership.com>
  459. wsrep_provider_version 3.14(r53b88eb)
  460. wsrep_ready ON
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement