DBbrain 提供了慢日志top sql 的模板查询功能,并且可以用api 调用接口获得top 慢日志。
但是文档没有提供示例,也没有接入explorer 工具中,该怎么调试接口呢?
本文以python 为例提供一个参考示例,其他代码可以自行实现。
接口文档:按照Sql模板查询指定时间段内的慢日志统计结果:https://cloud.tencent.com/document/api/1130/39556
代码示例:
from tencentcloud.common import credential
from tencentcloud.common.profile.client_profile import ClientProfile
from tencentcloud.common.profile.http_profile import HttpProfile
from tencentcloud.common.exception.tencent_cloud_sdk_exception import TencentCloudSDKException
from tencentcloud.common.abstract_client import AbstractClient
from tencentcloud.dbbrain.v20191016 import dbbrain_client, models
from tencentcloud.dbbrain.v20191016.dbbrain_client import DbbrainClient
try:
cred = credential.Credential("xx", "xx")
httpProfile = HttpProfile()
httpProfile.endpoint = "dbbrain.tencentcloudapi.com"
clientProfile = ClientProfile()
clientProfile.httpProfile = httpProfile
client = DbbrainClient(cred, "ap-xx", clientProfile)
req = models.DescribeSlowLogTopSqlsRequest()
params = '{"InstanceId":"cdb-","StartTime":"2020-03-06 00:00:00","EndTime":"2020-03-06 23:59:59","Offset":0,"Limit":7}'
req.from_json_string(params)
resp = client.DescribeSlowLogTopSqls(req)
print(resp.to_json_string())
except TencentCloudSDKException as err:
print(err)
原创声明:本文系作者授权腾讯云开发者社区发表,未经许可,不得转载。
如有侵权,请联系 cloudcommunity@tencent.com 删除。
原创声明:本文系作者授权腾讯云开发者社区发表,未经许可,不得转载。
如有侵权,请联系 cloudcommunity@tencent.com 删除。