变量对照

Variable_name,Value "activate_all_roles_on_login","OFF" "admin_address","" "admin_port","33062" "admin_ssl_ca","" "admin_ssl_capath","" "admin_ssl_cert","" "admin_ssl_cipher","" "admin_ssl_crl","" "admin_ssl_crlpath","" "admin_ssl_key","" "admin_tls_ciphersuites","" "admin_tls_version","TLSv1,TLSv1.1,TLSv1.2,TLSv1.3" "async_binlog_recovery","ON" "authentication_policy",",," "auto_detect_certs","OFF" "auto_generate_certs","OFF" "auto_increment_increment","1" "auto_increment_key_high_priority","ON" "auto_increment_offset","1" "autocommit","ON" "automatic_sp_privileges","ON" "avoid_temporal_upgrade","OFF" "back_log","3000" "basedir","/u01/mysql/" "big_tables","OFF" "bind_address","" "binlog_buffer_size","20971520" "binlog_cache_free_flush","ON" "binlog_cache_free_flush_limit_size","268435456" "binlog_cache_size","1048576" "binlog_checksum","CRC32" "binlog_direct_non_transactional_updates","OFF" "binlog_encryption","OFF" "binlog_error_action","ABORT_SERVER" "binlog_expire_logs_auto_purge","ON" "binlog_expire_logs_seconds","2592000" "binlog_format","ROW" "binlog_group_commit_sync_delay","0" "binlog_group_commit_sync_no_delay_count","0" "binlog_group_delay","100" "binlog_group_delay_running_threads","100" "binlog_gtid_simple_recovery","ON" "binlog_max_flush_queue_time","0" "binlog_order_commits","OFF" "binlog_parallel_flush","OFF" "binlog_rotate_encryption_master_key_at_startup","OFF" "binlog_row_event_max_size","8192" "binlog_row_image","FULL" "binlog_row_metadata","MINIMAL" "binlog_row_value_options","" "binlog_rows_query_log_events","OFF" "binlog_stmt_cache_size","32768" "binlog_transaction_compression","OFF" "binlog_transaction_compression_level_zstd","3" "binlog_transaction_dependency_history_size","500000" "binlog_transaction_dependency_tracking","WRITESET" "block_encryption_mode","aes-128-ecb" "build_id","912f3601b14fe596a21fa1ff4b2a663279ccb830" "bulk_insert_buffer_size","4194304" "caching_sha2_password_auto_generate_rsa_keys","ON" "caching_sha2_password_digest_rounds","5000" "caching_sha2_password_private_key_path","private_key.pem" "caching_sha2_password_public_key_path","public_key.pem" "ccl_max_waiting_count","0" "ccl_queue_bucket_count","4" "ccl_queue_bucket_size","64" "ccl_queue_hot_delete","OFF" "ccl_queue_hot_update","OFF" "ccl_restrict_super_user","OFF" "ccl_wait_timeout","86400" "character_set_client","utf8mb4" "character_set_connection","utf8mb4" "character_set_database","utf8mb3" "character_set_filesystem","binary" "character_set_results","utf8mb4" "character_set_server","utf8mb3" "character_set_system","utf8mb3" "character_sets_dir","/u01/mysql/share/charsets/" "check_proxy_users","OFF" "clear_log_file_pagecache","OFF" "client_endpoint_ip","" "collation_connection","utf8mb4_0900_ai_ci" "collation_database","utf8mb3_general_ci" "collation_server","utf8mb3_general_ci" "completion_type","NO_CHAIN" "concurrent_insert","AUTO" "connect_timeout","10" "connection_memory_chunk_size","8192" "connection_memory_limit","18446744073709551615" "core_file","ON" "crash_sql_stmt_max_length","2048" "create_admin_listener_thread","OFF" "cte_max_recursion_depth","1000" "datadir","/home/mysql/data/dbs/" "default_authentication_plugin","mysql_native_password" "default_collation_for_utf8mb4","utf8mb4_0900_ai_ci" "default_password_lifetime","0" "default_storage_engine","InnoDB" "default_table_encryption","OFF" "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" "disabled_storage_engines","MyISAM,BLACKHOLE,FEDERATED,ARCHIVE,MEMORY,XENGINE" "disconnect_on_expired_password","ON" "div_precision_increment","4" "enable_gtid_prefetch","OFF" "encdb","OFF" "encdb_driver_connection","OFF" "encdb_kms_agent_cmd","/home/mysql/kms_agent" "end_markers_in_json","OFF" "enforce_gtid_consistency","ON" "eq_range_index_dive_limit","100" "error_count","0" "event_scheduler","ON" "expire_logs_days","0" "explain_format","TRADITIONAL" "explicit_defaults_for_timestamp","OFF" "external_user","" "fetch_raw_tablespace_at_startup","ON" "flush","OFF" "flush_time","0" "force_memory_to_innodb","OFF" "force_myisam_to_innodb","OFF" "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","/home/mysql/data/dbs/i-bp19seygk5m1avgf27u1.log" "generated_random_password_length","20" "global_connection_memory_limit","18446744073709551615" "global_connection_memory_tracking","OFF" "group_concat_max_len","1024" "group_replication_advertise_recovery_endpoints","DEFAULT" "group_replication_allow_local_lower_version_join","OFF" "group_replication_auto_increment_increment","7" "group_replication_autorejoin_tries","3" "group_replication_bootstrap_group","OFF" "group_replication_certification_info_reserve_size","500000" "group_replication_clone_threshold","9223372036854775807" "group_replication_communication_debug_options","GCS_DEBUG_NONE" "group_replication_communication_max_message_size","10485760" "group_replication_communication_stack","MYSQL" "group_replication_components_stop_timeout","300" "group_replication_compression_threshold","1000000" "group_replication_consistency","BEFORE_ON_PRIMARY_FAILOVER" "group_replication_enforce_update_everywhere_checks","OFF" "group_replication_exit_state_action","READ_ONLY" "group_replication_flow_control_applier_threshold","25000" "group_replication_flow_control_certifier_threshold","25000" "group_replication_flow_control_hold_percent","10" "group_replication_flow_control_max_quota","0" "group_replication_flow_control_member_quota_percent","0" "group_replication_flow_control_min_quota","0" "group_replication_flow_control_min_recovery_quota","0" "group_replication_flow_control_mode","DISABLED" "group_replication_flow_control_period","1" "group_replication_flow_control_release_percent","50" "group_replication_force_clear_certification_info","ON" "group_replication_force_members","" "group_replication_group_name","08365201-4f1e-3249-8e01-2e21deca3e67" "group_replication_group_seeds","21.4.0.97:3042,21.4.2.159:3000,20.5.7.127:3007" "group_replication_gtid_assignment_block_size","1000000" "group_replication_ip_allowlist","AUTOMATIC" "group_replication_ip_whitelist","AUTOMATIC" "group_replication_local_address","21.4.0.97:3042" "group_replication_member_expel_timeout","0" "group_replication_member_weight","50" "group_replication_message_cache_size","1073741824" "group_replication_paxos_single_leader","ON" "group_replication_poll_spin_loops","0" "group_replication_recovery_complete_at","TRANSACTIONS_APPLIED" "group_replication_recovery_compression_algorithms","uncompressed" "group_replication_recovery_get_public_key","OFF" "group_replication_recovery_public_key_path","" "group_replication_recovery_reconnect_interval","60" "group_replication_recovery_retry_count","10" "group_replication_recovery_ssl_ca","" "group_replication_recovery_ssl_capath","" "group_replication_recovery_ssl_cert","" "group_replication_recovery_ssl_cipher","" "group_replication_recovery_ssl_crl","" "group_replication_recovery_ssl_crlpath","" "group_replication_recovery_ssl_key","" "group_replication_recovery_ssl_verify_server_cert","OFF" "group_replication_recovery_tls_ciphersuites","" "group_replication_recovery_tls_version","TLSv1,TLSv1.1,TLSv1.2,TLSv1.3" "group_replication_recovery_use_ssl","OFF" "group_replication_recovery_zstd_compression_level","3" "group_replication_single_primary_mode","ON" "group_replication_ssl_mode","DISABLED" "group_replication_start_on_boot","OFF" "group_replication_start_on_boot_delay","5000" "group_replication_tls_source","MYSQL_MAIN" "group_replication_transaction_size_limit","150000000" "group_replication_unreachable_majority_timeout","0" "group_replication_view_change_uuid","AUTOMATIC" "gtid_executed","08365201-4f1e-3249-8e01-2e21deca3e67:1-20451156,\n74f8c1c7-39d5-11f0-8363-00163e0dfaf9:1-228211,\n75ab9019-39d5-11f0-b040-00163e1d621b:1-9149,\n93c7a266-39d5-11f0-a8a2-00163e238152:1-278" "gtid_executed_compression_period","0" "gtid_mode","ON" "gtid_next","AUTOMATIC" "gtid_owned","" "gtid_prefetch_step","50000" "gtid_purged","08365201-4f1e-3249-8e01-2e21deca3e67:1-19493906,\n74f8c1c7-39d5-11f0-8363-00163e0dfaf9:1-228211,\n75ab9019-39d5-11f0-b040-00163e1d621b:1-9149,\n93c7a266-39d5-11f0-a8a2-00163e238152:1-278" "have_compress","YES" "have_dynamic_loading","YES" "have_geometry","YES" "have_openssl","YES" "have_profiling","YES" "have_query_cache","NO" "have_rtree_keys","YES" "have_ssl","YES" "have_statement_timeout","YES" "have_symlink","DISABLED" "histogram_generation_max_mem_size","20000000" "host_cache_size","644" "hostname","i-bp19seygk5m1avgf27u1" "identity","0" "ignore_index_hint_error","OFF" "immediate_server_version","999999" "implicit_primary_key","ON" "information_schema_stats_expiry","86400" "init_connect","" "init_file","" "init_replica","" "init_slave","" "inner_schema_list","" "inner_user_list","" "innodb_adaptive_flushing","ON" "innodb_adaptive_flushing_lwm","10" "innodb_adaptive_hash_index","OFF" "innodb_adaptive_hash_index_parts","8" "innodb_adaptive_max_sleep_delay","150000" "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_autoextend_increment","64" "innodb_autoinc_lock_mode","2" "innodb_buffer_pool_chunk_size","33554432" "innodb_buffer_pool_dump_at_shutdown","ON" "innodb_buffer_pool_dump_now","OFF" "innodb_buffer_pool_dump_pct","25" "innodb_buffer_pool_extension","OFF" "innodb_buffer_pool_extension_aio_read","ON" "innodb_buffer_pool_extension_chunk_size","33554432" "innodb_buffer_pool_extension_clock_scans","10" "innodb_buffer_pool_extension_dir","" "innodb_buffer_pool_extension_flush_dirty","ON" "innodb_buffer_pool_extension_io_read_capacity","0" "innodb_buffer_pool_extension_io_write_capacity","0" "innodb_buffer_pool_extension_read","ON" "innodb_buffer_pool_extension_size","268435456" "innodb_buffer_pool_filename","ib_buffer_pool" "innodb_buffer_pool_in_core_file","OFF" "innodb_buffer_pool_init_optimize","ON" "innodb_buffer_pool_instances","8" "innodb_buffer_pool_load_abort","OFF" "innodb_buffer_pool_load_at_startup","ON" "innodb_buffer_pool_load_now","OFF" "innodb_buffer_pool_resize_cancel","OFF" "innodb_buffer_pool_size","6442450944" "innodb_change_buffer_max_size","25" "innodb_change_buffering","none" "innodb_checksum_algorithm","crc32" "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_control_index_page_reserve","ON" "innodb_data_file_path","ibdata1:200M:autoextend" "innodb_data_file_purge","ON" "innodb_data_file_purge_all_at_shutdown","OFF" "innodb_data_file_purge_dir","" "innodb_data_file_purge_immediate","OFF" "innodb_data_file_purge_interval","100" "innodb_data_file_purge_max_size","128" "innodb_data_file_xattr_enabled","ON" "innodb_data_file_xattr_remove","OFF" "innodb_data_home_dir","/home/mysql/data/mysql" "innodb_ddl_buffer_size","1048576" "innodb_ddl_threads","4" "innodb_deadlock_detect","ON" "innodb_dedicated_server","OFF" "innodb_default_row_format","dynamic" "innodb_dg_arch_dir","./#orl_archive/" "innodb_dg_arch_file_flush_interval","16777216" "innodb_dg_arch_file_size","536870912" "innodb_dg_arch_io_merge_size","4096" "innodb_dg_redo_timestamp_interval","500" "innodb_directories","" "innodb_disable_sort_file_cache","OFF" "innodb_doublewrite","OFF" "innodb_doublewrite_batch_size","0" "innodb_doublewrite_dir","" "innodb_doublewrite_files","0" "innodb_doublewrite_pages","64" "innodb_encrypt_algorithm","aes_256_cbc" "innodb_extend_and_initialize","ON" "innodb_fast_shutdown","1" "innodb_faster_lru_scan","OFF" "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","1" "innodb_flush_method","O_DIRECT" "innodb_flush_neighbors","0" "innodb_flush_sync","ON" "innodb_flushing_avg_loops","30" "innodb_force_load_corrupted","OFF" "innodb_force_recovery","0" "innodb_fsync_threshold","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_idle_flush_pct","100" "innodb_index_pct_free","10" "innodb_instant_ddl_enabled","ON" "innodb_io_capacity","20000" "innodb_io_capacity_max","40000" "innodb_lock_wait_timeout","50" "innodb_log_buffer_size","8388608" "innodb_log_checksums","ON" "innodb_log_compressed_pages","OFF" "innodb_log_file_size","1572864000" "innodb_log_files_in_group","2" "innodb_log_group_home_dir","/home/mysql/data/mysql" "innodb_log_optimize_ddl","OFF" "innodb_log_spin_cpu_abs_lwm","80" "innodb_log_spin_cpu_pct_hwm","50" "innodb_log_wait_for_flush_spin_hwm","400" "innodb_log_write_ahead_size","4096" "innodb_log_writer_threads","ON" "innodb_lru_scan_depth","1024" "innodb_max_dirty_pages_pct","75.000000" "innodb_max_dirty_pages_pct_lwm","10.000000" "innodb_max_mtr_records_for_tmp_table","0" "innodb_max_purge_lag","0" "innodb_max_purge_lag_delay","0" "innodb_max_undo_log_size","1073741824" "innodb_monitor_disable","" "innodb_monitor_enable","" "innodb_monitor_reset","" "innodb_monitor_reset_all","" "innodb_multi_blocks_enabled","ON" "innodb_numa_interleave","ON" "innodb_old_blocks_pct","37" "innodb_old_blocks_time","1000" "innodb_online_alter_log_max_size","134217728" "innodb_open_files","20000" "innodb_optimize_fulltext_only","OFF" "innodb_oss_ddl_threads","16" "innodb_oss_default_big_block_size","2097152" "innodb_oss_files_limit","10240" "innodb_oss_prefetch","ON" "innodb_oss_prefetch_linear_pct_threshold","10" "innodb_oss_prefetch_random_pct_threshold","30" "innodb_oss_prefetch_task_limit","32" "innodb_page_cleaners","8" "innodb_page_size","16384" "innodb_parallel_read_threads","0" "innodb_parallel_redo_chunk_size","33554432" "innodb_parallel_redo_threads","1" "innodb_print_all_deadlocks","OFF" "innodb_print_data_file_purge_process","OFF" "innodb_print_ddl_logs","OFF" "innodb_purge_batch_size","300" "innodb_purge_rseg_truncate_frequency","128" "innodb_purge_threads","8" "innodb_random_read_ahead","OFF" "innodb_rds_chunk_flush_interval","100" "innodb_rds_drop_ahi_ahead","OFF" "innodb_rds_faster_ddl","ON" "innodb_rds_flashback_allow_gap","30" "innodb_rds_flashback_enabled","ON" "innodb_rds_flashback_interval","1" "innodb_rds_flashback_print_warning","ON" "innodb_rds_flashback_task_enabled","OFF" "innodb_rds_flashback_task_stop_all","OFF" "innodb_rds_free_resize","ON" "innodb_rds_resize_lock_interval","0" "innodb_rds_suspend_purge","OFF" "innodb_read_ahead_threshold","56" "innodb_read_io_threads","4" "innodb_read_only","OFF" "innodb_redo_log_archive_dirs","" "innodb_redo_log_capacity","104857600" "innodb_redo_log_encrypt","OFF" "innodb_redo_log_length_enabled","OFF" "innodb_redo_log_unclean_upgrade","ON" "innodb_replication_delay","0" "innodb_rollback_on_timeout","OFF" "innodb_rollback_segments","128" "innodb_segment_reserve_factor","12.500000" "innodb_sort_buffer_size","1048576" "innodb_spin_wait_delay","6" "innodb_spin_wait_pause_multiplier","50" "innodb_stats_auto_recalc","ON" "innodb_stats_include_delete_marked","OFF" "innodb_stats_method","nulls_equal" "innodb_stats_on_metadata","OFF" "innodb_stats_persistent","ON" "innodb_stats_persistent_sample_pages","20" "innodb_stats_transient_sample_pages","8" "innodb_status_output","OFF" "innodb_status_output_locks","OFF" "innodb_strict_mode","OFF" "innodb_sync_array_size","128" "innodb_sync_spin_loops","30" "innodb_table_locks","ON" "innodb_temp_data_file_path","ibtmp1:12M:autoextend" "innodb_temp_tablespaces_dir","./#innodb_temp/" "innodb_thread_concurrency","0" "innodb_thread_sleep_delay","10000" "innodb_tmpdir","" "innodb_trx_resurrect_table_lock_accelerate","OFF" "innodb_undo_directory","./" "innodb_undo_log_encrypt","OFF" "innodb_undo_log_truncate","ON" "innodb_undo_retention","0" "innodb_undo_space_reserved_size","0" "innodb_undo_space_supremum_size","10240" "innodb_undo_tablespaces","2" "innodb_use_fdatasync","OFF" "innodb_use_native_aio","ON" "innodb_validate_tablespace_paths","ON" "innodb_version","8.0.36" "innodb_write_io_threads","4" "insert_id","0" "interactive_timeout","7200" "internal_tmp_mem_storage_engine","MEMORY" "join_buffer_size","1048576" "json_document_max_depth","100" "keep_files_on_create","OFF" "key_buffer_size","16777216" "key_cache_age_threshold","300" "key_cache_block_size","1024" "key_cache_division_limit","100" "keyring_operations","ON" "kill_idle_transaction_timeout","0" "large_files_support","ON" "large_page_size","0" "large_pages","OFF" "last_insert_id","0" "lc_messages","en_US" "lc_messages_dir","/u01/mysql/share/" "lc_time_names","en_US" "license","GPL" "local_infile","ON" "lock_instance_mode","LOCK_NON" "lock_wait_timeout","31536000" "locked_in_memory","OFF" "log_bin","ON" "log_bin_basename","/home/mysql/log/mysql/mysql-bin" "log_bin_index","/home/mysql/log/mysql/mysql-bin.index" "log_bin_trust_function_creators","ON" "log_bin_use_v1_row_events","ON" "log_error","/home/mysql/log/mysql/master-error.log" "log_error_services","log_filter_internal; log_sink_internal" "log_error_suppression_list","MY-010520,MY-013360" "log_error_verbosity","3" "log_output","TABLE" "log_queries_not_using_indexes","OFF" "log_raw","OFF" "log_replica_updates","ON" "log_slave_updates","ON" "log_slow_admin_statements","OFF" "log_slow_extra","OFF" "log_slow_replica_statements","OFF" "log_slow_slave_statements","OFF" "log_statements_unsafe_for_binlog","ON" "log_throttle_queries_not_using_indexes","0" "log_timestamps","SYSTEM" "long_query_time","1.000000" "low_priority_updates","OFF" "lower_case_file_system","OFF" "lower_case_table_names","1" "maintain_max_connections","500" "maintain_user_list","aliyun_root,aurora,replicator,mysql.infoschema,mysql.session,mysql.sys" "mandatory_roles","" "master_info_repository","TABLE" "master_verify_checksum","OFF" "max_allowed_packet","1073741824" "max_binlog_cache_size","18446744073709547520" "max_binlog_size","524288000" "max_binlog_stmt_cache_size","18446744073709547520" "max_connect_errors","100" "max_connections","6520" "max_delayed_threads","20" "max_digest_length","1024" "max_error_count","64" "max_execution_time","0" "max_heap_table_size","67108864" "max_insert_delayed_threads","20" "max_join_size","18446744073709551615" "max_length_for_sort_data","1024" "max_points_in_geometry","65536" "max_prepared_stmt_count","16382" "max_relay_log_size","0" "max_seeks_for_key","18446744073709500000" "max_sort_length","1024" "max_sp_recursion_depth","0" "max_unix_admin_connections","100" "max_user_connections","6000" "max_write_lock_count","102400" "min_examined_row_limit","0" "multi_blocks_count","0" "multi_blocks_ddl_count","0" "myisam_data_pointer_size","6" "myisam_max_sort_file_size","2097152" "myisam_mmap_size","18446744073709551615" "myisam_recover_options","FORCE" "myisam_repair_threads","1" "myisam_sort_buffer_size","262144" "myisam_stats_method","nulls_unequal" "myisam_use_mmap","OFF" "mysql_native_password_proxy_users","OFF" "mysqlx_bind_address","" "mysqlx_compression_algorithms","DEFLATE_STREAM,LZ4_MESSAGE,ZSTD_STREAM" "mysqlx_connect_timeout","30" "mysqlx_deflate_default_compression_level","3" "mysqlx_deflate_max_client_compression_level","5" "mysqlx_document_id_unique_prefix","0" "mysqlx_enable_hello_notice","ON" "mysqlx_idle_worker_thread_timeout","60" "mysqlx_interactive_timeout","28800" "mysqlx_lz4_default_compression_level","2" "mysqlx_lz4_max_client_compression_level","8" "mysqlx_max_allowed_packet","67108864" "mysqlx_max_connections","100" "mysqlx_min_worker_threads","2" "mysqlx_port","33060" "mysqlx_port_open_timeout","0" "mysqlx_read_timeout","30" "mysqlx_socket","/tmp/mysqlx.sock" "mysqlx_ssl_ca","" "mysqlx_ssl_capath","" "mysqlx_ssl_cert","" "mysqlx_ssl_cipher","" "mysqlx_ssl_crl","" "mysqlx_ssl_crlpath","" "mysqlx_ssl_key","" "mysqlx_wait_timeout","28800" "mysqlx_write_timeout","60" "mysqlx_zstd_default_compression_level","3" "mysqlx_zstd_max_client_compression_level","11" "net_buffer_length","16384" "net_read_timeout","30" "net_retry_count","10" "net_shrink_count_threshold","5" "net_write_timeout","60" "new","OFF" "ngram_token_size","2" "offline_mode","OFF" "old","OFF" "old_alter_table","OFF" "open_files_limit","655350" "opt_enable_rds_priv_strategy","ON" "opt_indexstat","OFF" "opt_outline_enabled","ON" "opt_tablestat","OFF" "optimizer_max_subgraph_pairs","100000" "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,duplicateweedout=on,subquery_materialization_cost_based=on,use_index_extensions=on,condition_fanout_filter=on,derived_merge=on,use_invisible_indexes=off,skip_scan=on,hash_join=on,subquery_to_derived=off,prefer_ordering_index=on,hypergraph_optimizer=off,derived_condition_pushdown=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" "original_commit_timestamp","36028797018963968" "original_server_version","999999" "oss_access_key_id","**" "oss_access_key_secret","*" "oss_bucket_name","" "oss_common_sleep_time","50" "oss_directory","" "oss_enabled","OFF" "oss_endpoint","" "oss_get_sleep_time","30" "oss_iops_limit","19200" "oss_max_connections","64" "oss_put_sleep_time","100" "oss_recv_bandwidth_limit","307200" "oss_send_bandwidth_limit","307200" "oss_token","**" "oss_wait_available_timeout","600" "outline_allowed_sql_digest_truncate","ON" "outline_partitions","16" "parser_max_mem_size","18446744073709551615" "partial_revokes","OFF" "password_history","0" "password_require_current","OFF" "password_reuse_interval","0" "performance_agent_enabled","ON" "performance_agent_file_size","128" "performance_agent_interval","1" "performance_agent_network_device","enp, eth, em" "performance_agent_perfstat_volume_size","3600" "performance_point_dbug_enabled","OFF" "performance_point_enabled","ON" "performance_point_iostat_interval","2" "performance_point_iostat_volume_size","10000" "performance_point_lock_rwlock_enabled","ON" "performance_schema","ON" "performance_schema_accounts_size","10000" "performance_schema_digests_size","10000" "performance_schema_error_size","0" "performance_schema_events_stages_history_long_size","0" "performance_schema_events_stages_history_size","0" "performance_schema_events_statements_history_long_size","0" "performance_schema_events_statements_history_size","0" "performance_schema_events_transactions_history_long_size","0" "performance_schema_events_transactions_history_size","0" "performance_schema_events_waits_history_long_size","0" "performance_schema_events_waits_history_size","0" "performance_schema_hosts_size","10000" "performance_schema_max_cond_classes","150" "performance_schema_max_cond_instances","10000" "performance_schema_max_digest_length","0" "performance_schema_max_digest_sample_age","0" "performance_schema_max_file_classes","80" "performance_schema_max_file_handles","0" "performance_schema_max_file_instances","1000" "performance_schema_max_index_stat","10000" "performance_schema_max_memory_classes","500" "performance_schema_max_metadata_locks","10000" "performance_schema_max_mutex_classes","256" "performance_schema_max_mutex_instances","10000" "performance_schema_max_prepared_statements_instances","1000" "performance_schema_max_program_instances","10000" "performance_schema_max_rwlock_classes","100" "performance_schema_max_rwlock_instances","10000" "performance_schema_max_socket_classes","10" "performance_schema_max_socket_instances","1000" "performance_schema_max_sql_text_length","0" "performance_schema_max_stage_classes","200" "performance_schema_max_statement_classes","256" "performance_schema_max_statement_stack","1" "performance_schema_max_table_handles","10000" "performance_schema_max_table_instances","1000" "performance_schema_max_table_lock_stat","10000" "performance_schema_max_thread_classes","100" "performance_schema_max_thread_instances","10000" "performance_schema_session_connect_attrs_size","0" "performance_schema_setup_actors_size","10000" "performance_schema_setup_objects_size","10000" "performance_schema_show_processlist","OFF" "performance_schema_users_size","10000" "performance_tcp_write_wait_time_enabled","ON" "persist_binlog_to_redo","ON" "persist_binlog_to_redo_size_limit","1048576" "persist_log_bin","ON" "persist_only_admin_x509_subject","" "persist_sensitive_variables_in_plaintext","ON" "persisted_globals_load","ON" "pid_file","/home/mysql/data/my3042.pid" "plugin_dir","/u01/mysql/lib/plugin/" "port","3042" "preload_buffer_size","32768" "primary_fast_lookup","ON" "print_identified_with_as_hex","OFF" "profiling","ON" "profiling_history_size","15" "protocol_compression_algorithms","zlib,zstd,uncompressed" "protocol_version","10" "proxy_ip_list","21.4.1.234,20.5.6.12" "proxy_user","" "pseudo_replica_mode","OFF" "pseudo_slave_mode","OFF" "pseudo_thread_id","636529" "push_tran_info_default_interval","10" "query_alloc_block_size","8192" "query_prealloc_size","8192" "rand_seed1","0" "rand_seed2","0" "range_alloc_block_size","4096" "range_optimizer_max_mem_size","8388608" "rbr_exec_mode","STRICT" "rds_active_memory_profiling","OFF" "rds_audit_log_buffer_size","16777216" "rds_audit_log_connection_policy","ALL" "rds_audit_log_dir","" "rds_audit_log_enabled","OFF" "rds_audit_log_event_buffer_size","8192" "rds_audit_log_flush","OFF" "rds_audit_log_format","PLAIN" "rds_audit_log_policy","ALL" "rds_audit_log_row_limit","100000" "rds_audit_log_skip","OFF" "rds_audit_log_statement_policy","ALL" "rds_audit_log_strategy","ASYNCHRONOUS" "rds_audit_log_version","MYSQL_V3" "rds_binlog_cache_diagnose_size","524288000" "rds_check_core_file_enabled","ON" "rds_data_protect_admin","" "rds_data_protect_control","USER" "rds_data_protect_ignore","" "rds_data_protect_level","NONE" "rds_dg_arch_enabled","OFF" "rds_diagnose_ddl_options","SQLCOM_ALTER_TABLE" "rds_diagnose_log_options","BIG_TRANSACTION,DDL" "rds_diagnose_throttle_ddl_logs","10" "rds_disable_explicit_trans","OFF" "rds_expose_priv_list","XA_RECOVER_ADMIN,SESSION_VARIABLES_ADMIN,SHOW_ROUTINE" "rds_hotfix_version","0" "rds_ignore_password_validation_user_list","aurora,Xtrabak,replicator,eagleye,aliyun_root" "rds_kill_connections","20" "rds_kill_user_list","mysqladmin" "rds_print_tcp_error","OFF" "rds_reduce_super_to_repl_slave","OFF" "rds_release_date","20241231" "rds_version","36" "read_buffer_size","1048576" "read_only","OFF" "read_rnd_buffer_size","262144" "recycle_bin","OFF" "recycle_bin_retention","604800" "recycle_scheduler","OFF" "recycle_scheduler_interval","30" "recycle_scheduler_purge_table_print","OFF" "regexp_stack_limit","8000000" "regexp_time_limit","32" "relay_log","/home/mysql/log/mysql/slave-relay.log" "relay_log_basename","/home/mysql/log/mysql/slave-relay" "relay_log_index","/home/mysql/log/mysql/slave-relay-log.index" "relay_log_info_file","/home/mysql/log/mysql/slave-relay-log.info" "relay_log_info_repository","TABLE" "relay_log_purge","ON" "relay_log_recovery","OFF" "relay_log_space_limit","0" "replica_allow_batching","ON" "replica_checkpoint_group","512" "replica_checkpoint_period","300" "replica_compressed_protocol","OFF" "replica_exec_mode","STRICT" "replica_load_tmpdir","/home/mysql/log/tmp" "replica_max_allowed_packet","1073741824" "replica_net_timeout","60" "replica_parallel_type","LOGICAL_CLOCK" "replica_parallel_workers","8" "replica_pending_jobs_size_max","134217728" "replica_preserve_commit_order","ON" "replica_skip_errors","OFF" "replica_sql_verify_checksum","ON" "replica_transaction_retries","10" "replica_type_conversions","" "replication_optimize_for_static_plugin_config","OFF" "replication_sender_observe_commit_only","OFF" "report_host","21.4.0.97" "report_password","" "report_port","3042" "report_user","" "require_row_format","OFF" "require_secure_transport","OFF" "resultset_metadata","FULL" "reverse_repair_general_log_on_boot","ON" "rotate_log_table","OFF" "rotate_log_table_last_name","./mysql/slow_log_1748496702.CSV" "rpl_read_size","8192" "rpl_semi_sync_master_enabled","OFF" "rpl_semi_sync_master_timeout","1000" "rpl_semi_sync_master_trace_level","1" "rpl_semi_sync_master_wait_for_slave_count","1" "rpl_semi_sync_master_wait_no_slave","OFF" "rpl_semi_sync_master_wait_point","AFTER_SYNC" "rpl_semi_sync_slave_enabled","OFF" "rpl_semi_sync_slave_trace_level","1" "rpl_stop_replica_timeout","31536000" "rpl_stop_slave_timeout","31536000" "schema_definition_cache","256" "secondary_engine_cost_threshold","100000.000000" "secure_file_priv","NULL" "select_into_buffer_size","131072" "select_into_disk_sync","OFF" "select_into_disk_sync_delay","0" "sequence_read_skip_cache","OFF" "server_id","36609803" "server_id_bits","32" "server_uuid","75ab9019-39d5-11f0-b040-00163e1d621b" "session_track_gtids","OFF" "session_track_prepare_statements","OFF" "session_track_schema","ON" "session_track_state_change","ON" "session_track_system_variables","" "session_track_temporary_tables","OFF" "session_track_transaction_info","OFF" "session_track_user_variables","OFF" "set_connection_id_enabled","ON" "sha256_password_auto_generate_rsa_keys","ON" "sha256_password_private_key_path","private_key.pem" "sha256_password_proxy_users","OFF" "sha256_password_public_key_path","public_key.pem" "show_create_table_skip_secondary_engine","OFF" "show_create_table_verbosity","OFF" "show_gipk_in_create_table_and_information_schema","ON" "show_ipk_info","OFF" "show_old_temporals","OFF" "skip_dd_table_access_check","OFF" "skip_external_locking","ON" "skip_free_flush_ignorable_event","ON" "skip_name_resolve","ON" "skip_networking","OFF" "skip_replica_start","OFF" "skip_show_database","OFF" "skip_slave_start","OFF" "slave_allow_batching","ON" "slave_checkpoint_group","512" "slave_checkpoint_period","300" "slave_compressed_protocol","OFF" "slave_exec_mode","STRICT" "slave_load_tmpdir","/home/mysql/log/tmp" "slave_max_allowed_packet","1073741824" "slave_net_timeout","60" "slave_parallel_type","LOGICAL_CLOCK" "slave_parallel_workers","8" "slave_pending_jobs_size_max","134217728" "slave_preserve_commit_order","ON" "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_log_guarantee","ON" "slow_query_log","ON" "slow_query_log_file","/home/mysql/log/mysql/slow_query.log" "socket","/home/mysql/data/tmp/mysql.sock" "sort_buffer_size","2097152" "source_verify_checksum","OFF" "sql_auto_is_null","OFF" "sql_big_selects","ON" "sql_buffer_result","OFF" "sql_generate_invisible_primary_key","OFF" "sql_log_bin","ON" "sql_log_off","OFF" "sql_mode","ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION" "sql_notes","ON" "sql_quote_show_create","ON" "sql_replica_skip_counter","0" "sql_require_primary_key","OFF" "sql_safe_updates","OFF" "sql_select_limit","3000" "sql_slave_skip_counter","0" "sql_warnings","OFF" "ssl_ca","" "ssl_capath","" "ssl_cert","/home/mysql/data/ssl/ssl_rm-bp1z61qll5e58l2x5.cert" "ssl_cipher","ALL:@SECLEVEL=0" "ssl_crl","" "ssl_crlpath","" "ssl_fips_mode","OFF" "ssl_key","/home/mysql/data/ssl/ssl_rm-bp1z61qll5e58l2x5.key" "ssl_session_cache_mode","ON" "ssl_session_cache_timeout","300" "stack_overrun_warning","OFF" "statement_id","505777456" "stored_program_cache","256" "stored_program_definition_cache","256" "super_read_only","OFF" "sync_binlog","1" "sync_binlog_interval","50000" "sync_binlog_redo_together","OFF" "sync_master_info","10000" "sync_relay_log","10000" "sync_relay_log_info","10000" "sync_source_info","10000" "system_time_zone","CST" "table_definition_cache","4096" "table_encryption_privilege_check","OFF" "table_open_cache","8192" "table_open_cache_instances","16" "tablespace_definition_cache","256" "temptable_max_mmap","1073741824" "temptable_max_ram","1073741824" "temptable_use_mmap","OFF" "terminology_use_previous","NONE" "thread_cache_size","100" "thread_handling","pool-of-threads" "thread_pool_enabled","ON" "thread_pool_idle_timeout","10" "thread_pool_max_threads","10000" "thread_pool_normal_weights","50" "thread_pool_oversubscribe","32" "thread_pool_size","4" "thread_pool_stall_limit","100" "thread_pool_trans_weights","50" "thread_stack","1048576" "time_zone","+08:00" "timestamp","1748496749.610203" "tls_ciphersuites","" "tls_version","TLSv1,TLSv1.1,TLSv1.2" "tmp_table_size","2097152" "tmpdir","/home/mysql/log/tmp" "transaction_alloc_block_size","8192" "transaction_allow_batching","OFF" "transaction_isolation","READ-COMMITTED" "transaction_prealloc_size","4096" "transaction_read_only","OFF" "transaction_write_set_extraction","XXHASH64" "unique_checks","ON" "updatable_views_with_limit","YES" "upgrade_clear_invalid_comment","ON" "use_secondary_engine","ON" "version","8.0.36" "version_comment","Source distribution" "version_compile_machine","x86_64" "version_compile_os","Linux" "version_compile_zlib","1.2.13" "wait_binlog_flush","ON" "wait_timeout","86400" "warning_count","0" "windowing_use_high_precision","ON" "writeset_tracking_for_foreign_key","OFF" "writeset_tracking_for_ipk","ON" "xa_detach_on_prepare","ON"