TiDB Features

This document lists the features supported in different TiDB versions, including Long-Term Support (LTS) versions and Development Milestone Release (DMR) versions after the latest LTS version.

Data types, functions, and operators

Data types, functions, and operators7.06.66.56.15.45.35.25.15.04.0
Numeric typesYYYYYYYYYY
Date and time typesYYYYYYYYYY
String typesYYYYYYYYYY
JSON typeYYYEEEEEEE
Control flow functionsYYYYYYYYYY
String functionsYYYYYYYYYY
Numeric functions and operatorsYYYYYYYYYY
Date and time functionsYYYYYYYYYY
Bit functions and operatorsYYYYYYYYYY
Cast functions and operatorsYYYYYYYYYY
Encryption and compression functionsYYYYYYYYYY
Information functionsYYYYYYYYYY
JSON functionsYYYEEEEEEE
Aggregation functionsYYYYYYYYYY
Window functionsYYYYYYYYYY
Miscellaneous functionsYYYYYYYYYY
OperatorsYYYYYYYYYY
Character sets and collations 1YYYYYYYYYY
User-level lockYYYYNNNNNN

Indexing and constraints

Indexing and constraints7.06.66.56.15.45.35.25.15.04.0
Expression indexes 2YYYEEEEEEE
Columnar storage (TiFlash)YYYYYYYYYY
Use FastScan to accelerate queries in OLAP scenariosYEENNNNNNN
RocksDB engineYYYYYYYYYY
Titan pluginYYYYYYYYYY
Titan Level MergeEEEEEEEEEE
Use buckets to improve scan concurrencyEEEENNNNNN
Invisible indexesYYYYYYYYYN
Composite PRIMARY KEYYYYYYYYYYY
Unique indexesYYYYYYYYYY
Clustered index on integer PRIMARY KEYYYYYYYYYYY
Clustered index on composite or non-integer keyYYYYYYYYYN
Multi-valued indexesEENNNNNNNN
Foreign keyYYNNNNNNNN
TiFlash late materializationENNNNNNNNN

SQL statements

SQL statements 37.06.66.56.15.45.35.25.15.04.0
Basic SELECT, INSERT, UPDATE, DELETE, REPLACEYYYYYYYYYY
INSERT ON DUPLICATE KEY UPDATEYYYYYYYYYY
LOAD DATA INFILEYYYYYYYYYY
SELECT INTO OUTFILEYYYYYYYYYY
INNER JOIN, LEFT|RIGHT [OUTER] JOINYYYYYYYYYY
UNION, UNION ALLYYYYYYYYYY
EXCEPT and INTERSECT operatorsYYYYYYYYYN
GROUP BY, ORDER BYYYYYYYYYYY
Window FunctionsYYYYYYYYYY
Common Table Expressions (CTE)YYYYYYYYNN
START TRANSACTION, COMMIT, ROLLBACKYYYYYYYYYY
EXPLAINYYYYYYYYYY
EXPLAIN ANALYZEYYYYYYYYYY
User-defined variablesEEEEEEEEEE
BATCH [ON COLUMN] LIMIT INTEGER DELETEYYYYNNNNNN
BATCH [ON COLUMN] LIMIT INTEGER INSERT/UPDATE/REPLACEYYYNNNNNNN
ALTER TABLE ... COMPACTYYYENNNNNN
Table LockEEEEEEEEEE
TiFlash Query Result MaterializationEEENNNNNNN

Advanced SQL features

Advanced SQL features7.06.66.56.15.45.35.25.15.04.0
Prepared statement cacheYYYYYYEEEE
Non-prepared statement cacheENNNNNNNNN
SQL plan management (SPM)YYYYYYYYYY
Create bindings according to historical execution plansYYENNNNNNN
Coprocessor cacheYYYYYYYYYE
Stale ReadYYYYYYYYNN
Follower readsYYYYYYYYYY
Read historical data (tidb_snapshot)YYYYYYYYYY
Optimizer hintsYYYYYYYYYY
MPP execution engineYYYYYYYYYN
MPP execution engine - compression exchangeYYNNNNNNNN
Index MergeYYYYYEEEEE
Placement Rules in SQLYYYYEENNNN
Cascades PlannerEEEEEEEEEE

Data definition language (DDL)

Data definition language (DDL)7.06.66.56.15.45.35.25.15.04.0
Basic CREATE, DROP, ALTER, RENAME, TRUNCATEYYYYYYYYYY
Generated columnsEEEEEEEEEE
ViewsYYYYYYYYYY
SequencesYYYYYYYYYY
Auto incrementYYYYYYYYYY
Auto randomYYYYYYYYYY
TTL (Time to Live)YEENNNNNNN
DDL algorithm assertionsYYYYYYYYYY
Multi-schema change: add columnsYYYEEEEEEE
Change column typeYYYYYYYYNN
Temporary tablesYYYYYYNNNN
Concurrent DDL statementsYYYNNNNNNN
Acceleration of ADD INDEX and CREATE INDEXYYYNNNNNNN
Metadata lockYYYNNNNNNN
FLASHBACK CLUSTER TO TIMESTAMPYYYNNNNNNN

Transactions

Transactions7.06.66.56.15.45.35.25.15.04.0
Async commitYYYYYYYYYN
1PCYYYYYYYYYN
Large transactions (10GB)YYYYYYYYYY
Pessimistic transactionsYYYYYYYYYY
Optimistic transactionsYYYYYYYYYY
Repeatable-read isolation (snapshot isolation)YYYYYYYYYY
Read-committed isolationYYYYYYYYYY

Partitioning

Partitioning7.06.66.56.15.45.35.25.15.04.0
Range partitioningYYYYYYYYYY
Hash partitioningYYYYYYYYYY
Key partitioningYNNNNNNNNN
List partitioningYYYYEEEEEN
List COLUMNS partitioningYYYYEEEEEN
EXCHANGE PARTITIONYYYEEEEEEN
REORGANIZE PARTITIONYNNNNNNNNN
Dynamic pruningYYYYEEEENN
Range COLUMNS partitioningYYYNNNNNNN
Range INTERVAL partitioningEEENNNNNNN

Statistics

Statistics7.06.66.56.16.05.45.35.25.15.04.0
CMSketchDisabled by defaultDisabled by defaultDisabled by defaultDisabled by defaultDisabled by defaultDisabled by defaultDisabled by defaultYYYY
HistogramsYYYYYYYYYYY
Extended statisticsEEEEEEEEEEN
Statistics feedbackNNNDeprecatedDeprecatedDeprecatedEEEEE
Automatically update statisticsYYYYYYYYYYY
Fast AnalyzeEEEEEEEEEEE
Dynamic pruningYYYYEEEEENN
Collect statistics for PREDICATE COLUMNSEEEEEENNNNN
Control the memory quota for collecting statisticsEEEENNNNNNN
Randomly sample about 10000 rows of data to quickly build statisticsEEEEEEEEEEE
Lock statisticsEEENNNNNNNN

Security

Security7.06.66.56.15.45.35.25.15.04.0
Transparent layer security (TLS)YYYYYYYYYY
Encryption at rest (TDE)YYYYYYYYYY
Role-based authentication (RBAC)YYYYYYYYYY
Certificate-based authenticationYYYYYYYYYY
caching_sha2_password authenticationYYYYYYYNNN
tidb_sm3_password authenticationYYYNNNNNNN
tidb_auth_token authenticationYYYNNNNNNN
Password managementYYYNNNNNNN
MySQL compatible GRANT systemYYYYYYYYYY
Dynamic PrivilegesYYYYYYYYNN
Security Enhanced ModeYYYYYYYYNN
Redacted Log FilesYYYYYYYYYN

Data import and export

Data import and export7.06.66.56.15.45.35.25.15.04.0
Fast Importer (TiDB Lightning)YYYYYYYYYY
mydumper logical dumperDeprecatedDeprecatedDeprecatedDeprecatedDeprecatedDeprecatedDeprecatedDeprecatedDeprecatedDeprecated
Dumpling logical dumperYYYYYYYYYY
Transactional LOAD DATAE 5YYYYYYYYN 6
Database migration toolkit (DM)YYYYYYYYYY
TiDB BinlogYYYYYYYYYY
Change data capture (CDC)YYYYYYYYYY
Stream data to Amazon S3, Azure Blob Storage, NFS, and GCP through TiCDCYEENNNNNNN
TiCDC supports bidirectional replication between two TiDB clustersYYYNNNNNNN
TiCDC OpenAPI v2YNNNNNNNNN

Management, observability, and tools

Management, observability, and tools7.06.66.56.15.45.35.25.15.04.0
TiDB Dashboard UIYYYYYYYYYY
TiDB Dashboard Continuous ProfilingYYYYEENNNN
TiDB Dashboard Top SQLYYYYENNNNN
TiDB Dashboard SQL DiagnosticsYYYEEEEEEE
TiDB Dashboard Cluster DiagnosticsYYYEEEEEEE
TiKV-FastTune dashboardEEEEEEEEEE
Information schemaYYYYYYYYYY
Metrics schemaYYYYYYYYYY
Statements summary tablesYYYYYYYYYY
Statements summary tables - summary persistenceEENNNNNNNN
Slow query logYYYYYYYYYY
TiUP deploymentYYYYYYYYYY
Kubernetes operatorYYYYYYYYYY
Built-in physical backupYYYYYYYYYY
Global KillYYYYEEEEEE
Lock ViewYYYYYYYEEE
SHOW CONFIGYYYYYYYYYY
SET CONFIGYYYYEEEEEE
DM WebUIEEEENNNNNN
Foreground Quota LimiterYYYENNNNNN
Background Quota LimiterEEENNNNNNN
EBS volume snapshot backup and restoreYYYNNNNNNN
PITRYYYNNNNNNN
Global memory controlYYYNNNNNNN
Cross-cluster RawKV replicationEEENNNNNNN
Green GCEEEEEEEEEN
Resource controlEENNNNNNNN
TiFlash Disaggregated Storage and Compute Architecture and S3 SupportENNNNNNNNN

  1. TiDB incorrectly treats latin1 as a subset of utf8. See TiDB #18955 for more details.
  2. Starting from v6.5.0, the expression indexes created on the functions listed by the tidb_allow_function_for_expression_index system variable have been tested and can be used in production environments, and more functions will be supported in the future releases. For functions not listed by this variable, the corresponding expression indexes are not recommended for use in production environments. See expression indexes for details.
  3. See Statement Reference for a full list of SQL statements supported.
  4. For TiDB v4.0, the LOAD DATA transaction does not guarantee atomicity.
  5. For TiDB v7.0.0, the new parameter FIELDS DEFINED NULL BY and support for importing data from S3 and GCS are experimental features.