日志管理
更新时间: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    }