TiDB Weekly

News & blog posts

Last week, we published a post describes how we hacked through different approaches of clock skew and how TimeChaos in Chaos Mesh enables time to swing freely in containers.

This full post is here:

Simulating Clock Skew in K8s Without Affecting Other Containers on the Node

Inspired by Google's Key Visualizer, we have implemented Key Visualizer (KeyViz) in TiDB, a distributed, relational, NewSQL database. Key Visualizer displays system status graphically, which helps database administrators (DBAs) quickly troubleshoot database performance issues and enables users to gain deep insights into their applications.

Last week, we published another post that does a deep dive on what Key Visualizer is, how it works, how it can help you, and which scenarios it applies to. If you're a DBA or database developer, we hope you can take this knowledge and apply it to your own work. For example, if you're a developer, you could adopt TiDB and Key Visualizer for your own applications, or even design a similar tool to troubleshoot your system.

The full article is here:

Key Visualizer: Observe Distributed Databases to Discover the Unknowns

Community

New contributors

tikv:

• de-sh

docs:

• terror

chaos-mesh:

• wuurrd
• rbtcollins

Call for participation

TiDB

• To fix the issue that the incorrect result is returned when comparing NULL in the integer type column with the float type
• To address the issue that the show grants statement should contain the privilege information for creating bindings
• All help-wanted issues in TiDB

TiKV

• To always enable the pessimistic transaction
• To fix the unexpected escape characters in schedulers-payload
• 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 183 PRs in the TiDB repository, 6 PRs in the TiUP repository, 40 PRs in the TiDB Dashboard repository, 5 PRs in the TiSpark repository, and 78 PRs in the TiKV and PD repositories.

TiDB

• Fix the issue that an incorrect Region is returned when getting a Region by ID
• Enable update if the update list does not contain the view
• Make the get function return the NotExist error if the key is not found
• Fix duplicated lock keys that cause data inconsistency
• Support the auto_random table option
• Add TiFlash in the cluster_info table
• Fix the issue that two rows are inserted successfully with the same primary key
• Fix the potential HTTP connection leak
• Build the right range when the where clause only has the string column
• Fix the privilege check for loading data
• Implement the adaptive GC safePoint

TiDB Dashboard

• Support the dynamic configuration in the TiDB Dashboard
• Show the recent slow queries
• Add the TiFlash panel
• Add more columns for statements
• Add the slow query list and the detail page

TiUP

• Port the static checks used in TiDB
• Support upgrading TiFlash
• Add the CDC component
• Support the upgrade from nightly to latest nightly

TiKV

• Use the batch split for auto-split
• Check the state after resuming apply fsm
• Write the configuration change to the configuration file
• Consider the wake-up message when checking stale messages in peer fsm
• Support controlling the replication mode
• Do not push min_commit_ts if caller_start_ts is max u64

PD

• Unify the HTTP client

TiSpark

• Update the primary key TTL

On-going TiDB event

TiDB Usability Challenge Program