AWS 控制台查看RDS日志不太方便，被分割成多个问题。可以使用AWS提供的cli工具查看。
获取日志文件列表
# aws rds describe-db-log-files --db-instance-identifier ttlsa
{
"DescribeDBLogFiles": [
{
"LastWritten": 1440694800000,
"LogFileName": "error/mysql-error-running.log",
"Size": 0
},
{
"LastWritten": 1440693300000,
"LogFileName": "error/mysql-error-running.log.17",
"Size": 7628
},
{
"LastWritten": 1440740400000,
"LogFileName": "error/mysql-error.log",
"Size": 0
},
{
"LastWritten": 1440740460000,
"LogFileName": "general/mysql-general.log",
"Size": 2150341
},
{
"LastWritten": 1440720000000,
"LogFileName": "general/mysql-general.log.0",
"Size": 662034
},
{
"LastWritten": 1440723600000,
"LogFileName": "general/mysql-general.log.1",
"Size": 1723949
},
{
"LastWritten": 1440669600000,
"LogFileName": "general/mysql-general.log.10",
"Size": 6962833
},
{
"LastWritten": 1440673200000,
"LogFileName": "general/mysql-general.log.11",
"Size": 4218187
},
{
"LastWritten": 1440676800000,
"LogFileName": "general/mysql-general.log.12",
"Size": 1459437
},
{
"LastWritten": 1440680400000,
"LogFileName": "general/mysql-general.log.13",
"Size": 876901
},
{
"LastWritten": 1440684000000,
"LogFileName": "general/mysql-general.log.14",
"Size": 1716975
},
{
"LastWritten": 1440687600000,
"LogFileName": "general/mysql-general.log.15",
"Size": 2601324
},
{
"LastWritten": 1440691200000,
"LogFileName": "general/mysql-general.log.16",
"Size": 1401848
},
{
"LastWritten": 1440695100000,
"LogFileName": "general/mysql-general.log.17",
"Size": 1574018
},
{
"LastWritten": 1440698400000,
"LogFileName": "general/mysql-general.log.18",
"Size": 1346794
},
{
"LastWritten": 1440702000000,
"LogFileName": "general/mysql-general.log.19",
"Size": 1185733
},
{
"LastWritten": 1440727200000,
"LogFileName": "general/mysql-general.log.2",
"Size": 4163009
},
{
"LastWritten": 1440705600000,
"LogFileName": "general/mysql-general.log.20",
"Size": 1214236
},
{
"LastWritten": 1440709200000,
"LogFileName": "general/mysql-general.log.21",
"Size": 1068742
},
{
"LastWritten": 1440712800000,
"LogFileName": "general/mysql-general.log.22",
"Size": 1069574
},
{
"LastWritten": 1440716400000,
"LogFileName": "general/mysql-general.log.23",
"Size": 770949
},
{
"LastWritten": 1440730800000,
"LogFileName": "general/mysql-general.log.3",
"Size": 3245277
},
{
"LastWritten": 1440734400000,
"LogFileName": "general/mysql-general.log.4",
"Size": 4365122
},
{
"LastWritten": 1440738000000,
"LogFileName": "general/mysql-general.log.5",
"Size": 2981149
},
{
"LastWritten": 1440655200000,
"LogFileName": "general/mysql-general.log.6",
"Size": 3888023
},
{
"LastWritten": 1440658800000,
"LogFileName": "general/mysql-general.log.7",
"Size": 5970874
},
{
"LastWritten": 1440662400000,
"LogFileName": "general/mysql-general.log.8",
"Size": 7837699
},
{
"LastWritten": 1440666000000,
"LogFileName": "general/mysql-general.log.9",
"Size": 5372529
},
{
"LastWritten": 1440740460000,
"LogFileName": "slowquery/mysql-slowquery.log",
"Size": 667050
},
{
"LastWritten": 1440720300000,
"LogFileName": "slowquery/mysql-slowquery.log.0",
"Size": 415376
},
{
"LastWritten": 1440723600000,
"LogFileName": "slowquery/mysql-slowquery.log.1",
"Size": 668938
},
{
"LastWritten": 1440669600000,
"LogFileName": "slowquery/mysql-slowquery.log.10",
"Size": 2190953
},
{
"LastWritten": 1440673485000,
"LogFileName": "slowquery/mysql-slowquery.log.11",
"Size": 1313067
},
{
"LastWritten": 1440677084000,
"LogFileName": "slowquery/mysql-slowquery.log.12",
"Size": 486011
},
{
"LastWritten": 1440680700000,
"LogFileName": "slowquery/mysql-slowquery.log.13",
"Size": 273164
},
{
"LastWritten": 1440684000000,
"LogFileName": "slowquery/mysql-slowquery.log.14",
"Size": 568671
},
{
"LastWritten": 1440687900000,
"LogFileName": "slowquery/mysql-slowquery.log.15",
"Size": 872806
},
{
"LastWritten": 1440691500000,
"LogFileName": "slowquery/mysql-slowquery.log.16",
"Size": 446842
},
{
"LastWritten": 1440695100000,
"LogFileName": "slowquery/mysql-slowquery.log.17",
"Size": 581487
},
{
"LastWritten": 1440698700000,
"LogFileName": "slowquery/mysql-slowquery.log.18",
"Size": 589400
},
{
"LastWritten": 1440702300000,
"LogFileName": "slowquery/mysql-slowquery.log.19",
"Size": 539588
},
{
"LastWritten": 1440727500000,
"LogFileName": "slowquery/mysql-slowquery.log.2",
"Size": 1595618
},
{
"LastWritten": 1440705900000,
"LogFileName": "slowquery/mysql-slowquery.log.20",
"Size": 540075
},
{
"LastWritten": 1440709500000,
"LogFileName": "slowquery/mysql-slowquery.log.21",
"Size": 468390
},
{
"LastWritten": 1440713100000,
"LogFileName": "slowquery/mysql-slowquery.log.22",
"Size": 482289
},
{
"LastWritten": 1440716700000,
"LogFileName": "slowquery/mysql-slowquery.log.23",
"Size": 367358
},
{
"LastWritten": 1440730800000,
"LogFileName": "slowquery/mysql-slowquery.log.3",
"Size": 990419
},
{
"LastWritten": 1440734700000,
"LogFileName": "slowquery/mysql-slowquery.log.4",
"Size": 1392197
},
{
"LastWritten": 1440738300000,
"LogFileName": "slowquery/mysql-slowquery.log.5",
"Size": 984206
},
{
"LastWritten": 1440655500000,
"LogFileName": "slowquery/mysql-slowquery.log.6",
"Size": 1160637
},
{
"LastWritten": 1440659100000,
"LogFileName": "slowquery/mysql-slowquery.log.7",
"Size": 2085701
},
{
"LastWritten": 1440662700000,
"LogFileName": "slowquery/mysql-slowquery.log.8",
"Size": 1322150
},
{
"LastWritten": 1440666300000,
"LogFileName": "slowquery/mysql-slowquery.log.9",
"Size": 1723704
}
]
}
命令说明http://docs.aws.amazon.com/cli/latest/reference/rds/describe-db-log-files.html文章源自运维生存时间-https://www.ttlsa.com/mysql/using-aws-cli-scan-rds-log-file/
获取日志文件
# aws rds download-db-log-file-portion --db-instance-identifier ttlsa --output text --log-file-name general/mysql-general.log
RDS慢查询日志和general日志，只保留24小时，每小时轮滚。文章源自运维生存时间-https://www.ttlsa.com/mysql/using-aws-cli-scan-rds-log-file/ 文章源自运维生存时间-https://www.ttlsa.com/mysql/using-aws-cli-scan-rds-log-file/
我的微信
微信公众号
扫一扫关注运维生存时间公众号，获取最新技术文章~
评论