Help Center> GaussDB(for MySQL)> User Guide> Log Management> Enabling or Disabling Log Reporting
Updated on 2024-05-21 GMT+08:00

Enabling or Disabling Log Reporting

GaussDB(for MySQL) log management allows you to view database-level logs, 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 instance.

Constraints

  • 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 in Batches

  1. Log in to the management console.
  2. Click in the upper left corner and select a region and a project.
  3. Click in the upper left corner of the page, choose Databases > GaussDB(for MySQL).
  4. In the navigation pane, choose Log Reporting.
  5. Select one or more instances and click Enable Log Reporting.
  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.
    • This request does not take effect 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 1 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 a project.
  3. Click in the upper left corner of the page, 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 in batches
      1. Select one or more instances and click Disable Log Reporting.
      2. In the displayed dialog box, click OK.

        Figure 2 Disabling log reporting

    • Disabling log reporting for a DB instance
      1. Locate a DB instance and click in the Report Error Log to LTS column or Report Slow Log to LTS column.
      2. In the displayed dialog box, click Yes.

        Figure 3 Disabling slow log reporting

        Figure 4 Disabling error log reporting