Help Center> Database Security Service> FAQ> Database Audit Functions> How Long Is the Audit Data of Database Audit Stored by Default?
View PDF

How Long Is the Audit Data of Database Audit Stored by Default?

Database audit can store online and archived audit data for at least 180 days.

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

Basic

3
  • CPU: 4 vCPUs
  • Memory: 16 GB
  • Disk: 560 GB
  • Disk: 500 GB
  • Peak QPS: 3,000 queries/second
  • Database load rate: 3.6 million statements/hour
  • Stores 400 million online SQL statements.
  • Stores 5 billion archived SQL statements.

Professional

6
  • CPU: 8 vCPUs
  • Memory: 32 GB
  • Disk: 1084 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
  • Disk: 2108 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.
  • 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, IP1 and IP2. IP1 has a database port. IP2 has three database ports. IP1 and IP2 have four database instances in total. To audit all of them, select professional edition DBSS, which supports a maximum of six database instances.

  • The table above lists the system resources consumed by a database audit instance. Ensure you have sufficient resources 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: Database Audit Functions