TencentDB for DBbrain
- Release Notes and Announcements
- Product Introduction
- Operation Guide
- Cloud Access Management
- Monitoring and Alarms
- MySQL/TDSQL-C for MySQL Performance Optimization
- Redis Performance Optimization
- MongoDB Performance Optimization
- Full-Link Analysis
- Practical Tutorial
- API Documentation
- 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
- DBbrain APIs 2019-10-16
- Making API Requests
- Slow Log Analysis APIs
- Exception Detection APIs
- Other APIs
- Health Report Email Sending APIs
DocumentationTencentDB for DBbrainAPI DocumentationDBbrain APIs 2019-10-16Other APIsDescribeTopSpaceTables
DescribeTopSpaceTables
Last updated: 2024-11-19 21:55:20
1. API Description
Domain name for API request: dbbrain.intl.tencentcloudapi.com.
This API is used to query real-time space statistics of top tables of an instance. 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: DescribeTopSpaceTables. |
| 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, and PhysicalFileSize (only supported by TencentDB for MySQL instances). For TencentDB for MySQL instances, the default value is PhysicalFileSize; for other database instances, the default value is TotalLength. |
| 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 |
|---|---|---|
| TopSpaceTables | Array of TableSpaceData | List of the returned space statistics of top tables. |
| Timestamp | Integer | Timestamp (in seconds) of tablespace data collect points |
| 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 the space statistics of top tables
Input Example
https://dbbrain.intl.tencentcloudapi.com/?Action=DescribeTopSpaceTables
&InstanceId=cdb-test
&Limit=2
&SortBy=TableRows
&<common request parameters>
Output Example
{
"Response": {
"RequestId": "ed279d8b-a9d9-48d6-9429-e0fde000994a",
"Timestamp": 1603819881,
"TopSpaceTables": [
{
"DataFree": 0,
"TableName": "test",
"TotalLength": 0.1,
"TableSchema": "test_bak",
"FragRatio": 0,
"DataLength": 0.1,
"PhysicalFileSize": 0.1,
"TableRows": 9,
"Engine": "InnoDB",
"IndexLength": 0
},
{
"DataFree": 0,
"TableName": "test",
"TotalLength": 0.1,
"TableSchema": "test_bak",
"FragRatio": 0,
"DataLength": 0.1,
"PhysicalFileSize": 0.1,
"TableRows": 9,
"Engine": "InnoDB",
"IndexLength": 0
}
]
}
}
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 |
|---|---|
| FailedOperation | Operation failed. |
| 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