DB Parameter Groups

A DB parameter group is a definition that sets various parameters for the database engine when you create a virtual database server.

Since the parameters you can specify depend on the database engine and the version, perform tuning after you create a DB parameter group by changing the parameters that are created under the DB parameter group.

Creating a DB Parameter Group

Create a DB parameter group by specifying the parameters as shown below.

Table 1. Creating a DB Parameter Group (List of Items That Can Be Specified)
Item Description Required
Parameter group family

Specify the type of parameter group, which is determined by the database engine and the version. You can specify the following value:

  • enterprisepostgres_v9.6
  • symfoware_v12.1
Yes
DB parameter group ID

Specify the ID of the DB parameter group. The characters that you specify must meet the following specifications:

  • Use alphanumeric characters and hyphens
  • Use an alphabetic character as the first character
  • You cannot use a hyphen as the last character
  • You cannot use two or more consecutive hyphens
  • Specify at least 1 character, and no more than 63 characters
Note: If you omit the ID, random characters will be set.
 
DB parameter group name

Specify a name to identify the DB parameter group. The characters that you specify must meet the following specifications:

  • Use alphanumeric characters and hyphens
  • Use an alphabetic character as the first character
  • You cannot use a hyphen as the last character
  • You cannot use two or more consecutive hyphens
  • Specify at least 1 character, and no more than 255 characters
Yes
Description Specify a description for the DB parameter group  

Acquiring the DB Parameter Group List

Acquire a list of the DB parameter groups in the project.

Checking DB Parameter Group Information

Check the detailed information of the DB parameter group by specifying the ID of the DB parameter group in the project. You can check the following items of each parameter that can be specified for a database.

Table 2. Each Parameter Item That Can Be Checked
Item Description
Parameter name Check the parameter names that can be specified.
Parameter value Check the current setting value that corresponds to the parameter name.
Parameter value range Check the range of values that can be parameter values.
Parameter application method

Check the time when the parameter value is to be applied. The following choices for timing are available:

  • immediate: The value is applied immediately
  • reboot: The value is applied when the virtual database server is restarted.
Parameter data type Check the data type of the parameter value (example: Integer, String).
Description Check the description of the parameter.
Flags that indicate changeability Check whether or not the parameter value can be changed. "FALSE" indicates that it cannot be changed
Lowest version that supports the parameter Check what the lowest version that supports the parameter in the parameter group family is.
Source of the default value

Check where the default value is set from.

  • engine: Default value that is provided by the database engine
  • system: Default value that is set by IaaS system

Changing a DB Parameter Value

In order to change the parameter value to be set on the database, include in the DB parameter group the parameter that you want to modify, and modify the DB parameter group information. You cannot modify parameter values by specifying only individual parameters.

Table 3. Items That Can Be Changed for Each Parameter
Item Description
Parameter name Specify the parameter whose value you want to change. Specify the parameter name that is specified in the information of the DB parameter group
Parameter value Specify the value that you want to change the parameter value to. Specify a value in the parameter value range that is specified in the information of the DB parameter group
Parameter application method

Specify the time when the parameter value is applied. The following choices for timing are available:

  • immediate: The value is applied immediately
  • pending-reboot: The value is applied when the virtual database server is restarted.
Note: You can modify a maximum of 20 parameters per request.

Deleting a DB Parameter Group

Specify the ID of a DB parameter group in the project to delete a DB parameter group that is no longer necessary.