tencent cloud

PrevNext

Feedback

search by keyword

Recent Pages

Documentation
TencentDB for MySQL
    Documentation
    Download PDF

    Operation Logs

    Last updated: 2023-11-20 15:45:38
    Download PDF

      Overview

      A SQL statement query that takes more time than the specified value is referred to as a "slow query", and the corresponding statement is called a "slow query statement". The process where a database administrator (DBA) analyzes slow query statements and finds out the reasons why slow queries occur is known as "slow query analysis".
      In the Operation Log tab, you can view the slow logs details, error logs details, rollback logs, and logs delivery of the instance and download slow logs. You can also view and download database logs on the command line interface (CLI) or through TencentDB APIs. For more information, see DescribeSlowLogs and DescribeBinlogs.
      Note：
      Currently, slow log download, rollback and log delivery features are not supported for TencentDB for MySQL single-node instances of the cloud disk edition.

      Notes on MySQL slow queries

      long_query_time: Slow query threshold parameter that is accurate to the microsecond level. The default value is 1 second. When a SQL statement takes more time than the threshold to execute, it will be recorded in a slow log. When the long_query_time parameter is adjusted, existing slow logs will not be affected. For example, if the slow log threshold parameter is 1s, slow logs will be reported for exceeding queries; after this value is modified to 2s, the previously reported logs will still be displayed.
      log_queries_not_using_indexes: Whether to log unindexed queries. The default value is OFF.

      The Directions

      1. Log in to the TencentDB for MySQL console. In the instance list, click an Instance ID or Manage in the Operation column to enter the instance management page.
      2. On the Operation Log tab, you can view the slow logs details, error logs details, rollback logs and logs delivery of the instance and download slow logs.
      Feature
      Description
      Slow Log Details
      Records SQL statements that took more than 1 second to execute in the database for the past month
      Download Slow Log
      Downloads slow logs
      Error Log Details
      Records the detailed information of each startup and shutdown as well as all the serious warnings and errors during operation
      Rollback Log
      Records the status and progress of rollback tasks
      Collects data from slow logs and error logs sourced from TencentDB for MySQL instances, and deliver them to the Cloud Log Service (CLS) for analysis
      3. On the Download Slow Log tab, click Download in the Operation column to download slow logs.
      4. We recommend that you copy the download address in the pop-up window, log in to a (Linux) CVM instance in the same VPC as the TencentDB instance, and run the wget command to download over the private network at a higher speed. For more information, see Customizing Linux CVM Configurations.
      Note：
      Logs with a size of 0 KB cannot be downloaded.
      You can also click Download to download it directly. However, this may take a longer time.
      wget command format: wget -c 'log file download address' -O custom filename.log
      Below is a sample:
      wget -c 'http://szx.dl.cdb.tencentyun.com:303/cfdee?appid=1210&time=1591&sign=aIGM%3D' -O test.log
      
      
      Contact Us

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

      Contact Us
      Technical Support

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

      Submit a Ticket
      7x24 Phone Support
      Copyright © 2013-2024 Tencent Cloud. All Rights Reserved.
      Privacy PolicyLegalCookie Policy