Checks whether table partitions are appropriate.
Debugging
Request parameters
Parameter | Type | Required | Example | Description |
---|---|---|---|---|
Action | String | Yes | DescribeTablePartitionDiagnose |
The operation that you want to perform. Set the value to DescribeTablePartitionDiagnose. |
RegionId | String | Yes | cn-hangzhou |
The region ID. |
DBClusterId | String | Yes | am-bpxxxxxxxx47 |
The ID of the cluster. |
PageSize | Integer | No | 30 |
The number of entries to return on each page. Default value: 30. Valid values:
|
PageNumber | Integer | No | 1 |
The number of the page to return. Pages start from page 1. Default value: 1. |
Response parameters
Parameter | Type | Example | Description |
---|---|---|---|
TotalCount | Integer | 1 |
The total number of entries. |
RequestId | String | 1AD222E9-E606-4A42-BF6D-8A4442913CEF |
The ID of the request. |
PageSize | Integer | 123 |
The number of entries returned per page. |
PageNumber | Integer | 34 |
The page number of the returned page. |
DBClusterId | String | rm-uf6wjk5xxxxxxxxxx |
The ID of the cluster. |
SuggestMaxRecordsPerPartition | Long | 640000000 |
The recommended maximum number of rows in each list partition. |
SuggestMinRecordsPerPartition | Long | 64000000 |
The recommended minimum number of rows in each list partition. |
Items | Array of TablePartitionDiagnose |
The information of tables. |
|
TableName | String | user |
The table name. |
PartitionDetail | String | [20210110, 20210113,20210123] |
Details of the inappropriate partitions. |
SchemaName | String | test_db |
The name of the database. |
PartitionNumber | Integer | 34 |
The number of partitions. |
Examples
Sample requests
http(s)://[Endpoint]/?AccessKeyId=xxxx
&Action=DescribeTablePartitionDiagnose
&RegionId=cn-hangzhou
&DBClusterId=am-bpxxxxxxxx47
&PageSize=30
&PageNumber=1
&<Common request parameters>
Sample success responses
XML
format
HTTP/1.1 200 OK
Content-Type:application/xml
<TotalCount>1</TotalCount>
<RequestId>1AD222E9-E606-4A42-BF6D-8A4442913CEF</RequestId>
<PageSize>123</PageSize>
<PageNumber>34</PageNumber>
<DBClusterId>rm-uf6wjk5xxxxxxxxxx</DBClusterId>
<SuggestMaxRecordsPerPartition>640000000</SuggestMaxRecordsPerPartition>
<SuggestMinRecordsPerPartition>64000000</SuggestMinRecordsPerPartition>
<Items>
<TableName>user</TableName>
<PartitionDetail>[20210110, 20210113,20210123]</PartitionDetail>
<SchemaName>test_db</SchemaName>
<PartitionNumber>34</PartitionNumber>
</Items>
JSON
format
HTTP/1.1 200 OK
Content-Type:application/json
{
"TotalCount" : 1,
"RequestId" : "1AD222E9-E606-4A42-BF6D-8A4442913CEF",
"PageSize" : 123,
"PageNumber" : 34,
"DBClusterId" : "rm-uf6wjk5xxxxxxxxxx",
"SuggestMaxRecordsPerPartition" : 640000000,
"SuggestMinRecordsPerPartition" : 64000000,
"Items" : [ {
"TableName" : "user",
"PartitionDetail" : "[20210110, 20210113,20210123]",
"SchemaName" : "test_db",
"PartitionNumber" : 34
} ]
}
Error codes
HTTP status code | Error code | Error message | Description |
---|---|---|---|
500 | InternalError | An error occurred while processing your request. | The error message returned because an internal error has occurred. Try again later. |
503 | ServiceUnavailable | An error occurred while processing your request. | The error message returned because the service is unavailable. Try again later. |
For a list of error codes, visit the API Error Center.