Checks whether table partitions are appropriate.

Debugging

OpenAPI Explorer automatically calculates the signature value. For your convenience, we recommend that you call this operation in OpenAPI Explorer. OpenAPI Explorer dynamically generates the sample code of the operation for different SDKs.

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:

  • 30
  • 50
  • 100
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.