Aurora MySQLの性能調査・移行・監査ログ運用ナレッジ
スロークエリ調査、DMSエラー、文字セット移行、binlog保持期間、監査ログなど、Aurora MySQLの運用で判断が必要になる項目を整理しています。
- Aurora MySQL高How 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.最終検証日 2026-08-13
- Aurora MySQL中Why 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.最終検証日 2026-08-13
- Aurora MySQL高What 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.最終検証日 2026-08-13
- Aurora MySQL高How 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.最終検証日 2026-08-13
- Aurora MySQL高How 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.最終検証日 2026-08-13