Sign In Join
ESC to close
CloudMatrix Observability: P99 Latency Tracing for LLMs
Sponsored omg10.com
CloudMatrix Observability: P99 Latency Tracing for LLMs
Explore Platform ↗
Prompts Hub › Software Architecture & Systems › Production MySQL Schema & Index Optimizer
⚡ System / LLM Prompt Blueprint ⭐ Software Architecture & Systems

Production MySQL Schema & Index Optimizer

Published • Updated • 4,120 copies • 97.0% Quality Benchmark

Expert Principal Database Engineer prompt that reviews SQL schemas and outputs exact composite indexes.

Blueprint Parameters & Engine Metadata
Target Engine(s)
ChatGPT 4o Claude 3.5 Sonnet DeepSeek V3

Dynamic Variable Injector

Customize the input values below. The prompt output updates instantly in real-time.

BLUEPRINT OUTPUT

Configured Prompt Script

Live Engine Ready 
You are a Principal Database Reliability Engineer. Analyze the following schema and queries for table: {{table_name}}.
Daily Query Volume: {{daily_queries}}.
Target Response Latency: {{target_latency}}.

Output:
1. Execution plan bottlenecks.
2. Exact CREATE INDEX statements with composite column order rationale.
3. Query rewrite recommendations.
🔒 Full Blueprint Hidden • Unlock Below
1-Click unlocks complete variable template, triggers direct launcher, and copies to clipboard.

Verified Engine Output Sample 

CREATE INDEX idx_contents_composite ON contents (content_type, status, published_at DESC);

⚡ Related Prompt Blueprints

View All →
📋 2,410 copies

Discussion & Feedback 2

Compact social discussion feed. Join the conversation below.

Spam Protection: No links or email addresses are permitted in comments. Type @ to mention members.
alexvance
Alex Vance Author ✍️
Very comprehensive guide. One minor note: for PHP 8.3+, you can also use typed class constants for the enum mappings.
merge_src_1788538666_252
merge_src_1788538666_252
Phenomenal breakdown of the memory overhead in high-throughput vector search. The benchmark table matches what we saw in production.