Managing DDL Logs

Scenarios

DDL logs record the execution of data definition language (DDL) statements, including CREATE, ALTER, DROP, TRUNCATE, and RENAME. They provide a complete audit trail of database schema changes.

During database maintenance, you need to analyze schema changes (such as table modifications or index adjustments) to identify performance bottlenecks or data exceptions. Lack of centralized DDL log management and download capabilities makes it difficult to retrieve DDL logs quickly, increasing troubleshooting time.

TaurusDB lets you download DDL logs and set DDL log transfer policies. The default retention period for DDL logs is three days. You can set this period to 1 to 30 days. DDL logs are automatically deleted when they expire, but there is a delay in this process. You can filter and download specific logs by node and time range, accelerating database troubleshooting.

Constraints

• After DDL Log Transfer is enabled, logs will be stored in OBS, using OBS space.
• Once DDL Log Transfer is enabled, if the latest DDL log file is smaller than 50 MB, it will be retained even when the transfer function is disabled or the log file expires. You can identify the latest DDL log file by its filename.

Billing

DDL logs are stored in OBS and are not billed currently.

Enabling DDL Log Transfer

1. Log in to the TaurusDB console.
2. Click in the upper left corner and select a region and project.
3. On the Instances page, click the target instance name to go to the Basic Information page.
4. In the navigation pane, choose Logs.
5. On the DDL Logs tab page, click Configure DDL Log Transfer.
6. In the displayed dialog box, toggle on the DDL Log Transfer switch and set the log retention period.
   Figure 1 Configuring DDL log transfer
   

7. Click OK.

Viewing and Downloading DDL Logs

1. Log in to the TaurusDB console.
2. Click in the upper left corner and select a region and project.
3. On the Instances page, click the target instance name to go to the Basic Information page.
4. In the navigation pane, choose Logs. On the displayed page, click the DDL Logs tab.
   • Viewing DDL logs

     View DDL logs generated in the last 15 minutes, last 30 minutes, last 1 hour, last 24 hours, last 7 days, last 30 days, or a custom time range.

   • Downloading a single DDL log file

     Click Download in the Operation column to download a DDL log file to your local PC.

     Figure 2 Downloading a single DDL log file
     

   • Downloading multiple DDL log files

     Select the target files and click Batch Export above the list to download them. A maximum of 10 DDL log files can be downloaded at a time.

     Figure 3 Downloading multiple DDL log files
     

Disabling DDL Log Transfer

1. Log in to the TaurusDB console.
2. Click in the upper left corner and select a region and project.
3. On the Instances page, click the target TaurusDB instance name to go to the Basic Information page.
4. In the navigation pane, choose Logs.
5. Click the DDL Logs tab.
6. Click Configure DDL Log Transfer. In the displayed dialog box, toggle off the DDL Log Transfer switch.

   Existing DDL logs will be automatically deleted when the retention period ends. Deleted logs cannot be restored. Exercise caution when disabling this function.

7. Click OK.