Advertisement
Guest User

Show Global status

a guest
Jan 28th, 2021
241
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 12.97 KB | None | 0 0
  1. Aborted_clients 41
  2. Aborted_connects 4
  3. Acl_cache_items_count 0
  4. Binlog_cache_disk_use 5344
  5. Binlog_cache_use 21331
  6. Binlog_stmt_cache_disk_use 0
  7. Binlog_stmt_cache_use 54468
  8. Bytes_received 629201849
  9. Bytes_sent 1712850373
  10. Caching_sha2_password_rsa_public_key -----BEGIN PUBLIC KEY-----
  11. MIIBIjANBgkqhkiG9w0BAQEFAAOCAQ8AMIIBCgKCAQEAvh5I/Kj8m1NqICO71RIO
  12. b3kkgSKQWKlYAdTiQm9QpuASuSUleYzjYXHZzNBZi1ZBAM43H7gzDmVnzbkclyHv
  13. krd/Q+0e5Es58jWzm1hndb9zKKvavV9O+wB+dFlQwflz4ltrej3VOshcwBupG4+V
  14. EhhdmKYoLvrYv8lDNBxhBaPUpZJjX0qA...
  15. Com_admin_commands 1410
  16. Com_assign_to_keycache 0
  17. Com_alter_db 0
  18. Com_alter_event 0
  19. Com_alter_function 0
  20. Com_alter_instance 0
  21. Com_alter_procedure 0
  22. Com_alter_resource_group 0
  23. Com_alter_server 0
  24. Com_alter_table 2
  25. Com_alter_tablespace 0
  26. Com_alter_user 0
  27. Com_alter_user_default_role 0
  28. Com_analyze 0
  29. Com_begin 0
  30. Com_binlog 0
  31. Com_call_procedure 0
  32. Com_change_db 2376
  33. Com_change_master 0
  34. Com_change_repl_filter 0
  35. Com_check 0
  36. Com_checksum 0
  37. Com_clone 0
  38. Com_commit 17143
  39. Com_create_db 1
  40. Com_create_event 0
  41. Com_create_function 0
  42. Com_create_index 6
  43. Com_create_procedure 0
  44. Com_create_role 0
  45. Com_create_server 0
  46. Com_create_table 68651
  47. Com_create_resource_group 0
  48. Com_create_trigger 0
  49. Com_create_udf 0
  50. Com_create_user 0
  51. Com_create_view 52
  52. Com_create_spatial_reference_system 0
  53. Com_dealloc_sql 0
  54. Com_delete 0
  55. Com_delete_multi 0
  56. Com_do 0
  57. Com_drop_db 0
  58. Com_drop_event 0
  59. Com_drop_function 0
  60. Com_drop_index 6
  61. Com_drop_procedure 0
  62. Com_drop_resource_group 0
  63. Com_drop_role 0
  64. Com_drop_server 0
  65. Com_drop_spatial_reference_system 0
  66. Com_drop_table 21
  67. Com_drop_trigger 0
  68. Com_drop_user 0
  69. Com_drop_view 68
  70. Com_empty_query 0
  71. Com_execute_sql 0
  72. Com_explain_other 0
  73. Com_flush 1
  74. Com_get_diagnostics 0
  75. Com_grant 0
  76. Com_grant_roles 0
  77. Com_ha_close 0
  78. Com_ha_open 0
  79. Com_ha_read 0
  80. Com_help 0
  81. Com_import 0
  82. Com_insert 670539
  83. Com_insert_select 0
  84. Com_install_component 0
  85. Com_install_plugin 0
  86. Com_kill 13
  87. Com_load 0
  88. Com_lock_instance 0
  89. Com_lock_tables 2
  90. Com_optimize 0
  91. Com_preload_keys 0
  92. Com_prepare_sql 0
  93. Com_purge 0
  94. Com_purge_before_date 0
  95. Com_release_savepoint 0
  96. Com_rename_table 0
  97. Com_rename_user 0
  98. Com_repair 0
  99. Com_replace 0
  100. Com_replace_select 0
  101. Com_reset 0
  102. Com_resignal 0
  103. Com_restart 0
  104. Com_revoke 0
  105. Com_revoke_all 0
  106. Com_revoke_roles 0
  107. Com_rollback 0
  108. Com_rollback_to_savepoint 0
  109. Com_savepoint 0
  110. Com_select 76581
  111. Com_set_option 16658
  112. Com_set_password 0
  113. Com_set_resource_group 0
  114. Com_set_role 0
  115. Com_signal 0
  116. Com_show_binlog_events 0
  117. Com_show_binlogs 0
  118. Com_show_charsets 64
  119. Com_show_collations 19
  120. Com_show_create_db 2
  121. Com_show_create_event 0
  122. Com_show_create_func 0
  123. Com_show_create_proc 0
  124. Com_show_create_table 2336
  125. Com_show_create_trigger 0
  126. Com_show_databases 73
  127. Com_show_engine_logs 0
  128. Com_show_engine_mutex 0
  129. Com_show_engine_status 0
  130. Com_show_events 0
  131. Com_show_errors 0
  132. Com_show_fields 405852
  133. Com_show_function_code 0
  134. Com_show_function_status 43
  135. Com_show_grants 0
  136. Com_show_keys 94
  137. Com_show_master_status 0
  138. Com_show_open_tables 0
  139. Com_show_plugins 1
  140. Com_show_privileges 0
  141. Com_show_procedure_code 0
  142. Com_show_procedure_status 43
  143. Com_show_processlist 104
  144. Com_show_profile 1
  145. Com_show_profiles 0
  146. Com_show_relaylog_events 0
  147. Com_show_replicas 0
  148. Com_show_slave_hosts 0
  149. Com_show_replica_status 1
  150. Com_show_slave_status 1
  151. Com_show_status 68
  152. Com_show_storage_engines 19
  153. Com_show_table_status 2330
  154. Com_show_tables 47
  155. Com_show_triggers 2335
  156. Com_show_variables 252
  157. Com_show_warnings 0
  158. Com_show_create_user 0
  159. Com_shutdown 0
  160. Com_replica_start 0
  161. Com_slave_start 0
  162. Com_replica_stop 0
  163. Com_slave_stop 0
  164. Com_group_replication_start 0
  165. Com_group_replication_stop 0
  166. Com_stmt_execute 0
  167. Com_stmt_close 0
  168. Com_stmt_fetch 0
  169. Com_stmt_prepare 0
  170. Com_stmt_reset 0
  171. Com_stmt_send_long_data 0
  172. Com_truncate 0
  173. Com_uninstall_component 0
  174. Com_uninstall_plugin 0
  175. Com_unlock_instance 0
  176. Com_unlock_tables 0
  177. Com_update 0
  178. Com_update_multi 0
  179. Com_xa_commit 0
  180. Com_xa_end 0
  181. Com_xa_prepare 0
  182. Com_xa_recover 0
  183. Com_xa_rollback 0
  184. Com_xa_start 0
  185. Com_stmt_reprepare 0
  186. Connection_errors_accept 0
  187. Connection_errors_internal 0
  188. Connection_errors_max_connections 0
  189. Connection_errors_peer_address 0
  190. Connection_errors_select 0
  191. Connection_errors_tcpwrap 0
  192. Connections 93
  193. Created_tmp_disk_tables 3
  194. Created_tmp_files 251
  195. Created_tmp_tables 408902
  196. Current_tls_ca ca.pem
  197. Current_tls_capath
  198. Current_tls_cert server-cert.pem
  199. Current_tls_cipher
  200. Current_tls_ciphersuites
  201. Current_tls_crl
  202. Current_tls_crlpath
  203. Current_tls_key server-key.pem
  204. Current_tls_version TLSv1,TLSv1.1,TLSv1.2,TLSv1.3
  205. Delayed_errors 0
  206. Delayed_insert_threads 0
  207. Delayed_writes 0
  208. Error_log_buffered_bytes 22152
  209. Error_log_buffered_events 157
  210. Error_log_expired_events 0
  211. Error_log_latest_write 1611843432205658
  212. Flush_commands 3
  213. Handler_commit 7912763
  214. Handler_delete 3296
  215. Handler_discover 0
  216. Handler_external_lock 36698439
  217. Handler_mrr_init 0
  218. Handler_prepare 1412268
  219. Handler_read_first 4544245
  220. Handler_read_key 158203323
  221. Handler_read_last 68573
  222. Handler_read_next 480899545
  223. Handler_read_prev 0
  224. Handler_read_rnd 12516101
  225. Handler_read_rnd_next 303950738
  226. Handler_rollback 47
  227. Handler_savepoint 0
  228. Handler_savepoint_rollback 0
  229. Handler_update 117951927
  230. Handler_write 18662103
  231. Innodb_buffer_pool_dump_status Dumping of buffer pool not started
  232. Innodb_buffer_pool_load_status Buffer pool(s) load completed at 210126 12:19:33
  233. Innodb_buffer_pool_resize_status
  234. Innodb_buffer_pool_pages_data 466
  235. Innodb_buffer_pool_bytes_data 7634944
  236. Innodb_buffer_pool_pages_dirty 0
  237. Innodb_buffer_pool_bytes_dirty 0
  238. Innodb_buffer_pool_pages_flushed 771790
  239. Innodb_buffer_pool_pages_free 0
  240. Innodb_buffer_pool_pages_misc 46
  241. Innodb_buffer_pool_pages_total 512
  242. Innodb_buffer_pool_read_ahead_rnd 0
  243. Innodb_buffer_pool_read_ahead 1492356
  244. Innodb_buffer_pool_read_ahead_evicted 134332
  245. Innodb_buffer_pool_read_requests 957998256
  246. Innodb_buffer_pool_reads 2138072
  247. Innodb_buffer_pool_wait_free 0
  248. Innodb_buffer_pool_write_requests 18881199
  249. Innodb_data_fsyncs 865616
  250. Innodb_data_pending_fsyncs 4294967293
  251. Innodb_data_pending_reads 0
  252. Innodb_data_pending_writes 0
  253. Innodb_data_read 3647230976
  254. Innodb_data_reads 3633036
  255. Innodb_data_writes 1991841
  256. Innodb_data_written 2146872832
  257. Innodb_dblwr_pages_written 771362
  258. Innodb_dblwr_writes 205029
  259. Innodb_log_waits 0
  260. Innodb_log_write_requests 16823433
  261. Innodb_log_writes 979662
  262. Innodb_os_log_fsyncs 441042
  263. Innodb_os_log_pending_fsyncs 0
  264. Innodb_os_log_pending_writes 0
  265. Innodb_os_log_written 1909043200
  266. Innodb_page_size 16384
  267. Innodb_pages_created 122611
  268. Innodb_pages_read 3630484
  269. Innodb_pages_written 772119
  270. Innodb_redo_log_enabled ON
  271. Innodb_row_lock_current_waits 0
  272. Innodb_row_lock_time 0
  273. Innodb_row_lock_time_avg 0
  274. Innodb_row_lock_time_max 0
  275. Innodb_row_lock_waits 0
  276. Innodb_rows_deleted 0
  277. Innodb_rows_inserted 706143
  278. Innodb_rows_read 688647946
  279. Innodb_rows_updated 0
  280. Innodb_system_rows_deleted 3306
  281. Innodb_system_rows_inserted 2038780
  282. Innodb_system_rows_read 91883189
  283. Innodb_system_rows_updated 1960838
  284. Innodb_sampled_pages_read 0
  285. Innodb_sampled_pages_skipped 0
  286. Innodb_num_open_files 301
  287. Innodb_truncated_status_writes 0
  288. Innodb_undo_tablespaces_total 2
  289. Innodb_undo_tablespaces_implicit 2
  290. Innodb_undo_tablespaces_explicit 0
  291. Innodb_undo_tablespaces_active 2
  292. Key_blocks_not_flushed 0
  293. Key_blocks_unused 6698
  294. Key_blocks_used 0
  295. Key_read_requests 0
  296. Key_reads 0
  297. Key_write_requests 0
  298. Key_writes 0
  299. Locked_connects 0
  300. Max_execution_time_exceeded 0
  301. Max_execution_time_set 0
  302. Max_execution_time_set_failed 0
  303. Max_used_connections 5
  304. Max_used_connections_time 2021-01-27 10:26:53
  305. Mysqlx_aborted_clients 0
  306. Mysqlx_address ::
  307. Mysqlx_bytes_received 0
  308. Mysqlx_bytes_received_compressed_payload 0
  309. Mysqlx_bytes_received_uncompressed_frame 0
  310. Mysqlx_bytes_sent 0
  311. Mysqlx_bytes_sent_compressed_payload 0
  312. Mysqlx_bytes_sent_uncompressed_frame 0
  313. Mysqlx_compression_algorithm
  314. Mysqlx_compression_level
  315. Mysqlx_connection_accept_errors 0
  316. Mysqlx_connection_errors 0
  317. Mysqlx_connections_accepted 0
  318. Mysqlx_connections_closed 0
  319. Mysqlx_connections_rejected 0
  320. Mysqlx_crud_create_view 0
  321. Mysqlx_crud_delete 0
  322. Mysqlx_crud_drop_view 0
  323. Mysqlx_crud_find 0
  324. Mysqlx_crud_insert 0
  325. Mysqlx_crud_modify_view 0
  326. Mysqlx_crud_update 0
  327. Mysqlx_cursor_close 0
  328. Mysqlx_cursor_fetch 0
  329. Mysqlx_cursor_open 0
  330. Mysqlx_errors_sent 0
  331. Mysqlx_errors_unknown_message_type 0
  332. Mysqlx_expect_close 0
  333. Mysqlx_expect_open 0
  334. Mysqlx_init_error 0
  335. Mysqlx_messages_sent 0
  336. Mysqlx_notice_global_sent 0
  337. Mysqlx_notice_other_sent 0
  338. Mysqlx_notice_warning_sent 0
  339. Mysqlx_notified_by_group_replication 0
  340. Mysqlx_port 33060
  341. Mysqlx_prep_deallocate 0
  342. Mysqlx_prep_execute 0
  343. Mysqlx_prep_prepare 0
  344. Mysqlx_rows_sent 0
  345. Mysqlx_sessions 0
  346. Mysqlx_sessions_accepted 0
  347. Mysqlx_sessions_closed 0
  348. Mysqlx_sessions_fatal_error 0
  349. Mysqlx_sessions_killed 0
  350. Mysqlx_sessions_rejected 0
  351. Mysqlx_socket UNDEFINED
  352. Mysqlx_ssl_accepts 0
  353. Mysqlx_ssl_active
  354. Mysqlx_ssl_cipher
  355. Mysqlx_ssl_cipher_list
  356. Mysqlx_ssl_ctx_verify_depth 18446744073709551615
  357. Mysqlx_ssl_ctx_verify_mode 5
  358. Mysqlx_ssl_finished_accepts 0
  359. Mysqlx_ssl_server_not_after Jan 10 08:06:10 2031 GMT
  360. Mysqlx_ssl_server_not_before Jan 12 08:06:10 2021 GMT
  361. Mysqlx_ssl_verify_depth
  362. Mysqlx_ssl_verify_mode
  363. Mysqlx_ssl_version
  364. Mysqlx_stmt_create_collection 0
  365. Mysqlx_stmt_create_collection_index 0
  366. Mysqlx_stmt_disable_notices 0
  367. Mysqlx_stmt_drop_collection 0
  368. Mysqlx_stmt_drop_collection_index 0
  369. Mysqlx_stmt_enable_notices 0
  370. Mysqlx_stmt_ensure_collection 0
  371. Mysqlx_stmt_execute_mysqlx 0
  372. Mysqlx_stmt_execute_sql 0
  373. Mysqlx_stmt_execute_xplugin 0
  374. Mysqlx_stmt_get_collection_options 0
  375. Mysqlx_stmt_kill_client 0
  376. Mysqlx_stmt_list_clients 0
  377. Mysqlx_stmt_list_notices 0
  378. Mysqlx_stmt_list_objects 0
  379. Mysqlx_stmt_modify_collection_options 0
  380. Mysqlx_stmt_ping 0
  381. Mysqlx_worker_threads 2
  382. Mysqlx_worker_threads_active 0
  383. Not_flushed_delayed_rows 0
  384. Ongoing_anonymous_transaction_count 0
  385. Open_files 7
  386. Open_streams 0
  387. Open_table_definitions 1400
  388. Open_tables 1448
  389. Opened_files 7
  390. Opened_table_definitions 147431
  391. Opened_tables 1665181
  392. Performance_schema_accounts_lost 0
  393. Performance_schema_cond_classes_lost 0
  394. Performance_schema_cond_instances_lost 0
  395. Performance_schema_digest_lost 692355
  396. Performance_schema_file_classes_lost 0
  397. Performance_schema_file_handles_lost 0
  398. Performance_schema_file_instances_lost 0
  399. Performance_schema_hosts_lost 0
  400. Performance_schema_index_stat_lost 0
  401. Performance_schema_locker_lost 0
  402. Performance_schema_memory_classes_lost 0
  403. Performance_schema_metadata_lock_lost 0
  404. Performance_schema_mutex_classes_lost 0
  405. Performance_schema_mutex_instances_lost 0
  406. Performance_schema_nested_statement_lost 0
  407. Performance_schema_prepared_statements_lost 0
  408. Performance_schema_program_lost 0
  409. Performance_schema_rwlock_classes_lost 0
  410. Performance_schema_rwlock_instances_lost 0
  411. Performance_schema_session_connect_attrs_longest_seen 218
  412. Performance_schema_session_connect_attrs_lost 0
  413. Performance_schema_socket_classes_lost 0
  414. Performance_schema_socket_instances_lost 0
  415. Performance_schema_stage_classes_lost 0
  416. Performance_schema_statement_classes_lost 0
  417. Performance_schema_table_handles_lost 0
  418. Performance_schema_table_instances_lost 0
  419. Performance_schema_table_lock_stat_lost 0
  420. Performance_schema_thread_classes_lost 0
  421. Performance_schema_thread_instances_lost 0
  422. Performance_schema_users_lost 0
  423. Prepared_stmt_count 0
  424. Queries 1267227
  425. Questions 1265816
  426. Rsa_public_key -----BEGIN PUBLIC KEY-----
  427. MIIBIjANBgkqhkiG9w0BAQEFAAOCAQ8AMIIBCgKCAQEAvh5I/Kj8m1NqICO71RIO
  428. b3kkgSKQWKlYAdTiQm9QpuASuSUleYzjYXHZzNBZi1ZBAM43H7gzDmVnzbkclyHv
  429. krd/Q+0e5Es58jWzm1hndb9zKKvavV9O+wB+dFlQwflz4ltrej3VOshcwBupG4+V
  430. EhhdmKYoLvrYv8lDNBxhBaPUpZJjX0qA...
  431. Secondary_engine_execution_count 0
  432. Select_full_join 2678
  433. Select_full_range_join 0
  434. Select_range 2
  435. Select_range_check 15
  436. Select_scan 416922
  437. Slave_open_temp_tables 0
  438. Slow_launch_threads 0
  439. Slow_queries 56
  440. Sort_merge_passes 63
  441. Sort_range 0
  442. Sort_rows 13480336
  443. Sort_scan 475352
  444. Ssl_accept_renegotiates 0
  445. Ssl_accepts 86
  446. Ssl_callback_cache_hits 0
  447. Ssl_cipher TLS_AES_256_GCM_SHA384
  448. Ssl_cipher_list TLS_AES_256_GCM_SHA384:TLS_CHACHA20_POLY1305_SHA256:TLS_AES_128_GCM_SHA256:ECDHE-ECDSA-AES128-GCM-SHA256:ECDHE-ECDSA-AES256-GCM-SHA384:ECDHE-RSA-AES128-GCM-SHA256:ECDHE-ECDSA-AES128-SHA256:ECDHE-RSA-AES128-SHA256:ECDHE-RSA-AES256-GCM-SHA384:ECDHE-ECDSA-A...
  449. Ssl_client_connects 0
  450. Ssl_connect_renegotiates 0
  451. Ssl_ctx_verify_depth 4294967295
  452. Ssl_ctx_verify_mode 5
  453. Ssl_default_timeout 7200
  454. Ssl_finished_accepts 86
  455. Ssl_finished_connects 0
  456. Ssl_server_not_after Jan 10 08:06:10 2031 GMT
  457. Ssl_server_not_before Jan 12 08:06:10 2021 GMT
  458. Ssl_session_cache_hits 0
  459. Ssl_session_cache_misses 0
  460. Ssl_session_cache_mode SERVER
  461. Ssl_session_cache_overflows 0
  462. Ssl_session_cache_size 128
  463. Ssl_session_cache_timeouts 0
  464. Ssl_sessions_reused 0
  465. Ssl_used_session_cache_entries 0
  466. Ssl_verify_depth 4294967295
  467. Ssl_verify_mode 5
  468. Ssl_version TLSv1.3
  469. Table_locks_immediate 1036
  470. Table_locks_waited 0
  471. Table_open_cache_hits 16739382
  472. Table_open_cache_misses 1665276
  473. Table_open_cache_overflows 1663567
  474. Tc_log_max_pages_used 0
  475. Tc_log_page_size 0
  476. Tc_log_page_waits 0
  477. Threads_cached 3
  478. Threads_connected 2
  479. Threads_created 5
  480. Threads_running 2
  481. Uptime 246592
  482. Uptime_since_flush_status 246592
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement