Documentation
- 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
-
Reference
-
Tools
- Mydumper
- Syncer
- Loader
- TiDB Data Migration
- TiDB Lightning
- sync-diff-inspector
- PD Control
- PD Recover
- TiKV Control
- TiDB Control
- Download
- MySQL Compatibility
-
SQL
- SQL Language Structure
- Data Types
-
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
- Window 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
- 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
- RECOVER TABLE
- 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 REGIONS
- SHOW TABLE STATUS
- SHOW [GLOBAL|SESSION] VARIABLES
- SHOW WARNINGS
- SPLIT REGION
- START TRANSACTION
- TRACE
- TRUNCATE
- UPDATE
- USE
- Constraints
- Generated Columns
- Partitioning
- Character Set
- SQL Mode
- Views
- Configuration
- Key Monitoring Metrics
- Alert Rules
- Security
- Transactions
- System Databases
- Errors Codes
- Supported Client Drivers
- Garbage Collection (GC)
- Performance
- Best Practices
- TiSpark
- TiDB Binlog Cluster Overview
- Adopters
-
Tools
- TiDB in Kubernetes
- FAQs
- Support
- Contribute
- Roadmap
- Releases
TiDB 2.0.2 Release Notes
On May 21, 2018, TiDB 2.0.2 is released. Compared with TiDB 2.0.1, this release has great improvement in system stability.
TiDB
- Fix the issue of pushing down the Decimal division expression
- Support using the
USE INDEXsyntax in theDeletestatement - Forbid using the
shard_row_id_bitsfeature in columns withAuto-Increment - Add the timeout mechanism for writing Binlog
PD
- Make the balance leader scheduler filter the disconnected nodes
- Modify the timeout of the transfer leader operator to 10s
- Fix the issue that the label scheduler does not schedule when the cluster Regions are in an unhealthy state
- Fix the improper scheduling issue of
evict leader scheduler
TiKV
- Fix the issue that the Raft log is not printed
- Support configuring more gRPC related parameters
- Support configuring the timeout range of leader election
- Fix the issue that the obsolete learner is not deleted
- Fix the issue that the snapshot intermediate file is mistakenly deleted
"TiDB 2.0.2 Release Notes"
was last updated
Aug 5 2019:
*: fix all markdownlint issue in docs repo (#1410) (f410df4)