Viewing parameter values for a DB parameter group in Amazon Aurora
You can get a list of all parameters in a DB parameter group and their values.
To view the parameter values for a DB parameter group
-
Sign in to the AWS Management Console and open the Amazon RDS console at https://console.aws.amazon.com/rds/
. -
In the navigation pane, choose Parameter groups.
The DB parameter groups appear in a list.
-
Choose the name of the parameter group to see its list of parameters.
To view the parameter values for a DB parameter group, use the AWS CLI describe-db-parameters
command with the following
required parameter.
--db-parameter-group-name
Example
The following example lists the parameters and parameter values for a DB parameter group named mydbparametergroup.
aws rds describe-db-parameters --db-parameter-group-name
mydbparametergroup
The command returns a response like the following:
DBPARAMETER Parameter Name Parameter Value Source Data Type Apply Type Is Modifiable DBPARAMETER allow-suspicious-udfs engine-default boolean static false DBPARAMETER auto_increment_increment engine-default integer dynamic true DBPARAMETER auto_increment_offset engine-default integer dynamic true DBPARAMETER binlog_cache_size 32768 system integer dynamic true DBPARAMETER socket /tmp/mysql.sock system string static false
To view the parameter values for a DB parameter group, use the RDS API DescribeDBParameters
command with the following
required parameter.
DBParameterGroupName