Note
This variable is available starting with V1.4.
Description
ob_sql_audit_percentage specifies the percentage of the maximum memory size of SQL audit in the current tenant.
Privilege requirements
Query variables
systenant and all user tenants can use theSHOW VARIABLESstatement or theSYS.TENANT_VIRTUAL_GLOBAL_VARIABLEview (Oracle mode) or theinformation_schema.GLOBAL_VARIABLESview (MySQL mode) to query the value of global system variables.Modify variables
systenant can directly modify the value of global system variables.MySQL user tenants must have the
SUPERorALTER SYSTEMprivilege to modify the value of global system variables.Oracle user tenants must have the
ALTER SYSTEMprivilege to modify the value of global system variables.
Attributes
| Attribute | Description |
|---|---|
| Type | Int |
| Default value | 3 |
| Value range | [0, 80] |
| Scope | Global |
| Modifiable | Yes. You can execute the SET statement to modify the value. |
Examples
Set the maximum memory size of SQL audit to 3% of the memory size of the current tenant.
obclient> SET GLOBAL ob_sql_audit_percentage =3;