CUBRID metrics
Database metric comprehensively collects the database workload and resource usage. The WhaTap monitoring service continuously collects metric data to identify bottlenecks in the database and provides data to help identify the root cause of the performance issue.
| Classification | Item | Description |
|---|---|---|
| File I/O related items | Num_file_removes | Number of deleted files |
Num_file_creates | Number of created files | |
Num_file_ioreads | Number of reads from disk | |
Num_file_iowrites | Number of cases saved to disk | |
Num_file_iosynches | Number of syncs with disk | |
| Page buffer related items | Num_data_page_fetches | Number of fetched pages |
Num_data_page_dirties | Number of dirty pages | |
Num_data_page_ioreads | Number of pages read from disk (a higher value indicates the efficiency is lower; correlates with a lower hit rate) | |
Num_data_page_iowrites | Number of pages written to disk (a greater value indicates the efficiency is lower) | |
Num_data_page_victims | Number of cases the thread that flushes data from buffer to disk, is awakened (not the number of pages being flushed or victims) | |
Num_data_page_iowrites_for_replacement | Number of candidate data pages written to disk | |
Num_adaptive_flush_pages | Number of data pages flushed from data buffer to disk | |
Num_adaptive_flush_log_pages | Number of log pages flushed from log buffer to disk | |
Num_adaptive_flush_max_pages | Number of data pages allowed for flushing from data and log buffers to disk | |
Num_sort_io_pages | Number of pages fetched from disk while sorting (a greater value indicates the efficiency is lower) | |
Num_sort_data_pages | Number of pages found from page buffer while sorting (a greater value indicates the efficiency is higher) | |
| Log related items | Num_log_page_ioreads | Number of read log pages |
Num_log_page_iowrites | Number of stored log pages | |
Num_log_append_records | Number of added log records | |
Num_log_archives | Number of stored logs | |
Num_log_start_checkpoints | Check point start count | |
Num_log_end_checkpoints | Check point end count | |
Num_log_wals | Unused | |
| Transaction related items | Num_tran_commits | Commit count |
Num_tran_rollbacks | Rollback count | |
Num_tran_savepoints | Save point count | |
Num_tran_start_topops | Number of started top operations | |
Num_tran_end_topops | Number of ended top operations | |
Num_tran_interrupts | Number of interrupts | |
| Concurrency/lock related items | Num_page_locks_acquired | Number of page locks acquired |
Num_object_locks_acquired | Number of object locks acquired | |
Num_page_locks_converted | Number of page lock type conversions | |
Num_object_locks_converted | Number of object lock type conversions | |
Num_page_locks_re-requested | Number of page locks re-requested | |
Num_object_locks_re-requested | Number of object locks re-requested | |
Num_page_locks_waits | Number of pages waiting for lock | |
Num_object_locks_waits | Number of objects waiting for lock | |
| Index related items | Num_btree_inserts | Number of added items |
Num_btree_deletes | Number of deleted items | |
Num_btree_updates | Number of updated items | |
Num_btree_covered | Number of cases in which the index includes all data upon query | |
Num_btree_noncovered | Number of cases where the index contains some or no data upon query | |
Num_btree_resumes | Number of index scans exceeding index_scan_oid_buffer_pages | |
Num_btree_multirange_optimization | Number of cases where multi-range optimization was performed for WHERE ... IN ... LIMIT conditional queries | |
Num_btree_splits | Number of B-tree node division operations | |
Num_btree_merges | Number of B-tree node merge operations | |
| Query related items | Num_query_selects | Number of SELECT queries performed |
Num_query_inserts | Number of INSERT queries performed | |
Num_query_deletes | Number of DELETE queries performed | |
Num_query_updates | Number of UPDATE queries performed | |
Num_query_sscans | Number of sequential scans (full scans) | |
Num_query_iscans | Number of index scans | |
Num_query_lscans | Number of LIST scans | |
Num_query_setscans | Number of SET scans | |
Num_query_methscans | Number of METHOD scans | |
Num_query_nljoins | Number of nested loop joins | |
Num_query_mjoins | Number of merge joins | |
Num_query_objfetches | Number of object fetches | |
| Network request related items | Num_network_requests | Number of network requests |
| Query plan cache related items | Num_plan_cache_add | Number of cases where new cache entry has been added |
Num_plan_cache_lookup | Number of lookups attempted using a specific key | |
Num_plan_cache_hit | Number of entries hit in the query string hash table | |
Num_plan_cache_miss | Number of entries not hit in the query string hash table | |
Num_plan_cache_full | Number of victim searches when the cache entries exceeded the allowed limit | |
Num_plan_cache_delete | Number of victimized cache entries | |
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. | |
Num_plan_cache_query_string_hash_entries | Number of entries in the query string hash table | |
Num_plan_cache_xasl_id_hash_entries | Number of entries in the xasl id hash table | |
Num_plan_cache_class_oid_hash_entries | Number of entries in the class oid hash table | |
| Buffer hit rate related items | Data_page_buffer_hit_ratio | Page buffer hit rate ( Num_data_page_fetches - Num_data_page_ioreads)*100 / Num_data_page_fetches |
| HA related items | Time_ha_replication_delay | Replication delay time (sec) |