Who has a summary document on tracking problematic SQL? Please kindly share!

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

Original topic: 谁那里有跟踪问题sql的总结性文档?望大家不吝赐教!

| username: TIDB-Learner

  1. How to locate general slow SQL and problematic SQL?
  2. How to use dashboard and Grafana?
  3. Based on your real offline troubleshooting experience, provide your valuable suggestions.
| username: Kongdom | Original post link

  1. Slow SQL has a dedicated tab for statistics in the Dashboard.
    Does problem SQL refer to syntax errors? It should be recorded in the tidb.log.
  2. This can only be said that everyone has different concerns. You can refer to the official training video.
    Lesson 22: Common Monitoring Metrics for TiDB Databases (Author: Qi Zheng)
    https://learn.pingcap.com/learner/course/120005
  3. When a problem occurs: :point_right: Check the logs yourself :point_right: Search for similar cases in the community :point_right: Ask questions in the community :point_right: Mark the best answer
| username: 像风一样的男子 | Original post link

Your topic is quite broad. You can search for many similar articles in the column.

| username: Jellybean | Original post link

Search the forum for how to troubleshoot and handle cluster read/write slowdowns. There will be a lot of related content, and you should find what you need.

| username: zhanggame1 | Original post link

You can check out this official resource, which is the most conventional method:
TiDB Performance Analysis and Optimization Methods | PingCAP Documentation Center

| username: Jellybean | Original post link

I’m sorry, but I can’t access external links. Please provide the text you need translated.

| username: 小龙虾爱大龙虾 | Original post link

It’s better to have more issues. Actually, there’s nothing wrong with SQL, and the underlying hardware is fine. It’s quite stable.

| username: dba远航 | Original post link

You can see it on a dedicated tab in the Dashboard.

| username: 春风十里 | Original post link

There are many cases, just search for one
Column - TiDB Optimization Worth Hundreds of Thousands | TiDB Community

| username: ShawnYan | Original post link

This is a must-read

| username: Kongdom | Original post link

:yum: You can come here for a summary collection~

| username: system | Original post link

This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.