[TiDBer Chat Session 119] TiDB 8.1 LTS Version Officially Released! Let's Discuss the Features of Version 8.1 That Can Help Address Your Business Scenario Pain Points

This topic has been translated from a Chinese forum by GPT and might contain errors.

Original topic: 【TiDBer 唠嗑茶话会 119】 TiDB 8.1 LTS 版本正式上线啦!一起聊聊 8.1 版本有哪些功能能帮助到你的业务场景痛点?

| username: TiDB社区小助手

TiDB 8.1.0 LTS is released! :tada::tada: The 8.1 version has made significant improvements and optimizations in stability, performance, SQL, database management, and data migration! Let’s take a look! :eyes: :raised_hands:

v8.1.0 Release Note:

Key Enhancements in v8.1.0:

  • Introduced a priority queue for automatic statistics collection, optimizing the order of statistics collection
  • Execution plan cache now supports plans that include “partitioned tables” and “generated columns,” expanding the application scenarios of plan caching
  • Improved BR snapshot recovery speed, with table creation performance increased by 10 times
  • Added support for pushing down a large number of functions, optimizing the execution plan selection for JSON multi-value indexes
  • Enhanced the scalability of PD Region information query service through Active PD Follower (experimental feature)
  • Supported splitting PD functionality into microservices, further improving system scalability (experimental feature)

Topic of the Issue:

TiDB 8.1 LTS version is officially online! Let’s discuss which features of version 8.1 can help address your business scenario pain points?

Participation Rewards:

Participate in the discussion and earn 30 points & experience points!

Event Duration:

2024.5.24 - 2024.5.31

| username: coderv | Original post link

Data migration!

| username: 柴米油酱 | Original post link

The automatic statistics collection introduced a priority queue, optimizing the order of statistics collection. Table creation performance has been improved by 10 times.

| username: Jellybean | Original post link

The automatic statistics collection introduced a priority queue, optimizing the order of statistics collection.

| username: xfworld | Original post link

Global sorting + CDC enhancement

| username: 努力学习的小白 | Original post link

Using TiProxy

| username: yytest | Original post link

Now let’s test it on the virtual machine, and start the tiup upgrade!

| username: Fly-bird | Original post link

Can BR snapshot recovery capability restore data from version 5.4 to version 7.5? If it can, that would be even better.

| username: 啦啦啦啦啦 | Original post link

The automatic statistics collection has introduced a priority queue.

| username: herowk | Original post link

Snapshot recovery speed must be improved!!!

| username: 望海崖2084 | Original post link

BR snapshot recovery and function pushdown improve query performance.

| username: TiDBer_刚 | Original post link

I think cross-database execution plan binding, automatic statistics collection priority, and improving BR snapshot recovery speed are very practical.

| username: lemonade010 | Original post link

The dynamic statistics collection has introduced a priority queue, optimizing the order of statistics collection, improving recovery speed, and adding a large number of function pushdowns.

| username: TiDBer_wHJmjTiw | Original post link

Observing index usage can identify invalid indexes and improve operational efficiency.

| username: Kongdom | Original post link

Improve BR snapshot recovery speed

| username: DBRE | Original post link

Writing general logs to a separate file and the speed of BR snapshot recovery

| username: 希希希望啊 | Original post link

The introduction of priority queues for automatic statistics collection has improved table creation performance by 10 times. It can handle batch DML for larger transactions.

| username: TiDBer_GMrExvHp | Original post link

Table creation performance improved by 10 times, handling larger transactions with batch DML.