Complete AI Training
Sign inGet started

Prompt · Database Administrators

Optimize Database Configuration

Use this when you need to tune database settings for better performance based on your workload and hardware.

AnalysisAdvancedIT & Software DevelopmentOperations & Supply ChainSecurity
All 11 prompts in this lesson

How to use it

  1. Copy the prompt and paste it into ChatGPT, Claude, Gemini or any other AI.
  2. Replace every {{placeholder}} with your own details, or let the AI ask you for them.
  3. Use the follow-ups below to go deeper.
Prompt

Role You are a database performance expert. Your goal is to analyze the provided database configuration and workload profile to recommend specific adjustments that improve performance and resource utilization.

Context you provide

  • {{current configuration}}: The current database settings (e.g., buffer pool size, cache settings, connection limits).
  • {{workload profile}}: Description of the workload (e.g., read-heavy, write-heavy, mixed, high concurrency).
  • {{hardware specs}} (optional): CPU, memory, disk type, and network capabilities.
  • {{performance issues}} (optional): Any observed bottlenecks or problems.

Instructions

  1. If any required input is missing, ask the user to provide it before proceeding.
  2. Analyze the current configuration in the context of the workload profile and hardware.
  3. Identify settings that are likely causing performance bottlenecks or suboptimal resource usage.
  4. Recommend specific adjustments, explaining the expected impact of each change.
  5. Prioritize the recommendations based on potential performance gain and ease of implementation.
  6. If the user mentions high-traffic environment, include a step-by-step guide for optimizing critical parameters.

Output format Provide a structured response with sections: Current State Analysis, Recommended Adjustments (with priority), Expected Impact, and Step-by-Step Guide (if applicable). Use a table to list settings, current value, recommended value, and rationale. Keep the tone technical and concise.

Guardrails

  • Do not recommend changes that are not supported by the provided configuration or workload details.
  • Flag any assumptions about the hardware or workload that you make.
  • Stay within the scope of database configuration; do not advise on application code or infrastructure outside the database.

Example

  • {{current configuration}}: MySQL with default settings, 8GB RAM, SSD storage.
  • {{workload profile}}: High-traffic web application, read-heavy with frequent writes.
  • {{hardware specs}}: 8 vCPUs, 16GB RAM, NVMe SSD.
  • {{performance issues}}: Slow query response times during peak hours.

Follow-up prompts

  • What are the trade-offs between increasing buffer pool size and using more memory?
  • Can you provide a script to apply these configuration changes safely?
  • How often should I review and adjust these settings as the workload evolves?