dble中执行语句慢,怎么排查 #2958
Answered
by
Dinosauria
PanternBao
asked this question in
Q&A
dble中执行语句慢,怎么排查
#2958
-
一段很简单的SQL,但dble查询和单库查询执行时间对比,相差n秒,dble执行查询慢在哪里?怎么排查? |
Beta Was this translation helpful? Give feedback.
Answered by
Dinosauria
Nov 17, 2021
Replies: 2 comments
-
排查方向:
找出具体哪个环节耗时较多 |
Beta Was this translation helpful? Give feedback.
0 replies
Answer selected by
yanhuqing666
-
前置知识需要简单了解下dble一条sql的内部流程
慢日志中可以体现上述步骤的各个阶段耗时。 各个阶段的耗时说明:
举例 文档中有使用dble的慢日志说明 如何开启慢日志 |
Beta Was this translation helpful? Give feedback.
0 replies
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
排查方向:
找出具体哪个环节耗时较多