Amazon RDS MySQL Services

# Describe RDS MySQL instance status, Multi-AZ topology, and storage allocation
aws rds describe-db-instances \
  --db-instance-identifier prod-mysql-rds-primary \
  --query "DBInstances[0].{Status:DBInstanceStatus,EngineVersion:EngineVersion,MultiAZ:MultiAZ,AllocatedStorage:AllocatedStorage,StorageType:StorageType,IOPS:Iops}" \
  --output table

# Verify RDS CloudWatch replica lag metrics over the past hour
aws cloudwatch get-metric-data \
  --metric-data-queries '[{"Id":"m1","MetricStat":{"Metric":{"Namespace":"AWS/RDS","MetricName":"ReplicaLag","Dimensions":[{"Name":"DBInstanceIdentifier","Value":"prod-mysql-rds-replica"}]},"Period":60,"Stat":"Maximum"}}]' \
  --start-time $(date -u -v-1H +%Y-%m-%dT%H:%M:%SZ) \
  --end-time $(date -u +%Y-%m-%dT%H:%M:%SZ)

-- Safe read-only inspection of active threads, query duration, and state
SHOW FULL PROCESSLIST;

-- Query performance schema for active metadata locks and thread waits
SELECT
  sys.format_time(processlist_time) AS duration,
  processlist_user AS user,
  processlist_host AS host,
  processlist_db AS db,
  processlist_state AS state,
  SUBSTRING(processlist_info, 1, 80) AS query_preview
FROM sys.processlist
WHERE processlist_command != 'Sleep'
ORDER BY processlist_time DESC
LIMIT 10;