tencent cloud

TencentDB for MySQL

문서TencentDB for MySQL

Failure to Obtain slow_query_log_file via a Command

포커스 모드
폰트 크기
마지막 업데이트 시간: 2025-12-02 17:27:18

Symptom Description

The user failed to obtain the slow_query_log_file data by running the following command:
select @@slow_query_log_file;
Error message:
ERROR 1193 (HY000): Unknown system variable 'slow_query_log_file'
Version: 5.7

Possible Causes

Since slow_query_log_file is marked with TENCENT_VAR in MySQL 5.7, the result cannot be obtained directly by running the SELECT command.

Solution

If the error prompt in the above scenario occurs when you attempt to obtain the slow_query_log_file data, run the following command to obtain the corresponding data:
show global variables like '%slow_query_log_file%';

도움말 및 지원

문제 해결에 도움이 되었나요?

피드백