tencent cloud

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.
    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