Note
- Starting from OceanBase Database V2.x, the SQL Audit system tables are split by tenant. As a result, the memory occupied by SQL Audit is now tenant-level. Therefore, the server-level memory eviction upper limit defined by this parameter is no longer applicable. This parameter is removed starting from OceanBase Database V4.0.0.
- Starting from OceanBase Database V2.x, use the system variable
ob_sql_audit_percentageto control the percentage of SQL Audit memory in the current tenant. For more information about the system variableob_sql_audit_percentage, see ob_sql_audit_percentage.
Description
sql_audit_memory_limit specifies the maximum amount of memory that can be occupied by SQL audit data.
Attributes
| Attribute | Description |
|---|---|
| Parameter type | Capacity |
| Default value | 3G |
| Value range | [64M, +∞) |
| Effective upon OBServer node restart | No |