The cubrid statdump utility checks statistics information processed by the CUBRID database server. The statistics information mainly consists of the followings: File I/O, Page buffer, Logs, Transactions, Concurrency/Lock, Index, and Network request
Note that you must specify the parameter communication_histogram to yes in the cubrid.conf before executing the utility. You can also check statistics information of server with session commands (;.h on) in the CSQL.
cubrid statdump options database_name
options : [{-o |--ouput-file=}file_name] [{-i |--interval=}secs] [-c|--cumulative] [{-s |-substr=}sub_string]
Outputting statistics information periodically (-i or --interval)
cubrid statdump -i 5 testdb
Thu April 07 23:10:08 KST 2011
*** SERVER EXECUTION STATISTICS ***
Num_file_creates = 0
Num_file_removes = 0
Num_file_ioreads = 0
Num_file_iowrites = 0
Num_file_iosynches = 0
Num_data_page_fetches = 0
Num_data_page_dirties = 0
Num_data_page_ioreads = 0
Num_data_page_iowrites = 0
Num_data_page_victims = 0
Num_data_page_iowrites_for_replacement = 0
Num_log_page_ioreads = 0
Num_log_page_iowrites = 0
Num_log_append_records = 0
Num_log_archives = 0
Num_log_checkpoints = 0
Num_log_wals = 0
Num_page_locks_acquired = 0
Num_object_locks_acquired = 0
Num_page_locks_converted = 0
Num_object_locks_converted = 0
Num_page_locks_re-requested = 0
Num_object_locks_re-requested = 0
Num_page_locks_waits = 0
Num_object_locks_waits = 0
Num_tran_commits = 0
Num_tran_rollbacks = 0
Num_tran_savepoints = 0
Num_tran_start_topops = 0
Num_tran_end_topops = 0
Num_tran_interrupts = 0
Num_btree_inserts = 0
Num_btree_deletes = 0
Num_btree_updates = 0
Num_btree_covered = 0
Num_btree_noncovered = 0
Num_btree_resumes = 0
Num_query_selects = 0
Num_query_inserts = 0
Num_query_deletes = 0
Num_query_updates = 0
Num_query_sscans = 0
Num_query_iscans = 0
Num_query_lscans = 0
Num_query_setscans = 0
Num_query_methscans = 0
Num_query_nljoins = 0
Num_query_mjoins = 0
Num_query_objfetches = 0
Num_network_requests = 1
Num_adaptive_flush_pages = 0
Num_adaptive_flush_log_pages = 0
Num_adaptive_flush_max_pages = 900
*** OTHER STATISTICS ***
Data_page_buffer_hit_ratio = 0.00
Category of Statistics Information
Category |
Item |
Description |
---|---|---|
File I/O |
Num_file_removes |
The number of files removed |
Num_file_creates |
The number of files created |
|
Num_file_ioreads |
The number of files read |
|
Num_file_iowrites |
The number of files stored |
|
Num_file_iosynches |
The number of file synchronization |
|
Page buffer |
Num_data_page_fetches |
The number of pages fetched |
Num_data_page_dirties |
The number of duty pages |
|
Num_data_page_ioreads |
The number of pages read |
|
Num_data_page_iowrites |
The number of pages stored |
|
Num_data_page_victims |
The number specifying the victim data to be flushed from the data page to the disk |
|
Num_data_page_iowrites_for_replacement |
The number of the written data pages specified as victim |
|
Num_adaptive_flush_pages |
The number of data pages flushed from the data buffer to the disk |
|
Num_adaptive_flush_log_pages |
The number of log pages flushed from the log buffer to the disk |
|
Num_adaptive_flush_max_pages |
The maximum number of pages allowed to flush from data and the log buffer to the disk |
|
Logs |
Num_log_page_ioreads |
The number of log pages read |
Num_log_page_iowrites |
The number of log pages stored |
|
Num_log_append_records |
The number of log records appended |
|
Num_log_archives |
The number of logs archived |
|
Num_log_checkpoints |
The number of checkpoints |
|
Num_log_wals |
Not used |
|
Transactions |
Num_tran_commits |
The number of commits |
Num_tran_rollbacks |
The number of rollbacks |
|
Num_tran_savepoints |
The number of savepoints |
|
Num_tran_start_topops |
The number of top operations started |
|
Num_tran_end_topops |
The number of top perations stopped |
|
Num_tran_interrupts |
The number of interruptions |
|
Concurrency/lock |
Num_page_locks_acquired |
The number of locked pages acquired |
Num_object_locks_acquired |
The number of locked objects acquired |
|
Num_page_locks_converted |
The number of locked pages converted |
|
Num_object_locks_converted |
The number of locked objects converted |
|
Num_page_locks_re-requested |
The number of locked pages requested |
|
Num_object_locks_re-requested |
The number of locked objects requested |
|
Num_page_locks_waits |
The number of locked pages waited |
|
Num_object_locks_waits |
The number of locked objects waited |
|
Index |
Num_btree_inserts |
The number of nodes inserted |
Num_btree_deletes |
The number of nodes deleted |
|
Num_btree_updates |
The number of nodes updated |
|
Num_btree_covered |
The number of cases in which an index includes all data upon query execution |
|
Num_btree_noncovered |
The number of cases in which an index includes some or no data upon query execution |
|
Num_btree_resumes |
The exceeding number of index scan specified in index_scan_oid_buffer_pages |
|
Query Related |
Num_query_selects |
The number of SELECT query execution |
Num_query_inserts |
The number of INSERT query execution |
|
Num_query_deletes |
The number of DELETE query execution |
|
Num_query_updates |
The number of UPDATE query execution |
|
Num_query_sscans |
The number of sequential scans (full scan) |
|
Num_query_iscans |
The number of index scans |
|
Num_query_lscans |
The number of LIST scans |
|
Num_query_setscans |
The number of SET scans |
|
Num_query_methscans |
The number of METHOD scans |
|
Num_query_nljoins |
The number of nested loop joins |
|
Num_query_mjoins |
The number of parallel joins |
|
Num_query_objfetches |
The number of fetch objects |
|
Network request related |
Num_network_requests |
The number of network requested |
|
Data_page_buffer_hit_ratio |
Hit Ratio of page buffers |
Saving statistics information to a file (-o or --output-file)
The -o options is used to store statistics information of server processing for the database to a specified file.
cubrid statdump -o statdump.log testdb
Displays the accumulated operation statistics information (-c or --cumulative)
You can display the accumulated operation statistics information of the target database server by using the -c option. By combining this with the -i option, you can check the operation statistics information at a specified interval.
cubrid statdump -i 5 -c testdb
Displays statistics that includes specified string (-s or --substr)
You can display statistics about items of which name include the specified string by using -s option.
The following example shows how to display statistics about items of which name include "data".
cubrid statdump –s data testdb
*** SERVER EXECUTION STATISTICS ***
Num_data_page_fetches = 135
Num_data_page_dirties = 0
Num_data_page_ioreads = 0
Num_data_page_iowrites = 0
Num_data_page_victims = 0
Num_data_page_iowrites_for_replacement = 0
*** OTHER STATISTICS ***
Data_page_buffer_hit_ratio = 100.00
Note Each status information consists of 64-bit INTEGER data and the corresponding statistics information can be lost if the accumulated value exceeds the limit.