Skip to main content

Parameter Group

A parameter group is a collection of engine configuration values that you set for your database instance. It contains the mapping of what you want each of these parameters to be set.

Commonly used Parameters Group variables

ParameterDescription
innodb_buffer_pool_sizeSize of the buffer pool where InnoDB caches table and index data.
max_connectionsThe maximum permitted number of simultaneous client connections.
thread_cache_sizeThe number of threads that can be stored in the thread cache.
table_open_cacheThe number of open tables for all threads.
wait_timeoutSeconds the server waits for activity on a non-interactive connection.
key_buffer_sizeSize of the buffer used for index blocks for MyISAM tables.
log_binEnables binary logging.
innodb_log_file_sizeThe size of each log file in the log group.
innodb_flush_log_at_trx_commitControls balance between strict ACID compliance and higher performance.
max_allowed_packetMaximum size of one packet or any generated/intermediate string.
innodb_file_per_tableStores each InnoDB table to its own .ibd file.
query_cache_typeSpecifies the types of queries that are cached.
slow_query_logEnables the slow query log.
tmp_table_sizeMaximum size of internal in-memory temporary tables.

How to create Parameter Group

For creating a Parameter group, you need to click on Database from the side navigation bar.

Parameter Group Image 1

After clicking on Database, click on Parameter Group from the sidebar and then click on the Add Parameter Group button.

Parameter Group Image 2

Parameter Group Image 3

After clicking on the Add Parameter Group, select a relevant plan for your database and give a name and description.

Parameter Group Image 4

Different database engines have different Parameter groups available. You need to select the required database engine for which you want to create a Parameter group. Below is the list of database engines that we currently support:

  • MariaDB - 10.4
  • MySQL 5.6
  • MySQL 5.7
  • MySQL 8.0
  • PostgreSQL 10.0
  • PostgreSQL 11.0
  • PostgreSQL 12.0
  • PostgreSQL 13.0
  • PostgreSQL 14.0

Select PG Plans

Fill in the details like this:

Parameter Group Image 5

Click on the Create button.

Parameter Group Image 6

After the parameter group is created, it will be shown like this:

Parameter Group Image 7

Now, clicking on the Action button will give options like this:

Parameter Group Image 8

Click on Edit Parameter Group to edit the DBaaS configuration.

Parameter Group Image 9

After clicking on Edit Parameter Group, the user will see parameters like this:

Parameter Group Image 10

Click on Edit Parameters on the top right corner of the page to edit the parameters options.

Parameter Group Image 11

After clicking on Edit Parameters, change the parameter according to your requirements.

Parameter Group Image 12

After changing the parameters, click on Save Changes to save the changes you have applied on the parameters.

Parameter Group Image 13

After changing the parameters and saving those changes, click on the Back button.

Parameter Group Image 14

After changing the parameters, click on Sync All to apply the changes the user has made to its parameter group so that it can be synced with the relevant database service.

Parameter Group Image 15

Click on Delete Parameter Group to delete the Parameter Group.

Parameter Group Image 16

How to attach Parameter group to your Database

Parameter Group Image 17

After creating a DBaaS, the user will be able to see the Parameter Groups option in the bottom left corner of the page.

Parameter Group Image 18

After clicking on the checkbox, the user will be able to see a box.

Parameter Group Image 19

After clicking on the Select Group expansion panel, the user will be able to select the parameter group he/she wants to attach to its Database.

Parameter Group Image 20

After selecting the desired parameter group, click on the Attach Group button to attach the group to the database.

Parameter Group Image 21

After attaching the parameter group, the user will be able to see the attached group in the bottom of the Connection Details tab.

Parameter Group Image 22

To detach the parameter group, click on the Detach Group button.

Parameter Group Image 22