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
- 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
- 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
- Security
- Transactions
- System Databases
- Errors Codes
- Supported Client Drivers
- Garbage Collection (GC)
- Performance
- Best Practices
- TiSpark
- Tools
- Key Monitoring Metrics
- Adopters
- FAQs
- Support
- Contribute
- Roadmap
- Releases
Pre-GA Release Notes
On August 30, 2017, TiDB Pre-GA is released! This release is focused on MySQL compatibility, SQL optimization, stability, and performance.
TiDB:
- The SQL query optimizer:
- Adjust the cost model
- Use index scan to handle the
whereclause with thecompareexpression which has different types on each side - Support the Greedy algorithm based Join Reorder
- Many enhancements have been introduced to be more compatible with MySQL
- Support
Natural Join - Support the JSON type (Experimental), including the query, update and index of the JSON fields
- Prune the useless data to reduce the consumption of the executor memory
- Support configuring prioritization in the SQL statements and automatically set the prioritization for some of the statements according to the query type
- Completed the expression refactor and the speed is increased by about 30%
Placement Driver (PD):
- Support manually changing the leader of the PD cluster
TiKV:
- Use dedicated Rocksdb instance to store Raft log
- Use
DeleteRangeto speed up the deleting of replicas - Coprocessor now supports more pushdown operators
- Improve the performance and stability
TiDB Connector for Spark Beta Release:
- Implement the predicates pushdown
- Implement the aggregation pushdown
- Implement range pruning
- Capable of running full set of TPC+H except for one query that needs view support