tencent cloud

TDSQL-C for MySQL

문서TDSQL-C for MySQL

Slow Log Overview

Download
포커스 모드
폰트 크기
마지막 업데이트 시간: 2024-11-13 21:54:24

Overview

Slow logs are also called slow SQL queries. They are a type of logs provided by TDSQL-C for MySQL to record SQL statements with a longer response time than the threshold in the database process. Specifically, SQL statements with a longer execution time than the long_query_time value are recorded in slow logs.
Note:
The slow log feature is currently in beta test and only available in Beijing region. It will be made available in more regions.

Parameters

The long_query_time value of TDSQL-C for MySQL defaults to 1, indicating that SQL statements running more than 1 seconds will be recorded in slow logs. You can adjust the value in the range of 0.000000 to 3,600.000000. For more information, see Setting Instance Parameters.

Purpose

After setting this parameter in TDSQL-C for MySQL, you can identify and optimize inefficient SQL statements. Simply put, slow logs are used to troubleshoot SQL statement issues and check the current performance.

Relevant operations

Operation
Use Case
Method
Prevent slow logs from being generated
Get suggestions from DBbrain for slow SQL statement optimization.
Set slow log parameters
Set the value of `long_query_time` to record slow logs.
View slow log monitoring alarms
View slow instance queries through the instance monitoring metric (Slow Queries) and set alarms to receive notifications.
Query and download slow log details
On the **Operation Log** page, query the following slow log information: execution time, SQL statement, client address, username, database, execution duration (s), lock duration (s), parsed rows, and returned rows. You can download them in CSV or native formats.
Analyze and optimize slow logs
View the complete SQL template, SQL sample, and optimization suggestion and description through DBbrain to analyze and optimize SQL statements.
다음 주제: Service Level Agreement

도움말 및 지원

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

피드백