Open Source RDBMS - Seamless, Scalable, Stable and Free

한국어 | Login |Register

CUBRID Manager Monitoring


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.

 

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.

 

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.

 

 

9.2. 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 button in the bar at the top of the broker status monitoring pane.

 

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 button in the bar at the top of the database status monitoring pane.

 

Chart Properties Setting

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

 

 

Manage Dashboard

 

Dashboard tap appears next to Hosts tab when you select Tool > Open Dashboard Explorer in menu. Dashboard is supported in CUBRID 2008 R3.1 or later.

 

Add Dashboard

Right-click on the Dashboard tab and select Add Dashboard. Then, Add Monitoring Dashboard dialog will appear. Enter the dashboard name in Dashboard name field and click Add button.

 

Step 1: Set Host Information

Enter the host information of the database server you want to monitor. At this time, The CUBRID manager server must be running in the host.

  • Alias name : Enter an alias in the host information. If you skip this step, the host address is used.
  • IP address : Enter the IP address of the host to monitor.
  • Port : Enter the cm_port of CUBRID Manager server installed in the host. You can check cm_port value in $CUBRID/conf/cm.conf file.
  • Password : Enter the password for a CUBRID Manager administrator.
  • Connect : Verify whether it is possible to access with the entered host information. You can move to the next step only if the connection test succeeds.

Step 2: Select Database

Select one of the databases you wish to monitor which are installed in the host.

  • Alias name : Enter an alias for the database information. If you skip this step, the database name is used.
  • DBA password : Enter the DBA password of the database.
  • HA Mode : It is automatically selected when the database is configured in HA mode (ha_mode=on).
  • Add database : Verify whether the database information entered can access the database, and add it to the list of databases. If HA is configured in the database, a window that enables you to detect the rest of HA-configured database and add them will appear.
  • Add HA database : If HA is configured in the database, you can add the rest of HA-configured databases.
  • Delete : Delete information registered in the list of databases.

Step 2-1: Add HA Database

If you click the Add HA database button in the step 2, you can add the rest of HA configured nodes. If you click Yes in the window that confirms whether to add standby node, you can add the host information and database information of the standby node in the Add HA database window.

  • Port : Enter the cm_port of CUBRID Manager server installed in the host. You can check cm_port in CUBRID/conf/cm.conf file.
  • Password : Enter the password for a CUBRID Manager administrator.
  • DBA password : Enter the DBA password of the database.
  • Add database : Verify whether the database information entered can access the database, and add it to the list of databases.
  • Delete : Delete information registered in the list of databases.

Step 3: Select Broker

You can select the broker running in the host, and add it as a target to be monitored.

  • Alias name : Enter an alias of the broker. If you skip this step, the broker name is used.
  • Add broker : Add selected broker in the list of brokers.
  • Delete : Delete the registered information in the list of brokers.

 

Manage Dashboard Window

You can use a mouse or keyboard direction key to adjust a target object displayed on the dashboard windows; the adjusted location information is stored in a local directory where CUBRID Manager is installed, and the final location information always will be used. You can also adjust screen ratio by using the <Ctrl> key with mouse scrolling or <+> or <-> keys in the keyboard.

 

A popup menu will appear when you click right-click on the dashboard window.

  • Select All : You can select all the objects indicated in the monitoring window to move their location.
  • Add Host Monitor : You can add new host information that you want to monitor in the monitoring dashboard.
  • Refresh : You can manually refresh the monitoring dashboard.

 

 

Dashboard - Host Monitor

 

It monitors the host in which database or broker is running and shows the current value of the CPU, MEMORY, and IO WAIT as percentage. A popup menu where you can configure functions below will appear when you right-click on the host monitor.

 

View Detailed Information

View Detailed Information shows changes with time of CPU, MEMORY, and IO WAIT.

You can configure the chart properties by clicking the icon on the upper right in the View Detailed Information screen.

  • Plot Appearance : Configure the colors of cross gridlines and the background of a monitor host chart.
  • Series Selection : Select items to display in a monitor host chart, and configure the colors and line thickness of the graph.
  • History Record : Specify a directory where history will be saved when recording is on.
  • Chart Selection : Select a chart to be monitored.

Clicking the start recording icon in the View Detailed Information screen will save all statistical data being recorded into a local folder. To stop recording, click stop recording icon.

 

View History Record

The function that provides the history record information. You can track trend of a specific time by selecting date and time.

 

 

Dashboard - Database Monitor

 

It monitors the database server which is currently running and shows the current value of CPU, MEMORY, and HA delay (msec) of the database server. A popup menu where you can configure functions below will appear when you right-click on the database monitor.

 

View Detailed Information

View Detailed Information shows changes with time of CPU, MEMORY, and HA delay.

You can configure the chart properties by clicking the icon on the upper right in the View Detailed Information screen.

  • Plot Appearance : Configure the colors of cross gridlines and the background of a monitor host chart.
  • Series Selection : Select items to display in a monitor host chart, and configure the colors and line thickness of the graph.
  • History Record : Specify a directory where history will be saved when recording is on.
  • Chart Selection : Select a chart to be monitored.

Clicking the start recording icon in the View Detailed Information screen will save all statistical data being recorded into a local folder. To stop recording, click stop recording icon.

 

View History Record

The function that provides the history record information. You can track trend of a specific time by selecting date and time.

 

View HA Applied Log

This is enabled in the HA standby database server where HA is configured; you can check the log generated upon execution of cubrid applylogdb command.

 

View HA Copied Log

This is enabled in the HA active database server where HA is configured; you can check the log generated upon execution of cubrid copylogdb command.

 

 

Dashboard - Broker Monitor

 

 

It monitors the broker which is currently running and shows the current value of the number of session and active session, including TPS. A popup menu where you can configure functions below will appear when you right-click on the broker monitor.

 

View Detailed Information

View Detailed Information shows values for the broker.

 

View History Record

The function that provides the history record information. You can track trend of a specific time by selecting date and time.

 

View Connected Client

This enables the window that represents an application client connected to a broker. An IP address of the connected application client is displayed.

 

View Connected Database

You can check database information connected by using the broker. The information based on the values of DB items are shown among broker monitoring items.

 

View Host

You can check the host information in which the database server is running.

 

Monitor Statistic

 

From CUBRID 9.2.0, CM Server starts support monitor statistic. And Cubrid Manager 2014.01 support this on UI.

In order to use this feature, you should enable this feature in configuration file - conf/cm.conf: change support_mon_statistic=NO to support_mon_statistic=YES. By default, it's disabled. After change, restart CM Server is necessary. After enable monitor statistic, CM Server will start to collect the monitor data by monitor interval. Then when you use this feature on CUBRID Manager, you can see these data in chart.

The detail as following:

 

1. Single host monitor statistic

You can add monitor statistic pages in each CUBRID node. You can add the monitor statistic page as following:

add_single_monitor_action.png

add_single_monitor_dialog.png

 

Then you'll see a white editor, click "Go to Edit Mode" button to change to edit mode.

monitor_statistic_page_init2.png

 

Then you can add/edit/remove monitor statistic chart. The available options for each chart item in configuration dailog are:

  • Data Type: Database, Database Volume, Broker, OS
  • Time Type: Daily, Weekly, Monthly, Yearly
  • Database: The started database list, only available when Data Type combo selected Database
  • Volume: The volume list for the selected database, only available when Data Type combo selected Database Volume
  • Broker: The broker list, only available when Data Type combo selected Broker
  • Metrics for Database: Metrics about CPU usage info, memory info, application info, IO info, pages info, HA info, database free space info
  • Metrics for Database Volume: Volume free space
  • Metrics for Broker: TPS, QPS, long transaction, long query, request, error query, job query
  • Metrics for OS: Metrics about CPU usage info, memory info, disk free space info

monitor_statistic_add_chart.png

 

 

2. Multi-host monitor statistic

You can add monitor statistic pages in Dashboard tab. Following picture shows how to add a multi-host monitor statistic page:

add_multihost_monitor_action.png

 

The dialog for configuration a chart item is a little different from single host situation. You can see the different from following picture:

monitor_statistic_add_chart2.png

You can add several hosts item with different info to a monitor statistic chart. The options for each chart is similar with single host situation.

 

3. View chart detail

You can double click the chart or Click “Detail” menu item on toolbar when edit mode to open the detail data view.

Note: It will display “-1” if the source data is invalid:

  • One of the chart element in a chart is unavailable
  • Not all the times has valid data. For example, you configure a chart display weekly data, but you enable monitor statistic on CM Server only one day, then six days' will be -1.

 

monitor_statistic_detail_page2.png

 

4. View/edit monitor statistic collecting interval

You can view/edit the monitor statistic collecting interval in each CUBRID node which support monitor statistic.

add_single_monitor_action.png

edit_monitor_interval.png

comments powered by Disqus
Page info
viewed 1805 times
translations en
Author
posted 2 years ago by
newpcraft
Contributors
updated 10 months ago by
View revisions
tagged
Share this article