Open Source RDBMS - Seamless, Scalable, Stable and Free

한국어 | Login |Register

CUBRID Manager Advanced Usage


12.1. Host Group Management

 

Host groups can make hosts display clearly when where are lots of hosts needed to manage.
 

manager_host_manage_overview.png

 

Hide or Show Groups

Users can choose hide or show the host group by menu as follows:

 

manager_host_manage_group.png  

 

  • Item menu : show host only and hide the group nodes.
  • Group menu : show the group nodes.

 

Open Groups Settings Dialog

 

manager_host_manage_settingdialog.png

 

Use Group Settings… above to open the group management dialog as follows:

 

manager_host_manage_groupsetting.png  

 

Buttons TopUPDownBottom are responsible to adjust the display order of group.

And buttons Add… Edit… will open a new dialog to add or edit a group.


Add, Edit Group Nodes of Hosts

Button Add will open a new group dialog to let users input the new group's name and children hosts.

Left area of the dialog is a list of current hosts which is not in current group and right area is a list of current group’s children hosts.

Button > will move the selected in the left to right and >> will move all of the left to right;

Button < will move the selected in right to left and << will all of the right to left.

 

Delete Group

Select a group to be deleted and push the button Delete.

Note: the Default Group can not be deleted and edited, it store the hosts which is not in other groups.


Drag Group

Users can drag several host nodes to another group node or change the display order of host nodes of current group node.

Users can also change the display order of host nodes when group nodes are hidden.

 

 

12.2. Configuring Background Operations in Multiple-Host Environment

 

If you manage databases in several hosts by using Add Host, databases can be configured for background operations. For example, if you want to execute a query to a database in host B while doing backup for a database in host A, the database backup operation, which generally takes a long time, can be configured to be executed as a background operation. The database operations that can be run in the background are as follows:

  • Database related : Create Database, Unload/Load Database, Backup/Restore Database, Rename Database, Copy Database, Optimize Database, Compact Database, Check Database
  • Table related : Import/Export, Delete All Records, Update data by changing constraints from NULL to NOT NULL
  • Volume : Add Volume

 

 

12.3. OID Navigator

 

It is used to search data by OIDs.

You can run the OID Navigator by right-clicking a database or inside the Result pane of the Query editor and then selecting OID Navigator. Note that this function is activated only while the database server is running; this is deactivated while the server is not running.

 

12.4. Query Tuner

The query tuner is used to develop the high performance SQL. You can tune the query and compare the performance between different queries. There are consists of two parts as "Tune a query", "Compare a query plan".

12.4.1 Tune a query

You can edit and run a query in order to get a query plan and a statistics when it runs. And also you can save the query plan result in order to compare other query plans.

(1) The toolbar for query:

 

  • To run the query.
  • To run the query plan only.
  • Save the query to the current selected project.

 

(2) The query editor: You can edit the query in this pane.

(3) The query result table: To display the result data.

(4) The toolbar for query plan: 

 

  • Hide/Show last query.
  • Show the query plan by text model.
  • Show the query plan by tree model.
  • Show the query plan by graph model.

 

(5) The query statistics table: To display current and last query statistics.

(6) The current query plan panel: This panel to display current query plan.

(7) The last query plan panel: This panel to display last query plan.

(8)  Query project toolbar: To manage the query project.

 

  • Add a query project.
  • Delete the selected project.
  • Rename the selected project.

 

 

12.4.2 Compare a query plan

As mentioned above, you can compare two query plan in order to get what is a different. You can compare queries, plans(there also supports graphical query plan).

 

(1) To select left query plan.

(2) To select right query plan.

(3) To display the query statistics.

(4) To display left selected query plan.

(5) Toolbar:

 

  • Refresh the display.
  • Delete right selected query.
  • Run the query again.
  • Show the query plan by text model.
  • Show the query plan by tree model.
  • Show the query plan by graph model.
(6) To display right query plan.

 

 

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