TiDB Weekly

News & blog post

Last week, we published an article that goes over how to build and run your own TiDB or TiKV, and how to run some benchmarks on those databases. The full article is here:

Building, Running, and Benchmarking TiKV and TiDB

TiDB 4.0 introduces SQL Plan Management (SPM), a mechanism that narrows down the optimizer's searching space to execution plans that are proven to perform well. SPM avoids performance degradation caused by unanticipated plan changes, and you don't have to change the application code.

Last week, we published an article that gives an overview of SPM and use an example to demonstrate how SPM helps the optimizer automatically select efficient execution plans.

The full article is here:

SQL Plan Management: Never Worry About Slow Queries Again

Community

New contributors

docs:

• Hangzhi

docs-cn:

• glkappe

tidb-operator:

• PengJi

Call for participation

TiDB

• To remove the default asc order in explain result
• To fix the issue that the table not exist error code in release-3.0 is not the same as that in master
• To fix the issue that the TestBuiltin unit test fails in different timezones
• To print SQL statements for the Out Of Memory (OOM) quota
• To evaluate aggregate functions in parallel with distinct in hashAgg
• All help-wanted issues in TiDB

TiKV

• All help-wanted issues in TiKV
• All help-wanted issues in PD

TiDB Change Data Capture (CDC)

• All help-wanted issues in TiDB Change Data Capture

Updates of the week

Progress

Last week, we landed 63 PRs in the TiDB repository, 2 PRs in the TiUP repository, 18 PRs in the TiDB Dashboard repository, 7 PRs in the TiSpark repository, and 16 PRs in the TiKV and PD repositories.

TiDB

• Fix the issue that the bootstrap SQL statements are not treated as internal queries in the statement summary
• Add a proposal document for the clustered index feature
• Fix the wrong plan type for the dataReaderBuilder error
• Fix the case of stmt_type in the statement summary

TiDB Dashboard

• Support the TiFlash disk information
• Support the case-insensitive log searching
• Refine UIs

TiUP

• Fix the panic caused by the mirror error
• Add the stack trace for check-configuration error

TiKV

• Fix the issue that restoring a backup archive from GCS does not work
• Use the key-only support of Titan for the raw key-value pair scan
• Support batching multiple requests into a Raft entry

PD

• Fix the 404 problem when using the region key command in pd-ctl

TiSpark

• Fix a TiSpark decoding error when using the Chunk encoding type
• Fix the split index
• Use snapshot.batchGet instead of snapshot.get

On-going TiDB event

TiDB Usability Challenge Program