Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- Variable_name Value
- Aborted_clients 6
- Aborted_connects 0
- AuroraDb_commits 666681
- AuroraDb_commit_latency 1461570244
- AuroraDb_ddl_stmt_duration 148898
- AuroraDb_select_stmt_duration 147205046631
- AuroraDb_insert_stmt_duration 587039457
- AuroraDb_update_stmt_duration 2011186605
- AuroraDb_delete_stmt_duration 18199011
- AuroraDb_lockmgr_bitmaps0_in_use 0
- AuroraDb_lockmgr_bitmaps1_in_use 0
- AuroraDb_lockmgr_bitmaps_mem_used 1158176
- AuroraDb_thread_deadlocks 0
- Aurora_available_alter_table_log_entries 0
- Aurora_dict_sys_mem_size 3125092
- Aurora_fast_insert_cache_hits 0
- Aurora_fast_insert_cache_misses 572
- Aurora_fwd_master_dml_stmt_count 0
- Aurora_fwd_master_dml_stmt_duration 0
- Aurora_fwd_master_errors_rpc_timeout 0
- Aurora_fwd_master_errors_session_limit 0
- Aurora_fwd_master_errors_session_timeout 0
- Aurora_fwd_master_open_sessions 0
- Aurora_fwd_master_select_stmt_count 0
- Aurora_fwd_master_select_stmt_duration 0
- Aurora_highest_commit_lsn 7617325554
- Aurora_last_allocated_lsn_for_replication 7617325555
- Aurora_lockmgr_memory_used 1409614912
- Aurora_missing_history_on_replica_incidents 4121973667908301873
- Aurora_ml_actual_request_cnt 0
- Aurora_ml_actual_response_cnt 0
- Aurora_ml_cache_hit_cnt 0
- Aurora_ml_logical_request_cnt 0
- Aurora_ml_logical_response_cnt 0
- Aurora_ml_retry_request_cnt 0
- Aurora_ml_single_request_cnt 0
- Aurora_oom_response
- Aurora_pq_max_concurrent_requests 8
- Aurora_pq_request_attempted 0
- Aurora_pq_request_attempted_grouping_aggr 0
- Aurora_pq_request_attempted_partition_table 0
- Aurora_pq_request_by_force_config 0
- Aurora_pq_request_by_global_config 0
- Aurora_pq_request_by_hint 0
- Aurora_pq_request_by_session_config 0
- Aurora_pq_request_executed 0
- Aurora_pq_request_executed_grouping_aggr 0
- Aurora_pq_request_executed_partition_table 0
- Aurora_pq_request_failed 0
- Aurora_pq_request_failed_grouping_aggr 0
- Aurora_pq_request_failed_partition_table 0
- Aurora_pq_request_in_instance_type_r_12xlarge 0
- Aurora_pq_request_in_instance_type_r_16xlarge 0
- Aurora_pq_request_in_instance_type_r_24xlarge 0
- Aurora_pq_request_in_instance_type_r_2xlarge 0
- Aurora_pq_request_in_instance_type_r_4xlarge 0
- Aurora_pq_request_in_instance_type_r_8xlarge 0
- Aurora_pq_request_in_instance_type_r_large 0
- Aurora_pq_request_in_instance_type_r_xlarge 0
- Aurora_pq_request_in_instance_type_unsupported 0
- Aurora_pq_request_in_progress 0
- Aurora_pq_request_in_reader_instance 0
- Aurora_pq_request_in_writer_instance 0
- Aurora_pq_request_not_chosen 0
- Aurora_pq_request_not_chosen_below_min_rows 0
- Aurora_pq_request_not_chosen_column_bit 0
- Aurora_pq_request_not_chosen_column_geometry 0
- Aurora_pq_request_not_chosen_column_lob 0
- Aurora_pq_request_not_chosen_column_virtual 0
- Aurora_pq_request_not_chosen_custom_charset 0
- Aurora_pq_request_not_chosen_fast_ddl 0
- Aurora_pq_request_not_chosen_few_pages_outside_buffer_pool 0
- Aurora_pq_request_not_chosen_full_text_index 0
- Aurora_pq_request_not_chosen_grouping_aggr 0
- Aurora_pq_request_not_chosen_grouping_aggr_aggr_type 0
- Aurora_pq_request_not_chosen_grouping_aggr_config 0
- Aurora_pq_request_not_chosen_grouping_aggr_expression 0
- Aurora_pq_request_not_chosen_grouping_aggr_filter 0
- Aurora_pq_request_not_chosen_grouping_aggr_large_aggr_result 0
- Aurora_pq_request_not_chosen_high_buffer_pool_pct 0
- Aurora_pq_request_not_chosen_index_hint 0
- Aurora_pq_request_not_chosen_innodb_table_format 0
- Aurora_pq_request_not_chosen_long_trx 0
- Aurora_pq_request_not_chosen_no_where_clause 0
- Aurora_pq_request_not_chosen_range_scan 0
- Aurora_pq_request_not_chosen_row_length_too_long 0
- Aurora_pq_request_not_chosen_small_table 0
- Aurora_pq_request_not_chosen_temporary_table 0
- Aurora_pq_request_not_chosen_tx_isolation 0
- Aurora_pq_request_not_chosen_unsupported_access 0
- Aurora_pq_request_not_chosen_update_delete_stmts 0
- Aurora_pq_request_throttled 0
- Aurora_pq_request_with_bloom_filter 0
- Aurora_pq_request_with_lob 0
- Aurora_pq_stmt_attempted 0
- Aurora_pq_stmt_attempted_hash_join 0
- Aurora_repl_bytes_received 0
- Aurora_reserved_mem_exceeded_incidents 0
- Aurora_tmz_version 0
- Aurora_total_op_memory 0
- Aurora_total_op_temp_space 0
- Aurora_used_alter_table_log_entries 0
- Aurora_volume_bytes_left_total 140360444575744
- Binlog_cache_disk_use 0
- Binlog_cache_use 0
- Binlog_stmt_cache_disk_use 0
- Binlog_stmt_cache_use 0
- Bytes_received 112030592831
- Bytes_sent 258456053996
- Com_admin_commands 0
- Com_assign_to_keycache 0
- Com_alter_db 0
- Com_alter_db_upgrade 0
- Com_alter_event 0
- Com_alter_function 0
- Com_alter_instance 0
- Com_alter_procedure 0
- Com_alter_server 0
- Com_alter_table 0
- Com_alter_tablespace 0
- Com_alter_user 0
- Com_analyze 0
- Com_begin 373888
- Com_binlog 0
- Com_call_procedure 153697
- Com_change_db 1
- Com_change_master 0
- Com_change_repl_filter 0
- Com_check 0
- Com_checksum 0
- Com_commit 433212
- Com_create_db 0
- Com_create_event 0
- Com_create_function 0
- Com_create_index 0
- Com_create_procedure 0
- Com_create_server 0
- Com_create_table 0
- Com_create_trigger 8
- Com_create_udf 0
- Com_create_user 0
- Com_create_view 0
- Com_dealloc_sql 0
- Com_delete 71954
- Com_delete_multi 1443
- Com_do 92740
- Com_drop_db 0
- Com_drop_event 0
- Com_drop_function 0
- Com_drop_index 0
- Com_drop_procedure 1
- Com_drop_server 0
- Com_drop_table 0
- Com_drop_trigger 8
- Com_drop_user 0
- Com_drop_view 0
- Com_empty_query 0
- Com_execute_sql 0
- Com_explain_other 0
- Com_flush 945
- Com_get_diagnostics 0
- Com_grant 0
- Com_ha_close 0
- Com_ha_open 0
- Com_ha_read 0
- Com_help 0
- Com_insert 634834
- Com_insert_select 52672
- Com_install_plugin 0
- Com_kill 0
- Com_load 0
- Com_lock_tables 0
- Com_optimize 0
- Com_preload_keys 0
- Com_prepare_sql 0
- Com_purge 0
- Com_purge_before_date 397
- Com_release_savepoint 0
- Com_rename_table 0
- Com_rename_user 0
- Com_repair 0
- Com_replace 0
- Com_replace_select 83048
- Com_reset 0
- Com_resignal 0
- Com_revoke 0
- Com_revoke_all 0
- Com_rollback 336
- Com_rollback_to_savepoint 0
- Com_savepoint 0
- Com_select 9113463
- Com_set_option 264750
- Com_signal 0
- Com_show_binlog_events 0
- Com_show_binlogs 0
- Com_show_charsets 0
- Com_show_collations 0
- Com_show_create_db 0
- Com_show_create_event 0
- Com_show_create_func 0
- Com_show_create_proc 0
- Com_show_create_table 0
- Com_show_create_trigger 0
- Com_show_databases 0
- Com_show_engine_logs 0
- Com_show_engine_mutex 0
- Com_show_engine_status 0
- Com_show_events 0
- Com_show_errors 0
- Com_show_fields 0
- Com_show_function_code 0
- Com_show_function_status 0
- Com_show_grants 0
- Com_show_keys 0
- Com_show_master_status 0
- Com_show_open_tables 0
- Com_show_plugins 0
- Com_show_privileges 0
- Com_show_procedure_code 0
- Com_show_procedure_status 0
- Com_show_processlist 0
- Com_show_profile 0
- Com_show_profiles 0
- Com_show_relaylog_events 0
- Com_show_slave_hosts 0
- Com_show_slave_status 0
- Com_show_status 36
- Com_show_storage_engines 0
- Com_show_table_status 0
- Com_show_tables 0
- Com_show_triggers 0
- Com_show_variables 399
- Com_show_warnings 7
- Com_show_create_user 0
- Com_shutdown 0
- Com_slave_start 0
- Com_slave_stop 0
- Com_group_replication_start 0
- Com_group_replication_stop 0
- Com_stmt_execute 16296143
- Com_stmt_close 16275099
- Com_stmt_fetch 0
- Com_stmt_prepare 16275152
- Com_stmt_reset 0
- Com_stmt_send_long_data 0
- Com_truncate 0
- Com_uninstall_plugin 0
- Com_unlock_tables 0
- Com_update 494921
- Com_update_multi 103815
- Com_xa_commit 0
- Com_xa_end 0
- Com_xa_prepare 0
- Com_xa_recover 0
- Com_xa_rollback 0
- Com_xa_start 0
- Com_awslambda 0
- Com_alter_system 0
- Com_unit_test 0
- Com_show_volume_status 0
- Com_stmt_reprepare 0
- Compression OFF
- Connection_errors_accept 0
- Connection_errors_internal 0
- Connection_errors_max_connections 0
- Connection_errors_peer_address 0
- Connection_errors_select 0
- Connection_errors_tcpwrap 0
- Connections 2266422
- Created_tmp_disk_tables 982228
- Created_tmp_files 68950
- Created_tmp_tables 18657920
- Delayed_errors 0
- Delayed_insert_threads 0
- Delayed_writes 0
- External_threads_connected 14
- Flush_commands 1
- Handler_commit 15635900
- Handler_delete 89369
- Handler_discover 0
- Handler_external_lock 125236085
- Handler_mrr_init 0
- Handler_prepare 0
- Handler_read_first 3405352
- Handler_read_key 13594515353
- Handler_read_last 21973
- Handler_read_next 42095761252
- Handler_read_prev 3056
- Handler_read_rnd 248150228
- Handler_read_rnd_next 12645062756
- Handler_rollback 5533615
- Handler_savepoint 0
- Handler_savepoint_rollback 0
- Handler_update 52540426
- Handler_write 14605399096
- Innodb_buffer_pool_dump_status Dumping of buffer pool not started
- Innodb_buffer_pool_load_status Loading of buffer pool not started
- Innodb_buffer_pool_resize_status
- Innodb_buffer_pool_pages_data 2116512
- Innodb_buffer_pool_bytes_data 34676932608
- Innodb_buffer_pool_pages_dirty 354764
- Innodb_buffer_pool_bytes_dirty 5812453376
- Innodb_buffer_pool_pages_flushed 27846
- Innodb_buffer_pool_pages_free 3755104
- Innodb_buffer_pool_pages_misc 0
- Innodb_buffer_pool_pages_total 5871616
- Innodb_buffer_pool_read_ahead_rnd 0
- Innodb_buffer_pool_read_ahead 0
- Innodb_buffer_pool_read_ahead_evicted 0
- Innodb_logical_read_ahead_page_count 25096317
- Innodb_buffer_pool_read_requests 151995141357
- Innodb_buffer_pool_reads 1591154
- Innodb_buffer_pool_wait_free 0
- Innodb_buffer_pool_write_requests 78191498
- Innodb_data_fsyncs 0
- Innodb_data_pending_fsyncs 0
- Innodb_data_pending_reads 0
- Innodb_data_pending_writes 0
- Innodb_data_read 27567800320
- Innodb_data_reads 0
- Innodb_data_writes 0
- Innodb_data_written 0
- Innodb_dblwr_pages_written 0
- Innodb_dblwr_writes 0
- Innodb_log_waits 0
- Innodb_log_write_requests 0
- Innodb_log_writes 0
- Innodb_os_log_fsyncs 0
- Innodb_os_log_pending_fsyncs 0
- Innodb_os_log_pending_writes 0
- Innodb_os_log_written 0
- Innodb_page_size 16384
- Innodb_pages_created 371052
- Innodb_pages_read 1682681
- Innodb_pages_written 27846
- Innodb_row_lock_current_waits 0
- Innodb_row_lock_time 400442
- Innodb_row_lock_time_avg 480
- Innodb_row_lock_time_max 44051
- Innodb_row_lock_waits 834
- Innodb_rows_deleted 89368
- Innodb_rows_inserted 58989249
- Innodb_rows_read 50559229604
- Innodb_rows_updated 3202217
- Innodb_num_open_files 310
- Innodb_truncated_status_writes 0
- Innodb_available_undo_logs 128
- Key_blocks_not_flushed 0
- Key_blocks_unused 13396
- Key_blocks_used 0
- Key_read_requests 0
- Key_reads 0
- Key_write_requests 0
- Key_writes 0
- Last_query_cost 0.000000
- Last_query_partial_plans 0
- Locked_connects 0
- Max_execution_time_exceeded 0
- Max_execution_time_set 0
- Max_execution_time_set_failed 0
- Max_used_connections 110
- Max_used_connections_time 2021-05-05 20:20:46
- Not_flushed_delayed_rows 0
- Ongoing_anonymous_transaction_count 0
- Open_files 2
- Open_streams 0
- Open_table_definitions 485
- Open_tables 5984
- Opened_files 69261
- Opened_table_definitions 498
- Opened_tables 2084463
- Performance_schema_accounts_lost 0
- Performance_schema_cond_classes_lost 0
- Performance_schema_cond_instances_lost 0
- Performance_schema_digest_lost 0
- Performance_schema_file_classes_lost 0
- Performance_schema_file_handles_lost 0
- Performance_schema_file_instances_lost 0
- Performance_schema_hosts_lost 0
- Performance_schema_index_stat_lost 0
- Performance_schema_locker_lost 0
- Performance_schema_memory_classes_lost 0
- Performance_schema_metadata_lock_lost 0
- Performance_schema_mutex_classes_lost 0
- Performance_schema_mutex_instances_lost 0
- Performance_schema_nested_statement_lost 0
- Performance_schema_prepared_statements_lost 0
- Performance_schema_program_lost 0
- Performance_schema_rwlock_classes_lost 0
- Performance_schema_rwlock_instances_lost 0
- Performance_schema_session_connect_attrs_lost 0
- Performance_schema_socket_classes_lost 0
- Performance_schema_socket_instances_lost 0
- Performance_schema_stage_classes_lost 0
- Performance_schema_statement_classes_lost 0
- Performance_schema_table_handles_lost 0
- Performance_schema_table_instances_lost 0
- Performance_schema_table_lock_stat_lost 0
- Performance_schema_thread_classes_lost 0
- Performance_schema_thread_instances_lost 0
- Performance_schema_users_lost 0
- Prepared_stmt_count 5
- Qcache_free_blocks 4685
- Qcache_free_memory 8279176
- Qcache_hits 6303912
- Qcache_inserts 6590660
- Qcache_lowmem_prunes 585971
- Qcache_not_cached 2468119
- Qcache_queries_in_cache 484674
- Qcache_total_blocks 4471002
- Queries 55306887
- Questions 19923532
- Select_full_join 1285085
- Select_full_range_join 54763
- Select_range 402379
- Select_range_check 1652
- Select_scan 2347931
- Slave_heartbeat_period 0.000
- Slave_last_heartbeat
- Slave_open_temp_tables 0
- Slave_received_heartbeats 0
- Slave_retried_transactions 0
- Slave_running OFF
- Slow_launch_threads 0
- Slow_queries 266
- Sort_merge_passes 152110
- Sort_range 298972
- Sort_rows 614100951
- Sort_scan 393196
- Ssl_accept_renegotiates 0
- Ssl_accepts 0
- Ssl_callback_cache_hits 0
- Ssl_cipher
- Ssl_cipher_list
- Ssl_client_connects 0
- Ssl_connect_renegotiates 0
- Ssl_ctx_verify_depth 18446744073709551615
- Ssl_ctx_verify_mode 5
- Ssl_default_timeout 0
- Ssl_finished_accepts 0
- Ssl_finished_connects 0
- Ssl_server_not_after Aug 22 17:08:50 2024 GMT
- Ssl_server_not_before May 5 09:13:23 2021 GMT
- Ssl_session_cache_hits 0
- Ssl_session_cache_misses 0
- Ssl_session_cache_mode SERVER
- Ssl_session_cache_overflows 0
- Ssl_session_cache_size 128
- Ssl_session_cache_timeouts 0
- Ssl_sessions_reused 0
- Ssl_used_session_cache_entries 0
- Ssl_verify_depth 0
- Ssl_verify_mode 0
- Ssl_version
- Table_locks_immediate 90
- Table_locks_waited 0
- Table_open_cache_hits 228057772
- Table_open_cache_misses 2084463
- Table_open_cache_overflows 2078458
- Tc_log_max_pages_used 0
- Tc_log_page_size 0
- Tc_log_page_waits 0
- Threads_cached 0
- Threads_connected 18
- Threads_created 28
- Threads_running 6
- Time_since_zero_connections 0
- Uptime 119320
- Uptime_since_flush_status 119320
- server_audit_active OFF
- server_audit_last_error
- server_audit_writes_failed 0
- server_aurora_das_messages_missed 0
- server_aurora_das_messages_queued 0
- server_aurora_das_num_fatal_errors 0
- server_aurora_das_running OFF
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement