SHOW GLOBAL STATUS;

"Variable_name","Value"
"Aborted_clients",3
"Aborted_connects",4
"AuroraDb_commits",270804
"AuroraDb_commit_latency",1241204318
"AuroraDb_ddl_stmt_duration",19056048
"AuroraDb_select_stmt_duration",27489626543
"AuroraDb_insert_stmt_duration",437306992
"AuroraDb_update_stmt_duration",32693016
"AuroraDb_delete_stmt_duration",25596945
"AuroraDb_lockmgr_bitmaps0_in_use",16
"AuroraDb_lockmgr_bitmaps1_in_use",0
"AuroraDb_lockmgr_bitmaps_mem_used",1725
"AuroraDb_thread_deadlocks",0
"Aurora_available_alter_table_log_entries",0
"Aurora_dict_sys_mem_size",5137827
"Aurora_fast_insert_cache_hits",0
"Aurora_fast_insert_cache_misses",0
"Aurora_lockmgr_memory_used",649275645
"Aurora_missing_history_on_replica_incidents",0
"Aurora_repl_bytes_received",0
"Aurora_reserved_mem_exceeded_incidents",0
"Aurora_total_op_memory",0
"Aurora_total_op_memory_limit",826097254
"Aurora_total_op_temp_space",0
"Aurora_total_op_temp_space_limit",23275533926
"Aurora_used_alter_table_log_entries",0
"Binlog_cache_disk_use",0
"Binlog_cache_use",0
"Binlog_stmt_cache_disk_use",0
"Binlog_stmt_cache_use",0
"Bytes_received",3924234277
"Bytes_sent",67045044667
"Com_admin_commands",794999
"Com_assign_to_keycache",0
"Com_alter_db",0
"Com_alter_db_upgrade",0
"Com_alter_event",0
"Com_alter_function",0
"Com_alter_procedure",0
"Com_alter_server",0
"Com_alter_table",678
"Com_alter_tablespace",0
"Com_alter_user",0
"Com_analyze",0
"Com_begin",104
"Com_binlog",0
"Com_call_procedure",0
"Com_change_db",169140
"Com_change_master",0
"Com_check",0
"Com_checksum",0
"Com_commit",158858
"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",339
"Com_create_trigger",0
"Com_create_udf",0
"Com_create_user",0
"Com_create_view",0
"Com_dealloc_sql",0
"Com_delete",2769
"Com_delete_multi",0
"Com_do",0
"Com_drop_db",0
"Com_drop_event",0
"Com_drop_function",0
"Com_drop_index",0
"Com_drop_procedure",0
"Com_drop_server",0
"Com_drop_table",675
"Com_drop_trigger",0
"Com_drop_user",0
"Com_drop_view",0
"Com_empty_query",0
"Com_execute_sql",0
"Com_flush",2485
"Com_get_diagnostics",0
"Com_grant",0
"Com_ha_close",0
"Com_ha_open",0
"Com_ha_read",0
"Com_help",0
"Com_insert",219803
"Com_insert_select",0
"Com_install_plugin",0
"Com_kill",0
"Com_load",0
"Com_lock_tables",339
"Com_optimize",0
"Com_preload_keys",0
"Com_prepare_sql",0
"Com_purge",0
"Com_purge_before_date",1059
"Com_release_savepoint",0
"Com_rename_table",0
"Com_rename_user",0
"Com_repair",0
"Com_replace",0
"Com_replace_select",0
"Com_reset",0
"Com_resignal",0
"Com_revoke",0
"Com_revoke_all",0
"Com_rollback",0
"Com_rollback_to_savepoint",0
"Com_savepoint",0
"Com_select",1537703
"Com_set_option",897631
"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",7552
"Com_show_create_trigger",1
"Com_show_databases",36
"Com_show_engine_logs",0
"Com_show_engine_mutex",0
"Com_show_engine_status",1
"Com_show_events",0
"Com_show_errors",0
"Com_show_fields",65272
"Com_show_function_code",0
"Com_show_function_status",0
"Com_show_grants",0
"Com_show_keys",6
"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",50
"Com_show_profile",0
"Com_show_profiles",0
"Com_show_relaylog_events",0
"Com_show_slave_hosts",0
"Com_show_slave_status",132374
"Com_show_status",5302
"Com_show_storage_engines",0
"Com_show_table_status",11106
"Com_show_tables",199
"Com_show_triggers",7467
"Com_show_variables",1471
"Com_show_warnings",0
"Com_slave_start",47655
"Com_slave_stop",15884
"Com_stmt_close",12
"Com_stmt_execute",317665
"Com_stmt_fetch",0
"Com_stmt_prepare",14
"Com_stmt_reprepare",0
"Com_stmt_reset",0
"Com_stmt_send_long_data",0
"Com_truncate",2
"Com_uninstall_plugin",0
"Com_unlock_tables",443
"Com_update",35385
"Com_update_multi",25
"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",5195
"Com_show_volume_status",0
"Compression","ON"
"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",185449
"Created_tmp_disk_tables",100117
"Created_tmp_files",3567
"Created_tmp_tables",449342
"Delayed_errors",0
"Delayed_insert_threads",0
"Delayed_writes",0
"External_threads_connected",2
"Flush_commands",1
"Handler_commit",3523659
"Handler_delete",66164
"Handler_discover",0
"Handler_external_lock",8778774
"Handler_mrr_init",0
"Handler_prepare",0
"Handler_read_first",109482
"Handler_read_key",807113598
"Handler_read_last",376
"Handler_read_next",9407049106
"Handler_read_prev",9522133
"Handler_read_rnd",14019302
"Handler_read_rnd_next",812686574
"Handler_rollback",214012
"Handler_savepoint",0
"Handler_savepoint_rollback",0
"Handler_update",2363076
"Handler_write",21175541
"Innodb_buffer_pool_dump_status","not started"
"Innodb_buffer_pool_load_status","not started"
"Innodb_buffer_pool_pages_data",369409
"Innodb_buffer_pool_bytes_data",6052397056
"Innodb_buffer_pool_pages_dirty",0
"Innodb_buffer_pool_bytes_dirty",0
"Innodb_buffer_pool_pages_flushed",0
"Innodb_buffer_pool_pages_free",140891
"Innodb_buffer_pool_pages_misc",0
"Innodb_buffer_pool_pages_total",510300
"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",21263628
"Innodb_buffer_pool_read_requests",50043948812
"Innodb_buffer_pool_reads",84775
"Innodb_buffer_pool_wait_free",0
"Innodb_buffer_pool_write_requests",63071717
"Innodb_data_fsyncs",0
"Innodb_data_pending_fsyncs",0
"Innodb_data_pending_reads",0
"Innodb_data_pending_writes",0
"Innodb_data_read",2015559680
"Innodb_data_reads",0
"Innodb_data_writes",0
"Innodb_data_written",0
"Innodb_dblwr_pages_written",0
"Innodb_dblwr_writes",0
"Innodb_have_atomic_builtins","ON"
"Innodb_log_waits",0
"Innodb_log_write_requests",0
"Innodb_log_writes",1
"Innodb_os_log_fsyncs",0
"Innodb_os_log_pending_fsyncs",0
"Innodb_os_log_pending_writes",0
"Innodb_os_log_written",512
"Innodb_page_size",16384
"Innodb_pages_created",249867
"Innodb_pages_read",123021
"Innodb_pages_written",0
"Innodb_row_lock_current_waits",0
"Innodb_row_lock_time",6
"Innodb_row_lock_time_avg",6
"Innodb_row_lock_time_max",6
"Innodb_row_lock_waits",1
"Innodb_rows_deleted",80305
"Innodb_rows_inserted",7297292
"Innodb_rows_read",10318923873
"Innodb_rows_updated",2677732
"Innodb_num_open_files",492
"Innodb_truncated_status_writes",0
"Innodb_available_undo_logs",128
"Key_blocks_not_flushed",0
"Key_blocks_unused",13371
"Key_blocks_used",32
"Key_read_requests",23957
"Key_reads",25
"Key_write_requests",18365
"Key_writes",0
"Last_query_cost",0.000000
"Last_query_partial_plans",0
"Max_used_connections",53
"Not_flushed_delayed_rows",0
"Open_files",22
"Open_streams",0
"Open_table_definitions",488
"Open_tables",1594
"Opened_files",420380
"Opened_table_definitions",1385
"Opened_tables",2772
"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",27931
"Performance_schema_hosts_lost",0
"Performance_schema_locker_lost",0
"Performance_schema_mutex_classes_lost",0
"Performance_schema_mutex_instances_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_thread_classes_lost",0
"Performance_schema_thread_instances_lost",0
"Performance_schema_users_lost",0
"Prepared_stmt_count",2
"Qcache_free_blocks",155
"Qcache_free_memory",207048
"Qcache_hits",971051
"Qcache_inserts",434924
"Qcache_lowmem_prunes",67440
"Qcache_not_cached",1047493
"Qcache_queries_in_cache",153473
"Qcache_total_blocks",686984
"Queries",5246807
"Questions",4451781
"Rsa_public_key",""
"Select_full_join",4737
"Select_full_range_join",1650
"Select_range",92192
"Select_range_check",0
"Select_scan",775997
"Slave_heartbeat_period",1800.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",969
"Sort_merge_passes",5756
"Sort_range",57137
"Sort_rows",13091552
"Sort_scan",64864
"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",""
"Ssl_server_not_before",""
"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",3876149
"Table_locks_waited",0
"Table_open_cache_hits",3839524
"Table_open_cache_misses",2429
"Table_open_cache_overflows",0
"Tc_log_max_pages_used",0
"Tc_log_page_size",0
"Tc_log_page_waits",0
"Threads_cached",0
"Threads_connected",7
"Threads_created",16
"Threads_running",1
"Time_since_zero_connections",0
"Uptime",317726
"Uptime_since_flush_status",317726
"aurora_scheduler_health_check","ON"
"server_audit_active","OFF"
"server_audit_last_error",""
"server_audit_writes_failed",0

SHOW GLOBAL VARIABLES;

"Variable_name","Value"
"aurora_binlog_use_large_read_buffer","OFF"
"aurora_enable_repl_bin_log_filtering","ON"
"aurora_enable_replica_log_compression","ON"
"aurora_enable_staggered_replica_restart","OFF"
"aurora_enable_zdr","OFF"
"aurora_lab_mode","OFF"
"aurora_load_from_s3_role",""
"aurora_max_alter_table_log_entries",1000
"aurora_max_connections_limit",16000
"aurora_select_into_s3_role",""
"aurora_server_id","asamazon2"
"aurora_use_key_prefetch","ON"
"aurora_version","1.17.8"
"aurora_zdr_timeout_on_replica_fall_behind","ON"
"auto_increment_increment",1
"auto_increment_offset",1
"autocommit","ON"
"automatic_sp_privileges","ON"
"aws_default_lambda_role",""
"aws_default_s3_role",""
"awsauthenticationplugin_max_backoff_delay",2000
"awsauthenticationplugin_max_retry_count",3
"awsauthenticationplugin_retry_delay",250
"back_log",250
"basedir","/rdsdbbin/oscar/"
"big_tables","OFF"
"bind_address","*"
"binlog_cache_size",32768
"binlog_checksum","CRC32"
"binlog_direct_non_transactional_updates","OFF"
"binlog_format","STATEMENT"
"binlog_max_flush_queue_time",0
"binlog_order_commits","ON"
"binlog_row_image","FULL"
"binlog_rows_query_log_events","OFF"
"binlog_stmt_cache_size",32768
"bulk_insert_buffer_size",8388608
"character_set_client","latin1"
"character_set_connection","latin1"
"character_set_database","latin1"
"character_set_filesystem","binary"
"character_set_results","latin1"
"character_set_server","latin1"
"character_set_system","utf8"
"character_sets_dir","/rdsdbbin/oscar-5.6.10a.200340.0/share/charsets/"
"collation_connection","latin1_swedish_ci"
"collation_database","latin1_swedish_ci"
"collation_server","latin1_swedish_ci"
"completion_type","NO_CHAIN"
"concurrent_insert","AUTO"
"connect_timeout",10
"core_file","ON"
"datadir","/rdsdbdata/db/"
"date_format","%Y-%m-%d"
"datetime_format","%Y-%m-%d %H:%i:%s"
"default_storage_engine","InnoDB"
"default_tmp_storage_engine","InnoDB"
"default_week_format",0
"delay_key_write","ON"
"delayed_insert_limit",100
"delayed_insert_timeout",300
"delayed_queue_size",1000
"disconnect_on_expired_password","ON"
"div_precision_increment",4
"end_markers_in_json","OFF"
"enforce_gtid_consistency","OFF"
"eq_range_index_dive_limit",10
"event_scheduler","OFF"
"expire_logs_days",0
"explicit_defaults_for_timestamp","ON"
"flush","OFF"
"flush_time",0
"foreign_key_checks","ON"
"ft_boolean_syntax","+ -><()~*:""""&|"
"ft_max_word_len",84
"ft_min_word_len",4
"ft_query_expansion_limit",20
"ft_stopword_file","(built-in)"
"general_log","OFF"
"general_log_file","/rdsdbdata/log/general/mysql-general.log"
"group_concat_max_len",1024
"gtid_executed",""
"gtid_mode","OFF"
"gtid_owned",""
"gtid_purged",""
"have_compress","YES"
"have_crypt","YES"
"have_dynamic_loading","YES"
"have_geometry","YES"
"have_openssl","YES"
"have_profiling","YES"
"have_query_cache","YES"
"have_rtree_keys","YES"
"have_ssl","YES"
"have_symlink","YES"
"host_cache_size",128
"hostname","ip-10-6-2-81"
"ignore_builtin_innodb","OFF"
"ignore_db_dirs",""
"ignore_default_storage_engine_errors","OFF"
"init_connect",""
"init_file",""
"init_slave",""
"innodb_adaptive_flushing","ON"
"innodb_adaptive_flushing_lwm",10
"innodb_adaptive_hash_index","OFF"
"innodb_adaptive_max_sleep_delay",150000
"innodb_additional_mem_pool_size",8388608
"innodb_api_bk_commit_interval",5
"innodb_api_disable_rowlock","OFF"
"innodb_api_enable_binlog","OFF"
"innodb_api_enable_mdl","OFF"
"innodb_api_trx_level",0
"innodb_aurora_enable_auto_akp","OFF"
"innodb_autoextend_increment",64
"innodb_autoinc_lock_mode",1
"innodb_buffer_pool_dump_at_shutdown","OFF"
"innodb_buffer_pool_dump_now","OFF"
"innodb_buffer_pool_dump_pct",100
"innodb_buffer_pool_filename","ib_buffer_pool"
"innodb_buffer_pool_instances",8
"innodb_buffer_pool_load_abort","OFF"
"innodb_buffer_pool_load_at_startup","OFF"
"innodb_buffer_pool_load_now","OFF"
"innodb_buffer_pool_size",8364490752
"innodb_change_buffer_max_size",25
"innodb_change_buffering","none"
"innodb_checksum_algorithm","none"
"innodb_checksums","OFF"
"innodb_cmp_per_index_enabled","OFF"
"innodb_commit_concurrency",0
"innodb_compression_failure_threshold_pct",5
"innodb_compression_level",6
"innodb_compression_pad_pct_max",50
"innodb_concurrency_tickets",5000
"innodb_data_file_path","ibdata1:12M:autoextend"
"innodb_data_home_dir",""
"innodb_disable_sort_file_cache","OFF"
"innodb_doublewrite","OFF"
"innodb_fast_shutdown",1
"innodb_file_format","Antelope"
"innodb_file_format_check","ON"
"innodb_file_format_max","Antelope"
"innodb_file_per_table","ON"
"innodb_flush_log_at_timeout",1
"innodb_flush_log_at_trx_commit",1
"innodb_flush_method","O_DIRECT"
"innodb_flush_neighbors",1
"innodb_flushing_avg_loops",30
"innodb_force_load_corrupted","OFF"
"innodb_force_recovery",0
"innodb_ft_aux_table",""
"innodb_ft_cache_size",8000000
"innodb_ft_enable_diag_print","OFF"
"innodb_ft_enable_stopword","ON"
"innodb_ft_max_token_size",84
"innodb_ft_min_token_size",3
"innodb_ft_num_word_optimize",2000
"innodb_ft_result_cache_limit",2000000000
"innodb_ft_server_stopword_table",""
"innodb_ft_sort_pll_degree",2
"innodb_ft_total_cache_size",640000000
"innodb_ft_user_stopword_table",""
"innodb_io_capacity",200
"innodb_io_capacity_max",2000
"innodb_large_prefix","OFF"
"innodb_lock_wait_timeout",50
"innodb_locks_unsafe_for_binlog","OFF"
"innodb_log_buffer_size",8388608
"innodb_log_file_size",50331648
"innodb_log_files_in_group",2
"innodb_log_group_home_dir","./"
"innodb_lru_scan_depth",1024
"innodb_max_dirty_pages_pct",75
"innodb_max_dirty_pages_pct_lwm",0
"innodb_max_purge_lag",0
"innodb_max_purge_lag_delay",0
"innodb_mirrored_log_groups",1
"innodb_monitor_disable",""
"innodb_monitor_enable",""
"innodb_monitor_reset",""
"innodb_monitor_reset_all",""
"innodb_old_blocks_pct",37
"innodb_old_blocks_time",1000
"innodb_online_alter_log_max_size",134217728
"innodb_open_files",6000
"innodb_optimize_fulltext_only","OFF"
"innodb_page_size",16384
"innodb_print_all_deadlocks","OFF"
"innodb_purge_batch_size",300
"innodb_purge_threads",1
"innodb_random_read_ahead","OFF"
"innodb_read_ahead_threshold",56
"innodb_read_io_threads",4
"innodb_read_only","OFF"
"innodb_replication_delay",0
"innodb_rollback_on_timeout","OFF"
"innodb_rollback_segments",128
"innodb_shared_buffer_pool_uses_huge_pages","ON"
"innodb_sort_buffer_size",1048576
"innodb_spin_wait_delay",6
"innodb_stats_auto_recalc","ON"
"innodb_stats_method","nulls_equal"
"innodb_stats_on_metadata","OFF"
"innodb_stats_persistent","ON"
"innodb_stats_persistent_sample_pages",20
"innodb_stats_sample_pages",8
"innodb_stats_transient_sample_pages",8
"innodb_strict_mode","OFF"
"innodb_support_xa","ON"
"innodb_sync_array_size",1
"innodb_sync_spin_loops",30
"innodb_table_locks","ON"
"innodb_thread_concurrency",0
"innodb_thread_sleep_delay",10000
"innodb_undo_directory","."
"innodb_undo_logs",128
"innodb_undo_tablespaces",0
"innodb_use_native_aio","OFF"
"innodb_use_sys_malloc","ON"
"innodb_version","1.2.10"
"innodb_write_io_threads",4
"interactive_timeout",180
"join_buffer_size",262144
"keep_files_on_create","OFF"
"key_buffer_size",16777216
"key_cache_age_threshold",300
"key_cache_block_size",1024
"key_cache_division_limit",100
"large_files_support","ON"
"large_page_size",0
"large_pages","OFF"
"lc_messages","en_US"
"lc_messages_dir","/rdsdbbin/oscar-5.6.10a.200340.0/share/"
"lc_time_names","en_US"
"license","GPL"
"local_infile","ON"
"lock_wait_timeout",31536000
"locked_in_memory","OFF"
"log_bin","OFF"
"log_bin_basename",""
"log_bin_index",""
"log_bin_trust_function_creators","OFF"
"log_bin_use_v1_row_events","OFF"
"log_error","/rdsdbdata/log/error/mysql-error.log"
"log_output","TABLE"
"log_queries_not_using_indexes","OFF"
"log_slave_updates","ON"
"log_throttle_queries_not_using_indexes",0
"log_warnings",1
"long_query_time",5.000000
"low_priority_updates","OFF"
"lower_case_file_system","OFF"
"lower_case_table_names",0
"master_info_repository","TABLE"
"master_verify_checksum","OFF"
"max_allowed_packet",4194304
"max_binlog_cache_size",18446744073709547520
"max_binlog_size",134217728
"max_binlog_stmt_cache_size",18446744073709547520
"max_connect_errors",100
"max_connections",1000
"max_delayed_threads",20
"max_digest_length",1024
"max_error_count",64
"max_heap_table_size",16777216
"max_insert_delayed_threads",20
"max_join_size",18446744073709551615
"max_length_for_sort_data",1024
"max_prepared_stmt_count",16382
"max_relay_log_size",0
"max_seeks_for_key",18446744073709551615
"max_sort_length",1024
"max_sp_recursion_depth",0
"max_tmp_tables",32
"max_user_connections",0
"max_write_lock_count",18446744073709551615
"metadata_locks_cache_size",1024
"min_examined_row_limit",0
"multi_range_count",256
"myisam_data_pointer_size",6
"myisam_max_sort_file_size",9223372036853727232
"myisam_mmap_size",18446744073709551615
"myisam_recover_options","OFF"
"myisam_repair_threads",1
"myisam_sort_buffer_size",8388608
"myisam_stats_method","nulls_unequal"
"myisam_use_mmap","OFF"
"net_buffer_length",16384
"net_read_timeout",30
"net_retry_count",10
"net_write_timeout",60
"new","OFF"
"old","OFF"
"old_alter_table","OFF"
"old_passwords",0
"open_files_limit",65535
"optimizer_prune_level",1
"optimizer_search_depth",62
"optimizer_switch","index_merge=on,index_merge_union=on,index_merge_sort_union=on,index_merge_intersection=on,engine_condition_pushdown=on,index_condition_pushdown=on,mrr=on,mrr_cost_based=on,block_nested_loop=on,batched_key_access=off,materialization=on,semijoin=on,loosescan=on,firstmatch=on,subquery_materialization_cost_based=on,use_index_extensions=on,hash_join=on,hash_join_cost_based=on"
"optimizer_trace","enabled=off,one_line=off"
"optimizer_trace_features","greedy_search=on,range_optimizer=on,dynamic_range=on,repeated_subselect=on"
"optimizer_trace_limit",1
"optimizer_trace_max_mem_size",16384
"optimizer_trace_offset",-1
"performance_schema","ON"
"performance_schema__auto__","ON"
"performance_schema_accounts_size",100
"performance_schema_digests_size",10000
"performance_schema_events_stages_history_long_size",10000
"performance_schema_events_stages_history_size",10
"performance_schema_events_statements_history_long_size",10000
"performance_schema_events_statements_history_size",10
"performance_schema_events_waits_history_long_size",10000
"performance_schema_events_waits_history_size",10
"performance_schema_hosts_size",100
"performance_schema_max_cond_classes",80
"performance_schema_max_cond_instances",44160
"performance_schema_max_digest_length",1024
"performance_schema_max_file_classes",50
"performance_schema_max_file_handles",32768
"performance_schema_max_file_instances",92616
"performance_schema_max_mutex_classes",200
"performance_schema_max_mutex_instances",307090
"performance_schema_max_rwlock_classes",40
"performance_schema_max_rwlock_instances",122430
"performance_schema_max_socket_classes",10
"performance_schema_max_socket_instances",2050
"performance_schema_max_stage_classes",150
"performance_schema_max_statement_classes",177
"performance_schema_max_table_handles",12000
"performance_schema_max_table_instances",25000
"performance_schema_max_thread_classes",50
"performance_schema_max_thread_instances",2130
"performance_schema_session_connect_attrs_size",512
"performance_schema_setup_actors_size",100
"performance_schema_setup_objects_size",100
"performance_schema_users_size",100
"pid_file","/rdsdbdata/log/mysql-3306.pid"
"plugin_dir","/rdsdbbin/oscar-5.6.10a.200340.0/lib/plugin/"
"port",3306
"preload_buffer_size",32768
"profiling","OFF"
"profiling_history_size",15
"protocol_version",10
"query_alloc_block_size",8192
"query_cache_limit",1048576
"query_cache_min_res_unit",4096
"query_cache_size",464717824
"query_cache_type","ON"
"query_cache_wlock_invalidate","OFF"
"query_prealloc_size",8192
"range_alloc_block_size",4096
"read_buffer_size",262144
"read_only","OFF"
"read_rnd_buffer_size",524288
"relay_log","/rdsdbdata/log/relaylog/relaylog"
"relay_log_basename","/rdsdbdata/log/relaylog/relaylog"
"relay_log_index","/rdsdbdata/log/relaylog/relaylog.index"
"relay_log_info_file","relay-log.info"
"relay_log_info_repository","TABLE"
"relay_log_purge","ON"
"relay_log_recovery","ON"
"relay_log_space_limit",1000000000
"report_host",""
"report_password",""
"report_port",3306
"report_user",""
"require_fk_checks_for_ddl","OFF"
"rpl_stop_slave_timeout",31536000
"secure_auth","ON"
"secure_file_priv","/tmp/"
"server_audit_cw_upload","OFF"
"server_audit_events",""
"server_audit_excl_users",""
"server_audit_incl_users",""
"server_audit_logging","OFF"
"server_audit_mode",0
"server_audit_query_log_limit",1024
"server_id",1319298596
"server_id_bits",32
"server_uuid","d192bc27-8bae-3b30-bd8e-104cb49698c3"
"session_track_system_variables",""
"sha256_password_private_key_path","private_key.pem"
"sha256_password_public_key_path","public_key.pem"
"skip_external_locking","ON"
"skip_name_resolve","ON"
"skip_networking","OFF"
"skip_show_database","OFF"
"slave_allow_batching","OFF"
"slave_checkpoint_group",512
"slave_checkpoint_period",300
"slave_compressed_protocol","OFF"
"slave_exec_mode","STRICT"
"slave_load_tmpdir","/rdsdbdata/tmp/"
"slave_max_allowed_packet",1073741824
"slave_net_timeout",3600
"slave_parallel_workers",0
"slave_pending_jobs_size_max",16777216
"slave_rows_search_algorithms","TABLE_SCAN,INDEX_SCAN"
"slave_skip_errors","OFF"
"slave_sql_verify_checksum","ON"
"slave_transaction_retries",10
"slave_type_conversions",""
"slow_launch_time",2
"slow_query_log","ON"
"slow_query_log_file","/rdsdbdata/log/slowquery/mysql-slowquery.log"
"socket","/tmp/mysql.sock"
"sort_buffer_size",262144
"sql_auto_is_null","OFF"
"sql_big_selects","ON"
"sql_buffer_result","OFF"
"sql_log_bin","ON"
"sql_log_off","OFF"
"sql_mode",""
"sql_notes","ON"
"sql_quote_show_create","ON"
"sql_safe_updates","OFF"
"sql_select_limit",18446744073709551615
"sql_slave_skip_counter",0
"sql_warnings","OFF"
"ssl_ca","/rdsdbdata/rds-metadata/ca-cert.pem"
"ssl_capath",""
"ssl_cert","/rdsdbdata/rds-metadata/server-cert.pem"
"ssl_cipher","AES256-SHA:AES128-SHA:DES-CBC3-SHA:ADH-DES-CBC3-SHA:EDH-RSA-DES-CBC3-SHA:EDH-DSS-DES-CBC3-SHA:ADH-AES256-SHA:DHE-RSA-AES256-SHA:DHE-DSS-AES256-SHA:ADH-AES128-SHA:DHE-RSA-AES128-SHA:DHE-DSS-AES128-SHA:HIGH"
"ssl_crl",""
"ssl_crlpath",""
"ssl_key","/rdsdbdata/rds-metadata/server-key.pem"
"storage_engine","InnoDB"
"stored_program_cache",256
"sync_binlog",1
"sync_frm","ON"
"sync_master_info",10000
"sync_relay_log",10000
"sync_relay_log_info",10000
"system_time_zone","UTC"
"table_definition_cache",20000
"table_open_cache",6000
"table_open_cache_instances",4
"thread_cache_size",11
"thread_concurrency",10
"thread_handling","multiple-connections-per-thread"
"thread_stack",262144
"time_format","%H:%i:%s"
"time_zone","Australia/Sydney"
"timed_mutexes","OFF"
"tmp_table_size",16777216
"tmpdir","/rdsdbdata/tmp/"
"transaction_alloc_block_size",8192
"transaction_prealloc_size",4096
"tx_isolation","REPEATABLE-READ"
"tx_read_only","OFF"
"unique_checks","ON"
"updatable_views_with_limit","YES"
"user_disable_external_log","OFF"
"version","5.6.10-log"
"version_comment","MySQL Community Server (GPL)"
"version_compile_machine","x86_64"
"version_compile_os","Linux"
"wait_timeout",180

SHOW FULL PROCESSLIST;

+--------+-------------+----------------------+------------+---------+------+----------------------+-----------------------+
| Id     | User        | Host                 | db         | Command | Time | State                | Info                  |
+--------+-------------+----------------------+------------+---------+------+----------------------+-----------------------+
|     26 | rdsadmin    | localhost            | NULL       | Sleep   |    1 | cleaned up           | NULL                  |
|     33 | rdsadmin    | localhost            | NULL       | Sleep   |    0 | delayed send ok done | NULL                  |
|     34 | rdsadmin    | localhost            | NULL       | Sleep   |    1 | delayed send ok done | NULL                  |
|     35 | rdsadmin    | localhost            | NULL       | Sleep   |    8 | cleaned up           | NULL                  |
|     36 | rdsadmin    | localhost            | NULL       | Sleep   |    1 | cleaned up           | NULL                  |
| 190619 | user | xxx.206.131.43:54189 | as_staging | Sleep   |   65 | cleaned up           | NULL                  |
| 190620 | user | xxx.206.131.43:54196 | NULL       | Sleep   |   63 | cleaned up           | NULL                  |
| 190745 | root        | xxx.31.6.254:59992   | NULL       | Query   |    0 | init                 | SHOW FULL PROCESSLIST |
| 190772 | system user |                      | NULL       | Connect |    5 | Connecting to master | NULL                  |
| 190773 | system user |                      | NULL       | Connect |    0 | System lock          | NULL                  |
+--------+-------------+----------------------+------------+---------+------+----------------------+-----------------------+


SHOW ENGINE INNODB STATUS;

| InnoDB |      |
=====================================
2019-08-28 23:55:13 2b8111e81700 INNODB MONITOR OUTPUT
=====================================
Per second averages calculated from the last 42 seconds
-----------------
BACKGROUND THREAD
-----------------
srv_master_thread loops: 231089 srv_active, 0 srv_shutdown, 86791 srv_idle
srv_master_thread log flush and writes: 0
----------
SEMAPHORES
----------
OS WAIT ARRAY INFO: reservation count 258062
OS WAIT ARRAY INFO: signal count 278517
Mutex spin waits 517729, rounds 6131338, OS waits 201315
RW-shared spins 53639, rounds 176841, OS waits 3864
RW-excl spins 52448, rounds 1609998, OS waits 52547
Spin rounds per wait: 11.84 mutex, 3.30 RW-shared, 30.70 RW-excl
------------
TRANSACTIONS
------------
Trx id counter 9411951543
Purge done for trx's n:o < 9411947507 undo n:o < 0 state: running but idle
History list length 1560
LIST OF TRANSACTIONS FOR EACH SESSION:
---TRANSACTION 0, not started
MySQL thread id 185701, OS thread handle 0x2b8111e81700, query id 5253634 172.31.6.254 root init
SHOW ENGINE INNODB STATUS
---TRANSACTION 9411951536, not started
MySQL thread id 185703, OS thread handle 0x2b8111f44700, query id 0 System lock
---TRANSACTION 9406525599, not started
MySQL thread id 150708, OS thread handle 0x2b8111e81700, query id 5253619 203.206.131.43 agentselect cleaned up
---TRANSACTION 9406619692, not started
MySQL thread id 150706, OS thread handle 0x2b8012388700, query id 5253064 203.206.131.43 agentselect cleaned up
---TRANSACTION 9411948824, not started
MySQL thread id 33, OS thread handle 0x2b7fb2749700, query id 5253618 localhost rdsadmin delayed send ok done
---TRANSACTION 9411950606, not started
MySQL thread id 36, OS thread handle 0x2b7fb27cb700, query id 5253624 localhost rdsadmin cleaned up
---TRANSACTION 9411949047, not started
MySQL thread id 35, OS thread handle 0x2b8012243700, query id 5253538 localhost rdsadmin cleaned up
---TRANSACTION 9411951395, not started
MySQL thread id 34, OS thread handle 0x2b8012284700, query id 5253630 localhost rdsadmin delayed send ok done
--------
FILE I/O
--------
I/O thread 0 state: waiting for i/o request (insert buffer thread)
I/O thread 1 state: waiting for i/o request (log thread)
I/O thread 2 state: waiting for i/o request (read thread)
I/O thread 3 state: waiting for i/o request (read thread)
I/O thread 4 state: waiting for i/o request (read thread)
I/O thread 5 state: waiting for i/o request (read thread)
I/O thread 6 state: waiting for i/o request (write thread)
I/O thread 7 state: waiting for i/o request (write thread)
I/O thread 8 state: waiting for i/o request (write thread)
I/O thread 9 state: waiting for i/o request (write thread)
Pending normal aio reads: 0 [0, 0, 0, 0] , aio writes: 0 [0, 0, 0, 0] ,
 ibuf aio reads: 0, log i/o's: 0, sync i/o's: 0
Pending flushes (fsync) log: 0; buffer pool: 0
0 OS file reads, 0 OS file writes, 0 OS fsyncs
0.00 reads/s, 0 avg bytes/read, 0.00 writes/s, 0.00 fsyncs/s
-------------------------------------
INSERT BUFFER AND ADAPTIVE HASH INDEX
-------------------------------------
Ibuf: size 1, free list len 0, seg size 2, 0 merges
merged operations:
 insert 0, delete mark 0, delete 0
discarded operations:
 insert 0, delete mark 0, delete 0
Adaptive hash table 0: Hash table size 575987, node heap has 0 buffer(s)
Adaptive hash table 1: Hash table size 575987, node heap has 0 buffer(s)
Adaptive hash table 2: Hash table size 575987, node heap has 0 buffer(s)
Adaptive hash table 3: Hash table size 575987, node heap has 0 buffer(s)
Adaptive hash table 4: Hash table size 575987, node heap has 0 buffer(s)
Adaptive hash table 5: Hash table size 575987, node heap has 0 buffer(s)
Adaptive hash table 6: Hash table size 575987, node heap has 0 buffer(s)
Adaptive hash table 7: Hash table size 575987, node heap has 0 buffer(s)
Adaptive hash table 8: Hash table size 575987, node heap has 0 buffer(s)
Adaptive hash table 9: Hash table size 575987, node heap has 0 buffer(s)
Adaptive hash table 10: Hash table size 575987, node heap has 0 buffer(s)
Adaptive hash table 11: Hash table size 575987, node heap has 0 buffer(s)
Adaptive hash table 12: Hash table size 575987, node heap has 0 buffer(s)
Adaptive hash table 13: Hash table size 575987, node heap has 0 buffer(s)
Adaptive hash table 14: Hash table size 575987, node heap has 0 buffer(s)
Adaptive hash table 15: Hash table size 575987, node heap has 0 buffer(s)
Adaptive hash table 16: Hash table size 575987, node heap has 0 buffer(s)
Adaptive hash table 17: Hash table size 575987, node heap has 0 buffer(s)
Adaptive hash table 18: Hash table size 575987, node heap has 0 buffer(s)
Adaptive hash table 19: Hash table size 575987, node heap has 0 buffer(s)
Adaptive hash table 20: Hash table size 575987, node heap has 0 buffer(s)
Adaptive hash table 21: Hash table size 575987, node heap has 0 buffer(s)
Adaptive hash table 22: Hash table size 575987, node heap has 0 buffer(s)
Adaptive hash table 23: Hash table size 575987, node heap has 0 buffer(s)
Adaptive hash table 24: Hash table size 575987, node heap has 0 buffer(s)
Adaptive hash table 25: Hash table size 575987, node heap has 0 buffer(s)
Adaptive hash table 26: Hash table size 575987, node heap has 0 buffer(s)
Adaptive hash table 27: Hash table size 575987, node heap has 0 buffer(s)
Adaptive hash table 28: Hash table size 575987, node heap has 0 buffer(s)
Adaptive hash table 29: Hash table size 575987, node heap has 0 buffer(s)
Adaptive hash table 30: Hash table size 575987, node heap has 0 buffer(s)
Adaptive hash table 31: Hash table size 575987, node heap has 0 buffer(s)
0.00 hash searches/s, 13263.02 non-hash searches/s
---
LOG
---
Log sequence number 8204
Log flushed up to   8204
Pages flushed up to 8204
Last checkpoint at  8192
0 pending log writes, 0 pending chkp writes
0 log i/o's done, 0.00 log i/o's/second
----------------------
BUFFER POOL AND MEMORY
----------------------
Total memory allocated 0; in additional pool allocated 0
Dictionary memory allocated 5137827
Buffer pool size   510300
Free buffers       140859
Database pages     369441
Old database pages 136336
Modified db pages  0
Pending reads 0
Pending writes: LRU 0, flush list 0 single page 0
Pages made young 386427, not young 2300498
0.00 youngs/s, 0.00 non-youngs/s
Pages read 123023, created 249897, written 0
0.00 reads/s, 0.00 creates/s, 0.00 writes/s
Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000
Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
LRU len: 369441, unzip_LRU len: 0
I/O sum[0]:cur[0], unzip sum[0]:cur[0]
----------------------
INDIVIDUAL BUFFER POOL INFO
----------------------
---BUFFER POOL 0
Buffer pool size   255150
Free buffers       70463
Database pages     184687
Old database pages 68155
Modified db pages  0
Pending reads 0
Pending writes: LRU 0, flush list 0 single page 0
Pages made young 195312, not young 924002
0.00 youngs/s, 0.00 non-youngs/s
Pages read 61431, created 125004, written 0
0.00 reads/s, 0.00 creates/s, 0.00 writes/s
Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000
Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
LRU len: 184687, unzip_LRU len: 0
I/O sum[0]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 1
Buffer pool size   255150
Free buffers       70396
Database pages     184754
Old database pages 68181
Modified db pages  0
Pending reads 0
Pending writes: LRU 0, flush list 0 single page 0
Pages made young 191115, not young 1376496
0.00 youngs/s, 0.00 non-youngs/s
Pages read 61592, created 124893, written 0
0.00 reads/s, 0.00 creates/s, 0.00 writes/s
Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000
Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
LRU len: 184754, unzip_LRU len: 0
I/O sum[0]:cur[0], unzip sum[0]:cur[0]
--------------
ROW OPERATIONS
--------------
0 queries inside InnoDB, 0 queries in queue
0 read views open inside InnoDB
Main thread process no. 7112, id 47839233193728, state: sleeping
Number of rows inserted 7297410, updated 2681687, deleted 80307, read 10326786527
0.10 inserts/s, 7.71 updates/s, 0.00 deletes/s, 11921.93 reads/s
----------------------------
END OF INNODB MONITOR OUTPUT