Advertisement
Guest User

Untitled

a guest
Jun 26th, 2019
314
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 12.82 KB | None | 0 0
  1. SHOW GLOBAL STATUS
  2.  
  3. Aborted_clients 102
  4. Aborted_connects 47
  5. Access_denied_errors 47
  6. Acl_column_grants 0
  7. Acl_database_grants 3
  8. Acl_function_grants 0
  9. Acl_procedure_grants 0
  10. Acl_proxy_users 1
  11. Acl_role_grants 0
  12. Acl_roles 0
  13. Acl_table_grants 0
  14. Acl_users 5
  15. Aria_pagecache_blocks_not_flushed 0
  16. Aria_pagecache_blocks_unused 11166
  17. Aria_pagecache_blocks_used 6790
  18. Aria_pagecache_read_requests 219618368
  19. Aria_pagecache_reads 52787
  20. Aria_pagecache_write_requests 36321956
  21. Aria_pagecache_writes 17274570
  22. Aria_transaction_log_syncs 1163
  23. Binlog_commits 0
  24. Binlog_group_commits 0
  25. Binlog_group_commit_trigger_count 0
  26. Binlog_group_commit_trigger_lock_wait 0
  27. Binlog_group_commit_trigger_timeout 0
  28. Binlog_snapshot_file
  29. Binlog_snapshot_position 0
  30. Binlog_bytes_written 0
  31. Binlog_cache_disk_use 0
  32. Binlog_cache_use 0
  33. Binlog_stmt_cache_disk_use 0
  34. Binlog_stmt_cache_use 0
  35. Busy_time 0.000000
  36. Bytes_received 5722980862
  37. Bytes_sent 108024354903
  38. Com_admin_commands 0
  39. Com_alter_db 0
  40. Com_alter_db_upgrade 0
  41. Com_alter_event 0
  42. Com_alter_function 0
  43. Com_alter_procedure 0
  44. Com_alter_server 0
  45. Com_alter_table 278
  46. Com_alter_tablespace 0
  47. Com_alter_user 0
  48. Com_analyze 0
  49. Com_assign_to_keycache 0
  50. Com_begin 3335
  51. Com_binlog 0
  52. Com_call_procedure 2
  53. Com_change_db 771
  54. Com_change_master 0
  55. Com_check 145
  56. Com_checksum 0
  57. Com_commit 3335
  58. Com_compound_sql 0
  59. Com_create_db 2
  60. Com_create_event 0
  61. Com_create_function 0
  62. Com_create_index 0
  63. Com_create_procedure 2
  64. Com_create_role 0
  65. Com_create_server 0
  66. Com_create_table 60
  67. Com_create_temporary_table 2
  68. Com_create_trigger 0
  69. Com_create_udf 0
  70. Com_create_user 0
  71. Com_create_view 0
  72. Com_dealloc_sql 20
  73. Com_delete 39485
  74. Com_delete_multi 0
  75. Com_do 0
  76. Com_drop_db 2
  77. Com_drop_event 0
  78. Com_drop_function 0
  79. Com_drop_index 0
  80. Com_drop_procedure 4
  81. Com_drop_role 0
  82. Com_drop_server 0
  83. Com_drop_table 4
  84. Com_drop_temporary_table 0
  85. Com_drop_trigger 0
  86. Com_drop_user 0
  87. Com_drop_view 0
  88. Com_empty_query 0
  89. Com_execute_immediate 0
  90. Com_execute_sql 30
  91. Com_flush 2
  92. Com_get_diagnostics 0
  93. Com_grant 0
  94. Com_grant_role 0
  95. Com_ha_close 0
  96. Com_ha_open 0
  97. Com_ha_read 0
  98. Com_help 0
  99. Com_insert 3234885
  100. Com_insert_select 2
  101. Com_install_plugin 0
  102. Com_kill 0
  103. Com_load 0
  104. Com_lock_tables 0
  105. Com_multi 0
  106. Com_optimize 0
  107. Com_preload_keys 0
  108. Com_prepare_sql 30
  109. Com_purge 0
  110. Com_purge_before_date 0
  111. Com_release_savepoint 0
  112. Com_rename_table 0
  113. Com_rename_user 0
  114. Com_repair 0
  115. Com_replace 13
  116. Com_replace_select 0
  117. Com_reset 0
  118. Com_resignal 0
  119. Com_revoke 0
  120. Com_revoke_all 0
  121. Com_revoke_role 0
  122. Com_rollback 0
  123. Com_rollback_to_savepoint 0
  124. Com_savepoint 0
  125. Com_select 4551729
  126. Com_set_option 1229746
  127. Com_show_authors 0
  128. Com_show_binlog_events 0
  129. Com_show_binlogs 120
  130. Com_show_charsets 0
  131. Com_show_collations 0
  132. Com_show_contributors 0
  133. Com_show_create_db 0
  134. Com_show_create_event 0
  135. Com_show_create_func 0
  136. Com_show_create_proc 0
  137. Com_show_create_table 4
  138. Com_show_create_trigger 0
  139. Com_show_create_user 0
  140. Com_show_databases 33
  141. Com_show_engine_logs 0
  142. Com_show_engine_mutex 0
  143. Com_show_engine_status 117
  144. Com_show_errors 0
  145. Com_show_events 0
  146. Com_show_explain 0
  147. Com_show_fields 4
  148. Com_show_function_status 0
  149. Com_show_generic 0
  150. Com_show_grants 3
  151. Com_show_keys 2
  152. Com_show_master_status 3
  153. Com_show_open_tables 0
  154. Com_show_plugins 117
  155. Com_show_privileges 0
  156. Com_show_procedure_status 0
  157. Com_show_processlist 0
  158. Com_show_profile 0
  159. Com_show_profiles 0
  160. Com_show_relaylog_events 0
  161. Com_show_slave_hosts 0
  162. Com_show_slave_status 120
  163. Com_show_status 586
  164. Com_show_storage_engines 0
  165. Com_show_table_status 40
  166. Com_show_tables 178
  167. Com_show_triggers 0
  168. Com_show_variables 142
  169. Com_show_warnings 2
  170. Com_shutdown 0
  171. Com_signal 0
  172. Com_start_all_slaves 0
  173. Com_start_slave 0
  174. Com_stmt_close 30
  175. Com_stmt_execute 30
  176. Com_stmt_fetch 0
  177. Com_stmt_prepare 30
  178. Com_stmt_reprepare 0
  179. Com_stmt_reset 0
  180. Com_stmt_send_long_data 0
  181. Com_stop_all_slaves 0
  182. Com_stop_slave 0
  183. Com_truncate 0
  184. Com_uninstall_plugin 0
  185. Com_unlock_tables 0
  186. Com_update 3224506
  187. Com_update_multi 4
  188. Com_xa_commit 0
  189. Com_xa_end 0
  190. Com_xa_prepare 0
  191. Com_xa_recover 0
  192. Com_xa_rollback 0
  193. Com_xa_start 0
  194. Compression OFF
  195. Connection_errors_accept 0
  196. Connection_errors_internal 0
  197. Connection_errors_max_connections 0
  198. Connection_errors_peer_address 0
  199. Connection_errors_select 0
  200. Connection_errors_tcpwrap 0
  201. Connections 612001
  202. Cpu_time 0.000000
  203. Created_tmp_disk_tables 64142
  204. Created_tmp_files 2854
  205. Created_tmp_tables 501332
  206. Delayed_errors 0
  207. Delayed_insert_threads 0
  208. Delayed_writes 0
  209. Delete_scan 4
  210. Empty_queries 1328589
  211. Executed_events 0
  212. Executed_triggers 0
  213. Feature_check_constraint 0
  214. Feature_delay_key_write 0
  215. Feature_dynamic_columns 0
  216. Feature_fulltext 0
  217. Feature_gis 0
  218. Feature_locale 68
  219. Feature_subquery 450
  220. Feature_timezone 0
  221. Feature_trigger 0
  222. Feature_window_functions 0
  223. Feature_xml 0
  224. Flush_commands 1
  225. Handler_commit 8013687
  226. Handler_delete 3625839
  227. Handler_discover 156
  228. Handler_external_lock 0
  229. Handler_icp_attempts 1523929443
  230. Handler_icp_match 1513883424
  231. Handler_mrr_init 0
  232. Handler_mrr_key_refills 0
  233. Handler_mrr_rowid_refills 0
  234. Handler_prepare 0
  235. Handler_read_first 13741
  236. Handler_read_key 491765892
  237. Handler_read_last 8459
  238. Handler_read_next 4642171972
  239. Handler_read_prev 3336495
  240. Handler_read_retry 0
  241. Handler_read_rnd 45481560
  242. Handler_read_rnd_deleted 455
  243. Handler_read_rnd_next 5714187248
  244. Handler_rollback 2464
  245. Handler_savepoint 0
  246. Handler_savepoint_rollback 0
  247. Handler_tmp_update 324818425
  248. Handler_tmp_write 417162934
  249. Handler_update 13485028
  250. Handler_write 14292117
  251. Innodb_buffer_pool_dump_status
  252. Innodb_buffer_pool_load_status Buffer pool(s) load completed at 190625 23:08:08
  253. Innodb_buffer_pool_resize_status
  254. Innodb_buffer_pool_pages_data 706394
  255. Innodb_buffer_pool_bytes_data 11573559296
  256. Innodb_buffer_pool_pages_dirty 1924
  257. Innodb_buffer_pool_bytes_dirty 31522816
  258. Innodb_buffer_pool_pages_flushed 5939931
  259. Innodb_buffer_pool_pages_free 540372
  260. Innodb_buffer_pool_pages_misc 63874
  261. Innodb_buffer_pool_pages_total 1310640
  262. Innodb_buffer_pool_read_ahead_rnd 0
  263. Innodb_buffer_pool_read_ahead 107830
  264. Innodb_buffer_pool_read_ahead_evicted 0
  265. Innodb_buffer_pool_read_requests 15528920164
  266. Innodb_buffer_pool_reads 552578
  267. Innodb_buffer_pool_wait_free 0
  268. Innodb_buffer_pool_write_requests 197870509
  269. Innodb_data_fsyncs 1516806
  270. Innodb_data_pending_fsyncs 0
  271. Innodb_data_pending_reads 0
  272. Innodb_data_pending_writes 0
  273. Innodb_data_read 11305552384
  274. Innodb_data_reads 690135
  275. Innodb_data_writes 6569738
  276. Innodb_data_written 202787001344
  277. Innodb_dblwr_pages_written 5939800
  278. Innodb_dblwr_writes 563557
  279. Innodb_log_waits 0
  280. Innodb_log_write_requests 19517640
  281. Innodb_log_writes 53877
  282. Innodb_os_log_fsyncs 58512
  283. Innodb_os_log_pending_fsyncs 0
  284. Innodb_os_log_pending_writes 0
  285. Innodb_os_log_written 8147064320
  286. Innodb_page_size 16384
  287. Innodb_pages_created 16344
  288. Innodb_pages_read 690050
  289. Innodb_pages0_read 81
  290. Innodb_pages_written 5939931
  291. Innodb_row_lock_current_waits 0
  292. Innodb_row_lock_time 112361
  293. Innodb_row_lock_time_avg 9
  294. Innodb_row_lock_time_max 67
  295. Innodb_row_lock_waits 12386
  296. Innodb_rows_deleted 1048792
  297. Innodb_rows_inserted 1619325
  298. Innodb_rows_read 6502331942
  299. Innodb_rows_updated 10872830
  300. Innodb_system_rows_deleted 0
  301. Innodb_system_rows_inserted 1258
  302. Innodb_system_rows_read 3774
  303. Innodb_system_rows_updated 0
  304. Innodb_num_open_files 84
  305. Innodb_truncated_status_writes 0
  306. Innodb_available_undo_logs 128
  307. Innodb_undo_truncations 0
  308. Innodb_page_compression_saved 0
  309. Innodb_num_index_pages_written 0
  310. Innodb_num_non_index_pages_written 0
  311. Innodb_num_pages_page_compressed 0
  312. Innodb_num_page_compressed_trim_op 0
  313. Innodb_num_pages_page_decompressed 0
  314. Innodb_num_pages_page_compression_error 0
  315. Innodb_num_pages_encrypted 0
  316. Innodb_num_pages_decrypted 0
  317. Innodb_have_lz4 ON
  318. Innodb_have_lzo OFF
  319. Innodb_have_lzma OFF
  320. Innodb_have_bzip2 OFF
  321. Innodb_have_snappy OFF
  322. Innodb_have_punch_hole ON
  323. Innodb_defragment_compression_failures 0
  324. Innodb_defragment_failures 0
  325. Innodb_defragment_count 0
  326. Innodb_onlineddl_rowlog_rows 0
  327. Innodb_onlineddl_rowlog_pct_used 0
  328. Innodb_onlineddl_pct_progress 0
  329. Innodb_secondary_index_triggered_cluster_reads 4433465156
  330. Innodb_secondary_index_triggered_cluster_reads_avo... 0
  331. Innodb_encryption_rotation_pages_read_from_cache 0
  332. Innodb_encryption_rotation_pages_read_from_disk 0
  333. Innodb_encryption_rotation_pages_modified 0
  334. Innodb_encryption_rotation_pages_flushed 0
  335. Innodb_encryption_rotation_estimated_iops 0
  336. Innodb_encryption_key_rotation_list_length 0
  337. Innodb_encryption_n_merge_blocks_encrypted 0
  338. Innodb_encryption_n_merge_blocks_decrypted 0
  339. Innodb_encryption_n_rowlog_blocks_encrypted 0
  340. Innodb_encryption_n_rowlog_blocks_decrypted 0
  341. Innodb_scrub_background_page_reorganizations 0
  342. Innodb_scrub_background_page_splits 0
  343. Innodb_scrub_background_page_split_failures_underf... 0
  344. Innodb_scrub_background_page_split_failures_out_of... 0
  345. Innodb_scrub_background_page_split_failures_missin... 0
  346. Innodb_scrub_background_page_split_failures_unknow... 0
  347. Innodb_scrub_log 0
  348. Innodb_encryption_num_key_requests 0
  349. Key_blocks_not_flushed 0
  350. Key_blocks_unused 25625
  351. Key_blocks_used 1160
  352. Key_blocks_warm 695
  353. Key_read_requests 48934489
  354. Key_reads 1171
  355. Key_write_requests 835
  356. Key_writes 368
  357. Last_query_cost 0.000000
  358. Master_gtid_wait_count 0
  359. Master_gtid_wait_time 0
  360. Master_gtid_wait_timeouts 0
  361. Max_statement_time_exceeded 0
  362. Max_used_connections 202
  363. Memory_used 197596056
  364. Not_flushed_delayed_rows 0
  365. Open_files 140
  366. Open_streams 0
  367. Open_table_definitions 171
  368. Open_tables 633
  369. Opened_files 261212
  370. Opened_plugin_libraries 0
  371. Opened_table_definitions 802
  372. Opened_tables 957
  373. Opened_views 0
  374. Performance_schema_accounts_lost 0
  375. Performance_schema_cond_classes_lost 0
  376. Performance_schema_cond_instances_lost 0
  377. Performance_schema_digest_lost 0
  378. Performance_schema_file_classes_lost 0
  379. Performance_schema_file_handles_lost 0
  380. Performance_schema_file_instances_lost 0
  381. Performance_schema_hosts_lost 0
  382. Performance_schema_locker_lost 0
  383. Performance_schema_mutex_classes_lost 0
  384. Performance_schema_mutex_instances_lost 0
  385. Performance_schema_rwlock_classes_lost 0
  386. Performance_schema_rwlock_instances_lost 0
  387. Performance_schema_session_connect_attrs_lost 0
  388. Performance_schema_socket_classes_lost 0
  389. Performance_schema_socket_instances_lost 0
  390. Performance_schema_stage_classes_lost 0
  391. Performance_schema_statement_classes_lost 0
  392. Performance_schema_table_handles_lost 0
  393. Performance_schema_table_instances_lost 0
  394. Performance_schema_thread_classes_lost 0
  395. Performance_schema_thread_instances_lost 0
  396. Performance_schema_users_lost 0
  397. Prepared_stmt_count 0
  398. Qcache_free_blocks 0
  399. Qcache_free_memory 0
  400. Qcache_hits 0
  401. Qcache_inserts 0
  402. Qcache_lowmem_prunes 0
  403. Qcache_not_cached 0
  404. Qcache_queries_in_cache 0
  405. Qcache_total_blocks 0
  406. Queries 12901538
  407. Questions 12901534
  408. Rows_read 10433924243
  409. Rows_sent 1190065107
  410. Rows_tmp_read 396955025
  411. Rpl_status AUTH_MASTER
  412. Select_full_join 212361
  413. Select_full_range_join 0
  414. Select_range 1887552
  415. Select_range_check 0
  416. Select_scan 449989
  417. Slave_connections 0
  418. Slave_heartbeat_period 0.000
  419. Slave_open_temp_tables 0
  420. Slave_received_heartbeats 0
  421. Slave_retried_transactions 0
  422. Slave_running OFF
  423. Slave_skipped_errors 0
  424. Slaves_connected 0
  425. Slaves_running 0
  426. Slow_launch_threads 0
  427. Slow_queries 469
  428. Sort_merge_passes 2990
  429. Sort_priority_queue_sorts 40727
  430. Sort_range 244966
  431. Sort_rows 195483664
  432. Sort_scan 77111
  433. Ssl_accept_renegotiates 0
  434. Ssl_accepts 0
  435. Ssl_callback_cache_hits 0
  436. Ssl_cipher
  437. Ssl_cipher_list
  438. Ssl_client_connects 0
  439. Ssl_connect_renegotiates 0
  440. Ssl_ctx_verify_depth 0
  441. Ssl_ctx_verify_mode 0
  442. Ssl_default_timeout 0
  443. Ssl_finished_accepts 0
  444. Ssl_finished_connects 0
  445. Ssl_server_not_after
  446. Ssl_server_not_before
  447. Ssl_session_cache_hits 0
  448. Ssl_session_cache_misses 0
  449. Ssl_session_cache_mode NONE
  450. Ssl_session_cache_overflows 0
  451. Ssl_session_cache_size 0
  452. Ssl_session_cache_timeouts 0
  453. Ssl_sessions_reused 0
  454. Ssl_used_session_cache_entries 0
  455. Ssl_verify_depth 0
  456. Ssl_verify_mode 0
  457. Ssl_version
  458. Subquery_cache_hit 3038830
  459. Subquery_cache_miss 495908
  460. Syncs 2526
  461. Table_locks_immediate 3058626
  462. Table_locks_waited 3850
  463. Tc_log_max_pages_used 0
  464. Tc_log_page_size 4096
  465. Tc_log_page_waits 0
  466. Threadpool_idle_threads 0
  467. Threadpool_threads 0
  468. Threads_cached 43
  469. Threads_connected 12
  470. Threads_created 460
  471. Threads_running 2
  472. Update_scan 109994
  473. Uptime 35054
  474. Uptime_since_flush_status 35054
  475. wsrep_cluster_conf_id 18446744073709551615
  476. wsrep_cluster_size 0
  477. wsrep_cluster_state_uuid
  478. wsrep_cluster_status Disconnected
  479. wsrep_connected OFF
  480. wsrep_local_bf_aborts 0
  481. wsrep_local_index 18446744073709551615
  482. wsrep_provider_name
  483. wsrep_provider_vendor
  484. wsrep_provider_version
  485. wsrep_ready OFF
  486. wsrep_thread_count 0
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement