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.