aws rds mysql查询缓存_AWS RDS如何用CLI命令获取和下载实例上的慢查询日志

首先需要找到AWS Access Key ID and Secret Access Key，具体方法可以参考下文：

http://blog.iyunker.com/%E6%95%99%E4%BD%A0%E5%A6%82%E4%BD%95%E6%89%BE%E5%88%B0aws-access-key-id-and-secret-access-key/

找到后写入~/.aws目录的credentials文件里，内容举例如下:

[root@ip-10-0-2-20 .aws]# cat credentials

[default]

aws_access_key_id = AKIAPQBIEU44HMCCACKE

aws_secret_access_key = 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

获取MySQL慢查询日志文件的列表用如下命令:

[root@ip-10-0-2-20 logs]# aws --output text rds describe-db-log-files --db-instance-identifier msj3

DESCRIBEDBLOGFILES      1505877300000   error/mysql-error.log   0

DESCRIBEDBLOGFILES      1487040936000   mysqlUpgrade    3297

DESCRIBEDBLOGFILES      1505877300000   slowquery/mysql-slowquery.log   549

DESCRIBEDBLOGFILES      1505865300000   slowquery/mysql-slowquery.log.0 2196

DESCRIBEDBLOGFILES      1505869