On this page

Show all

Help Center/ Database Security Service/ FAQs/ Functions/ How Long Is the Database Audit Data Stored by Default?

How Long Is the Database Audit Data Stored by Default?

Updated on 2022-09-22 GMT+08:00

Database audit can store online and archived audit data for at least 180 days. If the backup function is disabled and disk space is sufficient, logs are stored on the audit instance for 180 days by default. If a large number of new audit logs are to be stored, the system automatically deletes old logs on a rolling basis to ensure sufficient disk space. If the backup function is enabled, logs and backup logs will also be stored in OBS for same duration.

However, the storage duration also depends on the disk capacity of the log database. To store your audit data long enough, you are advised to:

Choose a database audit edition suitable for your business.
- To audit a small volume of data, purchase the basic edition.
- To audit a large volume of data, purchase the professional or advanced edition.
  For more information, see Table 1.
Back up audit logs.
For details, see Backing Up and Restoring Database Audit Logs.

**Table 1** Database audit editions
Version	Maximum Databases	System Resource	Performance
Professional	6	CPU: 8 vCPUs Memory: 32 GB Hard disk: 1000 GB	Peak QPS: 6,000 queries/second Database load rate: 7.2 million statements/hour Stores 600 million online SQL statements. Stores 10 billion archived SQL statements.
Advanced	30	CPU: 16 vCPUs Memory: 64 GB Hard disk: 2000 GB	Peak QPS: 30,000 queries/second Database load rate: 10.80 million statements/hour Stores 1.5 billion online SQL statements. Stores 60 billion archived SQL statements.

NOTE:

A database instance is uniquely defined by its database IP address and port.
The number of database instances equals the number of database ports. If a database IP address has N database ports, there are N database instances.

Example: A user has two database IP addresses, IP₁ and IP₂. IP₁ has a database port. IP₂ has three database ports. IP₁ and IP₂ have four database instances in total. To audit all of them, select professional edition DBSS, which supports a maximum of six database instances.
To change the edition of a DBSS instance, unsubscribe from it and purchase a new one.
The table above lists the system resources consumed by a database audit instance. Ensure your system has the required configurations before purchasing database audit instances.
Online SQL statements are counted based on the assumption that the capacity of an SQL statement is 1 KB.

Parent topic: Functions

Feedback

Was this page helpful?

Helpful Not helpful

Provide feedback

Thank you very much for your feedback. We will continue working to improve the documentation.

The system is busy. Please try again later.

Which of the following issues have you encountered?

Content is inconsistent with the product UI

Unclear descriptions

Lack of examples or code

Incorrect steps

Can't find what I need

Lack of best practices

Feedback (optional)

0/500

Select at least one type of issue, and enter your comments or suggestions.

Enter a maximum of 500 characters.

Submit Cancel