Open Source RDBMS - Seamless, Scalable, Stable and Free

한국어 | Login |Register

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

Status Monitor

The Status monitor provides the following functions:

Adding the Status Monitor

In the navigation tree, right-click the [Status monitor] and select [Add Template]; the [Add Template] dialog will appear. In the dialog, you can create a monitoring template by selecting monitoring target, item, or chart property etc. Note that the options in the [Add Template] may be different from the picture below if you are connected to the version which is earlier than 3.0.

  • [Monitor type] : Select either DATABASE or BROKER.
  • [Template name] : Enter the name of status monitoring template to be created.
  • [Chart Title] Tab : Specify a title (to be displayed at the top of a chart), background color, and font.
  • [Plot Appearance] Tab : Set colors for a chart title, horizontal/vertical asix, or grid line.
  • [Series Selection] Tab : Select a target to be monitored. 

manager_monitor_template.png

Monitoring Database Status

If you select DATABASE in the [Monitor type], you can select a desired monitoring item of database in the [Series Selection] and then add it to a template.

Monitoring database shows statistics data executed by the CUBRID server by using the cubrid statdump utility. It monitors items such as log pages, indexes, queries, or transactions. For more information, see "Outputting Statistics Information of Server."

Monitoring Broker Status

If you select BROKER in the [Monitor type], you can select a desired monitoring item of Broker in the [Serier Selection] and then add it to a template.

There are seven types of Broker monitoring item: SESSION, ACTIVE_SESSION, ERR_Q, LONG_Q, LONG_T, QPS, RPS, and TPS. For more information, see "Checking the Broker Status." All other object monitoring values except for ACTIVE_SESSION of the Broker represent the number of occurrences that happen during the last sampling interval.

  • SESSION : The number of applications (CAS) connected to the Broker. In other words, it means the number of applications, not IDLE status. This value cannot exceeds the value specified in the MAX_NUM_APPL_SERVER parameter.
  • ACTIVE_SESSION : The number of active applications (CAS) with BUSY status. In other words, it means the number of transactions that are currently executed.
  • ERR_Q : The number of errors occurred
  • LONG_Q : The number of long queries
  • LONG_T : The number of long transactions
  • QPS : The number of queries processed per second by the Broker
  • RPS : The number of requests per second received by the Broker
  • TPS : The number of transactions processed per second by the Broker
Template Information
  • Name : Enter the name of the Status monitoring template to be created.
  • Description : Enter the description of the template to be created.
  • Sampling term (Second) : Specify the interval (in seconds) at which the target object is to be monitored.
  • Target database : Select the target database. It is activated when the monitoring target object is related to the Database Server.
Editing the Status Monitor

You can edit in the same interface as with [Add Template] by right-clicking the Status monitor template to edit and then selecting [Edit Template].

Deleting the Status Monitor

To delete a registered Status monitor template, right-click the template to delete and then select [Delete Template].

Executing the Status Monitor

If you right-click the Status Monitor Template to execute and then select [Status Monitor], the Status Monitor pane appears where you can monitor the Server and the Broker status depending on the selected template. The Status Monitor shows separate charts for each collected item, which consists of the current, minimum, maximum and average values.

The Status Monitor, represented in separate views, can be viewed together with other view interfaces. It can also be viewed outside the CUBRID Manager, which makes it convenient to perform jobs and monitoring at the same time in multi-monitor environment.

manager_monitor.png

Integrated Status Monitoring

This feature is supported only when you connect to a database of CUBRID 2008 R2.2 or higher.

Broker Status Monitoring

You can monitor items related to the broker by combining them into a single chart. You can set the chart property by clicking the [Configuration icon_setting.png] button in the bar at the top of the broker status monitoring pane. 

manager_monitor_broker.png

Database Status Monitoring

This feature is supported only when you connect to a database of CUBRID 2008 R2.2 or higher. You can monitor items related to the database by combining them into a single chart.

The items that can be monitored are the same as the item displayed when the cubrid statdump utility is executed. You can set the chart property by clicking the [Configuration icon_setting.png] button in the bar at the top of the database status monitoring pane.    

manager_monitor_database.jpg

Chart Properties Setting

You can set the chart title, image and items to be monitored in the chart setting wizard.