Stanley shows you how to identify
which Amazon RDS DB parameter
groups are custom or default


How can I identify which Amazon Relational Database Service (Amazon RDS) DB parameters are in a custom parameter group and which are in a default group?

You can modify parameters for custom DB parameter groups to make a change or to resolve an incompatible-parameters issue. You can compare the differences between the custom parameter group settings and determine which values are set by default. For example, you can identify which parameters triggered the incompatible-parameters issue by reviewing the default value and comparing the custom parameter group to the default parameter group for your RDS engine.

Using the Amazon RDS console

You use the Amazon RDS console to compare two parameter groups.

  1. Open the Amazon RDS console, and select the region that contains the RDS instance.
  2. Choose Parameter Groups from the navigation pane.
  3. Choose two parameter groups that you want to compare, and then Parameter group actions.
  4. Choose Compare Parameters.

The result is a Parameter Comparison table that lists of all parameters and values. Review the Parameter Comparison table to see the values of parameters for both default and custom parameter groups.

Using the AWS Command Line Interface (AWS CLI)

You can use the AWS CLI to compare parameter groups by using the describe-db-parameters and describe-db-cluster-parameters commands.

Run the following command to view the settings for a parameter group, including the source for each:

aws rds describe-db-parameters --db-parameter-group-name INSERT-YOUR-PG-NAME-HERE --region INSERT-REGION-HERE

To list the default value for the engine family, you can use the same command or use the describe-engine-default-parameters for database-level parameters and the describe-engine-default-cluster-parameters for cluster-level parameters.

The following example shows the default parameters for the MySQL engine version 5.6 parameter group family:

aws rds describe-engine-default-parameters --db-parameter-group-family mysql5.6

Note: There is no AWS CLI command that compares two parameter groups at the same time. This feature is available only in the Amazon RDS console. You can use the AWS CLI command --output text to list in plaintext instead of the default JSON format. You can then compare the plaintext files that list the parameter groups.

Did this page help you? Yes | No

Back to the AWS Support Knowledge Center

Need help? Visit the AWS Support Center

Published: 2016-11-11

Updated: 2018-10-05