• Relational Database Service

rds
  1. Help Center
  2. Relational Database Service
  3. User Guide
  4. Managing DB Instances
  5. Parameter Groups
  6. Modifying Parameters in a Parameter Group

Modifying Parameters in a Parameter Group

You can modify parameters in parameter groups you have created.

You can change parameter values in customer-created parameter groups only and cannot change parameter values in default parameter groups.

The following are the key points you should know when using parameters in a parameter group:

  • When you change a dynamic parameter value on the Parameters page and save the change, the change takes effect immediately regardless of the Effective upon Reboot setting. When you change static parameter values in a parameter group and save the changes, the changes will take effect only after you manually reboot the DB instances to which the parameter group applies.
  • When you change parameter values in parameter groups in batches on the Parameter Group Management page and save the changes, the changes will take effect only after you apply the parameter groups to DB instances. When you change static parameter values in a parameter group and save the changes, the changes will take effect only after you apply the parameter group to DB instances and manually reboot the DB instances. For details, see section Applying a Parameter Group to DB Instances.

If you change a parameter value, when the change applies is determined by the type of parameter.

The RDS console displays the status of the parameter group applied to DB instances. For example, if the DB instance does not use the latest changes made to the parameter group, the RDS console displays the parameter group with a status of Pending reboot. You need to manually reboot the DB instance for the latest parameter changes to take effect for that DB instance.

NOTE:

RDS has default parameter groups whose parameter values cannot be changed. You can view these parameter values by clicking the default parameter group names. If a custom parameter group is set incorrectly and causes a database reboot to fail, you can use a default parameter group to reset the database.

For details on modifying parameters in a MySQL parameter group, see section Modifying Parameters in a Parameter Group.

For details on modifying parameters in a PostgreSQL parameter group, see section Modifying Parameters in a Parameter Group.

For details on modifying parameters in a Microsoft SQL Server parameter group, see section Modifying Parameters in a Parameter Group.