Note:
This topic has been translated from a Chinese forum by GPT and might contain errors.Original topic: 【TiDB 社区每周精选】TiDB 常用 SQL & 记一次 TiDB v5.2.3 迁移到 v6.1.0 的过程
|
username: TiDB社区小助手
Common SQL in TiDB
This article summarizes and records commonly used SQL in TiDB, including queries for table size, statistics, execution plans, viewing regions, hotspot table issues, slow queries, TiFlash, admin commands, modifying isolation parameters, and troubleshooting.
Documenting the Migration Process from TiDB v5.2.3 to v6.1.0
This article documents the process of migrating from TiDB v5.2.3 to v6.1.0. There are many methods for migrating between TiDB clusters, and this article provides options based on the actual situation of the customer. Before migration, it is necessary to compare the parameter files and system variables of the two clusters, and after migration, parameter adjustments should be made.
TiFlash Source Code Reading (Part 6): Design and Implementation Analysis of DeltaTree Index
In previous source code analyses, we have deeply analyzed the computing and storage layers of TiFlash. This article explains the role of DeltaTree Index during reads and how to maintain the DeltaTree Index.
TiFlash Source Code Reading (Part 7): TiFlash Proxy Module
The TiFlash source code reading series introduces the internal implementation of TiFlash from the source code level. In previous introductions, you should have gained some understanding of how TiFlash stores and computes. This article mainly introduces the implementation of the TiFlash Proxy module, i.e., how TiFlash replicas are added and data is retrieved.
- TiKV Error: Connection to Port 20160 Timed Out
- Optimization Directions for Slow SQL
- Lightning Full Import Stuck for Almost a Day
- TiKV Error: Region 9555
- TiDB Component Node Memory Slowly Increases Until Exhausted
December 10th, Shanghai Offline Serverless HTAP Database Experience Workshop
On December 10th, join the Shanghai offline Serverless HTAP database experience workshop. Build an all-in-cloud bookstore website in 20 minutes, and learn from PingCAP’s original ecosystem team engineers how to flexibly use TiDB components in different scenarios to improve query analysis efficiency!
One-click Registration
Click here for more information
Discover and Challenge | PingCAP DevCon 2022 Registration Open
What are the cutting-edge trends in the database industry? How does PingCAP create leading database products? How can users leverage the new generation of database services to achieve data agility?
From December 1st to 3rd, you are invited to find out.
Conference Highlights Preview:
This Devcon 2022 can be attended both online and offline. Register to earn +100 points, and get a chance to win limited edition Ti frisbees! Start from Ti Planet and join us to discover and challenge! Scan the code to register directly!
TiDBer Chat Tea Party 47: If You Are Watching the World Cup and the Database Has a Problem, But It’s Not Urgent and Won’t Affect Business, Would You Go to Work If Your Boss Calls You?
Imagine… the World Cup has started… After a long day, you sit in front of the TV full of excitement, ready to cheer with a drink in hand. At this moment, the familiar and dreaded work phone rings. It turns out there’s a problem with the database, although it’s not very urgent, your boss asks you to work overtime. At this moment… would you go?
Click to Participate
TiDBer Chat Tea Party 46: What Does a Day in the Life of a TiDBer Look Like?
TiDBer Chat Tea Party 45: Set a Flag, What Is Your Next Badge Goal?
After seeing so many updated badges, which one do TiDBers like the most & find the most meaningful? Do you have any ideas for new badges? Are there any events you think should be commemorated with a badge?