Skip to main content

Database Performance Optimization

This tutorial is a read-first performance review for commerce and high-traffic workloads.

Copy-paste prompt​

Run a mittwald database performance readiness review for my production project.

Tasks:
1) List MySQL and Redis instances.
2) Inspect configuration and capacity signals.
3) Flag likely bottlenecks and missing cache coverage.
4) Recommend prioritized actions for this week.

Read-only only. No writes.

What the agent will do automatically​

  • Gather current MySQL/Redis inventory and config.
  • Analyze capacity and cache readiness signals.
  • Prioritize likely risk areas.

What you (human) must still do​

  • Choose which recommendations to execute.
  • Schedule maintenance windows for changes.
  • Provide business-side performance thresholds.

Likely questions the agent will ask and good answers​

  • Which project/database is critical? -> Production project <project-id>.
  • What is acceptable latency? -> Keep checkout DB queries under 200ms p95.
  • Can I apply changes now? -> No, recommendations only.

Verification prompt​

Re-run the same readiness checks and confirm no data gaps in the audit.
Return the list of inspected database IDs and the top 3 risks.

Rollback/cleanup prompt​

No rollback needed for read-only audit. If any write action happened accidentally, list affected resource IDs and propose reversal steps.

Resume after failure​

Resume the readiness audit from the first database that does not yet have findings.