TOC.md

TiDB Documentation

Documentation List

• Introduction
• Concepts
  • Architecture
  • Key Features
    • Horizontal Scalability
    • MySQL Compatible Syntax
    • Replicate from and to MySQL
    • Distributed Transactions with Strong Consistency
    • Cloud Native Architecture
    • Minimize ETL with HTAP
    • Fault Tolerance & Recovery with Raft
    • Automatic Rebalancing
    • Deployment and Orchestration with Ansible, Kubernetes, Docker
    • JSON Support
    • Spark Integration
    • Read Historical Data Without Restoring from Backup
    • Fast Import and Restore of Data
    • Hybrid of Column and Row Storage
    • SQL Plan Management
    • Open Source
    • Online Schema Changes
• How-to
  • Get Started
    • Start a Local Cluster
      • From Binary
      • From Homebrew
      • From DBdeployer
      • In Kubernetes
      • In Docker Compose
    • Explore SQL with TiDB
    • Import Example Database
    • Read Historical Data
    • TiDB Binlog Tutorial
    • TiDB Data Migration Tutorial
    • TiSpark Quick Start Guide
  • Deploy
    • Hardware Recommendations
    • From Binary Tarball
      • For Testing Environments
      • For Production Environments
    • Orchestrated Deployment
      • Ansible Deployment (Recommended)
      • Ansible Offline Deployment
      • Docker Deployment
      • Kubernetes Deployment
    • Geographic Redundancy
      • Overview
      • Configure Location Awareness
    • Data Migration with Ansible
  • Configure
    • Time Zone
    • Memory Control
  • Secure
    • Transport Layer Security (TLS)
      • Enable TLS For MySQL Clients
      • Enable TLS Between TiDB Components
    • Generate Self-signed Certificates
  • Monitor
    • Overview
    • Monitor a TiDB Cluster
  • Migrate
    • Overview
    • Migrate from MySQL
      • Migrate the Full Data
      • Migrate the Incremental Data
    • Migrate from Aurora
    • Migrate from CSV
  • Maintain
    • Common Ansible Operations
    • Backup and Restore
    • Identify Slow Queries
  • Scale
    • Scale using Ansible
    • Scale a TiDB Cluster
  • Upgrade
    • Upgrade to TiDB 3.0
    • Upgrade to TiDB 2.1
    • Rolling updates with Ansible
    • Upgrade TiDB Data Migration
  • Troubleshoot
    • Troubleshoot Cluster Setup
    • Troubleshoot TiDB Data Migration
    • Troubleshoot TiDB Lightning
• Reference
  • MySQL Compatibility
  • SQL
    • SQL Language Structure
      • Literal Values
      • Schema Object Names
      • Keywords and Reserved Words
      • User-Defined Variables
      • Expression Syntax
      • Comment Syntax
    • Data Types
      • Overview
      • Default Values
      • Numeric Types
        • BIT
        • BOOL|BOOLEAN
        • TINYINT
        • SMALLINT
        • MEDIUMINT
        • INT|INTEGER
        • BIGINT
        • DECIMAL
        • FLOAT
        • DOUBLE
      • Date and Time Types
        • DATE
        • DATETIME
        • TIMESTAMP
        • TIME
        • YEAR
      • String Types
        • CHAR
        • VARCHAR
        • TEXT
        • LONGTEXT
        • BINARY
        • VARBINARY
        • TINYBLOB
        • BLOB
        • MEDIUMBLOB
        • LONGBLOB
        • ENUM
        • SET
      • JSON Type
    • Functions and Operators
      • Function and Operator Reference
      • Type Conversion in Expression Evaluation
      • Operators
      • Control Flow Functions
      • String Functions
      • Numeric Functions and Operators
      • Date and Time Functions
      • Bit Functions and Operators
      • Cast Functions and Operators
      • Encryption and Compression Functions
      • Information Functions
      • JSON Functions
      • Aggregate (GROUP BY) Functions
      • Miscellaneous Functions
      • Precision Math
    • SQL Statements
      • ADD COLUMN
      • ADD INDEX
      • ADMIN
      • ALTER TABLE
      • ALTER USER
      • ANALYZE TABLE
      • BEGIN
      • COMMIT
      • CREATE DATABASE
      • CREATE INDEX
      • CREATE TABLE LIKE
      • CREATE TABLE
      • CREATE USER
      • CREATE VIEW
      • DEALLOCATE
      • DELETE
      • DESC
      • DESCRIBE
      • DO
      • DROP COLUMN
      • DROP DATABASE
      • DROP INDEX
      • DROP TABLE
      • DROP USER
      • DROP VIEW
      • EXECUTE
      • EXPLAIN ANALYZE
      • EXPLAIN
      • FLUSH PRIVILEGES
      • FLUSH STATUS
      • FLUSH TABLES
      • GRANT <privileges>
      • INSERT
      • KILL [TIDB]
      • LOAD DATA
      • MODIFY COLUMN
      • PREPARE
      • RENAME INDEX
      • RENAME TABLE
      • REPLACE
      • REVOKE <privileges>
      • ROLLBACK
      • SELECT
      • SET [NAMES|CHARACTER SET]
      • SET PASSWORD
      • SET TRANSACTION
      • SET [GLOBAL|SESSION] <variable>
      • SHOW CHARACTER SET
      • SHOW COLLATION
      • SHOW [FULL] COLUMNS FROM
      • SHOW CREATE TABLE
      • SHOW CREATE USER
      • SHOW DATABASES
      • SHOW ENGINES
      • SHOW ERRORS
      • SHOW [FULL] FIELDS FROM
      • SHOW GRANTS
      • SHOW INDEXES [FROM|IN]
      • SHOW INDEX [FROM|IN]
      • SHOW KEYS [FROM|IN]
      • SHOW PRIVILEGES
      • SHOW [FULL] PROCESSSLIST
      • SHOW SCHEMAS
      • SHOW [FULL] TABLES
      • SHOW TABLE STATUS
      • SHOW [GLOBAL|SESSION] VARIABLES
      • SHOW WARNINGS
      • START TRANSACTION
      • TRACE
      • TRUNCATE
      • UPDATE
      • USE
    • Constraints
    • Generated Columns
    • Character Set
  • Configuration
    • tidb-server
      • MySQL System Variables
      • TiDB Specific System Variables
      • Configuration Flags
      • Configuration File
    • pd-server
      • Configuration Flags
    • tikv-server
      • Configuration Flags
  • Security
    • Security Compatibility with MySQL
    • The TiDB Access Privilege System
    • TiDB User Account Management
  • Transactions
    • Overview
    • Transaction Model
    • Isolation Levels
    • Pessimistic Transactions
  • System Databases
    • mysql
    • information_schema
  • Errors Codes
  • Supported Client Drivers
  • Garbage Collection (GC)
  • Performance
    • Overview
    • Understanding the Query Execution Plan
    • Introduction to Statistics
    • Optimizer Hints
    • Tune TiKV
  • Best Practices
  • TiSpark
  • Tools
    • Mydumper
    • Syncer
    • Loader
    • TiDB Data Migration
      • Overview
      • Restrictions
      • Features
        • Table Routing
        • Black and White Lists
        • Binlog Event Filter
        • Column Mapping
        • Replication Delay Monitoring
        • Sharding Support
          • Introduction
          • Restrictions
          • Handle Sharding DDL Locks Manually
      • Usage Scenarios
        • Simple Scenario
        • Shard Merge Scenario
      • Deploy
      • Configure
        • Overview
        • Task Configuration
      • Monitor
      • Manage the Task
      • Cluster Operations
      • Migrate from MySQL compatible database
        • Migrate from Aurora
      • Troubleshoot
    • TiDB Lightning
      • Overview
      • Deployment
      • Checkpoints
      • Table Filter
      • CSV Support
      • Monitor
      • Troubleshoot
      • FAQ
    • TiDB Binlog
      • Overview
      • Deploy
      • Monitor
      • Maintain
      • Upgrade
    • PD Control
    • PD Recover
    • TiKV Control
    • TiDB Control
    • Download
  • Key Monitoring Metrics
    • Overview
    • TiDB
    • PD
    • TiKV
  • Adopters
• FAQs
  • TiDB FAQs
  • TiDB Lightning FAQs
  • Upgrade FAQs
• Support
  • Support Resources
  • Report an Issue
• Contribute
  • Contribute to TiDB
  • Improve the Docs

• Roadmap

• Releases
  • v3.0
    • 3.0.0-rc.2
    • 3.0.0-rc.1
    • 3.0.0-beta.1
    • 3.0.0-beta
  • v2.1
    • 2.1.12
    • 2.1.11
    • 2.1.10
    • 2.1.9
    • 2.1.8
    • 2.1.7
    • 2.1.6
    • 2.1.5
    • 2.1.4
    • 2.1.3
    • 2.1.2
    • 2.1.1
    • 2.1 GA
    • 2.1 RC5
    • 2.1 RC4
    • 2.1 RC3
    • 2.1 RC2
    • 2.1 RC1
    • 2.1 Beta
  • v2.0
    • 2.0.11
    • 2.0.10
    • 2.0.9
    • 2.0.8
    • 2.0.7
    • 2.0.6
    • 2.0.5
    • 2.0.4
    • 2.0.3
    • 2.0.2
    • 2.0.1
    • 2.0
    • 2.0 RC5
    • 2.0 RC4
    • 2.0 RC3
    • 2.0 RC1
    • 1.1 Beta
    • 1.1 Alpha
  • v1.0
    • 1.0.8
    • 1.0.7
    • 1.0.6
    • 1.0.5
    • 1.0.4
    • 1.0.3
    • 1.0.2
    • 1.0.1
    • 1.0
    • Pre-GA
    • RC4
    • RC3
    • RC2
    • RC1