Checks whether SQL diagnostics is enabled for an ApsaraDB for OceanBase cluster.
Scenarios
The SQL diagnostics feature analyzes suspicious SQL statements, slow SQL statements, and top SQL statements.
Risk level
Default risk level: low.
You can change the risk level when you apply this rule.
Compliance evaluation logic
- The ApsaraDB for OceanBase cluster is compliant if SQL diagnostics is enabled.
- The ApsaraDB for OceanBase cluster is non-compliant if SQL diagnostics is disabled. For remediation, see Remediation.
Rule details
| Item | Description |
| Rule name | oceanbase-instance-enabled-sql-diagnosis |
| Rule ID | oceanbase-instance-enabled-sql-diagnosis |
| Tag | OceanBase,Instance |
| Automatic remediation | Not supported |
| Trigger type | Periodic execution |
| Time interval | 24 hours |
| Supported resource type | ApsaraDB for OceanBase cluster |
| Input parameter | None |
Remediation
Enable SQL diagnostics. For more information, see < data-node="2886516" baseurl="t2226384_v1_0_0.dita" data-tag="xref" id="xref_6la_p2p_0rs" href="t2068907.xdita#topic-2068907">SQL Analysis.
该文章对您有帮助吗？