日志管理
更新时间:2024-10-14
日志管理
查询慢日志明细
使用以下代码查询慢日志明细。
Java
1public void getSlowLog(RdsClient rdsClient){
2RdsSlowLogRequest request = new RdsSlowLogRequest();
3 //实例ID,可选
4 request.setInstanceId("rds-N5CfquAn");
5 //开始时间,可选
6 request.setStartTime(DATE_FORMAT.parse("2024-07-01T00:00:00Z"));
7 //结束时间,可选
8 request.setEndTime(DATE_FORMAT.parse("2024-07-12T00:00:00Z"));
9 //开始页数,可选
10 request.setPageNo(0);
11 //每页行数 ,默认为10,可选
12 request.setPageSize(10);
13 List<String> dbs = new ArrayList<>();
14 //默认为:数据库名称,可选
15 dbs.add("db_123");
16 request.setDbName(dbs);
17 List<String> ips = new ArrayList<>();
18 //主机名,可选
19 ips.add("localhost");
20 request.setHostIp(ips);
21 List<String> names = new ArrayList<>();
22 //用户名,可选
23 names.add("testName");
24 request.setUserName(names);
25 //sql语句,可选
26 request.setSql("sleep(1)");
27 RdsSlowLogResponse slowLogResponse = rdsClient.getSlowLog(request);
28 print("getSlowLog", slowLogResponse);
29 }
查询慢日志列表
使用以下代码可以查询指定实例的慢日志列表。
Java
1public void getSlowLogDownloadTaskList(RdsClient rdsClient) {
2 RdsSlowLogDownloadTasksRequest request = new RdsSlowLogDownloadTasksRequest();
3 //实例ID,必选
4 request.setInstanceId("rds-N5CfquAn");
5 //慢日志时间,必选
6 request.setDatetime("2024-07-11T19:48:05Z");
7 RdsSlowLogDownloadTasksResponse response = rdsClient.getSlowLogDownloadTaskList(request);
8 print("getSlowLogDownloadTaskList", response);
9 }
查询慢日志下载详情
使用以下代码可以查询慢日志下载详情。
Java
1public void getSlowLogDownloadDetail(RdsClient rdsClient) {
2 RdsSlowLogDownloadDetailRequest request = new RdsSlowLogDownloadDetailRequest();
3 //实例ID,必选
4 request.setInstanceId("rds-jHqrZCEk");
5 //慢日志ID,必选
6 request.setLogId("slowlog.202307310005");
7 //下载有效时间(单位:秒),必选
8 request.setDownloadValidTimeInSec(1800);
9 RdsSlowLogDownloadDetailResponse detailResponse = rdsClient.getSlowLogDownloadDetail(request);
10 print("getSlowLogDownloadDetail", detailResponse);
11 }
获取错误日志详情
使用以下代码可以获取错误日志详情
Java
1public void getSlowLogGetErrorLogDetails(RdsClient rdsClient) {
2 RdsSlowLogGetErrorLogDetailsRequest request = new RdsSlowLogGetErrorLogDetailsRequest();
3 //实例ID,可选
4 request.setInstanceId("rds-b3VFCjMA");
5 //开始时间,可选
6 request.setStartTime("2024-07-10T16:00:00Z");
7 //结束时间,可选
8 request.setEndTime("2024-07-10T16:00:05Z");
9 //开始页数 1,可选
10 request.setPageNo("1");
11 //每页行数 ,默认为10,可选
12 request.setPageSize("10");
13 //搜索关键词,可选
14 request.setKeyWord("Logging");
15 RdsSlowLogGetErrorLogDetailsResponse response = rdsClient.getSlowLogGetErrorLogDetails(request);
16 print("getSlowLogGetErrorLogDetails", response);
17 }
错误日志下载详情
使用以下代码可以获取错误日志下载详情
Java
1public void getSlowLogErrorLogDownloadDetails(RdsClient rdsClient) {
2 RdsSlowLogErrorLogDownloadDetailsRequest request = new RdsSlowLogErrorLogDownloadDetailsRequest();
3 //实例ID,必选
4 request.setInstanceId("rds-1AfwpHXs");
5 //错误日志ID,必选
6 request.setLogId("slowlog.202307310005");
7 //下载有效时间(单位:秒),必选
8 request.setDownloadValidTimeInSec(1090);
9 RdsSlowLogErrorLogDownloadDetailsResponse response = rdsClient.getSlowLogErrorLogDownloadDetails(request);
10 print("getSlowLogErrorLogDownloadDetails", response);
11 }
错误日志列表
使用以下代码可以获取错误日志列表
Java
1public void slowLogGetErrorLogList(RdsClient rdsClient) {
2 RdsSlowLogGetErrorLogListRequest request = new RdsSlowLogGetErrorLogListRequest();
3 //实例ID,必选
4 request.setInstanceId("rds-jHqrZCEk");
5 //UTC 日期时间(比如要查询 2023-07-28 的日志,则该参数取值 2023-07-28 16:43:39),必选
6 request.setDatetime("2024-07-11 00:00:00");
7 RdsSlowLogGetErrorLogListResponse response = rdsClient.slowLogGetErrorLogList(request);
8 print("slowLogGetErrorLogList", response);
9 }
获取pg日志详情
使用以下代码可以获取pg日志详情
Java
1public void getPGLogDetails(RdsClient rdsClient) {
2 RdsGetPGLogDetailsRequest request = new RdsGetPGLogDetailsRequest();
3 //实例ID,必选
4 request.setInstanceId("rds-jHqrZCEk");
5 //pg 日志ID,必选
6 request.setPglogId("postgresql-2024-07-11_000000.log");
7 //下载链接有效期,单位是秒。默认值3600
8 request.setDownloadValidTimeInSec(3600);
9 RdsGetPGLogDetailsResponse response = rdsClient.getPGLogDetails(request);
10 print("getPGLogDetails", response);
11 }
获取pg日志列表
使用以下代码可以获取pg日志列表
Java
1public void getPGList(RdsClient rdsClient) {
2 RdsGetPGListRequest request = new RdsGetPGListRequest();
3 //实例ID,必选
4 request.setInstanceId("rds-jHqrZCEk");
5 //日期,格式如:2023-06-14,必选
6 request.setDate("2023-06-14");
7 RdsGetPGListResponse response = rdsClient.getPGList(request);
8 print("getPGList", response);
9 }