Variable index

115 topics referenced by configuration review rules. Each page links to Oracle MySQL 8.4 manuals where applicable. Filter by variable name or category (e.g., "security", "buffer pool", "replication").

• admin_addressConnections & ThreadingINFO
• admin_portConnections & ThreadingINFO
• bind_addressNetworkingINFO
• binlog_cache_sizeBinary LoggingINFO
• binlog_expire_logs_secondsBinary LoggingWARNING
• binlog_formatBinary LoggingWARNING
• binlog_row_imageBinary LoggingINFO
• binlog_transaction_dependency_trackingBinary LoggingINFO
• connect_timeoutConnections & ThreadingINFO
• cpu_governorOS & HardwareINFO
• default_authentication_pluginSecurityINFO
• delay_key_writeGeneral MiscWARNING
• expire_logs_daysBinary LoggingINFO
• general_logLogging & MonitoringCRITICAL
• gtid_modeBinary LoggingWARNING
• init_connectGeneral MiscWARNING
• init_fileGeneral MiscWARNING
• innodb_adaptive_hash_indexInnoDB MiscINFO
• innodb_adaptive_max_sleep_delayInnoDB ConcurrencyINFO
• innodb_autoinc_lock_modeInnoDB Concurrency, PXC / GaleraCRITICAL
• innodb_buffer_pool_chunk_sizeInnoDB Buffer PoolINFO
• innodb_buffer_pool_dump_at_shutdownInnoDB Buffer PoolINFO
• innodb_buffer_pool_dump_pctInnoDB Buffer PoolINFO
• innodb_buffer_pool_instancesInnoDB Buffer PoolINFO
• innodb_buffer_pool_load_at_startupInnoDB Buffer PoolINFO
• innodb_buffer_pool_sizeInnoDB Buffer PoolWARNING
• innodb_change_bufferingInnoDB MiscINFO
• innodb_checksum_algorithmInnoDB I/OWARNING
• innodb_commit_concurrencyInnoDB ConcurrencyINFO
• innodb_concurrency_ticketsInnoDB ConcurrencyINFO
• innodb_deadlock_detectInnoDB MiscINFO
• innodb_doublewriteInnoDB I/OINFO
• innodb_file_per_tableInnoDB I/OINFO
• innodb_flush_log_at_trx_commitInnoDB Redo LogCRITICAL
• innodb_flush_methodInnoDB I/OWARNING
• innodb_flush_neighborsInnoDB I/OINFO
• innodb_io_capacityInnoDB I/OWARNING
• innodb_io_capacity_maxInnoDB I/OINFO
• innodb_lock_wait_timeoutInnoDB MiscWARNING
• innodb_log_buffer_sizeInnoDB Redo LogWARNING
• innodb_log_file_sizeInnoDB Redo LogWARNING
• innodb_numa_interleaveInnoDB MiscINFO
• innodb_page_cleanersInnoDB I/OINFO
• innodb_page_sizeInnoDB I/OINFO
• innodb_print_all_deadlocksInnoDB MiscINFO
• innodb_purge_threadsInnoDB MiscINFO
• innodb_read_io_threadsInnoDB I/OINFO
• innodb_redo_log_capacityInnoDB Redo LogWARNING
• innodb_stats_on_metadataInnoDB MiscINFO
• innodb_statusSchema & TablesCRITICAL
• innodb_sync_array_sizeInnoDB ConcurrencyINFO
• innodb_sync_spin_loopsInnoDB ConcurrencyINFO
• innodb_thread_concurrencyInnoDB ConcurrencyINFO
• innodb_thread_sleep_delayInnoDB ConcurrencyINFO
• innodb_use_fdatasyncInnoDB I/OINFO
• innodb_write_io_threadsInnoDB I/OINFO
• io_schedulerOS & HardwareINFO
• join_buffer_sizePer-Thread MemoryWARNING
• local_infileSecurityCRITICAL
• log_binBinary LoggingWARNING
• log_error_verbosityLogging & MonitoringINFO
• log_queries_not_using_indexesLogging & MonitoringINFO
• log_replica_updatesBinary LoggingWARNING
• log_slow_admin_statementsLogging & MonitoringINFO
• long_query_timeLogging & MonitoringINFO
• max_allowed_packetPer-Thread Memory, NetworkingWARNING
• max_connectionsConnections & ThreadingWARNING
• max_heap_table_sizePer-Thread MemoryWARNING
• myisam_tablesSchema & TablesWARNING
• mysqlx_bind_addressNetworkingINFO
• numaOS & HardwareINFO
• open_files_limitOS & HardwareINFO
• password_historySecurityINFO
• performance_schemaLogging & MonitoringWARNING
• portGeneral MiscINFO
• pxc_strict_modePXC / GaleraWARNING
• read_buffer_sizePer-Thread MemoryINFO
• read_onlyReplicationWARNING
• read_rnd_buffer_sizePer-Thread MemoryINFO
• relay_log_info_repositoryReplicationWARNING
• relay_log_recoveryReplicationWARNING
• replica_parallel_typeReplicationINFO
• replica_parallel_workersReplicationINFO
• replica_preserve_commit_orderReplicationINFO
• require_secure_transportSecurityWARNING
• skip_name_resolveSecurityINFO
• slow_query_logLogging & MonitoringWARNING
• sort_buffer_sizePer-Thread MemoryWARNING
• source_info_repositoryReplicationWARNING
• sql_modeSecurityWARNING
• ssl_certSecurityINFO
• swap_usageOS & HardwareCRITICAL
• sync_binlogBinary LoggingCRITICAL
• sync_frmGeneral MiscWARNING
• table_definition_cacheTable CacheINFO
• table_open_cacheTable CacheWARNING
• table_open_cache_instancesTable CacheINFO
• tables_without_pkSchema & TablesCRITICAL
• thread_cache_sizeConnections & ThreadingINFO
• thread_handlingConnections & ThreadingINFO
• tmp_table_sizePer-Thread MemoryWARNING
• transparent_hugepagesOS & HardwareWARNING
• usersSecurityCRITICAL
• versionVersion & LifecycleCRITICAL
• vm.swappinessOS & HardwareWARNING
• wait_timeoutConnections & ThreadingINFO
• wsrep_cluster_sizePXC / GaleraINFO
• wsrep_cluster_statusPXC / GaleraCRITICAL
• wsrep_desyncPXC / GaleraINFO
• wsrep_flow_control_pausedPXC / GaleraWARNING
• wsrep_local_recv_queue_avgPXC / GaleraWARNING
• wsrep_readyPXC / GaleraCRITICAL
• wsrep_slave_threadsPXC / GaleraINFO
• wsrep_sst_methodPXC / GaleraINFO
• wsrep_sync_waitPXC / GaleraINFO