SQL statements processed per second
| Metric | Description | Unit |
|---|---|---|
| sql_all_count | The number of SQL statements processed per second. | times/s |
| sql_delete_count | The number of Delete statements processed per second. | times/s |
| sql_insert_count | The number of Insert statements processed per second. | times/s |
| sql_other_count | The number of other statements, such as DDL, DCL, and DTL statements, processed per second. | times/s |
| sql_replace_count | The number of Replace statements processed per second. | times/s |
| sql_select_count | The number of Select statements processed per second. | times/s |
| sql_update_count | The number of Update statements processed per second. | times/s |
Response time
| Metric | Description | Unit |
|---|---|---|
| sql_all_rt | The average response time for SQL statements. | ms |
| sql_delete_rt | The average response time for Delete statements. | ms |
| sql_insert_rt | The average response time for Insert statements. | ms |
| sql_other_rt | The average response time for other statements, such as DDL, DCL, and DTL statements. | ms |
| sql_replace_rt | The average response time for Replace statements. | ms |
| sql_select_rt | The average response time for Select statements. | ms |
| sql_update_rt | The average response time for Update statements. | ms |
| sql_all_rt_p99 | The average response time for SQL statements at the 99th percentile. | ms |
| sql_delete_rt_p99 | The 99th percentile response time for SQL DELETE operations. This value indicates that 99% of the DELETE operations have a response time less than or equal to this value. This value is used to measure the stability of the performance of DELETE operations. | ms |
| sql_insert_rt_p99 | The 99th percentile response time for SQL INSERT operations. This value is used to measure the performance of slow queries. | ms |
| sql_other_rt_p99 | The 99th percentile response time for other types of SQL queries. This value indicates that 99% of the queries have a response time less than or equal to this value. The unit is ms. | ms |
| sql_replace_rt_p99 | The 99th percentile response time for SQL REPLACE operations. This value is used to measure the tail latency of slow queries. The unit is ms. | ms |
| sql_select_rt_p99 | The 99th percentile response time for SQL queries. This value indicates that 99% of the queries have a response time less than or equal to this value. This value is used to measure the tail latency of database query performance. | ms |
| sql_update_rt_p99 | The 99th percentile response time for SQL UPDATE operations. This value indicates that 99% of the UPDATE requests have a response time less than or equal to this value. This value is used to measure the tail latency of database update operations. | ms |
| sql_all_rt_p95 | The average response time for SQL statements at the 95th percentile. | ms |
| sql_delete_rt_p95 | The 95th percentile response time for SQL DELETE operations. This value is used to measure the latency of DELETE operations. The unit is ms. | ms |
| sql_insert_rt_p95 | The 95th percentile response time for SQL INSERT operations. This value indicates that 95% of the INSERT operations are completed within this time. The unit is ms. | ms |
| sql_other_rt_p95 | The 95th percentile response time for other types of SQL queries. The unit is ms. | ms |
| sql_replace_rt_p95 | The 95th percentile response time for SQL REPLACE operations. This value is used to measure the performance of the database in processing SQL REPLACE statements. The unit is ms. | ms |
| sql_select_rt_p95 | The 95th percentile response time for SQL queries. This value indicates that 95% of the queries have a response time less than or equal to this value. This value is used to measure the tail latency of database query performance. | ms |
| sql_update_rt_p95 | The average response time for Delete statements. | ms |
| sql_all_rt_p90 | The average response time for SQL statements at the 90th percentile. | ms |
| sql_delete_rt_p90 | The 90th percentile response time for SQL DELETE operations. This value indicates that 90% of the DELETE requests have a response time less than or equal to this value. This value is used to measure the performance of DELETE operations. | ms |
| sql_insert_rt_p90 | The 90th percentile response time for SQL INSERT operations. The unit is ms. | ms |
| sql_other_rt_p90 | The 90th percentile response time for SQL queries. This value indicates that 90% of the queries have a response time less than or equal to this value. This value is used to measure the tail latency of database query performance. | ms |
| sql_replace_rt_p90 | The 90th percentile response time for SQL REPLACE statements. This value indicates that 90% of the REPLACE statements have a response time less than or equal to this value. This value is used to measure the performance of REPLACE operations. | ms |
| sql_select_rt_p90 | The 90th percentile response time for SQL queries. This value indicates that 90% of the queries have a response time less than or equal to this value. This value is used to measure the tail latency of database query performance. | ms |
| sql_update_rt_p90 | The average response time for Delete statements. | ms |
Sessions
| Metric | Description | Unit |
|---|---|---|
| all_session | The number of current sessions. This value indicates the number of active client connections to the database. | count |
| active_session | The number of active sessions. | count |
SQL execution plan category
| Metric | Description | Unit |
|---|---|---|
| sql_distributed_count | The number of distributed execution plans processed per second. | times/s |
| sql_local_count | The number of local executions processed per second. | times/s |
| sql_remote_count | The number of remote execution plans processed per second. | times/s |
Slow SQL
| Metric | Description | Unit |
|---|---|---|
| slow_sql_count | The number of slow SQL queries. This value is used to monitor database performance issues. A slow SQL query is an SQL statement whose execution time exceeds the specified threshold. | count |
Number of execution events in a tenant in a specific state
| Metric | Description | Unit |
|---|---|---|
| ob_sql_event | The number of SQL execution events in a tenant in a specific state. This value is used to monitor the distribution of SQL execution states. | times |
| ob_sql_event_in_parse | The number of SQL execution events in a tenant in the parse state. This value is used to monitor the concurrent load during the SQL parsing stage. | count |
| ob_sql_event_in_pl_parse | The number of SQL execution events in a tenant in the pl parse state. | count |
| ob_sql_event_in_plan_cache | The number of SQL execution events in a tenant in the plan cache state. | count |
| ob_sql_event_in_sql_optimize | The number of SQL execution events in a tenant in the SQL optimization state. | count |
| ob_sql_event_in_sql_execution | The number of SQL execution events in a tenant in the SQL execution state. This value is used to monitor the number of concurrent or active events during the SQL execution stage. | times |
| ob_sql_event_in_px_execution | The number of SQL execution events in a tenant in the parallel execution (PX execution) state. This value is used to monitor the concurrency during the parallel query execution stage. | count |
| ob_sql_event_in_sequence_load | The number of SQL execution events in a tenant in the sequence load state. | count |
Wait events per second
| Metric | Description | Unit |
|---|---|---|
| wait_event_count | The number of wait events per second. This metric indicates the frequency of wait events in the database. Unit: times/s. | times/s |
| system_event_other_count | The number of other system events per second. This metric indicates the frequency of unclassified system events. Unit: times/s. | times/s |
| system_event_application_count | The number of application wait events per second. This metric indicates the frequency of application wait events. Unit: times/s. | times/s |
| system_event_configuration_count | The number of configuration change events per second. This metric indicates the frequency of system configuration changes. Unit: times/s. | times/s |
| system_event_administrative_count | The number of administrative wait events per second. This metric indicates the frequency of administrative wait events. Unit: times/s. | times/s |
| system_event_concurrency_count | The number of concurrent system events. This metric indicates the number of concurrent system events. Unit: count. | count |
| system_event_commit_count | The number of committed transactions per second. This metric indicates the frequency of committed transactions. Unit: times/s. | times/s |
| system_event_idle_count | The number of idle wait events per second. This metric indicates the frequency of idle wait events. Unit: times/s. | times/s |
| system_event_network_count | The number of network wait events per second. This metric indicates the frequency of network wait events. Unit: times/s. | times/s |
| system_event_user_io_count | The number of user I/O wait events per second. This metric indicates the frequency of user I/O wait events. Unit: times/s. | times/s |
| system_event_system_io_count | The number of system I/O wait events per second. This metric indicates the frequency of system I/O wait events. Unit: times/s. | times/s |
| system_event_scheduler_count | The number of events triggered by the event scheduler per second. This metric indicates the frequency of events triggered by the event scheduler. Unit: times/s. | times/s |
| system_event_cluster_count | The number of cluster events per second. This metric indicates the frequency of cluster events. Unit: times/s. | times/s |
Average wait time
| Metric | Description | Unit |
|---|---|---|
| wait_event_rt | The average wait time. | μs |
| system_event_other_time_waites | The average wait time of other wait events. | μs |
| system_event_application_time_waites | The average wait time of application wait events. | μs |
| system_event_configuration_time_waites | The average wait time of configuration wait events. | μs |
| system_event_administrative_time_waites | The average wait time of administrative wait events. | μs |
| system_event_concurrency_waites | The average wait time of concurrency wait events. | μs |
| system_event_commit_waites | The average wait time of commit wait events. | μs |
| system_event_idle_waites | The average wait time of idle wait events. | μs |
| system_event_network_waites | The average wait time of network wait events. | μs |
| system_event_user_io_waites | The average wait time of user I/O wait events. | μs |
| system_event_system_io_waites | The average wait time of system I/O wait events. | μs |
| system_event_scheduler_waites | The average wait time of scheduler wait events. | μs |
| system_event_cluster_waites | The average wait time of cluster wait events. | μs |
Number of SQL requests entering the wait queue per second
| Metric | Description | Unit |
|---|---|---|
| request_dequeue_count | The number of requests dequeued from the processing queue per second. | times/s |
| request_enqueue_count | The number of requests enqueued into the processing queue per second. | times/s |
SQL request wait time in the wait queue
| Metric | Description | Unit |
|---|---|---|
| request_queue_time | The wait time of an SQL request in the wait queue. | μs |
Non-idle wait time of a tenant database
| Metric | Description | Unit |
|---|---|---|
| ob_waitevent_count | The number of wait events in a tenant database. This metric indicates the frequency of specific wait events in OceanBase Database. | times |
| ob_foreground_waitevent_count | The number of wait events in the foreground of a tenant database. This metric indicates the number of concurrent wait events in the foreground sessions of OceanBase Database. | times |
| ob_background_waitevent_count | The number of wait events in the background of a tenant database. This metric indicates the frequency of wait events in the background tasks of OceanBase Database. | times |
CPU utilization of a tenant
| Metric | Description | Unit |
|---|---|---|
| ob_cpu_percent | The CPU utilization of a tenant thread. | % |
Memory utilization of an OB tenant
| Metric | Description | Unit |
|---|---|---|
| ob_tenant_memory_percent | The memory utilization of an OB tenant. | % |
MEMStore utilization
| Metric | Description | Unit |
|---|---|---|
| memstore_percent | The utilization of MEMStore. | % |
Number of open cursors
| Metric | Description | Unit |
|---|---|---|
| opened_cursors_count | The number of open cursors. This metric indicates the number of open cursors in database sessions. | count |
RPC packet receive and send time
| Metric | Description | Unit |
|---|---|---|
| rpc_packet_in_rt | The average time for an RPC packet to be received. | μs |
| rpc_packet_out_rt | The average time for an RPC packet to be sent. | μs |
RPC packet receive and send data volume per unit time
| Metric | Description | Unit |
|---|---|---|
| rpc_packet_in | The data volume of an RPC packet received per unit time. | byte |
| rpc_packet_out | The data volume of an RPC packet sent per unit time. | byte |
Work time of a tenant database
| Metric | Description | Unit |
|---|---|---|
| ob_worktime | The work time of a tenant database. | s |
| ob_foreground_worktime | The work time of the foreground of a tenant database. | s |
| ob_background_worktime | The work time of the background of a tenant database. | s |
Non-idle wait time of the tenant database
| Metric | Description | Unit |
|---|---|---|
| ob_no_idle_waiting_time | Non-idle wait time of the tenant database | s |
| ob_foreground_no_idle_waiting_time | Non-idle wait time of the foreground of the tenant database | s |
| ob_background_no_idle_waiting_time | Non-idle wait time of the background of the tenant database | s |
Replica delay
| Metric | Description | Unit |
|---|---|---|
| ob_clog_ls_max_replayed_scn | Replica delay | s |