- Release Notes and Announcements
- Product Introduction
- Purchase Guide
- Operation Guide
- Practical Tutorial
- API Documentation
- History
- Introduction
- Introduction
- API Category
- Making API Requests
- Redis related APIs
- Health Report Email Sending APIs
- Exception Detection APIs
- Session Killing APIs
- Space Analysis APIs
- Slow Log Analysis APIs
- Security Audit APIs
- Database Audit APIs
- Other APIs
- Data Types
- Error Codes
- DBbrain APIs 2019-10-16
- FAQs
- Service Level Agreement
- Glossary
- Contact Us
- Release Notes and Announcements
- Product Introduction
- Purchase Guide
- Operation Guide
- Practical Tutorial
- API Documentation
- History
- Introduction
- Introduction
- API Category
- Making API Requests
- Redis related APIs
- Health Report Email Sending APIs
- Exception Detection APIs
- Session Killing APIs
- Space Analysis APIs
- Slow Log Analysis APIs
- Security Audit APIs
- Database Audit APIs
- Other APIs
- Data Types
- Error Codes
- DBbrain APIs 2019-10-16
- FAQs
- Service Level Agreement
- Glossary
- Contact Us
1. API Description
Domain name for API request: dbbrain.tencentcloudapi.com.
This API is used to get the daily space data of top tables consuming the most instance space. The data is daily collected by DBbrain during a specified time period. The returned results are sorted by size by default.
A maximum of 20 requests can be initiated per second for this API.
We recommend you to use API Explorer
Try it
API Explorer provides a range of capabilities, including online call, signature authentication, SDK code generation, and API quick search. It enables you to view the request, response, and auto-generated examples.
2. Input Parameters
The following request parameter list only provides API request parameters and some common parameters. For the complete common parameter list, see Common Request Parameters.
| Parameter Name | Required | Type | Description |
|---|---|---|---|
| Action | Yes | String | Common Params. The value used for this API: DescribeTopSpaceTableTimeSeries. |
| Version | Yes | String | Common Params. The value used for this API: 2021-05-27. |
| Region | No | String | Common Params. This parameter is not required for this API. |
| InstanceId | Yes | String | Instance ID. |
| Limit | No | Integer | Number of returned top tables. Maximum value: 100. Default value: 20. |
| SortBy | No | String | Field used to sort top tables. Valid values: DataLength, IndexLength, TotalLength, DataFree, FragRatio, TableRows, PhysicalFileSize. Default value: PhysicalFileSize. |
| StartDate | No | Date | Start date, such as "2021-01-01". It can be as early as 29 days before the current date and is 6 days before the end date by default. |
| EndDate | No | Date | End date, such as "2021-01-01". It can be as early as 29 days before the current date and is the current date by default. |
| Product | No | String | Service type. Valid values: mysql (TencentDB for MySQL), cynosdb (TDSQL-C for MySQL). Default value: mysql. |
3. Output Parameters
| Parameter Name | Type | Description |
|---|---|---|
| TopSpaceTableTimeSeries | Array of TableSpaceTimeSeries | Time series list of the returned space statistics of top tables. |
| RequestId | String | The unique request ID, which is returned for each request. RequestId is required for locating a problem. |
4. Example
Example1 Getting the daily space statistics of top tables during the specified time period
Input Example
https://dbbrain.tencentcloudapi.com/?Action=DescribeTopSpaceTableTimeSeries
&InstanceId=cdb-test
&Limit=2
&StartDate=2020-01-01
&EndDate=2020-01-01
&<Common request parameters>
Output Example
{
"Response": {
"RequestId": "d97eacb0-cebd-40b6-963b-579092454f05",
"TopSpaceTableTimeSeries": [
{
"TableName": "test",
"TableSchema": "test_bak",
"SeriesData": {
"Series": [
{
"Values": [
0
],
"Metric": "DataFree",
"Unit": "MB"
},
{
"Values": [
0.1
],
"Metric": "DataLength",
"Unit": "MB"
},
{
"Values": [
0
],
"Metric": "IndexLength",
"Unit": "MB"
},
{
"Values": [
0.1
],
"Metric": "TotalLength",
"Unit": "MB"
},
{
"Values": [
0
],
"Metric": "FragRatio",
"Unit": "%"
},
{
"Values": [
9
],
"Metric": "TableRows",
"Unit": ""
},
{
"Values": [
0.1
],
"Metric": "PhysicalFileSize",
"Unit": "MB"
}
],
"Timestamp": [
1588089600
]
},
"Engine": "InnoDB"
},
{
"TableName": "test22",
"TableSchema": "test_bak",
"SeriesData": {
"Series": [
{
"Values": [
0
],
"Metric": "DataFree",
"Unit": "MB"
},
{
"Values": [
0.1
],
"Metric": "DataLength",
"Unit": "MB"
},
{
"Values": [
0
],
"Metric": "IndexLength",
"Unit": "MB"
},
{
"Values": [
0.1
],
"Metric": "TotalLength",
"Unit": "MB"
},
{
"Values": [
0
],
"Metric": "FragRatio",
"Unit": "%"
},
{
"Values": [
6
],
"Metric": "TableRows",
"Unit": ""
},
{
"Values": [
0.1
],
"Metric": "PhysicalFileSize",
"Unit": "MB"
}
],
"Timestamp": [
1588089600
]
},
"Engine": "InnoDB"
}
]
}
}
5. Developer Resources
SDK
TencentCloud API 3.0 integrates SDKs that support various programming languages to make it easier for you to call APIs.
- Tencent Cloud SDK 3.0 for Python
- Tencent Cloud SDK 3.0 for Java
- Tencent Cloud SDK 3.0 for PHP
- Tencent Cloud SDK 3.0 for Go
- Tencent Cloud SDK 3.0 for Node.js
- Tencent Cloud SDK 3.0 for .NET
- Tencent Cloud SDK 3.0 for C++
Command Line Interface
6. Error Code
The following only lists the error codes related to the API business logic. For other error codes, see Common Error Codes.
| Error Code | Description |
|---|---|
| AuthFailure | Error with CAM signature/authentication. |
| FailedOperation | Operation failed. |
| InternalError | Internal error. |
| InvalidParameter | Incorrect parameter. |
| InvalidParameterValue | Incorrect parameter value. |
| LimitExceeded | The quota limit is exceeded. |
| MissingParameter | Missing parameter. |
| OperationDenied | Operation denied. |
| OperationDenied.UserHasNoStrategy | Error with CAM authentication. |
| ResourceNotFound | The resource does not exist. |
| UnauthorizedOperation | The operation is unauthorized. |
| UnknownParameter | Unknown parameter. |
| UnsupportedOperation | Unsupported operation. |
Yes
No
Was this page helpful?