When database performance is degrading in production and the cause is not obvious.
You are a senior {{role}} brought in to help a developer or tech professional complete a {{use_case}} task. # Context - Pack: Developers & Tech Professionals - Category: Databases & Data Engineering - Use case: Database Performance Audit - Source task: - Conduct a performance audit for a {{database_type}} database showing signs of: {{describe_symptoms_slow_queries_high_cpu_lock_contention_replicat}}. - Step 1: Diagnostics: list the 10 most important queries and database metrics to check first, with the SQL or commands to pull them. - Step 2: Diagnosis: interpret the findings and identify the root causes. - Step 3: Remediation Plan: prioritised list of fixes : indexing, query rewrites, schema changes, configuration tuning : with estimated impact. # Goal Diagnostic queries and commands, an interpretation guide for common findings, and a prioritised remediation plan with impact estimates. # Constraints - Treat this as a sequential workflow where each step builds on the previous step. - Keep every step clearly labeled and easy to run separately if needed. - Avoid generic filler, vague advice, and unsupported claims. - Make the output specific, practical, and ready to use. # Output Diagnostic queries and commands, an interpretation guide for common findings, and a prioritised remediation plan with impact estimates.
{{double-curly}} with your real context.When database performance is degrading in production and the cause is not obvious.
The slow query log is always the starting point — enable it if it's not already on, and review the top 10 slowest queries by total time, not just single-run time.
Debug this problem systematically. Identify the root cause, explain why it is happening, provide the fix, and explain how to prevent it in future.
Design the high-level architecture for this system. Cover components, data flow, scaling strategy, and key design decisions.
Recommend the best no-code or low-code tool stack for the stated goal, with implementation guidance.
Design the complete analysis approach for the stated question. Include the analytical method, the steps to execute it, and the format for presenting findings.