Skip to content

Latest commit

 

History

History
150 lines (90 loc) · 4.98 KB

client_guide.md

File metadata and controls

150 lines (90 loc) · 4.98 KB

English Korean

Client UI Guide

- Connect

- Check the CUBIRID agent Connection status

When the CUBRID Agent is connected to a server, an object is added to the Objects View as shown in the figure above. The CUBRID Agent connection is checked under the HostName where the Agent is executed and the subordinate.

- Add CUBRID Perspective

You can add a perspective to check the CUBRID information.

  • Initialization screen

- Add View

  • After selecting the Cubrid Object in the ObjectView, through the Context Menu and MainMenu(Object) You can add more views to the initial perspective.

  • A View with a fixed DB and Counter is added as a Context Menu to each View. DB, Counter selection is fixed and maintained even when restarting.

- View information

1) Server Info

CUBRID DB information connected to CMS, CPU usage in DB, ACTIVE SESSION, The LOCK WAIT SESSIONS information is displayed, and the view cannot be closed and can only be minimized.

* CPU(%) : CPU usage for DB. 
* ACTIVE SESSION : Sum of Active TranList connected to each DB. (gettransactioninfo)
* LOCK WAIT SESSIONS : Sum of TranList where wait_for_lock_holder is not (-1) in each DB. (gettransactioninfo )

2) SingleRealTimeMultiView

View that displays a single item among DB information and broker information as a graph.

Single item list

  1. Same information as ServerInfo information
  * Cpu Usage : CPU usage for DB.
  * Active Sessions : Sum of Active TranList connected to each DB. 
  * Lock Wait Sessions : Sum of TranList where wait_for_lock_holder is not (-1) in each DB.
  1. list of StatDump info (Num values ​​that can be checked through CUBRID statdump util)
Data Page IO Writes
Data Page IO Reads
Data Page Fetches
Data Page Dirties
Data Buffer Hit Ratio
Query Sscans
Sort IO Page
Sort Data Page
  1. Processed plandump info (through CUBRID plandump util)
XASL Plan Hit Rate (%) : Divide Hits value by Lookups value in plandump XASL Cache.
Filter Predicate Hit Rate (%) : Divide EntryHists value by Lookups value in plandump Filter Predicate Cache
  1. list of broker info
Transaction Per 5 Second : Cumulative data for 5 seconds in TPS of Broker status info .
Query Per 5 Second : Cumulative data for 5 seconds in QPS of Broker status info .
Error Query Per 5 Second : Cumulative data for 5 seconds in Error Query of Broker status info .

View for Realtime and Past through context menu in SingleRealTimeMultiView

You can add RealTime View and Past View to check real-time data or past data.

  1. Viewer for realtime : Real-time information transferred every 5 seconds from CMS(CUBRID Manager Server).

[popup for add View]

[Result]

  1. Viewer for Past – Less than a day : Set to less than one day and real-time information display period data as a graph.

[popup for add View]

[Result]

  1. Viewer for Past – More then a day : Set to more than one day and Accumulate real-time information to display period data as a graph

[popup for add View]

[Result]

3) DB Space Info

View showing volume capacity information in each DB

4) Long Transaction List

Transaction information that has timed out for more than 3 seconds is updated after the view is created. If the host, pid, user, and program are different even in the same SQL text, it is a different transaction. MaxList can be changed and data can be checked from 10 to 1000.