DescribeTopSpaceTableTimeSeries
Last updated: 2024-11-19 21:55:21
1. API Description
Domain name for API request: dbbrain.intl.tencentcloudapi.com.
This API is used to query 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 return 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: 2019-10-16. |
| Region | Yes | String | Common Params. For more information, please see the list of regions supported by the product. |
| 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. It can be as early as 29 days before the current date, and defaults to 6 days before the end date. |
| EndDate | No | Date | End date. It can be as early as 29 days before the current date, and defaults to the current date. |
| Product | No | String | Service type. Valid values: mysql (TencentDB for MySQL), cynosdb (TencentDB for CynosDB (compatible with 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, generated by the server, will be returned for every request (if the request fails to reach the server for other reasons, the request will not obtain a RequestId). RequestId is required for locating a problem. |
4. Example
Example1 Getting daily space statistics of top tables during a specified time period
Input Example
https://dbbrain.intl.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 |
|---|---|
| InvalidParameter | Incorrect parameter. |
| InvalidParameterValue | Incorrect parameter value. |
| OperationDenied.UserHasNoStrategy | Error with CAM authentication. |
| UnauthorizedOperation | The operation is unauthorized. |
Was this page helpful?
You can also Contact Sales or Submit a Ticket for help.
Yes
No