Open Source RDBMS - Seamless, Scalable, Stable and Free

한국어 | Login |Register

Versions available for this page: CUBRID 8.3.0 |  CUBRID 8.3.1 |  CUBRID 8.4.0 |  CUBRID 8.4.1 |  CUBRID 8.4.3 |  CUBRID 9.0.0 | 

Outputting Statistics Information of Server

Description

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.

Syntax

cubrid statdump options database_name

options :

[{-o |--ouput-file=}file_name] [{-i |--interval=}secs] [-c|--cumulative] [{-s |-substr=}sub_string]

  • cubrid : An integrated utility for the CUBRID service and database management.
  • installdb : A command that dumps the statistics information on the database server execution.
  • options : --o, -i-c, and -s options are available.
  • database_name : The name of database which has the statistics data to be dumped.
Option

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 saved

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 saved

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 saved

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

(Servuce Workload)

Num_query_selects

The number of SELECT requested

Num_query_inserts

The number of INSERT queries

Num_query_deletes

The number of DELETE queries

Num_query_updates

The number of UPDATE queries

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

Num_network_requests

The number of networks requested

 

Data_page_buffer_hit_ratio

Hit Ratio of page buffers
(Num_data_page_fetches - Num_data_page_ioreads)*100 / Num_data_page_fetches

Saving statistics information to a file (-o or --output-file)

The -o options is used to save 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 examples displays 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.