[Case Study & Solution] Slow Query/Slow Log/Slow SQL Issues

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

Original topic: 【故障案例&解决方案】慢查询/慢日志/慢SQL问题

| username: Billmay表妹

Slow Queries/Slow Logs/Slow SQL Issues - Column Articles

Contributor: @TiDB Community Assistant

TiDB Query Optimization and Tuning Series (III) Slow Query Diagnosis, Monitoring, and Troubleshooting

TiDB Query Optimization and Tuning Series (V) Tuning Case Practices

Contributor: @ealam_Xiaoyu

A Slow Query with Multiple Table Join Order - TiDB Join Features

Contributor: @aylen

TiDB Slow Log Parsing Source Code Interpretation

Contributor: @18515065291

Solving Slow SQL Issues with Business Upgrade to 5.0

TiDB Optimization Worth Hundreds of Thousands

Contributor: @Hacker_o052psBo

Solving Slow SQL Issues with Report Business Upgrade to 5.0

Contributor: @jiyf

Optimizing a Slow SQL Statement with LIKE Condition

Contributor: @BraveChen

SQL Tuning Case Sharing Based on TiDB Execution Plan

Contributor: @HHHHHHULK

SQL Executing Normally in MySQL Becomes Slow in TiDB

Contributor: @luzizhou

TiDB Slow Log Practices at Banyu

Contributor: @mysia

Elastic Stack Handling TiDB Slow Logs

Contributor: @mydb

Several TiDB SQL Optimization Cases

An Investigation into a Strange Slow Write Issue in TiDB Cluster

Slow Queries/Slow Logs/Slow SQL Issues - Technical Q&A

Questions about Slow Query Time in Grafana Panel

Slow Queries Caused by High Concurrency Update with Pessimistic Lock in TiDB

Does TiDB Slow Query Log Never Delete Automatically?

Ordinary Insert Statement Recorded as Slow Query, Query_time Takes 3s, Why? How to Optimize?

How to Monitor Slow Queries with Prometheus in TiDB and Set Up Alerts to Report Slow Queries?

Inner Join Query is Slow

Stats in Slow Query slow_query Dictionary Table is Pseudo

TiDB SQL Slow Query

Slow Query Log Retention Time

What Do Two Metrics in Slow Query Log Mean?

Dashboard Slow Query Interface Lacks Columns

Dashboard Exporting Slow Query Data Error

Currently, a Single Slow SQL in TiDB Causes Severe Performance Degradation of the Entire Cluster

TiDB Becomes Very Laggy, Full of Slow Queries, Stuck on TiKV

Slow Query Sending Results Takes a Long Time, How to Troubleshoot

Setting Retention Days for Slow Logs

No Maximum Memory Usage Column in Slow Query Menu

TiDB Dashboard Slow Query Column Cannot Query Slow SQL Statements

SQL Slow Query: Process Keys Far Exceed Keys in Index Range

How to Terminate an Ongoing Slow SQL

How to Troubleshoot a Large Number of Slow SQLs

Consultation on Slow SQL

TiDB Slow Log Memory Usage

Dashboard Slow SQL Module Responds Slowly

Slow SQL Optimization, Same SQL Executes Normally in MySQL

Select Slow SQL Time Consumed in Prewrite

TiDB Built-in System Tables Automatically Generate a Large Number of Slow SQL Statements

Must TiDB Maintain Session Connection for Executing Slow SQL?

SQL Slow Query: Process Keys Far Exceed Keys in Index Range

Slow Queries Not Counted When Log Level is Error

TiDB Slow Log Shows Many Large Backoff_time

Memory Used by SQL and Memory Recorded in Slow Log Are Inconsistent

After Deleting Slow Logs, Flush Logs Cannot Generate New Slow Log Files

TiDB Dashboard Slow Log Interface

No Slow Query Log Records for the Current Day in TiDB Cluster - tidb_slow_query.log

Function of getBatchLogForReversedScan in Slow Log

How to Modify Default Value of TiDB Slow Query Log Recording

Slow Queries/Slow Logs/Slow SQL Issues - Official Documentation

Slow Query Log

Analyze Slow Queries

TiDB Dashboard Slow Query Page

TiDB Component Slow Query Log

Slow Log Memory Mapping Table

Configure TiDB Slow Query Log Persistent Volume

How to Record Slow Query Logs Separately in TiDB and Locate Slow Query SQL?

Slow Read Queries

Slow Query Page Shows Unknown Field Error

Search Similar Slow Queries by SQL Fingerprint

SQL Performance Tuning

| username: tidb菜鸟一只 | Original post link

Great post, I recommend students who encounter slow SQL issues to study it.

| username: Running | Original post link

Good article, it’s been compiled into a manual.

| username: weixiaobing | Original post link

Recommend to bookmark

| username: Hacker_ufuLjDKs | Original post link

Top, nice, nice, nice

| username: Alex920 | Original post link

Thank you, thank you.

| username: cassblanca | Original post link

I only discovered this post after exploring for a month. Thanks to my cousin for collecting so many valuable knowledge points. :grinning:

| username: zhanggame1 | Original post link

Learned.