[User Popular Recommendation] Sharing Slow Log Query Script

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

Original topic: 【用户热门推荐】分享慢日志查询脚本

| username: longzhuquan

Share your own script for analyzing slow query logs. Please test it yourself before using it in production.
gather_top_sql.sh (25.6 KB)

| username: zhanggame1 | Original post link

Support

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

Not bad, but can’t you also see it through the dashboard?

| username: TiDBer_RjzUpGDL | Original post link

Thank you for sharing.

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

Thank you for sharing :blush:

| username: residentevil | Original post link

This script has quite a lot of SHELL code, thanks for sharing.

| username: forever | Original post link

Awesome, you even made it into HTML.

| username: redgame | Original post link

:clap::clap::clap:

| username: DBAER | Original post link

Sure :+1:

| username: TiDBer_aaO4sU46 | Original post link

:+1::+1::+1:

| username: ShawnYan | Original post link

@longzhuquan
May I ask,

Combining scheduled tasks with Nginx’s automatic indexing feature

What does it mean?

| username: FutureDB | Original post link

Interesting.

| username: zhang_2023 | Original post link

Awesome

| username: 像风一样的男子 | Original post link

Saved.

| username: Kongdom | Original post link

:+1::+1::+1: Thanks for sharing

| username: onlyacat | Original post link

:+1::+1::+1: Thanks for sharing

| username: Jolyne | Original post link

One-click triple interaction

| username: 路在何chu | Original post link

Thank you, expert.

| username: 小于同学 | Original post link

Very good, thank you for sharing.

| username: danghuagood | Original post link

Awesome!