Help Center/ GaussDB(for MySQL)/ User Guide/ Logs and Auditing/ Configuring Log Reporting
Updated on 2024-11-06 GMT+08:00
View PDF
Share

Configuring Log Reporting

You can view database-level logs on the Logs page, including error logs and slow SQL query logs.

Scenarios

If you enable log reporting for your DB instance, new logs generated for the instance will be uploaded to Log Tank Service (LTS) for management.

Precautions

  • You will be billed for this function.
  • Ensure that there are available LTS log groups and log streams in the same region as your DB instance.
  • Error logs and slow query logs cannot share the same log stream.
  • You can bind a new structuring template to an error log stream or slow log query stream, but once selected, the log stream type cannot be changed.
  • If a structuring template has been bound to a log stream, ensure that the template type is the same as the log type when you select the log stream. For example, if an error log template has been bound to a log stream, the log stream cannot be used for slow query logs.

Enabling Log Reporting

  1. Log in to the management console.
  2. Click in the upper left corner and select a region and project.
  3. Click in the upper left corner of the page and choose Databases > GaussDB(for MySQL).
  4. In the navigation pane, choose Log Reporting.
  5. Select one or more instances and click Enable Log Reporting.

    Figure 1 Enabling log reporting for multiple instances

  6. In the displayed dialog box, select a log group and log stream, and click OK.

    • Error logs and slow query logs cannot share the same log stream.
    • Log reporting cannot be enabled immediately. There is a delay of about 10 minutes.
    • You can only enable either error log reporting to LTS or slow log reporting to LTS.
    • Audit logs record all requests sent to your DB instance and are stored in LTS.
    Figure 2 Enabling log reporting

Disabling Log Reporting

  1. Log in to the management console.
  2. Click in the upper left corner and select a region and project.
  3. Click in the upper left corner of the page and choose Databases > GaussDB(for MySQL).
  4. In the navigation pane, choose Log Reporting.
  5. Disable log reporting in either of the following ways:

    • If log reporting is disabled, logs generated for the DB instance will not be reported to LTS.
    • This request is not applied immediately. There is a delay of about 10 minutes.
    • Disabling log reporting for multiple instances
      1. Select one or more instances and click Disable Log Reporting.
      2. In the displayed dialog box, click OK.
        Figure 3 Disabling log reporting

    • Disabling log reporting for a single instance
      1. Locate an instance and click in the Report Error Logs to LTS or Report Slow Logs to LTS column.
      2. In the displayed dialog box, click Yes.
        Figure 4 Disabling slow log reporting

        Figure 5 Disabling error log reporting

Parent Topic: Logs and Auditing