tencent cloud

$0 14-Day TrialExperience EdgeOne for acceleration and security protection!

Feedback

Slow Log Overview

Last updated: 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.

Catalog

In The Article

Slow Log Overview

Contact Us

Contact our sales team or business advisors to help your business.

Technical Support

Open a ticket if you're looking for further assistance. Our Ticket is 7x24 avaliable.

7x24 Phone Support
Hong Kong, China
+852 800 906 020 (Toll Free)
United States
+1 844 606 0804 (Toll Free)
United Kingdom
+44 808 196 4551 (Toll Free)
Canada
+1 888 605 7930 (Toll Free)
Australia
+61 1300 986 386 (Toll Free)
EdgeOne hotline
+852 300 80699
More local hotlines coming soon