Open Source RDBMS - Seamless, Scalable, Stable and Free

한국어 | Login |Register

Versions available for this page: CUBRID 8.3.1 |  CUBRID 8.4.0 |  CUBRID 8.4.1 |  CUBRID 8.4.3 |  CUBRID 9.0.0 | 



Dynamically Changing Broker Parameters

Description

You can configure the parameters related to running the Broker in the Broker configuration file (cubrid_broker.confcubrid_broker.conf). For details, see Parameter by Broker in the "Performance Management Guide." You can also modify some broker parameters temporarily while the Broker is running by using the broker_changer utility. The following broker parameters can be modified dynamically.

  • ACCESS_MODE
  • ACCESS_LOG
  • APPL_SERVER_MAX_SIZE
  • KEEP_CONNECTION
  • LOG_BACKUP
  • LONG_QUERY_TIME
  • LONG_TRANSACTION_TIME
  • MAX_QUERY_TIMEOUT
  • SLOW_LOG
  • SQL_LOG
  • SQL_LOG_MAX_SIZE
  • STATEMENT_POOLING
  • TIME_TO_KILL
Syntax

The syntax for the broker_changer utility, which is used to change broker parameters while the Broker is running, is as follows. Enter the name of the currently running Broker for the broker_name. The parameters can be used only for dynamically modifiable parameters. The value must be specified based on the parameter to be modified. You can specify CAS identifier (cas_id) to apply the changes to the specific CAS. cas_id is an ID to be output by cubrid broker status command.

broker_changer  broker_name [cas_idparameters  value

Example 1

Enter the following to configure the SQL_LOG parameter to ON so that SQL logs can be written to the currently running Broker. Such dynamic parameter change is effective only while the Broker is running.

% broker_changer query_editor sql_log on

OK

Example 2

Enter the following to change Broker's ACCESS_MODE to Read Only and automatically reset the Broker in HA environment.

% broker_changer broker_m access_mode ro

OK

Note If you want to control the service using Cubrid utilities on Windows Vista or the later versions of Window, you are recommended to open the command prompt window as an administrator. For details, see the notes of CUBRID Utilities.