[ { "name": "[mysqld]\n" }, { "name": "activate_all_roles_on_login", "value": "'0'\n" }, { "name": "basedir", "value": "'/rdsdbbin/mysql'\n" }, { "name": "big_tables", "value": "'0'\n" }, { "name": "bind_address", "value": "'*'\n" }, { "name": "binlog_cache_size", "value": "'32768'\n" }, { "name": "binlog_direct_non_transactional_updates", "value": "'0'\n" }, { "name": "binlog_expire_logs_seconds", "value": "'2592000'\n" }, { "name": "binlog_format", "value": "'ROW'\n" }, { "name": "binlog_row_metadata", "value": "'MINIMAL'\n" }, { "name": "auto_generate_certs", "value": "'1'\n" }, { "name": "caching_sha2_password_private_key_path", "value": "'private_key.pem'\n" }, { "name": "caching_sha2_password_public_key_path", "value": "'public_key.pem'\n" }, { "name": "cte_max_recursion_depth", "value": "'1000'\n" }, { "name": "datadir", "value": "'/rdsdbdata/db/'\n" }, { "name": "default_authentication_plugin", "value": "'mysql_native_password'\n" }, { "name": "default_password_lifetime", "value": "'0'\n" }, { "name": "default_storage_engine", "value": "'InnoDB'\n" }, { "name": "event-scheduler", "value": "'ON'\n" }, { "name": "binlog_expire_logs_seconds", "value": "'2592000'\n" }, { "name": "explicit_defaults_for_timestamp\n" }, { "name": "general-log", "value": "'1'\n" }, { "name": "general-log-file", "value": "'/rdsdbdata/log/general/mysql-general.log'\n" }, { "name": "gtid_mode", "value": "'0'\n" }, { "name": "gtid-mode", "value": "'OFF_PERMISSIVE'\n" }, { "name": "histogram_generation_max_mem_size", "value": "'20000000'\n" }, { "name": "information_schema_stats_expiry", "value": "'86400'\n" }, { "name": "innodb_buffer_pool_size", "value": "'49392123904'\n" }, { "name": "innodb_data_file_path", "value": "'ibdata1:12M:autoextend'\n" }, { "name": "innodb-data-home-dir", "value": "'/rdsdbdata/db/innodb'\n" }, { "name": "innodb_doublewrite", "value": "'1'\n" }, { "name": "innodb_doublewrite_batch_size", "value": "'16'\n" }, { "name": "innodb_doublewrite_pages", "value": "'32'\n" }, { "name": "innodb-file-per-table", "value": "'1'\n" }, { "name": "innodb-flush-method", "value": "'O_DIRECT'\n" }, { "name": "innodb_force_recovery", "value": "'0'\n" }, { "name": "innodb_log_buffer_size", "value": "'8388608'\n" }, { "name": "innodb_log_files_in_group", "value": "'2'\n" }, { "name": "innodb_log_file_size", "value": "'134217728'\n" }, { "name": "innodb-log-group-home-dir", "value": "'/rdsdbdata/log/innodb'\n" }, { "name": "innodb_log_spin_cpu_abs_lwm", "value": "'80'\n" }, { "name": "innodb_log_spin_cpu_pct_hwm", "value": "'50'\n" }, { "name": "innodb_log_wait_for_flush_spin_hwm", "value": "'400'\n" }, { "name": "innodb_print_ddl_logs", "value": "'0'\n" }, { "name": "innodb_purge_threads", "value": "'1'\n" }, { "name": "innodb_redo_log_encrypt", "value": "'0'\n" }, { "name": "innodb_stats_include_delete_marked", "value": "'0'\n" }, { "name": "innodb_undo_log_encrypt", "value": "'0'\n" }, { "name": "internal_tmp_mem_storage_engine", "value": "'MEMORY'\n" }, { "name": "join_buffer_size", "value": "'262144'\n" }, { "name": "key_buffer_size", "value": "'524288'\n" }, { "name": "large_pages", "value": "'0'\n" }, { "name": "lc_messages", "value": "'en_US'\n" }, { "name": "lc_messages", "value": "'en_US'\n" }, { "name": "local-infile", "value": "'1'\n" }, { "name": "log_bin_trust_function_creators", "value": "'1'\n" }, { "name": "log-error", "value": "'/rdsdbdata/log/error/mysql-error.log'\n" }, { "name": "log_error_services", "value": "'log_filter_internal; log_sink_internal'\n" }, { "name": "log-output", "value": "'FILE'\n" }, { "name": "log_queries_not_using_indexes", "value": "'1'\n" }, { "name": "log-slave-updates", "value": "'1'\n" }, { "name": "log_statements_unsafe_for_binlog", "value": "'0'\n" }, { "name": "long_query_time", "value": "'2'\n" }, { "name": "master_info_repository", "value": "'TABLE'\n" }, { "name": "master-info-repository", "value": "'TABLE'\n" }, { "name": "max_allowed_packet", "value": "'1073741824'\n" }, { "name": "max_binlog_size", "value": "'134217728'\n" }, { "name": "max_connections", "value": "'10000'\n" }, { "name": "max_digest_length", "value": "'1024'\n" }, { "name": "max_relay_log_size", "value": "'0'\n" }, { "name": "myisam_repair_threads", "value": "'1'\n" }, { "name": "mysqlx_bind_address", "value": "'*'\n" }, { "name": "mysqlx_connect_timeout", "value": "'30'\n" }, { "name": "mysqlx_document_id_unique_prefix", "value": "'0'\n" }, { "name": "mysqlx_idle_worker_thread_timeout", "value": "'60'\n" }, { "name": "mysqlx_interactive_timeout", "value": "'28800'\n" }, { "name": "mysqlx_max_allowed_packet", "value": "'1048576'\n" }, { "name": "mysqlx_max_connections", "value": "'100'\n" }, { "name": "mysqlx_min_worker_threads", "value": "'2'\n" }, { "name": "mysqlx_port", "value": "'33060'\n" }, { "name": "mysqlx_port_open_timeout", "value": "'0'\n" }, { "name": "mysqlx_read_timeout", "value": "'28800'\n" }, { "name": "mysqlx_socket", "value": "'/tmp/mysqlx.sock'\n" }, { "name": "mysqlx_interactive_timeout", "value": "'28800'\n" }, { "name": "mysqlx_write_timeout", "value": "'60'\n" }, { "name": "concurrent_insert", "value": "'AUTO'\n" }, { "name": "old_alter_table", "value": "'0'\n" }, { "name": "open_files_limit", "value": "'5000'\n" }, { "name": "optimizer_switch", "value": "'mrr_cost_based=off'\n" }, { "name": "parser_max_mem_size", "value": "'18446744073709551615'\n" }, { "name": "password_history", "value": "'0'\n" }, { "name": "password_reuse_interval", "value": "'0'\n" }, { "name": "persisted_globals_load", "value": "'0'\n" }, { "name": "pid-file", "value": "'/rdsdbdata/log/mysql-3306.pid'\n" }, { "name": "port", "value": "'3306'\n" }, { "name": "read_buffer_size", "value": "'262144'\n" }, { "name": "read_only", "value": "'0'\n" }, { "name": "read_rnd_buffer_size", "value": "'262144'\n" }, { "name": "regexp_stack_limit", "value": "'8000000'\n" }, { "name": "regexp_time_limit", "value": "'32'\n" }, { "name": "relay-log", "value": "'/rdsdbdata/log/relaylog/relaylog'\n" }, { "name": "relay_log_info_file", "value": "'relay-log.info'\n" }, { "name": "relay-log-info-repository", "value": "'TABLE'\n" }, { "name": "relay_log_purge", "value": "'TRUE'\n" }, { "name": "relay_log_recovery", "value": "'1'\n" }, { "name": "relay_log_space_limit", "value": "'0'\n" }, { "name": "rpl_read_size", "value": "'8192'\n" }, { "name": "schema_definition_cache", "value": "'256'\n" }, { "name": "secure-file-priv", "value": "'/secure_file_priv_dir'\n" }, { "name": "server-id", "value": "'1909644957'\n" }, { "name": "sha256_password_private_key_path", "value": "'private_key.pem'\n" }, { "name": "sha256_password_public_key_path", "value": "'public_key.pem'\n" }, { "name": "show_create_table_verbosity", "value": "'0'\n" }, { "name": "skip-slave-start", "value": "'1'\n" }, { "name": "slave_exec_mode", "value": "'IDEMPOTENT'\n" }, { "name": "slave_load_tmpdir", "value": "'/tmp'\n" }, { "name": "slow-query-log", "value": "'1'\n" }, { "name": "slow_query_log_file", "value": "'/rdsdbdata/log/slowquery/mysql-slowquery.log'\n" }, { "name": "socket", "value": "'/tmp/mysql.sock'\n" }, { "name": "max_join_size", "value": "'18446744073709551615'\n" }, { "name": "sql-mode", "value": "'NO_ENGINE_SUBSTITUTION'\n" }, { "name": "ssl_fips_mode", "value": "'0'\n" }, { "name": "stored_program_definition_cache", "value": "'256'\n" }, { "name": "sync-binlog", "value": "'1'\n" }, { "name": "table_open_cache_instances", "value": "'16'\n" }, { "name": "tablespace_definition_cache", "value": "'256'\n" }, { "name": "temptable_max_ram", "value": "'1073741824'\n" }, { "name": "thread_handling", "value": "'one-thread-per-connection'\n" }, { "name": "thread_stack", "value": "'262144'\n" }, { "name": "tmpdir", "value": "'/rdsdbdata/tmp'\n" }, { "name": "transaction_isolation", "value": "'READ-COMMITTED'\n" }, { "name": "windowing_use_high_precision", "value": "'1'\n" }, { "name": "performance_schema", "value": "'1'\n" }, { "name": "performance-schema-consumer-global-instrumentation", "value": "'ON'\n" }, { "name": "performance-schema-consumer-thread-instrumentation", "value": "'ON'\n" }, { "name": "performance-schema-consumer-events-waits-current", "value": "'ON'\n" }, { "name": "performance-schema-instrument", "value": "'wait/%=ON'\n" }, { "name": "log-bin", "value": "'/rdsdbdata/log/binlog/mysql-bin-changelog'\n" }, { "name": "replicate-ignore-table", "value": "'innodb_memcache.cache_policies'\n" }, { "name": "replicate-ignore-table", "value": "'innodb_memcache.config_options'\n" }, { "name": "replicate-ignore-table", "value": "'mysql.plugin'\n" }, { "name": "replicate-ignore-table", "value": "'mysql.rds_monitor'\n" }, { "name": "replicate-ignore-table", "value": "'mysql.rds_configuration'\n" }, { "name": "replicate-ignore-table", "value": "'mysql.rds_history'\n" }, { "name": "replicate-ignore-table", "value": "'mysql.rds_replication_status'\n" }, { "name": "replicate-ignore-table", "value": "'mysql.rds_sysinfo'\n" }, { "name": "plugin-load-add=rds_processlist=rds_performance_insights.so;rds_events_threads_waits_current=rds_performance_insights.so\n" }, { "name": "rds_processlist=FORCE_PLUS_PERMANENT\n" }, { "name": "rds_events_threads_waits_current=FORCE_PLUS_PERMANENT\n" } ]