--- title: Parameter Group sidebar_position: 3 --- import Tabs from '@theme/Tabs'; import TabItem from '@theme/TabItem'; 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 | Parameter | Description | | --------------------------------- | ---------------------------------------------------------------------- | | `innodb_buffer_pool_size` | Size of the buffer pool where InnoDB caches table and index data. | | `max_connections` | The maximum permitted number of simultaneous client connections. | | `thread_cache_size` | The number of threads that can be stored in the thread cache. | | `table_open_cache` | The number of open tables for all threads. | | `wait_timeout` | Seconds the server waits for activity on a non-interactive connection. | | `key_buffer_size` | Size of the buffer used for index blocks for MyISAM tables. | | `log_bin` | Enables binary logging. | | `innodb_log_file_size` | The size of each log file in the log group. | | `innodb_flush_log_at_trx_commit` | Controls balance between strict ACID compliance and higher performance. | | `max_allowed_packet` | Maximum size of one packet or any generated/intermediate string. | | `innodb_file_per_table` | Stores each InnoDB table to its own .ibd file. | | `query_cache_type` | Specifies the types of queries that are cached. | | `slow_query_log` | Enables the slow query log. | | `tmp_table_size` | Maximum size of internal in-memory temporary tables. | | Parameter | Description | | ------------------------------- | --------------------------------------------------------------------------------------------------- | | `shared_buffers` | Sets the amount of memory the database server uses for shared memory buffers. | | `work_mem` | Sets the maximum memory to be used for query workspaces. | | `maintenance_work_mem` | Sets the maximum memory to be used for maintenance operations. | | `max_connections` | Determines the maximum number of concurrent connections to the database server. | | `effective_cache_size` | Provides an estimate of available memory for disk caching by the OS and the database itself. | | `checkpoint_completion_target` | Specifies the target of checkpoint completion. | | `wal_buffers` | Sets the amount of memory used for write-ahead log (WAL) data. | | `autovacuum` | Enables the autovacuum daemon. | | `default_statistics_target` | Sets the default statistics target for table columns without a column-specific target. | | `work_mem` | Memory used by internal sort operations and hash tables before switching to temporary disk files. | | `max_wal_size` | Sets the WAL size that triggers a checkpoint. | | `min_wal_size` | Sets the minimum size to shrink the WAL to. | | `effective_io_concurrency` | Number of concurrent disk I/O operations PostgreSQL expects can be executed simultaneously. | | `random_page_cost` | Sets the cost of a non-sequentially fetched disk page. | | `seq_page_cost` | Sets the cost of a sequentially fetched disk page. | | Parameter | Description | | --------------------------------- | ---------------------------------------------------------------------- | | `innodb_buffer_pool_size` | Size of the buffer pool where InnoDB caches table and index data. | | `max_connections` | The maximum number of simultaneous client connections. | | `query_cache_size` | The amount of memory allocated for caching query results. | | `thread_cache_size` | The number of threads that can be stored in the thread cache. | | `table_open_cache` | The number of open tables for all threads. | | `wait_timeout` | Seconds the server waits for activity on a non-interactive connection. | | `key_buffer_size` | Size of the buffer used for index blocks for MyISAM tables. | | `log_bin` | Enables binary logging. | | `innodb_log_file_size` | The size of each log file in the log group. | | `innodb_flush_log_at_trx_commit` | Controls balance between strict ACID compliance and higher performance. | | `max_allowed_packet` | Maximum size of one packet or any generated/intermediate string. | | `innodb_file_per_table` | Stores each InnoDB table to its own .ibd file. | | `query_cache_type` | Specifies the types of queries that are cached. | | `slow_query_log` | Enables the slow query log. | | `tmp_table_size` | Maximum 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](images/ParameterGroup1.png) After clicking on **Database**, click on **Parameter Group** from the sidebar and then click on the **Add Parameter Group** button. ![Parameter Group Image 2](images/ParameterGroup2.png) ![Parameter Group Image 3](images/ParameterGroup3.png) After clicking on the **Add Parameter Group**, select a relevant plan for your database and give a name and description. ![Parameter Group Image 4](images/ParameterGroup4.png) 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](images/SelectPGPlans.png) Fill in the details like this: ![Parameter Group Image 5](images/ParameterGroup5.png) Click on the **Create** button. ![Parameter Group Image 6](images/ParameterGroup6.png) After the parameter group is created, it will be shown like this: ![Parameter Group Image 7](images/ParameterGroup7.png) Now, clicking on the **Action** button will give options like this: ![Parameter Group Image 8](images/ParameterGroup8.png) Click on **Edit Parameter Group** to edit the DBaaS configuration. ![Parameter Group Image 9](images/ParameterGroup9.png) After clicking on **Edit Parameter Group**, the user will see parameters like this: ![Parameter Group Image 10](images/ParameterGroup10.png) Click on **Edit Parameters** on the top right corner of the page to edit the parameters options. ![Parameter Group Image 11](images/ParameterGroup11.png) After clicking on **Edit Parameters**, change the parameter according to your requirements. ![Parameter Group Image 12](images/ParameterGroup12.png) After changing the parameters, click on **Save Changes** to save the changes you have applied on the parameters. ![Parameter Group Image 13](images/ParameterGroup13.png) After changing the parameters and saving those changes, click on the **Back** button. ![Parameter Group Image 14](images/ParameterGroup14.png) 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](images/ParameterGroup15.png) Click on **Delete Parameter Group** to delete the Parameter Group. ![Parameter Group Image 16](images/ParameterGroup16.png) ## How to attach Parameter group to your Database ![Parameter Group Image 17](images/ParameterGroup17.png) 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](images/ParameterGroup18.png) After clicking on the checkbox, the user will be able to see a box. ![Parameter Group Image 19](images/ParameterGroup19.png) 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](images/ParameterGroup20.png) After selecting the desired parameter group, click on the **Attach Group** button to attach the group to the database. ![Parameter Group Image 21](images/ParameterGroup21.png) 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](images/ParameterGroup22.png) To detach the parameter group, click on the **Detach Group** button. ![Parameter Group Image 22](images/ParameterGroup22.png) ---