562 lines (555 loc) · 34.4 KB

Table of Contents

GET STARTED

GUIDES

Manage Cluster
- Select Your Cluster Plan
- Manage TiDB Cloud Clusters
  - Create a TiDB Cloud Cluster
  - Connect to Your TiDB Cloud Cluster
  - Branch
  - Manage Spending Limit
  - Back Up and Restore TiDB Cloud Data
  - Export Data from TiDB Cloud
- Use an HTAP Cluster with TiFlash
- Monitor and Alert
- Tune Performance
  - Overview
  - Analyze Performance
  - SQL Tuning
    - Overview
    - Understanding the Query Execution Plan
      - Overview
      - EXPLAIN Walkthrough
      - Indexes
      - Joins
      - MPP Queries
      - Subqueries
      - Aggregation
      - Views
      - Partitions
      - Index Merge
    - SQL Optimization Process
      - Overview
      - Logic Optimization
        
        Overview
        
        Subquery Related Optimizations
        
        Column Pruning
        
        Decorrelation of Correlated Subquery
        
        Eliminate Max/Min
        
        Predicates Push Down
        
        Partition Pruning
        
        TopN and Limit Push Down
        
        Join Reorder
        
        Derive TopN or Limit from Window Functions
      - Physical Optimization
        
        Overview
        
        Index Selection
        
        Statistics
        
        Extended Statistics
        
        Wrong Index Solution
        
        Distinct Optimization
        
        Cost Model
        
        Runtime Filter
      - Prepared Execution Plan Cache
      - Non-Prepared Execution Plan Cache
    - Control Execution Plans
  - TiKV Follower Read
  - Coprocessor Cache
  - Garbage Collection (GC)
    - Overview
    - Configuration
  - Tune TiFlash Performance
- Upgrade a TiDB Cluster
- Delete a TiDB Cluster
Migrate or Import Data
Explore Data
- Chat2Query in SQL Editor
- SQL Proxy Account
Data Service
Security
- Security Overview
- Identity Access Control
- Network Access Control
- Audit Management
  - Console Audit Logging
Billing
Integrations

REFERENCE

SQL Reference
- Explore SQL with TiDB
- SQL Language Structure and Syntax
  - Attributes
  - Literal Values
  - Schema Object Names
  - Keywords and Reserved Words
  - User-Defined Variables
  - Expression Syntax
  - Comment Syntax
- SQL Statements
  - Overview
  - ADMIN
  - ADMIN CANCEL DDL
  - ADMIN CHECKSUM TABLE
  - ADMIN CHECK [TABLE|INDEX]
  - ADMIN CLEANUP INDEX
  - ADMIN PAUSE DDL
  - ADMIN RECOVER INDEX
  - ADMIN RESUME DDL
  - ADMIN SHOW DDL [JOBS|JOB QUERIES]
  - ALTER DATABASE
  - ALTER INSTANCE
  - ALTER SEQUENCE
  - ALTER TABLE
    - Overview
    - ADD COLUMN
    - ADD INDEX
    - ALTER INDEX
    - CHANGE COLUMN
    - COMPACT
    - DROP COLUMN
    - DROP INDEX
    - MODIFY COLUMN
    - RENAME INDEX
  - ALTER USER
  - ANALYZE TABLE
  - BATCH
  - BEGIN
  - CANCEL IMPORT JOB
  - COMMIT
  - CREATE [GLOBAL|SESSION] BINDING
  - CREATE DATABASE
  - CREATE INDEX
  - CREATE ROLE
  - CREATE SEQUENCE
  - CREATE TABLE LIKE
  - CREATE TABLE
  - CREATE USER
  - CREATE VIEW
  - DEALLOCATE
  - DELETE
  - DESC
  - DESCRIBE
  - DO
  - DROP [GLOBAL|SESSION] BINDING
  - DROP DATABASE
  - DROP ROLE
  - DROP SEQUENCE
  - DROP STATS
  - DROP TABLE
  - DROP USER
  - DROP VIEW
  - EXECUTE
  - EXPLAIN ANALYZE
  - EXPLAIN
  - FLASHBACK CLUSTER
  - FLASHBACK DATABASE
  - FLASHBACK TABLE
  - FLUSH PRIVILEGES
  - FLUSH STATUS
  - FLUSH TABLES
  - GRANT <privileges>
  - GRANT <role>
  - IMPORT INTO
  - INSERT
  - KILL [TIDB]
  - LOAD DATA
  - LOCK STATS
  - LOCK TABLES and UNLOCK TABLES
  - PREPARE
  - RECOVER TABLE
  - RENAME TABLE
  - RENAME USER
  - REPLACE
  - REVOKE <privileges>
  - REVOKE <role>
  - ROLLBACK
  - SAVEPOINT
  - SELECT
  - SET DEFAULT ROLE
  - SET [NAMES|CHARACTER SET]
  - SET PASSWORD
  - SET ROLE
  - SET TRANSACTION
  - SET [GLOBAL|SESSION] <variable>
  - SHOW ANALYZE STATUS
  - SHOW [GLOBAL|SESSION] BINDINGS
  - SHOW BUILTINS
  - SHOW CHARACTER SET
  - SHOW COLLATION
  - SHOW COLUMN_STATS_USAGE
  - SHOW COLUMNS FROM
  - SHOW CREATE DATABASE
  - SHOW CREATE SEQUENCE
  - SHOW CREATE TABLE
  - SHOW CREATE USER
  - SHOW DATABASES
  - SHOW ENGINES
  - SHOW ERRORS
  - SHOW FIELDS FROM
  - SHOW GRANTS
  - SHOW IMPORT JOB
  - SHOW INDEXES [FROM|IN]
  - SHOW MASTER STATUS
  - SHOW PRIVILEGES
  - SHOW PROCESSLIST
  - SHOW PROFILES
  - SHOW SCHEMAS
  - SHOW STATS_BUCKETS
  - SHOW STATS_HEALTHY
  - SHOW STATS_HISTOGRAMS
  - SHOW STATS_LOCKED
  - SHOW STATS_META
  - SHOW STATS_TOPN
  - SHOW STATUS
  - SHOW TABLE NEXT_ROW_ID
  - SHOW TABLE STATUS
  - SHOW TABLES
  - SHOW [GLOBAL|SESSION] VARIABLES
  - SHOW WARNINGS
  - START TRANSACTION
  - TABLE
  - TRACE
  - TRUNCATE
  - UNLOCK STATS
  - UPDATE
  - USE
  - WITH
- Data Types
  - Overview
  - Default Values
  - Numeric Types
  - Date and Time Types
  - String Types
  - JSON Type
- Functions and Operators
  - Overview
  - 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
  - Locking Functions
  - Information Functions
  - JSON Functions
    - Overview
    - Functions That Create JSON
    - Functions That Search JSON
    - Functions That Modify JSON
    - Functions That Return JSON
    - JSON Utility Functions
    - Functions That Aggregate JSON
  - Aggregate (GROUP BY) Functions
  - GROUP BY Modifiers
  - Window Functions
  - Miscellaneous Functions
  - Precision Math
  - Set Operations
  - Sequence Functions
  - List of Expressions for Pushdown
  - TiDB Specific Functions
- Clustered Indexes
- Global Indexes
- Constraints
- Generated Columns
- SQL Mode
- Table Attributes
- Transactions
  - Overview
  - Isolation Levels
  - Optimistic Transactions
  - Pessimistic Transactions
  - Non-Transactional DML Statements
- Views
- Partitioning
- Temporary Tables
- Cached Tables
- FOREIGN KEY Constraints
- Character Set and Collation
  - Overview
  - GBK
- Read Historical Data
  - Use Stale Read (Recommended)
  - Use the tidb_snapshot System Variable
- System Tables
  - mysql Schema
    - Overview
    - user
  - INFORMATION_SCHEMA
  - PERFORMANCE_SCHEMA
    - Overview
    - SESSION_CONNECT_ATTRS
  - SYS
    - Overview
    - schema_unused_indexes
- Metadata Lock
- TiDB Accelerated Table Creation
CLI Reference
- Overview
- auth
  - login
  - logout
  - whoami
- serverless
  - capacity
  - create
  - delete
  - describe
  - list
  - update
  - spending-limit
  - region
  - shell
  - branch
    - create
    - delete
    - describe
    - list
    - shell
  - import
    - cancel
    - describe
    - list
    - start
  - export
    - create
    - describe
    - list
    - cancel
    - download
  - sql-user
    - create
    - delete
    - list
    - update
  - authorized-network
    - create
    - delete
    - list
    - update
- completion
- config
  - create
  - delete
  - describe
  - edit
  - list
  - set
  - use
- project
  - list
- upgrade
- help
General Reference
- TiDB Classic Architecture
  - Overview
  - Storage
  - Computing
  - Scheduling
  - TSO
- TiDB X Architecture
- Storage Engines
  - TiKV
    - TiKV Overview
    - RocksDB Overview
  - TiFlash
    - TiFlash Overview
    - Spill to Disk
- TiDB Cloud Partner Web Console
- {{{ .starter }}} and Essential Limitations
- Limited SQL Features on TiDB Cloud
- TiDB Limitations
- System Variables
- Server Status Variables
- Table Filter
- URI Formats of External Storage Services
- Troubleshoot Inconsistency Between Data and Indexes
- Notifications
Support Plan
- Connected Care Overview
- Connected Care Details
- Connected Care Support Service Features
  - Connected: AI Chat in IM
  - Connected: IM Ticket Creation and Update Subscription
    - Create Tickets and Subscribe to Ticket Updates via Slack
    - Create Tickets and Subscribe to Ticket Updates via Lark
  - Connected: IM Interaction for Support Tickets
    - Interact with Support Tickets via Slack
    - Interact with Support Tickets via Lark
- Get Support
FAQs
- TiDB Cloud FAQs
- {{{ .starter }}} FAQs
Glossary