CUBRID metrics
Database metrics are a comprehensive collection of database workloads and resource usages. The WhaTap monitoring service continuously collects metrics to identify bottlenecks in the database and provides data to help identify the root causes of performance issues.
For more information about other metrics, see the following.
agent_status_summary
This category collects metrics related to agent status every 10 seconds.
Fields
| Field name | Unit | Description | Remarks |
|---|---|---|---|
inActTime | Millisecond(ms) | Amount of time the agent remains inactive | - |
isActive | - | Whether the agent is active or not | true / false |
isRestart | - | Whether the agent has been recently restarted | true / false |
lastActTime | Millisecond(ms) | Time when the agent was last activated | 0: If disabled |
oid | - | Unique IDs for each agent in the project | - |
startTime | Millisecond(ms) | Timestamp when the agent was started. | - |
db_cubrid_counter
Tags
The following lists the tags that are collected in the db_cubrid_counter category.
| Tag name | Description | Remarks |
|---|---|---|
agentIp | IP address per agent. | - |
dbIsMulti | Whether to support the multitenant or not. | - |
dbName | Database name. | - |
dbType | Database type. | - |
dbVersion | Version of the database in use. | - |
oname | Agent name | Unique value |
Field
The following lists the fields that are collected in the db_cubrid_counter category.
| Metrics | Description | Category |
|---|---|---|
active_sessions | Number of active sessions. | Transaction |
broker_count | Number of brokers. | Network |
connect_error | Number of connection errors. | Network |
data_page_buffer_hit_ratio | Data page buffer hit ratio. Calculation method: ( Num_data_page_fetches - Num_data_page_ioreads)*100 / Num_data_page_fetches | Buffer hit rate |
executions | Number of queries executed | Query |
fatal_count | Number of fatal errors. | Transaction |
lock_wait_sessions | Number of pending sessions. | Concurrency/Lock |
long_running_sessions | Number of long running sessions. | Transaction |
num_adaptive_flush_log_pages | Number of log pages flushed from log buffer to disk. | Page buffer |
num_adaptive_flush_max_pages | Number of data pages allowed for flushing from data and log buffers to disk. | Page buffer |
num_adaptive_flush_pages | Number of data pages flushed from data buffer to disk. | Page buffer |
num_btree_covered | Number of cases in which the index includes all data upon query. | Index |
num_btree_deletes | Number of items deleted from B-Tree. | Index |
num_btree_get_stats | Number of cases B-Tree statistics have been queried. | Index |
num_btree_inserts | Number of items inserted into B-Tree. | Index |
num_btree_merges | Number of B-Tree node merges. | Index |
num_btree_multirange_optimization | Number of cases where multi-range optimization was performed for WHERE ... IN ... LIMIT conditional queries | Index |
num_btree_noncovered | Number of cases where the index contains some or no data upon query. | Index |
num_btree_resumes | Number of restarts in B-Tree. It indicates the number of index scans that exceeded index_scan_oid_buffer_pages. | Index |
num_btree_splits | Number of B-Tree node splits. | Index |
num_btree_updates | Number of items updated from B-Tree. | Index |
num_data_page_dirties | Number of dirty data pages. | Page buffer |
num_data_page_fetches | Number of pages for the fetched data. | Page buffer |
num_data_page_ioreads | Number of data pages read from disk. A higher value indicates the efficiency is lower and correlates with a lower hit ratio. | Page buffer |
num_data_page_iowrites | Number of data pages written to disk. A higher value indicates that it is less efficient. | Page buffer |
num_file_creates | Number of created files. | I/O |
num_file_ioreads | Number of I/O operations read from disk. | I/O |
num_file_iosynches | Number of I/O operations for synchronization with disk. | I/O |
num_file_iowrites | Number of I/O operations stored to disk. | I/O |
num_file_page_allocs | Number of file page allocations. | I/O |
num_file_page_deallocs | Number of file page deallocations. | I/O |
num_file_removes | Number of removed files. | I/O |
num_heap_stats_bestspace_entries | Number of best space entries in heap statistics. | Page buffer |
num_heap_stats_bestspace_maxed | Number of best heap space entries. | Page buffer |
num_log_append_records | Number of added log records. | Log |
num_log_archives | Number of log archive operations executed. | Log |
num_log_page_ioreads | Number of log pages read from disk. | Log |
num_log_page_iowrites | Number of log pages written to disk. | Log |
num_log_wals | Number of Write-Ahead Logging (WAL) records written in the log. | Log |
num_network_requests | Number of network requests. | Network |
num_object_locks_acquired | Number of acquired object locks. | Concurrency/Lock |
num_object_locks_converted | Number of converted object locks. | Concurrency/Lock |
num_object_locks_re_requested | Number of re-requested object locks. | Concurrency/Lock |
num_object_locks_waits | Number of waiting object locks. | Concurrency/Lock |
num_page_locks_acquired | Number of acquired page locks. | Concurrency/Lock |
num_page_locks_converted | Number of converted page locks. | Concurrency/Lock |
num_page_locks_re_requested | Number of re-requested page locks. | Concurrency/Lock |
num_page_locks_waits | Number of waiting page locks. | Concurrency/Lock |
num_plan_cache_add | Number of entries added to the query plan cache. | Query plan cache |
num_plan_cache_class_oid_hash_entries | Number of entries in the class OID hash table. | Query plan cache |
num_plan_cache_delete | Number of cases a cache entry has been deleted. | Query plan cache |
num_plan_cache_full | Number of victim searches when the cache entries exceeded the allowed limit. | Query plan cache |
num_plan_cache_hit | Number of cases an entry has been found in the query string hash table. | Query plan cache |
num_plan_cache_invalid_xasl_id | Number of misses for entry in the xasl_id hash table. It is the number of errors that occurred when a specific entry was victimized on the server, but the entry was requested by the client. | Query plan cache |
num_plan_cache_lookup | Number of lookups attempted using a specific key. | Query plan cache |
num_plan_cache_miss | Number of entries not hit in the query string hash table. | Query plan cache |
num_plan_cache_query_string_hash_entries | Number of entries in the query string hash table. | Query plan cache |
num_plan_cache_xasl_id_hash_entries | Number of entries in the xasl id hash table. | Query plan cache |
num_prior_lsa_list_maxed | Maximum number of entries in the LSA list. | Log |
num_prior_lsa_list_removed | Number of entries removed from the LSA list. | Log |
num_prior_lsa_list_size | LSA list size. | Log |
num_query_deletes | Number of DELETE queries processed. | Query |
num_query_holdable_cursors | Number of processed cursors that can be held. | Query |
num_query_inserts | Number of INSERT queries processed. | Query |
num_query_iscans | Number of index scan queries processed. | Query |
num_query_lscans | Number of LIST scan queries processed. | Query |
num_query_methscans | Number of METHOD scan queries processed. | Query |
num_query_mjoins | Number of merge join queries processed. | Query |
num_query_nljoins | Number of nested loop join queries processed. | Query |
num_query_objfetches | Number of object fetch queries processed. | Query |
num_query_selects | Number of SELECT queries processed. | Query |
num_query_setscans | Number of SET scan queries processed. | Query |
num_query_sscans | Number of full scan queries processed. | Query |
num_query_updates | Number of UPDATE queries processed. | Query |
num_sort_data_pages | Number of pages found from page buffer while sorting. A higher value indicates that it is less efficient. | Page buffer |
num_sort_io_pages | Number of pages fetched from disk while sorting. A higher value indicates that it is less efficient. | Page buffer |
num_tran_commits | Number of committed transactions. | Transaction |
num_tran_end_topops | Number of top operation transactions that have been terminated. | Transaction |
num_tran_interrupts | Number of transaction interrupts. | Transaction |
num_tran_rollbacks | Number of rollback transactions. | Transaction |
num_tran_savepoints | Number of cases a save point is set. | Transaction |
num_tran_start_topops | Number of top operation transactions that have been started. | Transaction |
psize | Page size. | I/O |
qps | Number of queries processed per second. | Query |
replication_delay | Replication delay time. | HA |
time_ha_replication_delay | HA replication delay time (seconds). | HA |
total_query_time | Total query execution time. | Query |
total_sessions | Total number of sessions. | Transaction |
tps | Number of transactions per second. | Transaction |
warning_count | Number of warnings occurred. | Transaction |
XOS-related metrics
The following describes the metrics collected from the XOS agent.
| Metric | Unit | Description |
|---|---|---|
cpu(xos) | pct | CPU utilization, cpu_user + cpu_sys + cpu_iowait. |
cpu_user(xos) | pct | Time spent for CPU to execute user code. |
cpu_sys(xos) | pct | Time spent for CPU to execute the kernel code. |
cpu_iowait(xos) | pct | CPU time waited for IO. |
cpu_idle(xos) | pct | CPU processor's idle time. |
disk_reads(xos) | block | Amount of data read from disk. |
disk_read_bytes(xos) | byte | Amount of data read from disk. |
disk_writes(xos) | block | Amount of data written to disk. |
disk_write_bytes(xos) | byte | Amount of data written to disk. |
mem(xos) | pct | Memory utilization. |
mem_total(xos) | MB | Total amount of memory. |
mem_free(xos) | MB | Amount of memory not in use by the system. |
mem_used(xos) | MB | Amount of memory in use by the system. |
mem_buffcache(xos) | MB | Amount of memory used by the buff/cache. |
mem_swaptotal(xos) | MB | Set this in preparation for the case where the total Swap size and physical memory are insufficient. |
mem_swapfree(xos) | MB | Because the unused Swap area and Swap area are secured in disk space, the system performance may drop drastically while using Swap. |
mem_available(xos) | MB | Available memory area. |
net_recv_bytes(xos) | byte | Amount of data received over the network. |
net_recv_packets(xos) | - | Number of data packets received over the network. |
net_send_bytes(xos) | byte | Amount of data transmitted over the network. |
net_send_packets(xos) | - | Number of data packets transmitted over the network. |