1308970 - Switch RDS slow query log_output from TABLE to FILE

Status: RESOLVED FIXED

(Tree Management :: Treeherder: Infrastructure, defect, P2)

Description

[Ed Morley [:emorley]]

On RDS, `log_output` (http://dev.mysql.com/doc/refman/5.6/en/server-system-variables.html#sysvar_log_output) defaults to TABLE:
http://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_LogAccess.Concepts.MySQL.html

RDS supports FILE (https://aws.amazon.com/blogs/aws/amazon-rds-access-to-database-log-files/), so we should switch to it, to reduce writes to the DB, and to also benefit from the slightly more aggressive rotation, to avoid perf degradation in the case of many slow queries having been logged.

Comment 1

[Ed Morley [:emorley]]

Attachment: devservices-aws PR #5: Switch log_output from TABLE to FILE

Comment 2

[Kendall Libby [:fubar] (he/him)]

commited and RDS finally applied it

Comment 3

[Ed Morley [:emorley]]

Many thanks :-)

I've run 2x `CALL mysql.rds_rotate_slow_log;` on each of {prototype, stage, prod} to purge the old table-based logs.