TOC.md

TiDB Documentation

Documentation List

• Introduction
  • TiDB Introduction
  • Benchmarks
    • How to Test TiDB Using Sysbench
    • Sysbench Performance Test - v2.1 vs. v2.0
    • TPC-H 50G Performance Test - v2.1 vs. v2.0
    • DM Benchmark Report
• 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
    • Explore SQL with TiDB
    • Import Example Database
    • Read Historical Data
    • TiDB Binlog Tutorial
    • TiDB Data Migration Tutorial
    • TiDB Lightning 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
    • 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 2.1
  • Troubleshoot
    • Troubleshoot Cluster Setup
    • Troubleshoot TiDB Lightning
• Reference
  • SQL
    • MySQL Compatibility
    • 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 DATABASE
      • ALTER TABLE
      • ALTER USER
      • ANALYZE TABLE
      • BEGIN
      • COMMIT
      • CREATE DATABASE
      • CREATE INDEX
      • CREATE TABLE LIKE
      • CREATE TABLE
      • CREATE USER
      • DEALLOCATE
      • DELETE
      • DESC
      • DESCRIBE
      • DO
      • DROP COLUMN
      • DROP DATABASE
      • DROP INDEX
      • DROP TABLE
      • DROP USER
      • 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 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 REGIONS
      • SHOW TABLE STATUS
      • SHOW [GLOBAL|SESSION] VARIABLES
      • SHOW WARNINGS
      • SPLIT REGION
      • 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
  • 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
  • Key Monitoring Metrics
    • Overview
    • TiDB
    • PD
    • TiKV
  • Alert Rules
  • Best Practices
    • HAProxy Best Practices
    • PD Scheduling Best Practices
    • Grafana Best Practices
    • TiKV Performance Tuning with Massive Regions
  • TiSpark
  • TiDB Binlog
    • Overview
    • Deploy
    • Maintain
    • Monitor
    • Upgrade
    • Reparo
    • Binlog Slave Client
    • Troubleshoot
      • Troubleshooting
      • Error Handling
    • FAQ
  • Tools
    • Mydumper
    • Syncer
    • Loader
    • TiDB Data Migration
      • Overview
        • DM Overview
        • Restrictions
        • DM-worker
        • DM Relay Log
      • Features
        • Table Routing
        • Black and White Lists
        • Binlog Event Filter
        • Replication Delay Monitoring
        • Sharding Support
          • Introduction
          • Restrictions
          • Handle Sharding DDL Locks Manually
      • Usage Scenarios
        • Simple Scenario
        • Shard Merge Scenario
        • Shard Merge Best Practices
      • Deploy
      • Configure
        • Overview
        • Task Configuration
      • Manage the DM Cluster
        • Cluster Operations
        • Cluster Upgrade
      • Manage Replication Tasks
        • Manage Tasks
        • Precheck Tasks
        • Query Task Status
        • Skip or Replace Abnormal SQL Statements
      • Monitor
      • Migrate from MySQL compatible database
        • Migrate from Aurora
      • Troubleshoot
        • DM Troubleshooting
        • Error Description
        • Error Handling
      • FAQ
      • Releases
        • v1.0
          • 1.0.2
          • 1.0.3
      • TiDB DM Glossary
    • TiDB Lightning
      • Overview
      • Deployment
      • Configuration
      • Checkpoints
      • Table Filter
      • CSV Support
      • Web Interface
      • Monitor
      • Troubleshoot
      • FAQ
    • sync-diff-inspector
    • PD Control
    • PD Recover
    • TiKV Control
    • TiDB Control
    • Download
• FAQs
  • TiDB FAQs
  • TiDB Lightning FAQs
  • Upgrade FAQs
• Support
  • Support Resources
  • Report an Issue
• Contribute
  • Contribute to TiDB
  • Improve the Docs

• Adopters
• Roadmap

• Releases
  • v2.1
    • 2.1.19
    • 2.1.18
    • 2.1.17
    • 2.1.16
    • 2.1.15
    • 2.1.14
    • 2.1.13
    • 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
• Glossary