DescribeEngineDefaultParameters
Returns the default engine and system parameter information for the specified database engine.
Request Parameters
For information about the parameters that are common to all actions, see Common Parameters.
- DBParameterGroupFamily
-
The name of the DB parameter group family.
Valid Values:
-
aurora-mysql5.7
-
aurora-mysql8.0
-
aurora-postgresql10
-
aurora-postgresql11
-
aurora-postgresql12
-
aurora-postgresql13
-
aurora-postgresql14
-
custom-oracle-ee-19
-
custom-oracle-ee-cdb-19
-
db2-ae
-
db2-se
-
mariadb10.2
-
mariadb10.3
-
mariadb10.4
-
mariadb10.5
-
mariadb10.6
-
mysql5.7
-
mysql8.0
-
oracle-ee-19
-
oracle-ee-cdb-19
-
oracle-ee-cdb-21
-
oracle-se2-19
-
oracle-se2-cdb-19
-
oracle-se2-cdb-21
-
postgres10
-
postgres11
-
postgres12
-
postgres13
-
postgres14
-
sqlserver-ee-11.0
-
sqlserver-ee-12.0
-
sqlserver-ee-13.0
-
sqlserver-ee-14.0
-
sqlserver-ee-15.0
-
sqlserver-ex-11.0
-
sqlserver-ex-12.0
-
sqlserver-ex-13.0
-
sqlserver-ex-14.0
-
sqlserver-ex-15.0
-
sqlserver-se-11.0
-
sqlserver-se-12.0
-
sqlserver-se-13.0
-
sqlserver-se-14.0
-
sqlserver-se-15.0
-
sqlserver-web-11.0
-
sqlserver-web-12.0
-
sqlserver-web-13.0
-
sqlserver-web-14.0
-
sqlserver-web-15.0
Type: String
Required: Yes
-
- Filters.Filter.N
-
This parameter isn't currently supported.
Type: Array of Filter objects
Required: No
- Marker
-
An optional pagination token provided by a previous
DescribeEngineDefaultParameters
request. If this parameter is specified, the response includes only records beyond the marker, up to the value specified byMaxRecords
.Type: String
Required: No
- MaxRecords
-
The maximum number of records to include in the response. If more records exist than the specified
MaxRecords
value, a pagination token called a marker is included in the response so you can retrieve the remaining results.Default: 100
Constraints: Minimum 20, maximum 100.
Type: Integer
Required: No
Response Elements
The following element is returned by the service.
- EngineDefaults
-
Contains the result of a successful invocation of the
DescribeEngineDefaultParameters
action.Type: EngineDefaults object
Errors
For information about the errors that are common to all actions, see Common Errors.
Examples
Example
This example illustrates one usage of DescribeEngineDefaultParameters.
Sample Request
https://rds.us-west-2.amazonaws.com/
?Action=DescribeEngineDefaultParameters
&DBParameterGroupFamily=mysql5.1
&MaxRecords=100
&SignatureMethod=HmacSHA256
&SignatureVersion=4
&Version=2014-10-31
&X-Amz-Algorithm=AWS4-HMAC-SHA256
&X-Amz-Credential=AKIADQKE4SARGYLE/20140421/us-west-2/rds/aws4_request
&X-Amz-Date=20140421T194732Z
&X-Amz-SignedHeaders=content-type;host;user-agent;x-amz-content-sha256;x-amz-date
&X-Amz-Signature=747cc243a8a2385b0b06a9e2d145d08b905a39620b2782edd8382ea1712cf826
Sample Response
<DescribeEngineDefaultParametersResponse xmlns="http://rds.amazonaws.com/doc/2014-10-31/">
<DescribeEngineDefaultParametersResult>
<EngineDefaults>
<DBParameterGroupFamily>mysql5.1</DBParameterGroupFamily>
<Marker>bG9nX3FZXJpZ4Nfbm90X3VzaW5nX2luZGV4Z1M=</Marker>
<Parameters>
<Parameter>
<DataType>boolean</DataType>
<Source>engine-default</Source>
<IsModifiable>false</IsModifiable>
<Description>Controls whether user-defined functions that have only an xxx symbol for the main function can be loaded</Description>
<ApplyType>static</ApplyType>
<AllowedValues>0,1</AllowedValues>
<ParameterName>allow-suspicious-udfs</ParameterName>
</Parameter>
<Parameter>
<DataType>integer</DataType>
<Source>engine-default</Source>
<IsModifiable>true</IsModifiable>
<Description>Intended for use with master-to-master replication, and can be used to control the operation of AUTO_INCREMENT columns</Description>
<ApplyType>dynamic</ApplyType>
<AllowedValues>1-65535</AllowedValues>
<ParameterName>auto_increment_increment</ParameterName>
</Parameter>
<Parameter>
<DataType>integer</DataType>
<Source>engine-default</Source>
<IsModifiable>true</IsModifiable>
<Description>Determines the starting point for the AUTO_INCREMENT column value</Description>
<ApplyType>dynamic</ApplyType>
<AllowedValues>1-65535</AllowedValues>
<ParameterName>auto_increment_offset</ParameterName>
</Parameter>
</Parameters>
</EngineDefaults>
</DescribeEngineDefaultParametersResult>
<ResponseMetadata>
<RequestId>b789ce01-b98c-11d3-a907-5a2c468b9cb0</RequestId>
</ResponseMetadata>
</DescribeEngineDefaultParametersResponse>
See Also
For more information about using this API in one of the language-specific AWS SDKs, see the following: