Aurora MySQL Performance Investigation, Migration, and Audit Log Knowledge
Covers the judgment calls Aurora MySQL operations require — slow query investigation, DMS errors, character set migration, binlog retention, and audit logging.
- Aurora MySQLHighHow to Investigate a Slow Query in Aurora MySQLA procedure for finding slow queries by starting with lower-risk checks, in the order: slow query log, PROCESSLIST, EXPLAIN, and digest aggregation. Also shows alternatives for environments where performance_schema is disabled.Last Verified 2026-08-13
- Aurora MySQLMediumWhy AWS DMS Reports Error 1032 and How to Investigate ItError 1032 in DMS CDC means the corresponding row doesn't exist on the target. This organizes how to read the control tables, how to check for primary key mismatches, and the available task-setting options.Last Verified 2026-08-13
- Aurora MySQLHighWhat to Check When Migrating from utf8mb3 to utf8mb4 in Aurora MySQLThe first thing that breaks when converting to utf8mb4 is index key length. This organizes the SQL for finding targets, how to choose a collation, the impact of conversion, and where the settings live.Last Verified 2026-08-13
- Aurora MySQLHighHow to Check and Configure binlog Retention in Aurora MySQLCheck binlog retention with `mysql.rds_show_configuration` and set it in hours via `mysql.rds_set_configuration`. `binlog_format` is a cluster parameter and changing it requires a restart.Last Verified 2026-08-13
- Aurora MySQLHighHow to Collect and Review Audit Logs in Aurora MySQLA procedure for enabling Aurora MySQL's Advanced Auditing via a cluster parameter and reviewing it through CloudWatch Logs or RDS log files. Also organizes how to narrow down what gets recorded.Last Verified 2026-08-13