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 or ;.h all) in the CSQL.

Syntax

cubrid statdump options database_name

options : [{-o|--output-file=} file_name]] [{-i|--interval=} secs] [-c|--cumulative]

  • cubrid : An integrated utility for the CUBRID service and database management.
  • installdb : A command that dumps the statistics information about the database server execution.
  • options : --o, -i, and -c 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

 

Wed March 31 11:23:56 KST 2010

 

*** SERVER EXECUTION GLOBAL 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_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 = 2

Num_adaptive_flush_pages = 0

Num_adaptive_flush_log_pages = 0

Num_adaptive_flush_max_pages = 90

 

*** 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

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

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

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 that is not reset at a specified interval. 

cubrid statdump ?i 5 ?c testdb