system-variable-reference.md

title	summary
System Variable Reference	A list of all TiDB system variables and their references in the documentation.

System Variable Reference

This page lists all TiDB system variables and the documents that reference them in the documentation. You can view System Variables for more details of each variable.

Variable reference

allow_auto_random_explicit_insert

Referenced in:

• AUTO_RANDOM
• Insert Data
• SESSION_VARIABLES
• System Variables
• VARIABLES_INFO

authentication_ldap_sasl_auth_method_name

Referenced in:

• System Variables
• TiDB 7.1.0 Release Notes

authentication_ldap_sasl_bind_base_dn

Referenced in:

• System Variables
• TiDB 7.1.0 Release Notes

authentication_ldap_sasl_bind_root_dn

Referenced in:

• System Variables
• TiDB 7.1.0 Release Notes

authentication_ldap_sasl_bind_root_pwd

Referenced in:

• System Variables
• TiDB 7.1.0 Release Notes

authentication_ldap_sasl_ca_path

Referenced in:

• System Variables
• TiDB 7.1.0 Release Notes

authentication_ldap_sasl_init_pool_size

Referenced in:

• System Variables
• TiDB 7.1.0 Release Notes

authentication_ldap_sasl_max_pool_size

Referenced in:

• System Variables
• TiDB 7.1.0 Release Notes

authentication_ldap_sasl_server_host

Referenced in:

• System Variables
• TiDB 7.1.0 Release Notes

authentication_ldap_sasl_server_port

Referenced in:

• System Variables
• TiDB 7.1.0 Release Notes

authentication_ldap_sasl_tls

Referenced in:

• System Variables
• TiDB 7.1.0 Release Notes

authentication_ldap_simple_auth_method_name

Referenced in:

• System Variables
• TiDB 7.1.0 Release Notes

authentication_ldap_simple_bind_base_dn

Referenced in:

• System Variables
• TiDB 7.1.0 Release Notes

authentication_ldap_simple_bind_root_dn

Referenced in:

• System Variables
• TiDB 7.1.0 Release Notes

authentication_ldap_simple_bind_root_pwd

Referenced in:

• System Variables
• TiDB 7.1.0 Release Notes

authentication_ldap_simple_ca_path

Referenced in:

• System Variables
• TiDB 7.1.0 Release Notes

authentication_ldap_simple_init_pool_size

Referenced in:

• System Variables
• TiDB 7.1.0 Release Notes

authentication_ldap_simple_max_pool_size

Referenced in:

• System Variables
• TiDB 7.1.0 Release Notes

authentication_ldap_simple_server_host

Referenced in:

• System Variables
• TiDB 7.1.0 Release Notes

authentication_ldap_simple_server_port

Referenced in:

• System Variables
• TiDB 7.1.0 Release Notes

authentication_ldap_simple_tls

Referenced in:

• System Variables
• TiDB 7.1.0 Release Notes

auto_increment_increment

Referenced in:

• AUTO_INCREMENT
• AUTO_RANDOM
• Bidirectional Replication
• Error Codes and Troubleshooting
• SESSION_VARIABLES
• System Variables
• VARIABLES_INFO
• TiDB 7.1.6 Release Notes
• TiDB 6.5.10 Release Notes
• TiDB 3.0.9 Release Notes

auto_increment_offset

Referenced in:

• AUTO_INCREMENT
• AUTO_RANDOM
• Bidirectional Replication
• Error Codes and Troubleshooting
• SESSION_VARIABLES
• System Variables
• VARIABLES_INFO
• TiDB 7.1.6 Release Notes
• TiDB 6.5.10 Release Notes
• TiDB 3.0.9 Release Notes

autocommit

Referenced in:

• Non-Transactional DML Statements
• System Variables
• Transactions

block_encryption_mode

Referenced in:

• Encryption and Compression Functions
• System Variables

character_set_client

Referenced in:

• Character Set and Collation
• GBK
• SET [NAMES|CHARACTER SET]
• System Variables
• Use Dumpling to Export Data
• VIEWS
• Views
• Views

character_set_connection

Referenced in:

• Character Set and Collation
• GBK
• SET [NAMES|CHARACTER SET]
• System Variables
• Use Dumpling to Export Data

character_set_database

Referenced in:

• Character Set and Collation
• SET [NAMES|CHARACTER SET]
• System Variables

character_set_results

Referenced in:

• Character Set and Collation
• SET [NAMES|CHARACTER SET]
• System Variables
• TiDB 6.2.0 Release Notes
• TiDB 2.1 RC1 Release Notes

character_set_server

Referenced in:

• Character Set and Collation
• SET [NAMES|CHARACTER SET]
• System Variables
• TiDB 5.3 Release Notes

collation_connection

Referenced in:

• Character Set and Collation
• String Functions
• System Variables
• VIEWS
• Views
• Views

collation_database

Referenced in:

• Character Set and Collation
• System Variables

collation_server

Referenced in:

• Character Set and Collation
• System Variables
• TiDB 5.3 Release Notes
• TiDB 5.1 Release Notes
• TiDB 5.0.2 Release Notes

cte_max_recursion_depth

Referenced in:

• Highly Concurrent Write Best Practices
• System Variables
• TiDB 5.1 Release Notes

datadir

Referenced in:

• System Variables

ddl_slow_threshold

Referenced in:

• SHOW [GLOBAL|SESSION] VARIABLES
• System Variables

default_authentication_plugin

Referenced in:

• Security Compatibility with MySQL
• System Variables
• TiDB Features
• TiDB 7.1.0 Release Notes
• TiDB 6.3.0 Release Notes
• TiDB 5.2 Release Notes

default_collation_for_utf8mb4

Referenced in:

• Character Set and Collation
• System Variables
• TiDB 8.1.2 Release Notes
• TiDB 7.5.5 Release Notes
• TiDB 7.4.0 Release Notes

default_password_lifetime

Referenced in:

• System Variables
• TiDB Password Management
• TiDB 6.5.0 Release Notes

default_week_format

Referenced in:

• Date and Time Functions
• System Variables
• TiDB 4.0.11 Release Notes
• TiDB 2.1.7 Release Notes

disconnect_on_expired_password

Referenced in:

• System Variables
• TiDB 6.5.0 Release Notes

div_precision_increment

Referenced in:

• Numeric Functions and Operators
• System Variables
• TiDB 8.0.0 Release Notes

error_count

Referenced in:

• System Variables
• TiDB 2.1 RC1 Release Notes

foreign_key_checks

Referenced in:

• FOREIGN KEY Constraints
• System Variables
• TiDB 6.6.0 Release Notes

group_concat_max_len

Referenced in:

• Aggregate (GROUP BY) Functions
• System Variables
• TiDB 4.0.13 Release Notes

have_openssl

Referenced in:

• Certificate-Based Authentication for Login
• System Variables

have_ssl

Referenced in:

• Certificate-Based Authentication for Login
• System Variables

hostname

Referenced in:

• System Variables

identity

Referenced in:

• System Variables

init_connect

Referenced in:

• System Variables
• TiDB 6.3.0 Release Notes
• TiDB 5.1 Release Notes
• TiDB 5.0.4 Release Notes
• TiDB 4.0.14 Release Notes

innodb_lock_wait_timeout

Referenced in:

• System Variables
• TiDB Pessimistic Transaction Mode
• TiKV Configuration File
• Troubleshoot Lock Conflicts
• TiDB 3.0.6 Release Notes

interactive_timeout

Referenced in:

• Limited SQL features on TiDB Cloud
• System Variables
• TiDB Cluster Management FAQs
• Timeouts in TiDB
• TiDB 3.0 Beta Release Notes
• TiDB 3.0 GA Release Notes

last_insert_id

Referenced in:

• AUTO_RANDOM
• Connect to TiDB with mysql2
• Information Functions
• SHOW BUILTINS
• SQL Prepared Execution Plan Cache
• System Variables
• TiDB 7.2.0 Release Notes
• TiDB 3.1 RC Release Notes
• TiDB 2.1.17 Release Notes
• TiDB 2.1 RC2 Release Notes

last_plan_from_binding

Referenced in:

• SQL Plan Management (SPM)
• System Variables
• TiDB 4.0.12 Release Notes

last_plan_from_cache

Referenced in:

• Index Selection
• SQL Non-Prepared Execution Plan Cache
• SQL Prepared Execution Plan Cache
• System Variables
• TiDB 4.0.2 Release Notes

last_sql_use_alloc

Referenced in:

• System Variables
• TiDB 6.4.0 Release Notes

license

Referenced in:

• System Variables

max_allowed_packet

Referenced in:

• DM Advanced Task Configuration File
• Handle Errors in TiDB Data Migration
• Limited SQL features on TiDB Cloud
• System Variables
• TiDB Configuration File
• TiDB Data Migration FAQs
• TiDB Lightning Configuration
• TiDB 6.1.0 Release Notes
• TiDB 5.2.4 Release Notes
• TiDB 3.0.2 Release Notes
• TiDB 2.1.5 Release Notes
• TiDB 2.1 RC2 Release Notes
• TiDB 2.0.6 Release Notes

max_connections

Referenced in:

• Integrate TiDB with ProxySQL
• Modify Configuration Dynamically
• Precheck Errors, Migration Errors, and Alerts for Data Migration
• System Variables
• TiDB Cluster Management FAQs
• TiDB Configuration File

max_execution_time

Referenced in:

• Best Practices for Developing Java Applications with TiDB
• Connection Pools and Connection Parameters
• Optimizer Hints
• SQL Plan Management (SPM)
• SQL Prepared Execution Plan Cache
• System Variables
• Timeouts in TiDB
• Troubleshoot TiDB OOM Issues
• TiDB 6.4.0 Release Notes
• TiDB 4.0.2 Release Notes
• TiDB 2.1.14 Release Notes

max_prepared_stmt_count

Referenced in:

• PREPARE
• System Variables
• Troubleshoot TiDB OOM Issues
• TiDB 6.5.2 Release Notes

mpp_exchange_compression_mode

Referenced in:

• Explain Statements in the MPP Mode
• System Variables
• TiDB 6.6.0 Release Notes

mpp_version

Referenced in:

• Explain Statements in the MPP Mode
• System Variables
• TiDB 6.6.0 Release Notes

password_history

Referenced in:

• Security Compatibility with MySQL
• System Variables
• TiDB Password Management
• mysql Schema
• TiDB 6.5.0 Release Notes

password_reuse_interval

Referenced in:

• System Variables
• TiDB Password Management
• TiDB 6.5.0 Release Notes

pd_enable_follower_handle_region

Referenced in:

• System Variables
• TiDB Features
• Tune Region Performance
• tidb-performance-tuning-config
• TiDB 8.5.0 Release Notes
• TiDB 7.6.0 Release Notes

plugin_dir

Referenced in:

• Limited SQL features on TiDB Cloud
• System Variables
• TiDB 5.3 Release Notes

plugin_load

Referenced in:

• Limited SQL features on TiDB Cloud
• System Variables

port

Referenced in:

• System Variables

rand_seed1

Referenced in:

• System Variables

rand_seed2

Referenced in:

• System Variables

require_secure_transport

Referenced in:

• Enable TLS between TiDB Clients and Servers
• Limited SQL features on TiDB Cloud
• System Variables
• TLS Connections to TiDB Cloud Dedicated
• TiDB Cloud Release Notes in 2022
• TiDB 8.0.0 Release Notes
• TiDB 7.5.1 Release Notes
• TiDB 7.1.2 Release Notes
• TiDB 6.5.6 Release Notes
• TiDB 6.1.0 Release Notes

skip_name_resolve

Referenced in:

• Limited SQL features on TiDB Cloud
• System Variables

socket

Referenced in:

• System Variables

sql_mode

Referenced in:

• Aggregate (GROUP BY) Functions
• DM Advanced Task Configuration File
• Date and Time Types
• Miscellaneous Functions
• Partitioning
• Precision Math
• Privilege Management
• SHOW ERRORS
• SHOW WARNINGS
• SQL FAQs
• SQL Mode
• Schema Object Names
• System Variables
• TiDB Lightning FAQs
• TiDB User Account Management
• TiFlash Query Result Materialization
• Unstable Result Set
• Use TiDB to Read TiFlash Replicas
• SET [GLOBAL|SESSION] <variable>
• TiDB 8.5.0 Release Notes
• TiDB 8.1.0 Release Notes
• TiDB 8.0.0 Release Notes
• TiDB 7.6.0 Release Notes
• TiDB 7.5.5 Release Notes
• TiDB 7.5.3 Release Notes
• TiDB 7.5.2 Release Notes
• TiDB 7.5.1 Release Notes
• TiDB 7.1.5 Release Notes
• TiDB 7.1.4 Release Notes
• TiDB 7.1.0 Release Notes
• TiDB 6.5.9 Release Notes
• TiDB 6.5.7 Release Notes
• TiDB 5.4.1 Release Notes
• TiDB 5.1 Release Notes
• TiDB 5.0.2 Release Notes
• TiDB 4.0.16 Release Notes
• TiDB RC2 Release Notes

sql_require_primary_key

Referenced in:

• DM Advanced Task Configuration File
• System Variables
• TiDB 6.3.0 Release Notes

sql_select_limit

Referenced in:

• SQL Prepared Execution Plan Cache
• System Variables
• TiDB 4.0.2 Release Notes

ssl_ca

Referenced in:

• Certificate-Based Authentication for Login
• Connect to TiDB with Django
• Connect to TiDB with MySQL Connector/Python
• Connect to TiDB with PyMySQL
• Connect to TiDB with SQLAlchemy
• Connect to TiDB with peewee
• Get Started with TiDB + AI via Python
• Integrate TiDB Vector Search with Jina AI Embeddings API
• Integrate TiDB Vector Search with SQLAlchemy
• Integrate Vector Search with LangChain
• Integrate Vector Search with LlamaIndex
• System Variables

ssl_cert

Referenced in:

• Certificate-Based Authentication for Login
• System Variables

ssl_key

Referenced in:

• Certificate-Based Authentication for Login
• System Variables

system_time_zone

Referenced in:

• System Variables
• Time Zone Support
• TiDB 3.0.8 Release Notes

tidb_adaptive_closest_read_threshold

Referenced in:

• Follower Read
• System Variables
• TiDB 6.5.0 Release Notes
• TiDB 6.3.0 Release Notes

tidb_allow_batch_cop

Referenced in:

• SHOW [GLOBAL|SESSION] VARIABLES
• System Variables
• TiDB 4.0.3 Release Notes
• TiDB 4.0 RC.2 Release Notes

tidb_allow_fallback_to_tikv

Referenced in:

• System Variables
• TiDB 5.0 Release Notes

tidb_allow_function_for_expression_index

Referenced in:

• CREATE INDEX
• System Variables
• TiDB Configuration File
• TiDB Features

tidb_allow_mpp

Referenced in:

• Explain Statements in the MPP Mode
• Explore HTAP
• System Variables
• TiFlash Query Result Materialization
• Use TiFlash MPP Mode
• TiDB 7.3.0 Release Notes
• TiDB 7.1.0 Release Notes

tidb_allow_remove_auto_inc

Referenced in:

• AUTO_INCREMENT
• Known Incompatibility Issues with Third-Party Tools
• MySQL Compatibility
• SHOW [GLOBAL|SESSION] VARIABLES
• System Variables
• TiDB 3.0.4 Release Notes
• TiDB 2.1.18 Release Notes

tidb_allow_tiflash_cop

Referenced in:

• System Variables
• TiDB 7.3.0 Release Notes

tidb_analyze_column_options

Referenced in:

• How to Run CH-benCHmark Test on TiDB
• Stress Test TiDB Using TiUP Bench Component
• System Variables
• tidb-performance-tuning-config
• TiDB 8.3.0 Release Notes

tidb_analyze_distsql_scan_concurrency

Referenced in:

• System Variables
• TiDB 8.2.0 Release Notes
• TiDB 7.6.0 Release Notes

tidb_analyze_partition_concurrency

Referenced in:

• Introduction to Statistics
• System Variables
• TiDB 8.4.0 Release Notes
• TiDB 8.2.0 Release Notes
• TiDB 8.1.1 Release Notes
• TiDB 7.5.3 Release Notes
• TiDB 7.5.0 Release Notes

tidb_analyze_skip_column_types

Referenced in:

• Introduction to Statistics
• System Variables
• TiDB 8.2.0 Release Notes
• TiDB 7.2.0 Release Notes

tidb_analyze_version

Referenced in:

• ANALYZE_STATUS
• Introduction to Statistics
• SHOW ANALYZE STATUS
• System Variables
• TiDB Memory Control
• Troubleshoot TiDB OOM Issues
• TiDB 7.2.0 Release Notes
• TiDB 6.1.0 Release Notes
• TiDB 5.4 Release Notes
• TiDB 5.3 Release Notes
• TiDB 5.2.4 Release Notes
• TiDB 5.1.4 Release Notes
• TiDB 5.1 Release Notes

tidb_auto_analyze_concurrency

Referenced in:

• System Variables
• TiDB 8.4.0 Release Notes

tidb_auto_analyze_end_time

Referenced in:

• Introduction to Statistics
• SHOW [GLOBAL|SESSION] VARIABLES
• System Variables
• TiDB Troubleshooting Map
• Troubleshoot Increased Read and Write Latency
• TiDB 5.3 Release Notes

tidb_auto_analyze_partition_batch_size

Referenced in:

• Introduction to Statistics
• System Variables
• TiDB 7.6.0 Release Notes
• TiDB 6.4.0 Release Notes

tidb_auto_analyze_ratio

Referenced in:

• Introduction to Statistics
• SHOW STATS_HEALTHY
• SHOW [GLOBAL|SESSION] VARIABLES
• SQL FAQs
• System Variables
• TiDB Troubleshooting Map
• Troubleshoot Increased Read and Write Latency
• EXPLAIN Walkthrough
• TiDB 8.1.0 Release Notes
• TiDB 2.0.1 Release Notes

tidb_auto_analyze_start_time

Referenced in:

• Introduction to Statistics
• SHOW [GLOBAL|SESSION] VARIABLES
• System Variables
• TiDB Troubleshooting Map
• Troubleshoot Increased Read and Write Latency
• TiDB 5.3 Release Notes

tidb_auto_build_stats_concurrency

Referenced in:

• System Variables
• TiDB 6.5.0 Release Notes

tidb_backoff_lock_fast

Referenced in:

• SHOW [GLOBAL|SESSION] VARIABLES
• System Variables
• TiDB 5.4 Release Notes

tidb_backoff_weight

Referenced in:

• SHOW [GLOBAL|SESSION] VARIABLES
• System Variables
• TiDB 3.0.3 Release Notes

tidb_batch_commit

Referenced in:

• SHOW [GLOBAL|SESSION] VARIABLES
• System Variables
• TiDB 3.0 Beta Release Notes
• TiDB 3.0 GA Release Notes

tidb_batch_delete

Referenced in:

• SHOW [GLOBAL|SESSION] VARIABLES
• System Variables

tidb_batch_insert

Referenced in:

• System Variables
• TiDB 2.0.6 Release Notes

tidb_batch_pending_tiflash_count

Referenced in:

• System Variables

tidb_broadcast_join_threshold_count

Referenced in:

• Explain Statements in the MPP Mode
• System Variables
• Tune TiFlash Performance
• Use TiFlash MPP Mode
• TiDB 7.1.0 Release Notes

tidb_broadcast_join_threshold_size

Referenced in:

• Explain Statements in the MPP Mode
• System Variables
• Tune TiFlash Performance
• Use TiFlash MPP Mode
• TiDB 7.1.0 Release Notes

tidb_build_sampling_stats_concurrency

Referenced in:

• Introduction to Statistics
• System Variables
• TiDB 7.5.0 Release Notes

tidb_build_stats_concurrency

Referenced in:

• Introduction to Statistics
• SHOW [GLOBAL|SESSION] VARIABLES
• System Variables
• TiDB Cloud TPC-C Performance Test Report for TiDB v6.5.6
• TiDB Cloud TPC-C Performance Test Report for TiDB v7.1.3
• TiDB Cloud TPC-C Performance Test Report for TiDB v7.5.0
• TiDB Cloud TPC-C Performance Test Report for TiDB v8.1.0
• TiDB 7.5.0 Release Notes

tidb_capture_plan_baselines

Referenced in:

• SHOW [GLOBAL|SESSION] VARIABLES
• SQL Plan Management (SPM)
• System Variables
• TiDB 5.0 Release Notes
• TiDB 4.0 RC.1 Release Notes

tidb_cdc_write_source

Referenced in:

• Limited SQL features on TiDB Cloud
• System Variables
• TiDB 6.5.0 Release Notes

tidb_check_mb4_value_in_utf8

Referenced in:

• Character Set and Collation
• Limited SQL features on TiDB Cloud
• SHOW [GLOBAL|SESSION] VARIABLES
• System Variables
• TiDB Configuration File
• Upgrade and After Upgrade FAQs

tidb_checksum_table_concurrency

Referenced in:

• SHOW [GLOBAL|SESSION] VARIABLES
• System Variables
• TiDB Lightning Configuration

tidb_cloud_storage_uri

Referenced in:

• IMPORT INTO
• System Variables
• TiDB Global Sort
• TiDB 8.1.1 Release Notes
• TiDB 7.4.0 Release Notes

tidb_committer_concurrency

Referenced in:

• System Variables
• TiDB Cloud Release Notes in 2022
• TiDB Monitoring Metrics
• TiDB 6.1.0 Release Notes

tidb_config

Referenced in:

• Limited SQL features on TiDB Cloud
• SHOW [GLOBAL|SESSION] VARIABLES
• System Variables
• TiDB 6.2.0 Release Notes
• TiDB 1.1 Beta Release Notes

tidb_constraint_check_in_place

Referenced in:

• COMMIT
• Constraints
• DM Advanced Task Configuration File
• SHOW [GLOBAL|SESSION] VARIABLES
• System Variables
• Transactions
• TiDB 2.1.5 Release Notes

tidb_constraint_check_in_place_pessimistic

Referenced in:

• Constraints
• Error Codes and Troubleshooting
• Modify Configuration Dynamically
• SAVEPOINT
• System Variables
• TiDB Configuration File
• TiDB Pessimistic Transaction Mode
• TiDB 6.5.0 Release Notes
• TiDB 6.4.0 Release Notes
• TiDB 6.3.0 Release Notes

tidb_cost_model_version

Referenced in:

• Cost Model
• System Variables
• TiDB 6.5.0 Release Notes
• TiDB 6.2.0 Release Notes

tidb_current_ts

Referenced in:

• DR Solution Based on Primary and Secondary Clusters
• FLASHBACK CLUSTER
• Read Historical Data Using the tidb_external_ts Variable
• SHOW [GLOBAL|SESSION] VARIABLES
• System Variables
• TiDB Specific Functions
• TimeStamp Oracle (TSO) in TiDB
• Upstream and Downstream Clusters Data Validation and Snapshot Read

tidb_ddl_disk_quota

Referenced in:

• Limited SQL features on TiDB Cloud
• System Variables
• TiDB Distributed eXecution Framework (DXF)
• TiDB 6.3.0 Release Notes

tidb_ddl_enable_fast_reorg

Referenced in:

• ADMIN SHOW DDL [JOBS|JOB QUERIES]
• CREATE INDEX
• IMPORT INTO
• Limited SQL features on TiDB Cloud
• System Variables
• TiDB Configuration File
• TiDB Distributed eXecution Framework (DXF)
• TiDB Environment and System Configuration Check
• TiDB Features
• TiDB Software and Hardware Requirements
• TiDB 8.5.0 Release Notes
• TiDB 8.1.2 Release Notes
• TiDB 8.0.0 Release Notes
• TiDB 7.5.5 Release Notes
• TiDB 7.5.0 Release Notes
• TiDB 7.1.0 Release Notes
• TiDB 7.0.0 Release Notes
• TiDB 6.5.0 Release Notes
• TiDB 6.3.0 Release Notes

tidb_ddl_error_count_limit

Referenced in:

• Limited SQL features on TiDB Cloud
• SHOW [GLOBAL|SESSION] VARIABLES
• SQL FAQs
• System Variables
• TiDB Distributed eXecution Framework (DXF)

tidb_ddl_flashback_concurrency

Referenced in:

• Limited SQL features on TiDB Cloud
• System Variables
• TiDB 6.4.0 Release Notes
• TiDB 6.3.0 Release Notes

tidb_ddl_reorg_batch_size

Referenced in:

• ADMIN ALTER DDL JOBS
• ADMIN SHOW DDL [JOBS|JOB QUERIES]
• CREATE INDEX
• Execution Principles and Best Practices of DDL Statements
• Limited SQL features on TiDB Cloud
• Performance Tuning Best Practices
• SHOW [GLOBAL|SESSION] VARIABLES
• SQL FAQs
• System Variables
• TiDB Distributed eXecution Framework (DXF)
• Troubleshoot Increased Read and Write Latency
• EXPLAIN Walkthrough
• TiDB 8.5.0 Release Notes
• TiDB 8.3.0 Release Notes
• TiDB 3.0.3 Release Notes
• TiDB 2.1.4 Release Notes

tidb_ddl_reorg_max_write_speed

Referenced in:

• ADMIN ALTER DDL JOBS
• ADMIN SHOW DDL [JOBS|JOB QUERIES]
• System Variables
• TiDB 8.5.0 Release Notes
• TiDB 7.5.5 Release Notes

tidb_ddl_reorg_priority

Referenced in:

• CREATE INDEX
• Limited SQL features on TiDB Cloud
• SHOW [GLOBAL|SESSION] VARIABLES
• SQL FAQs
• System Variables
• TiDB Distributed eXecution Framework (DXF)
• Troubleshoot Increased Read and Write Latency
• TiDB 2.1 RC1 Release Notes

tidb_ddl_reorg_worker_cnt

Referenced in:

• ADMIN ALTER DDL JOBS
• ADMIN SHOW DDL [JOBS|JOB QUERIES]
• CREATE INDEX
• Execution Principles and Best Practices of DDL Statements
• Limited SQL features on TiDB Cloud
• Performance Tuning Best Practices
• SHOW [GLOBAL|SESSION] VARIABLES
• SQL FAQs
• System Variables
• TiDB Distributed eXecution Framework (DXF)
• Troubleshoot Increased Read and Write Latency
• EXPLAIN Walkthrough
• TiDB 8.5.0 Release Notes
• TiDB 8.3.0 Release Notes
• TiDB 8.0.0 Release Notes
• TiDB 3.0.3 Release Notes
• TiDB 2.1.4 Release Notes

tidb_default_string_match_selectivity

Referenced in:

• System Variables
• TiDB 6.2.0 Release Notes

tidb_disable_txn_auto_retry

Referenced in:

• How to Test TiDB Using Sysbench
• SHOW [GLOBAL|SESSION] VARIABLES
• System Variables
• TiDB Optimistic Transaction Model
• Transactions
• TiDB 8.0.0 Release Notes
• TiDB 7.6.0 Release Notes
• TiDB 3.0.0-rc.2 Release Notes
• TiDB 3.0 GA Release Notes
• TiDB 2.1 Beta Release Notes
• TiDB 2.1 GA Release Notes
• TiDB 2.0.5 Release Notes

tidb_distsql_scan_concurrency

Referenced in:

• Introduction to Statistics
• SHOW [GLOBAL|SESSION] VARIABLES
• SLOW_QUERY
• SQL FAQs
• System Variables
• TiDB Best Practices
• TiDB Cloud TPC-C Performance Test Report for TiDB v6.5.6
• TiDB Cloud TPC-C Performance Test Report for TiDB v7.1.3
• TiDB Cloud TPC-C Performance Test Report for TiDB v7.5.0
• TiDB Cloud TPC-C Performance Test Report for TiDB v8.1.0
• TiDB Memory Control
• Troubleshoot TiDB OOM Issues
• Use Dumpling to Export Data
• TiDB 6.4.0 Release Notes

tidb_dml_batch_size

Referenced in:

• LOAD DATA
• SHOW [GLOBAL|SESSION] VARIABLES
• System Variables
• TiDB 7.6.0 Release Notes
• TiDB 7.0.0 Release Notes
• TiDB 5.0 Release Notes
• TiDB 4.0 Beta Release Notes

tidb_dml_type

Referenced in:

• IMPORT INTO vs. TiDB Lightning
• Identify Expensive Queries
• System Variables
• TiDB Configuration File
• TiDB Features
• TiDB Memory Control
• tidb-performance-tuning-config
• TiDB 8.4.0 Release Notes
• TiDB 8.3.0 Release Notes
• TiDB 8.1.0 Release Notes
• TiDB 8.0.0 Release Notes

tidb_enable_1pc

Referenced in:

• Limited SQL features on TiDB Cloud
• System Variables
• TiDB Cluster Management FAQs
• TiDB Features
• Transactions
• TiDB 5.0 Release Notes

tidb_enable_analyze_snapshot

Referenced in:

• System Variables
• TiDB 6.2.0 Release Notes

tidb_enable_async_commit

Referenced in:

• Limited SQL features on TiDB Cloud
• System Variables
• TiDB Cluster Management FAQs
• TiDB Features
• Transactions
• TiDB 5.0 Release Notes
• TiDB 5.0 RC Release Notes

tidb_enable_async_merge_global_stats

Referenced in:

• System Variables
• TiDB 8.5.0 Release Notes
• TiDB 8.4.0 Release Notes
• TiDB 8.3.0 Release Notes
• TiDB 8.2.0 Release Notes
• TiDB 8.1.1 Release Notes
• TiDB 7.5.3 Release Notes
• TiDB 7.5.0 Release Notes

tidb_enable_auto_analyze

Referenced in:

• Introduction to Statistics
• Limited SQL features on TiDB Cloud
• SQL FAQs
• System Variables
• Use PLAN REPLAYER to Save and Restore the On-Site Information of a Cluster
• tidb-performance-tuning-config
• TiDB 6.1.0 Release Notes

tidb_enable_auto_analyze_priority_queue

Referenced in:

• Introduction to Statistics
• System Variables
• TiDB 8.5.0 Release Notes
• TiDB 8.4.0 Release Notes
• TiDB 8.3.0 Release Notes
• TiDB 8.2.0 Release Notes
• TiDB 8.0.0 Release Notes

tidb_enable_auto_increment_in_generated

Referenced in:

• CREATE INDEX
• System Variables
• TiDB 5.2 Release Notes

tidb_enable_batch_dml

Referenced in:

• System Variables
• TiDB Cloud Release Notes in 2022

tidb_enable_cascades_planner

Referenced in:

• SHOW [GLOBAL|SESSION] VARIABLES
• System Variables
• TiDB Features
• TiDB 3.0 Beta Release Notes

tidb_enable_check_constraint

Referenced in:

• CHECK_CONSTRAINTS
• Constraints
• System Variables
• TIDB_CHECK_CONSTRAINTS
• TiDB 7.2.0 Release Notes

tidb_enable_chunk_rpc

Referenced in:

• SHOW [GLOBAL|SESSION] VARIABLES
• System Variables

tidb_enable_clustered_index

Referenced in:

• Clustered Indexes
• Create a Table
• System Variables
• TiDB Backup & Restore Overview
• TiDB Configuration File
• TiDB Database Schema Design Overview
• TiDB Lightning Configuration
• TiDB 6.4.0 Release Notes
• TiDB 5.0 Release Notes
• TiDB 5.0 RC Release Notes

tidb_enable_collect_execution_info

Referenced in:

• Identify Slow Queries
• Limited SQL features on TiDB Cloud
• Modify Configuration Dynamically
• SHOW [GLOBAL|SESSION] VARIABLES
• System Variables
• TIDB_INDEX_USAGE
• TiDB Configuration File
• TiDB 8.0.0 Release Notes
• TiDB 7.6.0 Release Notes
• TiDB 7.5.1 Release Notes
• TiDB 4.0.2 Release Notes

tidb_enable_column_tracking

Referenced in:

• System Variables
• TiDB 8.3.0 Release Notes
• TiDB 8.2.0 Release Notes
• TiDB 5.4 Release Notes

tidb_enable_ddl

Referenced in:

• Limited SQL features on TiDB Cloud
• Modify Configuration Dynamically
• System Variables
• TiDB Configuration File
• Topology Configuration File for TiDB Deployment Using TiUP

tidb_enable_dist_task

Referenced in:

• ADMIN ALTER DDL JOBS
• ADMIN SHOW DDL [JOBS|JOB QUERIES]
• IMPORT INTO
• System Variables
• TiDB Distributed eXecution Framework (DXF)
• TiDB Global Sort
• TiDB Smooth Upgrade
• TiDB 8.1.0 Release Notes
• TiDB 7.5.0 Release Notes
• TiDB 7.3.0 Release Notes
• TiDB 7.1.0 Release Notes

tidb_enable_enhanced_security

Referenced in:

• BACKUP
• IMPORT INTO
• Limited SQL features on TiDB Cloud
• System Variables
• TiDB Configuration File
• TiDB Dashboard User Management
• TiDB Features
• TiDB 5.1 Release Notes

tidb_enable_exchange_partition

Referenced in:

• System Variables
• TiDB 7.1.0 Release Notes
• TiDB 6.3.0 Release Notes

tidb_enable_extended_stats

Referenced in:

• Introduction to Extended Statistics
• System Variables

tidb_enable_external_ts_read

Referenced in:

• DR Solution Based on Primary and Secondary Clusters
• Read Historical Data Using the tidb_external_ts Variable
• System Variables
• Upstream and Downstream Clusters Data Validation and Snapshot Read
• TiDB 6.4.0 Release Notes

tidb_enable_fast_analyze

Referenced in:

• Introduction to Extended Statistics
• System Variables
• TiDB Features
• TiDB 7.5.0 Release Notes
• TiDB 7.3.0 Release Notes
• TiDB 3.0.0-rc.1 Release Notes

tidb_enable_fast_create_table

Referenced in:

• System Variables
• TiDB Accelerated Table Creation
• TiDB 8.5.0 Release Notes
• TiDB 8.3.0 Release Notes
• TiDB 8.0.0 Release Notes

tidb_enable_fast_table_check

Referenced in:

• System Variables
• TiDB 7.2.0 Release Notes

tidb_enable_foreign_key

Referenced in:

• System Variables
• TiDB 6.6.0 Release Notes
• TiDB 6.3.0 Release Notes

tidb_enable_gc_aware_memory_track

Referenced in:

• Limited SQL features on TiDB Cloud
• System Variables
• TiDB 6.5.0 Release Notes

tidb_enable_global_index

Referenced in:

• System Variables
• TiDB 8.4.0 Release Notes
• TiDB 8.3.0 Release Notes
• TiDB 7.6.0 Release Notes

tidb_enable_gogc_tuner

Referenced in:

• Limited SQL features on TiDB Cloud
• System Variables
• TiDB 6.4.0 Release Notes

tidb_enable_historical_stats

Referenced in:

• System Variables
• Use PLAN REPLAYER to Save and Restore the On-Site Information of a Cluster
• TiDB 8.2.0 Release Notes
• TiDB 6.6.0 Release Notes

tidb_enable_historical_stats_for_capture

Referenced in:

• System Variables
• TiDB 6.6.0 Release Notes

tidb_enable_index_merge

Referenced in:

• Explain Statements Using Index Merge
• Index Selection
• Optimizer Hints
• SHOW [GLOBAL|SESSION] VARIABLES
• System Variables
• TiDB 5.4 Release Notes

tidb_enable_index_merge_join

Referenced in:

• System Variables

tidb_enable_inl_join_inner_multi_pattern

Referenced in:

• Optimizer Hints
• System Variables
• tidb-performance-tuning-config
• TiDB 8.4.0 Release Notes
• TiDB 8.3.0 Release Notes
• TiDB 7.0.0 Release Notes

tidb_enable_instance_plan_cache

Referenced in:

• System Variables
• TiDB Features
• tidb-performance-tuning-config
• TiDB 8.4.0 Release Notes

tidb_enable_lazy_cursor_fetch

Referenced in:

• Best Practices for Developing Java Applications with TiDB
• Connection Pools and Connection Parameters
• System Variables
• TiDB 8.3.0 Release Notes

tidb_enable_legacy_instance_scope

Referenced in:

• System Variables

tidb_enable_list_partition

Referenced in:

• System Variables
• TiDB 8.4.0 Release Notes
• TiDB 6.1.0 Release Notes
• TiDB 5.0 Release Notes

tidb_enable_local_txn

Referenced in:

• Limited SQL features on TiDB Cloud
• System Variables

tidb_enable_metadata_lock

Referenced in:

• Metadata Lock
• System Variables
• TiDB 6.5.0 Release Notes
• TiDB 6.3.0 Release Notes

tidb_enable_mutation_checker

Referenced in:

• System Variables
• Troubleshoot Inconsistency Between Data and Indexes
• TiDB 6.0.0 Release Notes

tidb_enable_new_cost_interface

Referenced in:

• System Variables
• TiDB 6.2.0 Release Notes

tidb_enable_new_only_full_group_by_check

Referenced in:

• SQL Mode
• System Variables
• TiDB 6.1.0 Release Notes

tidb_enable_non_prepared_plan_cache

Referenced in:

• SQL Non-Prepared Execution Plan Cache
• System Variables
• tidb-performance-tuning-config
• TiDB 7.4.0 Release Notes
• TiDB 7.2.0 Release Notes
• TiDB 7.1.0 Release Notes
• TiDB 7.0.0 Release Notes
• TiDB 6.6.0 Release Notes

tidb_enable_non_prepared_plan_cache_for_dml

Referenced in:

• SQL Non-Prepared Execution Plan Cache
• System Variables
• TiDB 7.1.0 Release Notes

tidb_enable_noop_functions

Referenced in:

• Information Functions
• SELECT
• SHOW [GLOBAL|SESSION] VARIABLES
• System Variables
• TiDB Pessimistic Transaction Mode
• TiDB 5.3 Release Notes
• TiDB 5.1 Release Notes
• TiDB 5.0 Release Notes

tidb_enable_noop_variables

Referenced in:

• System Variables
• TiDB 6.2.0 Release Notes

tidb_enable_null_aware_anti_join

Referenced in:

• System Variables
• TiDB 7.0.0 Release Notes
• TiDB 6.3.0 Release Notes

tidb_enable_ordered_result_mode

Referenced in:

• SQL FAQs
• System Variables
• TiDB 7.1.3 Release Notes
• TiDB 6.5.6 Release Notes

tidb_enable_outer_join_reorder

Referenced in:

• Introduction to Join Reorder
• System Variables
• TiDB 6.5.0 Release Notes
• TiDB 6.2.0 Release Notes
• TiDB 6.1.1 Release Notes
• TiDB 6.1.0 Release Notes

tidb_enable_paging

Referenced in:

• SQL FAQs
• System Variables
• TiDB 6.4.0 Release Notes
• TiDB 6.2.0 Release Notes
• TiDB 5.4 Release Notes

tidb_enable_parallel_apply

Referenced in:

• System Variables
• TiDB 7.3.0 Release Notes
• TiDB 7.1.1 Release Notes
• TiDB 6.5.4 Release Notes
• TiDB 5.4.1 Release Notes

tidb_enable_parallel_hashagg_spill

Referenced in:

• System Variables
• TiDB Memory Control
• TiDB 8.5.0 Release Notes
• TiDB 8.4.0 Release Notes
• TiDB 8.3.0 Release Notes
• TiDB 8.2.0 Release Notes
• TiDB 8.1.1 Release Notes
• TiDB 8.0.0 Release Notes

tidb_enable_pipelined_window_function

Referenced in:

• System Variables
• Window Functions

tidb_enable_plan_cache_for_param_limit

Referenced in:

• System Variables
• TiDB 6.6.0 Release Notes

tidb_enable_plan_cache_for_subquery

Referenced in:

• System Variables
• TiDB 7.0.0 Release Notes

tidb_enable_plan_replayer_capture

Referenced in:

• System Variables
• Use PLAN REPLAYER to Save and Restore the On-Site Information of a Cluster
• TiDB 6.6.0 Release Notes

tidb_enable_plan_replayer_continuous_capture

Referenced in:

• System Variables
• Use PLAN REPLAYER to Save and Restore the On-Site Information of a Cluster
• TiDB 7.0.0 Release Notes

tidb_enable_prepared_plan_cache

Referenced in:

• How to Test TiDB Using Sysbench
• SQL Prepared Execution Plan Cache
• System Variables
• TiDB Cloud Release Notes in 2022
• TiDB Dashboard FAQs
• TiDB 7.5.1 Release Notes
• TiDB 7.1.4 Release Notes
• TiDB 6.4.0 Release Notes
• TiDB 6.1.0 Release Notes

tidb_enable_prepared_plan_cache_memory_monitor

Referenced in:

• System Variables
• TiDB 6.4.0 Release Notes

tidb_enable_pseudo_for_outdated_stats

Referenced in:

• SQL FAQs
• System Variables
• TiDB 6.3.0 Release Notes
• TiDB 5.3 Release Notes

tidb_enable_rate_limit_action

Referenced in:

• System Variables
• TiDB Memory Control
• Troubleshoot TiDB OOM Issues
• TiDB 6.3.0 Release Notes

tidb_enable_resource_control

Referenced in:

• ALTER RESOURCE GROUP
• CREATE RESOURCE GROUP
• DROP RESOURCE GROUP
• Error Codes and Troubleshooting
• Limited SQL features on TiDB Cloud
• SET RESOURCE GROUP
• System Variables
• TiKV Configuration File
• Use Resource Control to Achieve Resource Group Limitation and Flow Control
• CALIBRATE RESOURCE
• TiDB 7.4.0 Release Notes
• TiDB 7.0.0 Release Notes
• TiDB 6.6.0 Release Notes

tidb_enable_reuse_chunk

Referenced in:

• System Variables
• TiDB 6.5.1 Release Notes
• TiDB 6.4.0 Release Notes

tidb_enable_row_level_checksum

Referenced in:

• System Variables
• TiCDC Data Integrity Validation for Single-Row Data
• TiDB Specific Functions
• TiDB 8.0.0 Release Notes
• TiDB 7.5.1 Release Notes
• TiDB 7.1.0 Release Notes

tidb_enable_shared_lock_promotion

Referenced in:

• System Variables
• TiDB Pessimistic Transaction Mode
• TiDB 8.3.0 Release Notes

tidb_enable_slow_log

Referenced in:

• Identify Slow Queries
• Limited SQL features on TiDB Cloud
• Modify Configuration Dynamically
• SHOW [GLOBAL|SESSION] VARIABLES
• Slow Queries Page of TiDB Dashboard
• System Variables
• TiDB Configuration File

tidb_enable_stats_owner

Referenced in:

• System Variables
• TiDB Configuration File
• TiDB 8.4.0 Release Notes

tidb_enable_stmt_summary

Referenced in:

• Limited SQL features on TiDB Cloud
• SHOW [GLOBAL|SESSION] VARIABLES
• SQL Plan Management (SPM)
• Statement Summary Tables
• System Variables
• TiDB 3.0.4 Release Notes

tidb_enable_strict_double_type_check

Referenced in:

• System Variables
• TiDB 5.0 Release Notes

tidb_enable_table_partition

Referenced in:

• SHOW [GLOBAL|SESSION] VARIABLES
• System Variables
• TiDB 8.4.0 Release Notes
• TiDB 4.0.13 Release Notes
• TiDB 3.0.8 Release Notes

tidb_enable_telemetry

Referenced in:

• System Variables
• TiDB 8.1.0 Release Notes
• TiDB 6.6.0 Release Notes
• TiDB 6.5.1 Release Notes
• TiDB 6.1.5 Release Notes

tidb_enable_tiflash_read_for_write_stmt

Referenced in:

• System Variables
• Use TiDB to Read TiFlash Replicas
• TiDB 7.1.0 Release Notes
• TiDB 6.5.0 Release Notes
• TiDB 6.3.0 Release Notes

tidb_enable_tmp_storage_on_oom

Referenced in:

• Best Practices for Developing Java Applications with TiDB
• Connection Pools and Connection Parameters
• Enable Encryption for Disk Spill
• Explain Statements That Use Joins
• System Variables
• TiDB Configuration File
• TiDB Memory Control

tidb_enable_top_sql

Referenced in:

• Limited SQL features on TiDB Cloud
• System Variables
• TiDB Dashboard Top SQL Page
• TiDB 5.4 Release Notes

tidb_enable_tso_follower_proxy

Referenced in:

• Limited SQL features on TiDB Cloud
• PD Microservices
• System Variables
• TiDB Features
• TiDB 8.5.0 Release Notes
• TiDB 5.3 Release Notes

tidb_enable_unsafe_substitute

Referenced in:

• Generated Columns
• System Variables
• TiDB 6.3.0 Release Notes

tidb_enable_vectorized_expression

Referenced in:

• SHOW [GLOBAL|SESSION] VARIABLES
• System Variables
• TiDB 5.4.1 Release Notes
• TiDB 5.2.4 Release Notes
• TiDB 5.1.4 Release Notes
• TiDB 5.0.6 Release Notes
• TiDB 4.0.16 Release Notes

tidb_enable_window_function

Referenced in:

• SHOW [GLOBAL|SESSION] VARIABLES
• System Variables
• Window Functions
• TiDB 3.0.8 Release Notes

tidb_enforce_mpp

Referenced in:

• Explore HTAP
• System Variables
• TiDB Configuration File
• TiFlash Query Result Materialization
• Troubleshoot a TiFlash Cluster
• Tune TiFlash Performance
• Usage Scenarios of Stale Read
• Use TiFlash MPP Mode
• TiDB 7.4.0 Release Notes
• TiDB 5.4.2 Release Notes
• TiDB 5.1.5 Release Notes
• TiDB 5.1 Release Notes
• TiDB 5.0.4 Release Notes

tidb_evolve_plan_baselines

Referenced in:

• SHOW [GLOBAL|SESSION] VARIABLES
• SQL Plan Management (SPM)
• System Variables
• TiDB 5.2 Release Notes

tidb_evolve_plan_task_end_time

Referenced in:

• SHOW [GLOBAL|SESSION] VARIABLES
• SQL Plan Management (SPM)
• System Variables

tidb_evolve_plan_task_max_time

Referenced in:

• SHOW [GLOBAL|SESSION] VARIABLES
• SQL Plan Management (SPM)
• System Variables

tidb_evolve_plan_task_start_time

Referenced in:

• SHOW [GLOBAL|SESSION] VARIABLES
• SQL Plan Management (SPM)
• System Variables

tidb_executor_concurrency

Referenced in:

• System Variables
• Troubleshoot TiDB OOM Issues
• TiDB 8.5.0 Release Notes
• TiDB 8.2.0 Release Notes
• TiDB 5.0 Release Notes

tidb_expensive_query_time_threshold

Referenced in:

• Identify Expensive Queries
• Limited SQL features on TiDB Cloud
• Modify Configuration Dynamically
• SHOW [GLOBAL|SESSION] VARIABLES
• System Variables
• TiDB Configuration File

tidb_expensive_txn_time_threshold

Referenced in:

• System Variables
• TiDB 7.2.0 Release Notes

tidb_external_ts

Referenced in:

• DR Solution Based on Primary and Secondary Clusters
• Read Historical Data Using the tidb_external_ts Variable
• System Variables
• Upstream and Downstream Clusters Data Validation and Snapshot Read
• Usage Scenarios of Stale Read
• TiDB 6.4.0 Release Notes

tidb_force_priority

Referenced in:

• Limited SQL features on TiDB Cloud
• Modify Configuration Dynamically
• SHOW [GLOBAL|SESSION] VARIABLES
• SQL FAQs
• System Variables
• TiDB Configuration File
• TiDB 2.1.5 Release Notes
• TiDB 2.1 RC3 Release Notes

tidb_gc_concurrency

Referenced in:

• Garbage Collection Configuration
• Limited SQL features on TiDB Cloud
• System Variables
• TiDB 8.3.0 Release Notes
• TiDB 5.0 Release Notes

tidb_gc_enable

Referenced in:

• DR Solution Based on Primary and Secondary Clusters
• Garbage Collection Configuration
• Limited SQL features on TiDB Cloud
• Migrate Data from TiDB to MySQL-compatible Databases
• Migrate from One TiDB Cluster to Another TiDB Cluster
• Migrate from TiDB Self-Managed to TiDB Cloud
• Replicate Data Between Primary and Secondary Clusters
• System Variables
• TiDB Troubleshooting Map
• TiDB 5.0 Release Notes

tidb_gc_life_time

Referenced in:

• Error Codes and Troubleshooting
• FLASHBACK CLUSTER
• FLASHBACK DATABASE
• FLASHBACK TABLE
• Garbage Collection Configuration
• Read Historical Data Using the System Variable tidb_snapshot
• Replicate Data to Kafka
• SQL FAQs
• Sink to MySQL
• Sink to TiDB Cloud
• Stale Read
• System Variables
• TiCDC FAQs
• TiDB Incremental Backup and Restore Guide
• TiDB Troubleshooting Map
• TiKV MVCC In-Memory Engine
• Timeouts in TiDB
• Use Dumpling to Export Data
• TiDB 6.1.1 Release Notes
• TiDB 5.0 Release Notes

tidb_gc_max_wait_time

Referenced in:

• Garbage Collection Configuration
• Limited SQL features on TiDB Cloud
• System Variables
• TiDB 6.1.0 Release Notes

tidb_gc_run_interval

Referenced in:

• Garbage Collection Configuration
• Limited SQL features on TiDB Cloud
• System Variables
• TiDB 5.0 Release Notes

tidb_gc_scan_lock_mode

Referenced in:

• GC Overview
• Garbage Collection Configuration
• Limited SQL features on TiDB Cloud
• System Variables
• TiDB Features
• TiDB 5.0.4 Release Notes
• TiDB 5.0 Release Notes

tidb_general_log

Referenced in:

• Configuration Options
• Limited SQL features on TiDB Cloud
• SHOW [GLOBAL|SESSION] VARIABLES
• System Variables
• TiDB Configuration File
• TiDB Data Migration FAQs
• TiDB 8.0.0 Release Notes

tidb_generate_binary_plan

Referenced in:

• Limited SQL features on TiDB Cloud
• System Variables
• TiDB Specific Functions
• TiDB 6.2.0 Release Notes

tidb_gogc_tuner_max_value

Referenced in:

• System Variables
• TiDB 7.5.5 Release Notes
• TiDB 7.5.0 Release Notes

tidb_gogc_tuner_min_value

Referenced in:

• System Variables
• TiDB 7.5.5 Release Notes
• TiDB 7.5.0 Release Notes

tidb_gogc_tuner_threshold

Referenced in:

• Limited SQL features on TiDB Cloud
• System Variables
• TiDB 8.0.0 Release Notes
• TiDB 7.1.4 Release Notes
• TiDB 6.5.9 Release Notes
• TiDB 6.4.0 Release Notes

tidb_guarantee_linearizability

Referenced in:

• Limited SQL features on TiDB Cloud
• System Variables
• tidb-performance-tuning-config

tidb_hash_exchange_with_new_collation

Referenced in:

• System Variables

tidb_hash_join_concurrency

Referenced in:

• Analyze Slow Queries
• Best Practices for Three-Node Hybrid Deployment
• Explain Statements That Use Joins
• SHOW [GLOBAL|SESSION] VARIABLES
• System Variables

tidb_hash_join_version

Referenced in:

• System Variables
• TiDB 8.4.0 Release Notes

tidb_hashagg_final_concurrency

Referenced in:

• SHOW [GLOBAL|SESSION] VARIABLES
• System Variables

tidb_hashagg_partial_concurrency

Referenced in:

• SHOW [GLOBAL|SESSION] VARIABLES
• System Variables

tidb_historical_stats_duration

Referenced in:

• System Variables
• TiDB 6.6.0 Release Notes

tidb_idle_transaction_timeout

Referenced in:

• Connection Pools and Connection Parameters
• System Variables
• TiDB Cluster Management FAQs
• TiDB Features
• Timeouts in TiDB
• TiDB 7.6.0 Release Notes

tidb_ignore_prepared_cache_close_stmt

Referenced in:

• Performance Analysis and Tuning
• Performance Tuning Practices for OLTP Scenarios
• SQL Prepared Execution Plan Cache
• System Variables
• tidb-performance-tuning-config
• TiDB 6.0.0 Release Notes

tidb_index_join_batch_size

Referenced in:

• Explain Statements That Use Joins
• SHOW [GLOBAL|SESSION] VARIABLES
• System Variables

tidb_index_join_double_read_penalty_cost_rate

Referenced in:

• System Variables
• TiDB 6.6.0 Release Notes

tidb_index_lookup_concurrency

Referenced in:

• SHOW [GLOBAL|SESSION] VARIABLES
• System Variables
• TiDB Best Practices

tidb_index_lookup_join_concurrency

Referenced in:

• Best Practices for Three-Node Hybrid Deployment
• Explain Statements That Use Joins
• SHOW [GLOBAL|SESSION] VARIABLES
• System Variables

tidb_index_lookup_size

Referenced in:

• SHOW [GLOBAL|SESSION] VARIABLES
• System Variables
• TiDB Best Practices

tidb_index_merge_intersection_concurrency

Referenced in:

• System Variables
• TiDB 6.5.0 Release Notes

tidb_index_serial_scan_concurrency

Referenced in:

• Introduction to Statistics
• SHOW [GLOBAL|SESSION] VARIABLES
• System Variables
• TiDB Best Practices
• TiDB Cloud TPC-C Performance Test Report for TiDB v6.5.6
• TiDB Cloud TPC-C Performance Test Report for TiDB v7.1.3
• TiDB Cloud TPC-C Performance Test Report for TiDB v7.5.0
• TiDB Cloud TPC-C Performance Test Report for TiDB v8.1.0
• Troubleshoot TiDB OOM Issues

tidb_init_chunk_size

Referenced in:

• SHOW [GLOBAL|SESSION] VARIABLES
• System Variables
• TiDB Transaction Isolation Levels
• TiDB 3.0 Beta Release Notes

tidb_instance_plan_cache_max_size

Referenced in:

• System Variables
• tidb-performance-tuning-config
• TiDB 8.4.0 Release Notes

tidb_instance_plan_cache_reserved_percentage

Referenced in:

• System Variables
• TiDB 8.4.0 Release Notes

tidb_isolation_read_engines

Referenced in:

• Limited SQL features on TiDB Cloud
• SHOW [GLOBAL|SESSION] VARIABLES
• Stress Test TiDB Using TiUP Bench Component
• System Variables
• TiFlash Compatibility Notes
• Use FastScan
• Use TiDB to Read TiFlash Replicas
• TiDB 4.0.2 Release Notes

tidb_last_ddl_info

Referenced in:

• System Variables

tidb_last_plan_replayer_token

Referenced in:

• System Variables
• Use PLAN REPLAYER to Save and Restore the On-Site Information of a Cluster
• TiDB 6.3.0 Release Notes

tidb_last_query_info

Referenced in:

• System Variables
• Use Resource Control to Achieve Resource Group Limitation and Flow Control
• TiDB 7.6.0 Release Notes
• TiDB 7.5.1 Release Notes

tidb_last_txn_info

Referenced in:

• System Variables

tidb_load_based_replica_read_threshold

Referenced in:

• System Variables
• Troubleshoot Hotspot Issues
• TiDB 7.1.0 Release Notes
• TiDB 7.0.0 Release Notes

tidb_load_binding_timeout

Referenced in:

• System Variables
• TiDB 8.0.0 Release Notes

tidb_lock_unchanged_keys

Referenced in:

• System Variables
• TiDB 7.3.0 Release Notes
• TiDB 7.1.1 Release Notes

tidb_log_file_max_days

Referenced in:

• Limited SQL features on TiDB Cloud
• System Variables
• TiDB 6.2.0 Release Notes

tidb_low_resolution_tso

Referenced in:

• SHOW [GLOBAL|SESSION] VARIABLES
• System Variables
• tidb-performance-tuning-config
• TiDB 8.5.0 Release Notes
• TiDB 8.3.0 Release Notes
• TiDB 8.0.0 Release Notes
• TiDB 3.0.0-rc.2 Release Notes
• TiDB 3.0 GA Release Notes

tidb_low_resolution_tso_update_interval

Referenced in:

• System Variables
• TiDB 8.0.0 Release Notes

tidb_max_auto_analyze_time

Referenced in:

• Introduction to Statistics
• System Variables
• TiDB 6.1.0 Release Notes

tidb_max_bytes_before_tiflash_external_group_by

Referenced in:

• System Variables
• TiFlash Spill to Disk
• TiDB 7.0.0 Release Notes

tidb_max_bytes_before_tiflash_external_join

Referenced in:

• System Variables
• TiFlash Spill to Disk
• TiDB 7.0.0 Release Notes

tidb_max_bytes_before_tiflash_external_sort

Referenced in:

• System Variables
• TiFlash Spill to Disk
• TiDB 7.0.0 Release Notes

tidb_max_chunk_size

Referenced in:

• SHOW [GLOBAL|SESSION] VARIABLES
• System Variables
• TiDB Transaction Isolation Levels
• tidb-performance-tuning-config
• TiDB 7.6.0 Release Notes
• TiDB 7.5.1 Release Notes
• TiDB 7.1.3 Release Notes
• TiDB 6.5.7 Release Notes
• TiDB 2.0.9 Release Notes

tidb_max_delta_schema_count

Referenced in:

• SHOW [GLOBAL|SESSION] VARIABLES
• SQL FAQs
• System Variables
• TiDB 3.0.5 Release Notes
• TiDB 2.1.18 Release Notes

tidb_max_paging_size

Referenced in:

• System Variables
• TiDB 6.3.0 Release Notes

tidb_max_tiflash_threads

Referenced in:

• Configure TiFlash
• Modify Configuration Dynamically
• System Variables
• TiDB Cloud Release Notes in 2022
• Tune TiFlash Performance
• TiDB 6.1.0 Release Notes

tidb_mem_oom_action

Referenced in:

• Non-Transactional DML Statements
• System Variables
• TiDB Cloud Release Notes in 2022
• TiDB Memory Control
• TiDB 6.5.0 Release Notes
• TiDB 6.1.0 Release Notes

tidb_mem_quota_analyze

Referenced in:

• Introduction to Statistics
• System Variables
• Troubleshoot TiDB OOM Issues
• TiDB 8.1.0 Release Notes
• TiDB 7.5.2 Release Notes
• TiDB 7.1.6 Release Notes
• TiDB 6.5.10 Release Notes
• TiDB 6.1.0 Release Notes

tidb_mem_quota_apply_cache

Referenced in:

• System Variables

tidb_mem_quota_binding_cache

Referenced in:

• SQL Plan Management (SPM)
• System Variables
• TiDB 6.0.0 Release Notes

tidb_mem_quota_query

Referenced in:

• Enable Encryption for Disk Spill
• Error Codes and Troubleshooting
• Explain Statements That Use Joins
• Identify Expensive Queries
• Non-Transactional DML Statements
• Optimizer Hints
• SHOW [GLOBAL|SESSION] VARIABLES
• System Variables
• TiDB Cloud Release Notes in 2022
• TiDB Configuration File
• TiDB Memory Control
• TiDB Troubleshooting Map
• TiFlash Query Result Materialization
• Troubleshoot TiDB OOM Issues
• TiDB 8.3.0 Release Notes
• TiDB 8.1.2 Release Notes
• TiDB 7.6.0 Release Notes
• TiDB 7.5.4 Release Notes
• TiDB 7.5.1 Release Notes
• TiDB 7.3.0 Release Notes
• TiDB 7.2.0 Release Notes
• TiDB 7.1.6 Release Notes
• TiDB 7.1.4 Release Notes
• TiDB 7.1.1 Release Notes
• TiDB 6.5.11 Release Notes
• TiDB 6.5.7 Release Notes
• TiDB 6.5.4 Release Notes
• TiDB 6.5.0 Release Notes
• TiDB 6.3.0 Release Notes
• TiDB 6.1.0 Release Notes
• TiDB 6.0.0 Release Notes
• TiDB 4.0.10 Release Notes

tidb_memory_debug_mode_alarm_ratio

Referenced in:

• System Variables

tidb_memory_debug_mode_min_heap_inuse

Referenced in:

• System Variables

tidb_memory_usage_alarm_keep_record_num

Referenced in:

• System Variables
• TiDB Memory Control
• TiDB 6.4.0 Release Notes

tidb_memory_usage_alarm_ratio

Referenced in:

• Limited SQL features on TiDB Cloud
• System Variables
• TiDB Memory Control
• Troubleshoot TiDB OOM Issues
• TiDB 6.4.0 Release Notes

tidb_merge_join_concurrency

Referenced in:

• System Variables

tidb_merge_partition_stats_concurrency

Referenced in:

• System Variables
• TiDB 7.5.0 Release Notes
• TiDB 7.1.4 Release Notes
• TiDB 6.5.9 Release Notes

tidb_metric_query_range_duration

Referenced in:

• Limited SQL features on TiDB Cloud
• Metrics Schema
• SHOW [GLOBAL|SESSION] VARIABLES
• System Variables

tidb_metric_query_step

Referenced in:

• Limited SQL features on TiDB Cloud
• Metrics Schema
• SHOW [GLOBAL|SESSION] VARIABLES
• System Variables

tidb_min_paging_size

Referenced in:

• System Variables
• TiDB 6.2.0 Release Notes

tidb_mpp_store_fail_ttl

Referenced in:

• System Variables

tidb_multi_statement_mode

Referenced in:

• Error Codes and Troubleshooting
• Integrate TiDB Cloud with n8n
• System Variables
• TiDB 7.5.1 Release Notes
• TiDB 7.1.4 Release Notes
• TiDB 6.5.8 Release Notes
• TiDB 5.2 Release Notes
• TiDB 5.1.1 Release Notes
• TiDB 5.0.3 Release Notes
• TiDB 4.0.14 Release Notes

tidb_non_prepared_plan_cache_size

Referenced in:

• System Variables
• TiDB 7.1.0 Release Notes
• TiDB 7.0.0 Release Notes
• TiDB 6.6.0 Release Notes

tidb_nontransactional_ignore_error

Referenced in:

• Non-Transactional DML Statements
• System Variables
• TiDB 6.1.0 Release Notes

tidb_opt_advanced_join_hint

Referenced in:

• System Variables
• TiDB 7.0.0 Release Notes

tidb_opt_agg_push_down

Referenced in:

• SHOW [GLOBAL|SESSION] VARIABLES
• System Variables
• Tune TiFlash Performance
• tidb-performance-tuning-config
• TiDB 7.3.0 Release Notes
• TiDB 7.1.1 Release Notes
• TiDB 6.5.4 Release Notes
• TiDB 6.4.0 Release Notes
• TiDB 6.1.7 Release Notes
• TiDB 5.4.2 Release Notes
• TiDB 5.1.5 Release Notes
• TiDB 4.0 GA Release Notes

tidb_opt_broadcast_cartesian_join

Referenced in:

• System Variables

tidb_opt_concurrency_factor

Referenced in:

• SHOW [GLOBAL|SESSION] VARIABLES
• System Variables

tidb_opt_copcpu_factor

Referenced in:

• SHOW [GLOBAL|SESSION] VARIABLES
• System Variables

tidb_opt_correlation_exp_factor

Referenced in:

• Introduction to Extended Statistics
• SHOW [GLOBAL|SESSION] VARIABLES
• System Variables
• TiDB 3.0.0-rc.1 Release Notes

tidb_opt_correlation_threshold

Referenced in:

• Introduction to Extended Statistics
• SHOW [GLOBAL|SESSION] VARIABLES
• System Variables

tidb_opt_cpu_factor

Referenced in:

• SHOW [GLOBAL|SESSION] VARIABLES
• System Variables

tidb_opt_derive_topn

Referenced in:

• Derive TopN or Limit from Window Functions
• System Variables
• tidb-performance-tuning-config
• TiDB 7.0.0 Release Notes

tidb_opt_desc_factor

Referenced in:

• SHOW [GLOBAL|SESSION] VARIABLES
• System Variables

tidb_opt_disk_factor

Referenced in:

• SHOW [GLOBAL|SESSION] VARIABLES
• System Variables

tidb_opt_distinct_agg_push_down

Referenced in:

• Distinct Optimization
• SHOW [GLOBAL|SESSION] VARIABLES
• System Variables
• TiDB Configuration File
• Tune TiFlash Performance
• tidb-performance-tuning-config

tidb_opt_enable_correlation_adjustment

Referenced in:

• System Variables
• TiDB 5.2 Release Notes

tidb_opt_enable_fuzzy_binding

Referenced in:

• SQL Plan Management (SPM)
• System Variables
• TiDB 7.6.0 Release Notes

tidb_opt_enable_hash_join

Referenced in:

• Optimizer Hints
• System Variables
• TiDB 7.4.0 Release Notes
• TiDB 7.1.2 Release Notes
• TiDB 6.5.6 Release Notes

tidb_opt_enable_late_materialization

Referenced in:

• System Variables
• TiFlash Late Materialization
• TiDB 7.1.0 Release Notes
• TiDB 7.0.0 Release Notes

tidb_opt_enable_mpp_shared_cte_execution

Referenced in:

• System Variables
• tidb-performance-tuning-config
• TiDB 7.3.0 Release Notes

tidb_opt_enable_non_eval_scalar_subquery

Referenced in:

• System Variables
• EXPLAIN
• EXPLAIN Walkthrough
• TiDB 7.3.0 Release Notes

tidb_opt_fix_control

Referenced in:

• Control Execution Plan
• Optimizer Fix Controls
• SQL Non-Prepared Execution Plan Cache
• System Variables
• tidb-performance-tuning-config
• TiDB 7.2.0 Release Notes
• TiDB 7.1.0 Release Notes

tidb_opt_force_inline_cte

Referenced in:

• System Variables
• TiDB 7.3.0 Release Notes
• TiDB 6.3.0 Release Notes

tidb_opt_insubq_to_join_and_agg

Referenced in:

• Optimizer Hints
• SHOW [GLOBAL|SESSION] VARIABLES
• Subquery Related Optimizations
• System Variables
• TiDB 3.0 Beta Release Notes

tidb_opt_join_reorder_threshold

Referenced in:

• Introduction to Join Reorder
• SHOW [GLOBAL|SESSION] VARIABLES
• System Variables
• TiDB 6.4.0 Release Notes
• TiDB 3.0.0-rc.1 Release Notes

tidb_opt_limit_push_down_threshold

Referenced in:

• System Variables
• TiDB 5.2 Release Notes

tidb_opt_memory_factor

Referenced in:

• SHOW [GLOBAL|SESSION] VARIABLES
• System Variables

tidb_opt_mpp_outer_join_fixed_build_side

Referenced in:

• System Variables

tidb_opt_network_factor

Referenced in:

• Index Selection
• SHOW [GLOBAL|SESSION] VARIABLES
• System Variables

tidb_opt_objective

Referenced in:

• System Variables
• TiDB 8.0.0 Release Notes
• TiDB 7.5.2 Release Notes
• TiDB 7.4.0 Release Notes

tidb_opt_ordering_index_selectivity_ratio

Referenced in:

• System Variables
• TiDB 8.0.0 Release Notes

tidb_opt_ordering_index_selectivity_threshold

Referenced in:

• System Variables
• TiDB 7.0.0 Release Notes

tidb_opt_prefer_range_scan

Referenced in:

• System Variables
• TiDB 8.4.0 Release Notes

tidb_opt_prefix_index_single_scan

Referenced in:

• System Variables
• TiDB 6.4.0 Release Notes

tidb_opt_projection_push_down

Referenced in:

• System Variables
• TiDB 8.3.0 Release Notes

tidb_opt_range_max_size

Referenced in:

• System Variables
• TiDB 6.4.0 Release Notes

tidb_opt_scan_factor

Referenced in:

• SHOW [GLOBAL|SESSION] VARIABLES
• System Variables

tidb_opt_seek_factor

Referenced in:

• Index Selection
• SHOW [GLOBAL|SESSION] VARIABLES
• System Variables

tidb_opt_skew_distinct_agg

Referenced in:

• System Variables
• TiDB 6.2.0 Release Notes

tidb_opt_three_stage_distinct_agg

Referenced in:

• System Variables
• TiDB 6.3.0 Release Notes

tidb_opt_tiflash_concurrency_factor

Referenced in:

• System Variables

tidb_opt_use_invisible_indexes

Referenced in:

• ALTER INDEX
• CREATE INDEX
• System Variables
• TiDB 8.0.0 Release Notes

tidb_opt_write_row_id

Referenced in:

• Limited SQL features on TiDB Cloud
• SHOW [GLOBAL|SESSION] VARIABLES
• System Variables
• TiDB 2.1 RC5 Release Notes

tidb_optimizer_selectivity_level

Referenced in:

• SHOW [GLOBAL|SESSION] VARIABLES
• System Variables

tidb_partition_prune_mode

Referenced in:

• Partitioning
• SQL Prepared Execution Plan Cache
• System Variables
• TiFlash Upgrade Guide
• Use TiFlash MPP Mode
• TiDB 8.5.0 Release Notes
• TiDB 8.1.0 Release Notes
• TiDB 6.3.0 Release Notes
• TiDB 5.1 Release Notes

tidb_persist_analyze_options

Referenced in:

• Introduction to Statistics
• System Variables
• TiDB 8.2.0 Release Notes
• TiDB 5.4 Release Notes

tidb_pessimistic_txn_fair_locking

Referenced in:

• System Variables
• Troubleshoot Lock Conflicts
• TiDB 7.1.0 Release Notes
• TiDB 7.0.0 Release Notes

tidb_placement_mode

Referenced in:

• Limited SQL features on TiDB Cloud
• System Variables
• TiDB 6.0.0 Release Notes

tidb_plan_cache_invalidation_on_fresh_stats

Referenced in:

• System Variables
• TiDB 7.1.0 Release Notes

tidb_plan_cache_max_plan_size

Referenced in:

• SQL Non-Prepared Execution Plan Cache
• SQL Prepared Execution Plan Cache
• System Variables
• TiDB 7.1.0 Release Notes

tidb_pprof_sql_cpu

Referenced in:

• Limited SQL features on TiDB Cloud
• SHOW [GLOBAL|SESSION] VARIABLES
• System Variables
• TiDB 3.0.10 Release Notes

tidb_pre_split_regions

Referenced in:

• System Variables
• TiDB 8.4.0 Release Notes

tidb_prefer_broadcast_join_by_exchange_data_size

Referenced in:

• System Variables
• Use TiFlash MPP Mode
• TiDB 7.1.0 Release Notes

tidb_prepared_plan_cache_memory_guard_ratio

Referenced in:

• SQL Prepared Execution Plan Cache
• System Variables
• TiDB 6.1.0 Release Notes

tidb_prepared_plan_cache_size

Referenced in:

• System Variables
• TiDB Cloud Release Notes in 2022
• TiDB 7.1.0 Release Notes
• TiDB 6.4.0 Release Notes
• TiDB 6.1.0 Release Notes

tidb_projection_concurrency

Referenced in:

• SHOW [GLOBAL|SESSION] VARIABLES
• System Variables
• TiDB 5.0 Release Notes

tidb_query_log_max_len

Referenced in:

• Identify Slow Queries
• SHOW [GLOBAL|SESSION] VARIABLES
• System Variables
• TiDB Cloud Release Notes in 2022
• TiDB 6.1.0 Release Notes
• TiDB 2.1 GA Release Notes
• TiDB 2.1 RC5 Release Notes

tidb_rc_read_check_ts

Referenced in:

• Performance Tuning Practices for OLTP Scenarios
• System Variables
• TiDB Transaction Isolation Levels
• tidb-performance-tuning-config
• TiDB 7.0.0 Release Notes
• TiDB 6.3.0 Release Notes
• TiDB 6.0.0 Release Notes

tidb_rc_write_check_ts

Referenced in:

• System Variables
• TiDB Transaction Isolation Levels
• TiDB 6.3.0 Release Notes

tidb_read_consistency

Referenced in:

• System Variables

tidb_read_staleness

Referenced in:

• Read Historical Data Using the tidb_read_staleness System Variable
• Stale Read
• System Variables
• Usage Scenarios of Stale Read
• TiDB 6.6.0 Release Notes
• TiDB 5.4 Release Notes

tidb_record_plan_in_slow_log

Referenced in:

• Limited SQL features on TiDB Cloud
• Modify Configuration Dynamically
• SHOW [GLOBAL|SESSION] VARIABLES
• System Variables
• TiDB Configuration File
• TiDB 3.0.5 Release Notes

tidb_redact_log

Referenced in:

• Configuration Options
• Identify Slow Queries
• Limited SQL features on TiDB Cloud
• Log Redaction
• Non-Transactional DML Statements
• System Variables
• TiDB 8.3.0 Release Notes
• TiDB 8.1.1 Release Notes
• TiDB 8.1.0 Release Notes
• TiDB 8.0.0 Release Notes
• TiDB 7.5.4 Release Notes
• TiDB 5.0 Release Notes
• TiDB 5.0 RC Release Notes

tidb_regard_null_as_point

Referenced in:

• System Variables
• TiDB 5.4 Release Notes

tidb_remove_orderby_in_subquery

Referenced in:

• System Variables
• TiDB 7.2.0 Release Notes

tidb_replica_read

Referenced in:

• Best Practices for Read-Only Storage Nodes
• Follower Read
• Follower Read
• Local Read under Three Data Centers Deployment
• Optimizer Hints
• SHOW [GLOBAL|SESSION] VARIABLES
• System Variables
• TiDB Best Practices on Public Cloud
• TiDB 7.0.0 Release Notes
• TiDB 6.6.0 Release Notes
• TiDB 6.5.0 Release Notes
• TiDB 6.3.0 Release Notes
• TiDB 5.4 Release Notes
• TiDB 4.0.2 Release Notes
• TiDB 3.1 Beta.2 Release Notes

tidb_request_source_type

Referenced in:

• System Variables
• Use Resource Control to Manage Background Tasks
• TiDB 7.4.0 Release Notes

tidb_resource_control_strict_mode

Referenced in:

• Optimizer Hints
• Privilege Management
• SET RESOURCE GROUP
• System Variables
• Use Resource Control to Achieve Resource Group Limitation and Flow Control
• TiDB 8.2.0 Release Notes

tidb_restricted_read_only

Referenced in:

• Limited SQL features on TiDB Cloud
• Privilege Management
• Replicate Data to MySQL-compatible Databases
• System Variables
• TiDB 8.4.0 Release Notes
• TiDB 5.4.1 Release Notes
• TiDB 5.3.1 Release Notes

tidb_retry_limit

Referenced in:

• SHOW [GLOBAL|SESSION] VARIABLES
• System Variables
• TiDB Optimistic Transaction Model
• TiDB Pessimistic Transaction Mode
• Transactions
• Troubleshoot Lock Conflicts
• TiDB 2.1 Beta Release Notes
• TiDB 2.1 GA Release Notes

tidb_row_format_version

Referenced in:

• Limited SQL features on TiDB Cloud
• SHOW [GLOBAL|SESSION] VARIABLES
• System Variables
• TiDB 4.0.13 Release Notes

tidb_runtime_filter_mode

Referenced in:

• Runtime Filter
• System Variables
• tidb-performance-tuning-config
• TiDB 7.3.0 Release Notes

tidb_runtime_filter_type

Referenced in:

• Runtime Filter
• System Variables

tidb_scatter_region

Referenced in:

• Highly Concurrent Write Best Practices
• Limited SQL features on TiDB Cloud
• SHOW [GLOBAL|SESSION] VARIABLES
• Split Region
• System Variables
• TiDB 8.4.0 Release Notes
• TiDB 7.1.0 Release Notes
• TiDB 6.1.7 Release Notes
• TiDB 2.1.15 Release Notes

tidb_schema_cache_size

Referenced in:

• Schema Cache
• System Variables
• TiDB 8.5.0 Release Notes
• TiDB 8.4.0 Release Notes
• TiDB 8.3.0 Release Notes
• TiDB 8.0.0 Release Notes

tidb_schema_version_cache_limit

Referenced in:

• System Variables
• TiDB 7.4.0 Release Notes

tidb_server_memory_limit

Referenced in:

• IMPORT INTO
• Limited SQL features on TiDB Cloud
• MEMORY_USAGE
• MEMORY_USAGE_OPS_HISTORY
• System Variables
• TiDB Configuration File
• TiDB Memory Control
• Troubleshoot TiDB OOM Issues
• TiDB 8.0.0 Release Notes
• TiDB 7.6.0 Release Notes
• TiDB 7.5.1 Release Notes
• TiDB 7.1.4 Release Notes
• TiDB 7.1.3 Release Notes
• TiDB 6.5.9 Release Notes
• TiDB 6.5.7 Release Notes
• TiDB 6.5.0 Release Notes
• TiDB 6.4.0 Release Notes

tidb_server_memory_limit_gc_trigger

Referenced in:

• IMPORT INTO
• Limited SQL features on TiDB Cloud
• System Variables
• TiDB Memory Control
• TiDB 6.4.0 Release Notes

tidb_server_memory_limit_sess_min_size

Referenced in:

• Limited SQL features on TiDB Cloud
• System Variables
• TiDB 6.5.2 Release Notes
• TiDB 6.4.0 Release Notes

tidb_service_scope

Referenced in:

• ADMIN SHOW DDL [JOBS|JOB QUERIES]
• Configuration Options
• IMPORT INTO vs. TiDB Lightning
• System Variables
• TiDB Distributed eXecution Framework (DXF)
• TiDB Features
• TiDB Global Sort
• TiDB 8.1.0 Release Notes
• TiDB 7.5.1 Release Notes
• TiDB 7.5.0 Release Notes
• TiDB 7.4.0 Release Notes

tidb_session_alias

Referenced in:

• System Variables
• TiDB 7.4.0 Release Notes

tidb_session_plan_cache_size

Referenced in:

• SQL Non-Prepared Execution Plan Cache
• SQL Prepared Execution Plan Cache
• System Variables
• TiDB Cloud Sysbench Performance Test Report for TiDB v8.1.0
• TiDB 7.4.0 Release Notes
• TiDB 7.1.0 Release Notes

tidb_shard_allocate_step

Referenced in:

• System Variables

tidb_shard_row_id_bits

Referenced in:

• System Variables
• TiDB 8.4.0 Release Notes

tidb_simplified_metrics

Referenced in:

• Limited SQL features on TiDB Cloud
• System Variables

tidb_skip_ascii_check

Referenced in:

• System Variables
• TiDB 5.0 Release Notes

tidb_skip_isolation_level_check

Referenced in:

• Error Codes and Troubleshooting
• Known Incompatibility Issues with Third-Party Tools
• SHOW [GLOBAL|SESSION] VARIABLES
• System Variables
• Transaction overview
• TiDB 5.1.4 Release Notes
• TiDB 3.0.0-rc.1 Release Notes
• TiDB 3.0 GA Release Notes

tidb_skip_missing_partition_stats

Referenced in:

• Introduction to Statistics
• System Variables
• TiDB 7.3.0 Release Notes

tidb_skip_utf8_check

Referenced in:

• Character Set and Collation
• DM Advanced Task Configuration File
• SHOW [GLOBAL|SESSION] VARIABLES
• System Variables
• TiDB Troubleshooting Map
• Upgrade and After Upgrade FAQs

tidb_slow_log_threshold

Referenced in:

• Identify Slow Queries
• Limited SQL features on TiDB Cloud
• Modify Configuration Dynamically
• Overview Page
• Quick Start with TiDB Self-Managed
• SHOW [GLOBAL|SESSION] VARIABLES
• Slow Queries Page of TiDB Dashboard
• System Variables
• TiDB Configuration File
• TiDB Deployment FAQs
• TiDB 2.1 GA Release Notes
• TiDB 2.1 RC5 Release Notes

tidb_slow_query_file

Referenced in:

• Identify Slow Queries
• Limited SQL features on TiDB Cloud
• SHOW [GLOBAL|SESSION] VARIABLES
• System Variables

tidb_snapshot

Referenced in:

• Cached Tables
• FLASHBACK CLUSTER
• FLUSH TABLES
• IMPORT INTO
• Non-Transactional DML Statements
• Read Historical Data Using the System Variable tidb_snapshot
• Replicate Data to Kafka
• SHOW [GLOBAL|SESSION] VARIABLES
• System Variables
• Temporary Tables
• TiDB Features
• Use Dumpling to Export Data
• TiDB 5.3 Release Notes
• TiDB 5.2.2 Release Notes
• TiDB 5.2 Release Notes
• TiDB 5.1.5 Release Notes
• TiDB 5.0.3 Release Notes
• TiDB 4.0.12 Release Notes
• TiDB 4.0.11 Release Notes
• TiDB 4.0.5 Release Notes
• TiDB 3.0.11 Release Notes
• TiDB 2.1.11 Release Notes
• TiDB 2.1.10 Release Notes
• TiDB 2.0.4 Release Notes

tidb_source_id

Referenced in:

• System Variables
• TiDB 6.5.0 Release Notes

tidb_stats_cache_mem_quota

Referenced in:

• System Variables
• Troubleshoot TiDB OOM Issues
• TiDB 7.4.0 Release Notes
• TiDB 6.1.0 Release Notes

tidb_stats_load_pseudo_timeout

Referenced in:

• Introduction to Statistics
• System Variables
• TiDB 6.4.0 Release Notes
• TiDB 5.4 Release Notes

tidb_stats_load_sync_wait

Referenced in:

• Introduction to Statistics
• Limited SQL features on TiDB Cloud
• System Variables
• TiDB Configuration File
• TiDB 8.0.0 Release Notes
• TiDB 6.4.0 Release Notes
• TiDB 5.4 Release Notes

tidb_stmt_summary_enable_persistent

Referenced in:

• Statement Summary Tables
• System Variables
• TiDB Configuration File
• TiDB 6.6.0 Release Notes

tidb_stmt_summary_file_max_backups

Referenced in:

• Statement Summary Tables
• System Variables
• TiDB Configuration File
• TiDB 6.6.0 Release Notes

tidb_stmt_summary_file_max_days

Referenced in:

• Statement Summary Tables
• System Variables
• TiDB Configuration File
• TiDB 6.6.0 Release Notes

tidb_stmt_summary_file_max_size

Referenced in:

• Statement Summary Tables
• System Variables
• TiDB Configuration File
• TiDB 6.6.0 Release Notes

tidb_stmt_summary_filename

Referenced in:

• Statement Summary Tables
• System Variables
• TiDB Configuration File
• TiDB 6.6.0 Release Notes

tidb_stmt_summary_history_size

Referenced in:

• Limited SQL features on TiDB Cloud
• SHOW [GLOBAL|SESSION] VARIABLES
• Statement Summary Tables
• System Variables

tidb_stmt_summary_internal_query

Referenced in:

• Limited SQL features on TiDB Cloud
• SHOW [GLOBAL|SESSION] VARIABLES
• Statement Summary Tables
• System Variables

tidb_stmt_summary_max_sql_length

Referenced in:

• Limited SQL features on TiDB Cloud
• SHOW [GLOBAL|SESSION] VARIABLES
• SLOW_QUERY
• Slow Queries Page of TiDB Dashboard
• Statement Summary Tables
• System Variables

tidb_stmt_summary_max_stmt_count

Referenced in:

• Limited SQL features on TiDB Cloud
• SHOW [GLOBAL|SESSION] VARIABLES
• SQL Statements Page of TiDB Dashboard
• Statement Summary Tables
• System Variables
• TiDB 5.2 Release Notes
• TiDB 5.1.1 Release Notes
• TiDB 5.0.4 Release Notes
• TiDB 4.0.14 Release Notes

tidb_stmt_summary_refresh_interval

Referenced in:

• Limited SQL features on TiDB Cloud
• SHOW [GLOBAL|SESSION] VARIABLES
• Statement Summary Tables
• System Variables

tidb_store_batch_size

Referenced in:

• System Variables
• TiDB 7.1.0 Release Notes
• TiDB 6.6.0 Release Notes

tidb_store_limit

Referenced in:

• Error Codes and Troubleshooting
• SHOW [GLOBAL|SESSION] VARIABLES
• System Variables
• TiDB 5.4 Release Notes

tidb_streamagg_concurrency

Referenced in:

• System Variables

tidb_super_read_only

Referenced in:

• System Variables
• TiDB 5.4.1 Release Notes
• TiDB 5.3.1 Release Notes

tidb_sysdate_is_now

Referenced in:

• System Variables
• TiDB 8.0.0 Release Notes
• TiDB 6.0.0 Release Notes

tidb_sysproc_scan_concurrency

Referenced in:

• Limited SQL features on TiDB Cloud
• System Variables
• TiDB 8.2.0 Release Notes
• TiDB 7.6.0 Release Notes
• TiDB 6.5.0 Release Notes

tidb_table_cache_lease

Referenced in:

• Cached Tables
• System Variables
• TiDB 6.0.0 Release Notes

tidb_tmp_table_max_size

Referenced in:

• System Variables
• Temporary Tables
• TiDB 5.3 Release Notes

tidb_top_sql_max_meta_count

Referenced in:

• Limited SQL features on TiDB Cloud
• System Variables
• TiDB 6.0.0 Release Notes

tidb_top_sql_max_time_series_count

Referenced in:

• Limited SQL features on TiDB Cloud
• System Variables
• TiDB 6.0.0 Release Notes

tidb_track_aggregate_memory_usage

Referenced in:

• System Variables

tidb_tso_client_batch_max_wait_time

Referenced in:

• Limited SQL features on TiDB Cloud
• System Variables
• TiDB Best Practices on Public Cloud
• TiDB 5.3 Release Notes

tidb_tso_client_rpc_mode

Referenced in:

• System Variables
• tidb-performance-tuning-config
• TiDB 8.4.0 Release Notes

tidb_ttl_delete_batch_size

Referenced in:

• Limited SQL features on TiDB Cloud
• System Variables
• TiDB 6.5.0 Release Notes

tidb_ttl_delete_rate_limit

Referenced in:

• Limited SQL features on TiDB Cloud
• System Variables
• TiDB 6.5.0 Release Notes

tidb_ttl_delete_worker_count

Referenced in:

• Limited SQL features on TiDB Cloud
• Periodically Delete Expired Data Using TTL (Time to Live)
• System Variables
• TiDB 8.4.0 Release Notes
• TiDB 8.1.2 Release Notes
• TiDB 7.1.6 Release Notes
• TiDB 6.5.0 Release Notes

tidb_ttl_job_enable

Referenced in:

• Periodically Delete Expired Data Using TTL (Time to Live)
• System Variables
• TiDB 8.5.0 Release Notes
• TiDB 8.1.2 Release Notes
• TiDB 7.5.5 Release Notes
• TiDB 6.5.0 Release Notes

tidb_ttl_job_schedule_window_end_time

Referenced in:

• Limited SQL features on TiDB Cloud
• Periodically Delete Expired Data Using TTL (Time to Live)
• System Variables
• TiDB 6.5.0 Release Notes

tidb_ttl_job_schedule_window_start_time

Referenced in:

• Limited SQL features on TiDB Cloud
• Periodically Delete Expired Data Using TTL (Time to Live)
• System Variables
• TiDB 6.5.0 Release Notes

tidb_ttl_running_tasks

Referenced in:

• Limited SQL features on TiDB Cloud
• Periodically Delete Expired Data Using TTL (Time to Live)
• System Variables
• TiDB 7.0.0 Release Notes

tidb_ttl_scan_batch_size

Referenced in:

• Limited SQL features on TiDB Cloud
• System Variables
• TiDB 6.5.0 Release Notes

tidb_ttl_scan_worker_count

Referenced in:

• Limited SQL features on TiDB Cloud
• Periodically Delete Expired Data Using TTL (Time to Live)
• System Variables
• TiDB 6.5.0 Release Notes

tidb_txn_assertion_level

Referenced in:

• System Variables
• Troubleshoot Inconsistency Between Data and Indexes
• TiDB 6.0.0 Release Notes

tidb_txn_commit_batch_size

Referenced in:

• System Variables
• TiDB 6.2.0 Release Notes

tidb_txn_entry_size_limit

Referenced in:

• System Variables
• TiDB Configuration File
• Transaction Restraints
• Troubleshoot TiDB Lightning
• TiDB 7.6.0 Release Notes

tidb_txn_mode

Referenced in:

• Limited SQL features on TiDB Cloud
• Optimistic Transactions and Pessimistic Transactions
• SHOW [GLOBAL|SESSION] VARIABLES
• System Variables
• TiDB Configuration File
• TiDB Pessimistic Transaction Mode
• Transactions
• tidb-performance-tuning-config
• TiDB 6.0.0 Release Notes
• TiDB 5.0 Release Notes
• TiDB 3.0.8 Release Notes
• TiDB 3.0.4 Release Notes

tidb_use_plan_baselines

Referenced in:

• CREATE [GLOBAL|SESSION] BINDING
• SHOW [GLOBAL|SESSION] VARIABLES
• SQL Plan Management (SPM)
• System Variables

tidb_wait_split_region_finish

Referenced in:

• Limited SQL features on TiDB Cloud
• SHOW [GLOBAL|SESSION] VARIABLES
• Split Region
• System Variables

tidb_wait_split_region_timeout

Referenced in:

• Limited SQL features on TiDB Cloud
• SHOW [GLOBAL|SESSION] VARIABLES
• Split Region
• System Variables

tidb_window_concurrency

Referenced in:

• SHOW [GLOBAL|SESSION] VARIABLES
• System Variables

tiflash_fastscan

Referenced in:

• System Variables
• Use FastScan
• TiDB 7.0.0 Release Notes
• TiDB 6.3.0 Release Notes

tiflash_fine_grained_shuffle_batch_size

Referenced in:

• System Variables
• TiDB 6.2.0 Release Notes

tiflash_fine_grained_shuffle_stream_count

Referenced in:

• System Variables
• Tune TiFlash Performance
• TiDB 6.2.0 Release Notes

tiflash_hashagg_preaggregation_mode

Referenced in:

• System Variables
• TiDB 8.3.0 Release Notes

tiflash_mem_quota_query_per_node

Referenced in:

• System Variables
• TiFlash Spill to Disk
• TiDB 7.4.0 Release Notes

tiflash_query_spill_ratio

Referenced in:

• System Variables
• TiFlash Spill to Disk
• TiDB 7.4.0 Release Notes

tiflash_replica_read

Referenced in:

• Create TiFlash Replicas
• System Variables
• TiDB Features
• TiDB 7.3.0 Release Notes

tikv_client_read_timeout

Referenced in:

• System Variables
• TiDB 7.5.1 Release Notes
• TiDB 7.4.0 Release Notes

time_zone

Referenced in:

• Date and Time Types
• SHOW [GLOBAL|SESSION] VARIABLES
• SQL Prepared Execution Plan Cache
• System Variables
• Time Zone Support
• TiDB 6.0.0 Release Notes
• TiDB 2.1.8 Release Notes

timestamp

Referenced in:

• System Variables

transaction_isolation

Referenced in:

• Known Incompatibility Issues with Third-Party Tools
• SET TRANSACTION
• System Variables
• TiDB 6.0.0 Release Notes

tx_isolation

Referenced in:

• Performance Tuning Practices for OLTP Scenarios
• System Variables

tx_isolation_one_shot

Referenced in:

• System Variables

tx_read_ts

Referenced in:

• System Variables

validate_password.check_user_name

Referenced in:

• Encryption and Compression Functions
• System Variables
• TiDB Password Management
• TiDB 6.5.0 Release Notes

validate_password.dictionary

Referenced in:

• Encryption and Compression Functions
• Security Compatibility with MySQL
• System Variables
• TiDB Password Management
• TiDB 6.5.0 Release Notes

validate_password.enable

Referenced in:

• Encryption and Compression Functions
• Limited SQL features on TiDB Cloud
• Security Compatibility with MySQL
• System Variables
• TiDB Password Management
• TiDB 6.5.0 Release Notes

validate_password.length

Referenced in:

• Encryption and Compression Functions
• Limited SQL features on TiDB Cloud
• System Variables
• TiDB Password Management
• TiDB 6.5.0 Release Notes

validate_password.mixed_case_count

Referenced in:

• Encryption and Compression Functions
• Limited SQL features on TiDB Cloud
• System Variables
• TiDB Password Management
• TiDB 6.5.0 Release Notes

validate_password.number_count

Referenced in:

• Encryption and Compression Functions
• Limited SQL features on TiDB Cloud
• System Variables
• TiDB Password Management
• TiDB 6.5.0 Release Notes

validate_password.policy

Referenced in:

• Encryption and Compression Functions
• Limited SQL features on TiDB Cloud
• System Variables
• TiDB Password Management
• TiDB 6.5.0 Release Notes

validate_password.special_char_count

Referenced in:

• Encryption and Compression Functions
• Limited SQL features on TiDB Cloud
• System Variables
• TiDB Password Management
• TiDB 6.5.0 Release Notes

version

Referenced in:

• System Variables

version_comment

Referenced in:

• System Variables

version_compile_machine

Referenced in:

• System Variables

version_compile_os

Referenced in:

• System Variables

wait_timeout

Referenced in:

• Best Practices for Developing Java Applications with TiDB
• Connection Pools and Connection Parameters
• Limited SQL features on TiDB Cloud
• System Variables
• TiDB Cluster Management FAQs
• TiProxy Overview
• Timeouts in TiDB
• Troubleshoot TiDB OOM Issues
• TiDB 3.0 Beta Release Notes
• TiDB 3.0 GA Release Notes

warning_count

Referenced in:

• System Variables
• TiDB 2.1 RC1 Release Notes

windowing_use_high_precision

Referenced in:

• System Variables
• Window Functions