Note:
This topic has been translated from a Chinese forum by GPT and might contain errors.
Original topic: 磁盘空间不足时会导致不记录大语句的慢查询么？
[TiDB Usage Environment] Production Environment
[TiDB Version] v5.1.0
[Reproduction Path] None
[Encountered Problem]
Only some slow queries are recorded in the slow query log. Manually executing a query that takes more than 10 seconds is not recorded in the slow query log, but there are indeed slow queries recorded today. Could insufficient disk space cause this situation?
You definitely need to ensure enough space, otherwise, the logs can’t be written… In severe cases, the service will crash… 
Insufficient disk space can cause various inexplicable problems. It feels like it’s essential to ensure that the basics are adequately provided.
It’s not that there is no space at all. The current situation is that some statements are recorded, while others are not. The time for all of them exceeds the threshold.
Could it be that they are not on the same TiDB server?
Just checked, all the slow queries are from one node, and the slow queries from other nodes are not recorded~
Is the configuration of TiDB server slow logs different?
show config where name like ‘%slow%’
The case is solved; it’s a bug in this version. When the log level is set to error, slow queries are not recorded.
Take a small notebook and jot it down~
I have encountered disk insufficiency twice. Generally, it becomes extremely slow even before any log records indicate a problem.
This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.
|
username: Kongdom
|
username: 
|
username: 
|
username: 
|
username: