Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- Variable_name,Value
- alter_algorithm,DEFAULT
- analyze_sample_percentage,100.000000
- aria_block_size,8192
- aria_checkpoint_interval,30
- aria_checkpoint_log_activity,1048576
- aria_encrypt_tables,OFF
- aria_force_start_after_recovery_failures,0
- aria_group_commit,none
- aria_group_commit_interval,0
- aria_log_file_size,1073741824
- aria_log_purge_type,immediate
- aria_max_sort_file_size,9223372036853727232
- aria_page_checksum,ON
- aria_pagecache_age_threshold,300
- aria_pagecache_buffer_size,134217728
- aria_pagecache_division_limit,100
- aria_pagecache_file_hash_size,512
- aria_recover_options,"BACKUP,QUICK"
- aria_repair_threads,1
- aria_sort_buffer_size,268434432
- aria_stats_method,nulls_unequal
- aria_sync_log_dir,NEWFILE
- aria_used_for_temp_tables,ON
- auto_increment_increment,1
- auto_increment_offset,1
- autocommit,ON
- automatic_sp_privileges,ON
- back_log,900
- basedir,/rdsdbbin/mysql/
- big_tables,OFF
- bind_address,
- binlog_annotate_row_events,ON
- binlog_cache_size,32768
- binlog_checksum,CRC32
- binlog_commit_wait_count,0
- binlog_commit_wait_usec,100000
- binlog_direct_non_transactional_updates,OFF
- binlog_expire_logs_seconds,0
- binlog_file_cache_size,16384
- binlog_format,MIXED
- binlog_optimize_thread_scheduling,ON
- binlog_row_image,FULL
- binlog_row_metadata,NO_LOG
- binlog_stmt_cache_size,32768
- bulk_insert_buffer_size,8388608
- character_set_client,utf8mb4
- character_set_connection,utf8mb4
- character_set_database,utf8mb3
- character_set_filesystem,binary
- character_set_results,utf8mb4
- character_set_server,latin1
- character_set_system,utf8mb3
- character_sets_dir,/rdsdbbin/mariadb-10.6.8.R1/share/charsets/
- check_constraint_checks,ON
- collation_connection,utf8mb4_general_ci
- collation_database,utf8mb3_general_ci
- collation_server,latin1_swedish_ci
- column_compression_threshold,100
- column_compression_zlib_level,6
- column_compression_zlib_strategy,DEFAULT_STRATEGY
- column_compression_zlib_wrap,OFF
- completion_type,NO_CHAIN
- concurrent_insert,AUTO
- connect_timeout,7200
- core_file,OFF
- datadir,/rdsdbdata/db/
- date_format,%Y-%m-%d
- datetime_format,"%Y-%m-%d %H:%i:%s"
- deadlock_search_depth_long,15
- deadlock_search_depth_short,4
- deadlock_timeout_long,7200
- deadlock_timeout_short,10000
- debug_no_thread_alarm,OFF
- default_master_connection,
- default_password_lifetime,0
- default_regex_flags,
- default_storage_engine,InnoDB
- default_tmp_storage_engine,
- default_week_format,0
- delay_key_write,ON
- delayed_insert_limit,100
- delayed_insert_timeout,300
- delayed_queue_size,1000
- disconnect_on_expired_password,OFF
- div_precision_increment,4
- encrypt_binlog,OFF
- encrypt_tmp_disk_tables,OFF
- encrypt_tmp_files,OFF
- enforce_storage_engine,
- eq_range_index_dive_limit,200
- error_count,0
- event_scheduler,OFF
- expensive_subquery_limit,100
- expire_logs_days,0.000000
- explicit_defaults_for_timestamp,OFF
- external_user,
- extra_max_connections,1
- extra_port,0
- 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,1048576
- gtid_binlog_pos,0-826979191-96027912425
- gtid_binlog_state,"0-303926702-43783454745,0-1428645245-91797308607,0-826979191-96027912425"
- gtid_cleanup_batch_size,64
- gtid_current_pos,0-826979191-96027912425
- gtid_domain_id,0
- gtid_ignore_duplicates,OFF
- gtid_pos_auto_engines,
- gtid_seq_no,0
- gtid_slave_pos,
- gtid_strict_mode,OFF
- 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
- histogram_size,254
- histogram_type,DOUBLE_PREC_HB
- host_cache_size,1403
- hostname,ip-172-27-0-219
- identity,0
- idle_readonly_transaction_timeout,1800
- idle_transaction_timeout,1800
- idle_write_transaction_timeout,1800
- ignore_builtin_innodb,OFF
- ignore_db_dirs,#rocksdb
- in_predicate_conversion_threshold,1000
- in_transaction,0
- init_connect,
- init_file,
- init_slave,
- innodb_adaptive_flushing,ON
- innodb_adaptive_flushing_lwm,10.000000
- innodb_adaptive_hash_index,OFF
- innodb_adaptive_hash_index_parts,8
- innodb_autoextend_increment,64
- innodb_autoinc_lock_mode,1
- innodb_buf_dump_status_frequency,0
- innodb_buffer_pool_chunk_size,134217728
- innodb_buffer_pool_dump_at_shutdown,ON
- innodb_buffer_pool_dump_now,OFF
- innodb_buffer_pool_dump_pct,25
- innodb_buffer_pool_filename,ib_buffer_pool
- innodb_buffer_pool_load_abort,OFF
- innodb_buffer_pool_load_at_startup,ON
- innodb_buffer_pool_load_now,OFF
- innodb_buffer_pool_size,197568495616
- innodb_change_buffer_max_size,25
- innodb_change_buffering,none
- innodb_checksum_algorithm,full_crc32
- innodb_cmp_per_index_enabled,OFF
- innodb_compression_algorithm,zlib
- innodb_compression_default,OFF
- innodb_compression_failure_threshold_pct,5
- innodb_compression_level,6
- innodb_compression_pad_pct_max,50
- innodb_data_file_path,ibdata1:12M:autoextend
- innodb_data_home_dir,/rdsdbdata/db/innodb
- innodb_deadlock_detect,ON
- innodb_deadlock_report,full
- innodb_default_encryption_key_id,1
- innodb_default_row_format,dynamic
- innodb_defragment,OFF
- innodb_defragment_fill_factor,0.900000
- innodb_defragment_fill_factor_n_recs,20
- innodb_defragment_frequency,40
- innodb_defragment_n_pages,7
- innodb_defragment_stats_accuracy,0
- innodb_disable_sort_file_cache,OFF
- innodb_doublewrite,ON
- innodb_encrypt_log,OFF
- innodb_encrypt_tables,OFF
- innodb_encrypt_temporary_tables,OFF
- innodb_encryption_rotate_key_age,1
- innodb_encryption_rotation_iops,100
- innodb_encryption_threads,0
- innodb_fast_shutdown,1
- innodb_fatal_semaphore_wait_threshold,600
- innodb_file_per_table,ON
- innodb_fill_factor,100
- innodb_flush_log_at_timeout,1
- innodb_flush_log_at_trx_commit,0
- innodb_flush_method,O_DIRECT
- innodb_flush_neighbors,0
- innodb_flush_sync,ON
- innodb_flushing_avg_loops,30
- innodb_force_primary_key,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_immediate_scrub_data_uncompressed,OFF
- innodb_instant_alter_column_allowed,add_drop_reorder
- innodb_io_capacity,2000
- innodb_io_capacity_max,4000
- innodb_lock_wait_timeout,7200
- innodb_log_buffer_size,33554432
- innodb_log_file_size,17179869184
- innodb_log_group_home_dir,/rdsdbdata/log/innodb
- innodb_log_write_ahead_size,8192
- innodb_lru_flush_size,32
- innodb_lru_scan_depth,1536
- innodb_max_dirty_pages_pct,95.000000
- innodb_max_dirty_pages_pct_lwm,0.000000
- innodb_max_purge_lag,0
- innodb_max_purge_lag_delay,0
- innodb_max_purge_lag_wait,4294967295
- innodb_max_undo_log_size,10485760
- innodb_monitor_disable,
- innodb_monitor_enable,
- innodb_monitor_reset,
- innodb_monitor_reset_all,
- innodb_numa_interleave,OFF
- 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_prefix_index_cluster_optimization,OFF
- innodb_print_all_deadlocks,OFF
- innodb_purge_batch_size,300
- innodb_purge_rseg_truncate_frequency,128
- innodb_purge_threads,4
- innodb_random_read_ahead,OFF
- innodb_read_ahead_threshold,56
- innodb_read_io_threads,8
- innodb_read_only,OFF
- innodb_read_only_compressed,OFF
- innodb_rollback_on_timeout,OFF
- innodb_sort_buffer_size,1048576
- innodb_spin_wait_delay,4
- innodb_stats_auto_recalc,ON
- innodb_stats_include_delete_marked,OFF
- innodb_stats_method,nulls_equal
- innodb_stats_modified_counter,0
- innodb_stats_on_metadata,OFF
- innodb_stats_persistent,ON
- innodb_stats_persistent_sample_pages,20
- innodb_stats_traditional,ON
- innodb_stats_transient_sample_pages,8
- innodb_status_output,OFF
- innodb_status_output_locks,OFF
- innodb_strict_mode,OFF
- innodb_sync_spin_loops,30
- innodb_table_locks,ON
- innodb_temp_data_file_path,ibtmp1:12M:autoextend
- innodb_tmpdir,
- innodb_undo_directory,./
- innodb_undo_log_truncate,OFF
- innodb_undo_tablespaces,0
- innodb_use_atomic_writes,ON
- innodb_use_native_aio,ON
- innodb_version,10.6.8
- innodb_write_io_threads,8
- insert_id,0
- interactive_timeout,7200
- join_buffer_size,262144
- join_buffer_space_limit,2097152
- join_cache_level,2
- keep_files_on_create,OFF
- key_buffer_size,16777216
- key_cache_age_threshold,300
- key_cache_block_size,1024
- key_cache_division_limit,100
- key_cache_file_hash_size,512
- key_cache_segments,0
- large_files_support,ON
- large_page_size,0
- large_pages,OFF
- last_gtid,
- last_insert_id,0
- lc_messages,en_US
- lc_messages_dir,
- lc_time_names,en_US
- license,GPL
- local_infile,ON
- lock_wait_timeout,7200
- locked_in_memory,OFF
- log_bin,ON
- log_bin_basename,/rdsdbdata/log/binlog/mysql-bin-changelog
- log_bin_compress,OFF
- log_bin_compress_min_len,256
- log_bin_index,/rdsdbdata/log/binlog/mysql-bin-changelog.index
- log_bin_trust_function_creators,ON
- log_disabled_statements,sp
- log_error,/rdsdbdata/log/error/mysql-error.log
- log_output,FILE
- log_queries_not_using_indexes,OFF
- log_slave_updates,ON
- log_slow_admin_statements,ON
- log_slow_disabled_statements,sp
- log_slow_filter,"admin,filesort,filesort_on_disk,filesort_priority_queue,full_join,full_scan,query_cache,query_cache_miss,tmp_table,tmp_table_on_disk"
- log_slow_rate_limit,1
- log_slow_slave_statements,ON
- log_slow_verbosity,"innodb,query_plan,explain"
- log_tc_size,24576
- log_warnings,2
- long_query_time,10.000000
- low_priority_updates,OFF
- lower_case_file_system,OFF
- lower_case_table_names,0
- master_verify_checksum,OFF
- max_allowed_packet,268435456
- max_binlog_cache_size,18446744073709547520
- max_binlog_size,134217728
- max_binlog_stmt_cache_size,18446744073709547520
- max_connect_errors,100
- max_connections,16000
- max_delayed_threads,20
- max_digest_length,1024
- max_error_count,64
- max_heap_table_size,423054278656
- max_insert_delayed_threads,20
- max_join_size,18446744073709551615
- max_length_for_sort_data,1024
- max_password_errors,4294967295
- max_prepared_stmt_count,16382
- max_recursive_iterations,1000
- max_relay_log_size,134217728
- max_rowid_filter_size,131072
- max_seeks_for_key,4294967295
- max_session_mem_used,9223372036854775807
- max_sort_length,1024
- max_sp_recursion_depth,0
- max_statement_time,7200.000000
- max_tmp_tables,32
- max_user_connections,0
- max_write_lock_count,4294967295
- metadata_locks_cache_size,1024
- metadata_locks_hash_instances,8
- min_examined_row_limit,0
- mrr_buffer_size,262144
- myisam_block_size,1024
- myisam_data_pointer_size,6
- myisam_max_sort_file_size,9223372036853727232
- myisam_mmap_size,18446744073709551615
- myisam_recover_options,"BACKUP,QUICK"
- myisam_repair_threads,1
- myisam_sort_buffer_size,134216704
- myisam_stats_method,NULLS_UNEQUAL
- myisam_use_mmap,OFF
- mysql56_temporal_format,ON
- net_buffer_length,16384
- net_read_timeout,120
- net_retry_count,10
- net_write_timeout,120
- old,OFF
- old_alter_table,DEFAULT
- old_mode,UTF8_IS_UTF8MB3
- old_passwords,OFF
- open_files_limit,112095
- optimizer_max_sel_arg_weight,32000
- optimizer_prune_level,1
- optimizer_search_depth,62
- optimizer_selectivity_sampling_limit,100
- optimizer_switch,"index_merge=on,index_merge_union=on,index_merge_sort_union=on,index_merge_intersection=on,index_merge_sort_intersection=off,engine_condition_pushdown=off,index_condition_pushdown=on,derived_merge=on,derived_with_keys=on,firstmatch=on,loosescan=on,materialization=on,in_to_exists=on,semijoin=on,partial_match_rowid_merge=on,partial_match_table_scan=on,subquery_cache=on,mrr=off,mrr_cost_based=off,mrr_sort_keys=off,outer_join_with_cache=on,semijoin_with_cache=on,join_cache_incremental=on,join_cache_hashed=on,join_cache_bka=on,optimize_join_buffer_size=on,table_elimination=on,extended_keys=on,exists_to_in=on,orderby_uses_equalities=on,condition_pushdown_for_derived=on,split_materialized=on,condition_pushdown_for_subquery=on,rowid_filter=on,condition_pushdown_from_having=on,not_null_range_scan=off"
- optimizer_trace,enabled=off
- optimizer_trace_max_mem_size,1048576
- optimizer_use_condition_selectivity,4
- performance_schema,ON
- performance_schema_accounts_size,-1
- 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_transactions_history_long_size,10000
- performance_schema_events_transactions_history_size,10
- performance_schema_events_waits_history_long_size,10000
- performance_schema_events_waits_history_size,10
- performance_schema_hosts_size,-1
- performance_schema_max_cond_classes,90
- performance_schema_max_cond_instances,-1
- performance_schema_max_digest_length,1024
- performance_schema_max_file_classes,80
- performance_schema_max_file_handles,32768
- performance_schema_max_file_instances,-1
- performance_schema_max_index_stat,-1
- performance_schema_max_memory_classes,320
- performance_schema_max_metadata_locks,-1
- performance_schema_max_mutex_classes,210
- performance_schema_max_mutex_instances,-1
- performance_schema_max_prepared_statements_instances,-1
- performance_schema_max_program_instances,-1
- performance_schema_max_rwlock_classes,50
- performance_schema_max_rwlock_instances,-1
- performance_schema_max_socket_classes,10
- performance_schema_max_socket_instances,-1
- performance_schema_max_sql_text_length,1024
- performance_schema_max_stage_classes,160
- performance_schema_max_statement_classes,222
- performance_schema_max_statement_stack,10
- performance_schema_max_table_handles,-1
- performance_schema_max_table_instances,-1
- performance_schema_max_table_lock_stat,-1
- performance_schema_max_thread_classes,50
- performance_schema_max_thread_instances,-1
- performance_schema_session_connect_attrs_size,512
- performance_schema_setup_actors_size,-1
- performance_schema_setup_objects_size,-1
- performance_schema_users_size,-1
- pid_file,/rdsdbdata/log/mysql-3306.pid
- plugin_dir,/rdsdbbin/mariadb-10.6.8.R1/lib/plugin/
- plugin_maturity,gamma
- port,3306
- preload_buffer_size,32768
- profiling,OFF
- profiling_history_size,15
- progress_report_time,5
- protocol_version,10
- proxy_protocol_networks,
- proxy_user,
- pseudo_slave_mode,OFF
- pseudo_thread_id,989214
- query_alloc_block_size,16384
- query_cache_limit,0
- query_cache_min_res_unit,4096
- query_cache_size,0
- query_cache_strip_comments,OFF
- query_cache_type,OFF
- query_cache_wlock_invalidate,OFF
- query_prealloc_size,24576
- rand_seed1,907258234
- rand_seed2,30352913
- range_alloc_block_size,4096
- read_binlog_speed_limit,0
- 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_purge,ON
- relay_log_recovery,ON
- relay_log_space_limit,0
- replicate_annotate_row_events,ON
- replicate_do_db,
- replicate_do_table,
- replicate_events_marked_for_skip,REPLICATE
- replicate_ignore_db,
- replicate_ignore_table,"mysql.rds_sysinfo,mysql.rds_configuration,mysql.rds_replication_status,mysql.rds_history"
- replicate_wild_do_table,
- replicate_wild_ignore_table,
- report_host,
- report_password,
- report_port,3306
- report_user,
- require_secure_transport,OFF
- rocksdb_access_hint_on_compaction_start,1
- rocksdb_advise_random_on_open,ON
- rocksdb_allow_concurrent_memtable_write,OFF
- rocksdb_allow_mmap_reads,OFF
- rocksdb_allow_mmap_writes,OFF
- rocksdb_allow_to_start_after_corruption,OFF
- rocksdb_blind_delete_primary_key,OFF
- rocksdb_block_cache_size,536870912
- rocksdb_block_restart_interval,16
- rocksdb_block_size,4096
- rocksdb_block_size_deviation,10
- rocksdb_bulk_load,OFF
- rocksdb_bulk_load_allow_sk,OFF
- rocksdb_bulk_load_allow_unsorted,OFF
- rocksdb_bulk_load_size,1000
- rocksdb_bytes_per_sync,0
- rocksdb_cache_dump,ON
- rocksdb_cache_high_pri_pool_ratio,0.000000
- rocksdb_cache_index_and_filter_blocks,ON
- rocksdb_cache_index_and_filter_with_high_priority,ON
- rocksdb_checksums_pct,100
- rocksdb_collect_sst_properties,ON
- rocksdb_commit_in_the_middle,OFF
- rocksdb_commit_time_batch_for_recovery,ON
- rocksdb_compact_cf,
- rocksdb_compaction_readahead_size,0
- rocksdb_compaction_sequential_deletes,0
- rocksdb_compaction_sequential_deletes_count_sd,OFF
- rocksdb_compaction_sequential_deletes_file_size,0
- rocksdb_compaction_sequential_deletes_window,0
- rocksdb_create_checkpoint,
- rocksdb_create_if_missing,ON
- rocksdb_create_missing_column_families,OFF
- rocksdb_datadir,./#rocksdb
- rocksdb_db_write_buffer_size,0
- rocksdb_deadlock_detect,OFF
- rocksdb_deadlock_detect_depth,50
- rocksdb_debug_manual_compaction_delay,0
- rocksdb_debug_optimizer_no_zero_cardinality,ON
- rocksdb_debug_ttl_ignore_pk,OFF
- rocksdb_debug_ttl_read_filter_ts,0
- rocksdb_debug_ttl_rec_ts,0
- rocksdb_debug_ttl_snapshot_ts,0
- rocksdb_default_cf_options,
- rocksdb_delayed_write_rate,0
- rocksdb_delete_cf,
- rocksdb_delete_obsolete_files_period_micros,21600000000
- rocksdb_enable_2pc,ON
- rocksdb_enable_bulk_load_api,ON
- rocksdb_enable_insert_with_update_caching,ON
- rocksdb_enable_thread_tracking,ON
- rocksdb_enable_ttl,ON
- rocksdb_enable_ttl_read_filtering,ON
- rocksdb_enable_write_thread_adaptive_yield,OFF
- rocksdb_error_if_exists,OFF
- rocksdb_error_on_suboptimal_collation,ON
- rocksdb_flush_log_at_trx_commit,1
- rocksdb_force_compute_memtable_stats,ON
- rocksdb_force_compute_memtable_stats_cachetime,60000000
- rocksdb_force_flush_memtable_and_lzero_now,OFF
- rocksdb_force_flush_memtable_now,OFF
- rocksdb_force_index_records_in_range,0
- rocksdb_git_hash,
- rocksdb_hash_index_allow_collision,ON
- rocksdb_ignore_datadic_errors,0
- rocksdb_ignore_unknown_options,ON
- rocksdb_index_type,kBinarySearch
- rocksdb_info_log_level,error_level
- rocksdb_io_write_timeout,0
- rocksdb_is_fd_close_on_exec,ON
- rocksdb_keep_log_file_num,10
- rocksdb_large_prefix,OFF
- rocksdb_lock_scanned_rows,OFF
- rocksdb_lock_wait_timeout,1
- rocksdb_log_dir,/rdsdbdata/log/error_rocksdb
- rocksdb_log_file_time_to_roll,60
- rocksdb_manifest_preallocation_size,4194304
- rocksdb_manual_compaction_threads,0
- rocksdb_manual_wal_flush,ON
- rocksdb_master_skip_tx_api,OFF
- rocksdb_max_background_jobs,2
- rocksdb_max_latest_deadlocks,5
- rocksdb_max_log_file_size,104857600
- rocksdb_max_manifest_file_size,1073741824
- rocksdb_max_manual_compactions,10
- rocksdb_max_open_files,56047
- rocksdb_max_row_locks,1048576
- rocksdb_max_subcompactions,1
- rocksdb_max_total_wal_size,0
- rocksdb_merge_buf_size,67108864
- rocksdb_merge_combine_read_size,1073741824
- rocksdb_merge_tmp_file_removal_delay_ms,0
- rocksdb_new_table_reader_for_compaction_inputs,OFF
- rocksdb_no_block_cache,OFF
- rocksdb_override_cf_options,
- rocksdb_paranoid_checks,ON
- rocksdb_pause_background_work,OFF
- rocksdb_perf_context_level,0
- rocksdb_persistent_cache_path,
- rocksdb_persistent_cache_size_mb,0
- rocksdb_pin_l0_filter_and_index_blocks_in_cache,ON
- rocksdb_print_snapshot_conflict_queries,OFF
- rocksdb_rate_limiter_bytes_per_sec,0
- rocksdb_records_in_range,0
- rocksdb_remove_mariabackup_checkpoint,OFF
- rocksdb_reset_stats,OFF
- rocksdb_rollback_on_timeout,OFF
- rocksdb_seconds_between_stat_computes,3600
- rocksdb_signal_drop_index_thread,OFF
- rocksdb_sim_cache_size,0
- rocksdb_skip_bloom_filter_on_read,OFF
- rocksdb_skip_fill_cache,OFF
- rocksdb_skip_unique_check_tables,.*
- rocksdb_sst_mgr_rate_bytes_per_sec,0
- rocksdb_stats_dump_period_sec,600
- rocksdb_stats_level,0
- rocksdb_stats_recalc_rate,0
- rocksdb_store_row_debug_checksums,OFF
- rocksdb_strict_collation_check,ON
- rocksdb_strict_collation_exceptions,
- rocksdb_supported_compression_types,Zlib
- rocksdb_table_cache_numshardbits,6
- rocksdb_table_stats_sampling_pct,10
- rocksdb_tmpdir,/rdsdbdata/tmp
- rocksdb_trace_sst_api,OFF
- rocksdb_two_write_queues,ON
- rocksdb_unsafe_for_binlog,OFF
- rocksdb_update_cf_options,
- rocksdb_use_adaptive_mutex,OFF
- rocksdb_use_clock_cache,OFF
- rocksdb_use_direct_io_for_flush_and_compaction,OFF
- rocksdb_use_direct_reads,OFF
- rocksdb_use_fsync,OFF
- rocksdb_validate_tables,1
- rocksdb_verify_row_debug_checksums,OFF
- rocksdb_wal_bytes_per_sync,0
- rocksdb_wal_dir,/rdsdbdata/log/rocksdb
- rocksdb_wal_recovery_mode,1
- rocksdb_wal_size_limit_mb,0
- rocksdb_wal_ttl_seconds,0
- rocksdb_whole_key_filtering,ON
- rocksdb_write_batch_max_bytes,0
- rocksdb_write_disable_wal,OFF
- rocksdb_write_ignore_missing_column_families,OFF
- rocksdb_write_policy,write_committed
- rowid_merge_buff_size,8388608
- rpl_semi_sync_master_enabled,OFF
- rpl_semi_sync_master_timeout,10000
- rpl_semi_sync_master_trace_level,32
- rpl_semi_sync_master_wait_no_slave,ON
- rpl_semi_sync_master_wait_point,AFTER_COMMIT
- rpl_semi_sync_slave_delay_master,OFF
- rpl_semi_sync_slave_enabled,OFF
- rpl_semi_sync_slave_kill_conn_timeout,5
- rpl_semi_sync_slave_trace_level,32
- secure_auth,ON
- secure_file_priv,/secure_file_priv_dir/
- secure_timestamp,NO
- server_id,826979191
- session_track_schema,ON
- session_track_state_change,OFF
- session_track_system_variables,"autocommit,character_set_client,character_set_connection,character_set_results,time_zone"
- session_track_transaction_info,OFF
- skip_external_locking,ON
- skip_name_resolve,ON
- skip_networking,OFF
- skip_parallel_replication,OFF
- skip_replication,OFF
- skip_show_database,OFF
- slave_compressed_protocol,OFF
- slave_ddl_exec_mode,IDEMPOTENT
- slave_domain_parallel_threads,0
- slave_exec_mode,STRICT
- slave_load_tmpdir,/rdsdbdata/tmp
- slave_max_allowed_packet,1073741824
- slave_net_timeout,60
- slave_parallel_max_queued,131072
- slave_parallel_mode,optimistic
- slave_parallel_threads,0
- slave_parallel_workers,0
- slave_run_triggers_for_rbr,NO
- slave_skip_errors,OFF
- slave_sql_verify_checksum,ON
- slave_transaction_retries,10
- slave_transaction_retry_errors,"1158,1159,1160,1161,1205,1213,1429,2013,12701"
- slave_transaction_retry_interval,0
- 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,2097152
- sql_auto_is_null,OFF
- sql_big_selects,ON
- sql_buffer_result,OFF
- sql_if_exists,OFF
- sql_log_bin,ON
- sql_log_off,OFF
- sql_mode,NO_ENGINE_SUBSTITUTION
- 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,ECDHE-RSA-AES256-GCM-SHA384:ECDHE-RSA-AES128-GCM-SHA256:ECDHE-RSA-AES256-SHA384:ECDHE-RSA-AES128-SHA256:ECDHE-RSA-AES256-SHA:ECDHE-RSA-AES128-SHA:AES256-GCM-SHA384:AES128-GCM-SHA256:AES256-SHA:AES128-SHA:DHE-RSA-AES128-SHA:DHE-RSA-AES256-SHA:DHE-DSS-AES128-SHA:DHE-DSS-AES256-SHA
- ssl_crl,
- ssl_crlpath,
- ssl_key,/rdsdbdata/rds-metadata/server-key.pem
- standard_compliant_cte,ON
- storage_engine,InnoDB
- stored_program_cache,256
- strict_password_validation,ON
- sync_binlog,0
- sync_frm,ON
- sync_master_info,10000
- sync_relay_log,10000
- sync_relay_log_info,10000
- system_time_zone,UTC
- system_versioning_alter_history,ERROR
- system_versioning_asof,DEFAULT
- table_definition_cache,400
- table_open_cache,6000
- table_open_cache_instances,8
- tcp_keepalive_interval,0
- tcp_keepalive_probes,0
- tcp_keepalive_time,0
- tcp_nodelay,ON
- thread_cache_size,256
- thread_handling,one-thread-per-connection
- thread_pool_dedicated_listener,OFF
- thread_pool_exact_stats,OFF
- thread_pool_idle_timeout,60
- thread_pool_max_threads,65536
- thread_pool_oversubscribe,3
- thread_pool_prio_kickup_timer,1000
- thread_pool_priority,auto
- thread_pool_size,64
- thread_pool_stall_limit,500
- thread_stack,262144
- time_format,%H:%i:%s
- time_zone,UTC
- timestamp,1661342169.921250
- tls_version,"TLSv1.1,TLSv1.2,TLSv1.3"
- tmp_disk_table_size,18446744073709551615
- tmp_memory_table_size,134217728
- tmp_table_size,134217728
- tmpdir,/rdsdbdata/tmp
- transaction_alloc_block_size,8192
- transaction_prealloc_size,4096
- tx_isolation,READ-COMMITTED
- tx_read_only,OFF
- unique_checks,ON
- updatable_views_with_limit,YES
- use_stat_tables,PREFERABLY_FOR_QUERIES
- userstat,ON
- version,10.6.8-MariaDB-log
- version_comment,"managed by https://aws.amazon.com/rds/"
- version_compile_machine,x86_64
- version_compile_os,Linux
- version_malloc_library,"jemalloc 0.0.0-0-g0000000000000000000000000000000000000000"
- version_source_revision,
- version_ssl_library,"OpenSSL 1.1.1o 3 May 2022"
- wait_timeout,7200
- warning_count,0
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement