Skip to content

Latest commit

 

History

History
62 lines (42 loc) · 4.13 KB

experimental-features.md

File metadata and controls

62 lines (42 loc) · 4.13 KB
Raw
title summary aliases
TiDB Experimental Features
Learn the experimental features of TiDB.
/tidb/dev/experimental-features-4.0/

TiDB Experimental Features

This document introduces the experimental features of TiDB in different versions. It is NOT recommended to use these features in the production environment.

Stability

  • TiFlash limits the use of I/O resources by compressing or sorting data, mitigating the contention for I/O resources between background tasks and front-end data reading and writing (Introduced in v5.0)
  • Improve the stability of the optimizer's choice of indexes (Introduced in v5.0)
    • Extend the statistics feature by collecting the multi-column order dependency information.
    • Refactor the statistics module, including deleting the TopN value from CMSKetch and the histogram, and adding NDV information for histogram buckets of each table index.
  • hibernate-regions. A Region that idles for a long time is automatically set as hibernated. This reduces the extra overhead caused by heartbeat messages between the Raft leader and the followers for idle Regions.

Scheduling

  • Cascading Placement Rules feature. It is a replica rule system that guides PD to generate corresponding schedules for different types of data. By combining different scheduling rules, you can finely control the attributes of any continuous data range, such as the number of replicas, the storage location, the host type, whether to participate in Raft election, and whether to act as the Raft leader. See Cascading Placement Rules for details. (Introduced in v4.0)
  • Elastic scheduling feature. It enables the TiDB cluster to dynamically scale out and in on Kubernetes based on real-time workloads, which effectively reduces the stress during your application's peak hours and saves overheads. See Enable TidbCluster Auto-scaling for details. (Introduced in v4.0)

SQL

  • List Partition (Introduced in v5.0)
  • List COLUMNS Partition (Introduced in v5.0)
  • The expression index feature. The expression index is also called the function-based index. When you create an index, the index fields do not have to be a specific column but can be an expression calculated from one or more columns. This feature is useful for quickly accessing the calculation-based tables. See Expression index for details. (Introduced in v4.0)
  • Generated Columns.
  • User-Defined Variables.
  • JSON data type and JSON functions.
  • View.

Configuration management

  • Persistently store configuration parameters in PD, and support dynamically modifying configuration items. (Introduced in v4.0)
  • SHOW CONFIG (Introduced in v4.0)

Data sharing and subscription

Storage

  • Disable Titan.
  • Titan Level Merge.
  • TiFlash supports distributing the new data of the storage engine on multiple hard drives to share the I/O pressure. (Introduced in v4.0)

Backup and restoration

Garbage collection

Diagnostics