You need to enable JavaScript to run this app.
RDS for MySQL

RDS for MySQL

  • Documentation
    • RDS for MySQLAPI referenceV2（2022-01-01）Managing parametersDescribeDBInstanceParametersLog
Copy page
Download PDF
Managing parameters
DescribeDBInstanceParametersLog
Copy page
Download PDF
DescribeDBInstanceParametersLog

Call the DescribeDBInstanceParametersLog API to query the parameter modification history of an instance.

Request type

Synchronous request.

Request parameters

Name
Type
Required
Example
Description
InstanceId
String
Yes
mysql-h441603c****
Instance ID.
StartTime
String
Yes
2020-03-01T00:00:00Z
Start time of the query. Format: yyyy-MM-ddTHH:mm:ssZ (UTC time).
EndTime
String
Yes
2020-03-01T10:00:00Z
End time of the query. Format: yyyy-MM-ddTHH:mm:ssZ (UTC time).
PageNumber
Integer
No
1
Current page number. Minimum value is 1. Default value is 1.
PageSize
Integer
No
10
Number of records per page. Minimum value is 1, maximum value does not exceed 1000. Default value is 10.

Response parameters

Name
Type
Example
Description
Total
Integer
1
Total number of query results.
ParameterChangeLogs
Object[]
None.
List of parameter modification records.
ParameterName
String
innodb_stats_sample_pages
Parameter Name.
Status
String
Applied

Status. Values:

  • Applied: Effective.
  • Invalid: Not effective.
  • Syncing: Being applied and not yet effective.
NewParameterValue
String
3
Modified parameter value.
OldParameterValue
String
8
Modify the previous parameter value.
ModifyTime
String
2020-03-01T00:00:00Z
Modify the timestamp of the parameter. Format: yyyy-MM-ddTHH:mmZ (UTC time).
CustomNodeIds
String[]
[ "mysql-b630addf****-r1415" ]
The list of node IDs to which the parameter modification is applied.
ParamApplyScope
String
AllNode

The application rule of parameter modification. The value is OnlyMasterSlaveNode, that is, the modification range of the parameter is the master node and the standby node.

tip

When the CustomNodeIds field is returned, the value of the ParamApplyScope field is invalid.

Sample request 

POST /?Action=DescribeDBInstanceParametersLog&Version=2022-01-01 HTTP/1.1
Accept: application/json
Content-Type: application/json
Host: rds-mysql.cn-beijing.volcengineapi.com
X-Date: 20211202T101010Z
Authorization: HMAC-SHA256 Credential=AKLTN2I0MmFiNzMxNWE5NDgzMzk4MmVjMTVkODlkZTZ****/20211202/cn-beijing/rds_mysql/request,SignedHeaders=x-date, Signature=71d31fc7bcf990142851c9833c5656391486cda0ae2e0b8ada733b7c6458****
{
    "InstanceId": "mysql-8baa525f****",
    "StartTime": "2023-01-01T00:00:00Z",
    "EndTime": "2024-11-10T00:00:00Z"
}

Sample response 

{
    "ResponseMetadata": {
        "RequestId": "2024101020003027D28AE4A308840C6BC8-7f9cbd",
        "Action": "DescribeDBInstanceParametersLog",
        "Version": "2022-01-01",
        "Service": "rds_mysql",
        "Region": "cn-beijing"
    },
    "Result": {
        "ParameterChangeLogs": [
            {
                "ModifyTime": "2024-10-10T11:55:42.000Z",
                "NewParameterValue": "2",
                "OldParameterValue": "1",
                "ParamApplyScope": "OnlyMasterSlaveNode",
                "ParameterName": "auto_increment_increment",
                "Status": "Applied"
            },
            {
                "CustomNodeIds": [
                    "mysql-8baa525f****-r6e37"
                ],
                "ModifyTime": "2024-10-10T11:55:42.000Z",
                "NewParameterValue": "2",
                "OldParameterValue": "1",
                "ParamApplyScope": "OnlyMasterSlaveNode",
                "ParameterName": "auto_increment_increment",
                "Status": "Applied"
            }
        ],
        "Total": 2
    }
}

Error codes

For more details, refer to Error codes.

Last updated: 2025.07.07 15:52:02