database-slow-query-logging-optimization

---
name: database-slow-query-logging-optimization
description: Use this skill when capturing, analyzing, and tuning slow database queries using slow query logs and automated index recommendations.
---
# Database Slow Query Logging & Query Tuning

## When to use
Use this skill when you need to capturing, analyzing, and tuning slow database queries using slow query logs and automated index recommendations.

## Prerequisites
- Working knowledge of systems administration, site reliability engineering, or accessibility standards.
- Appropriate administrative tooling, terminal shell, or screen reader testing environment.

## Step-by-step workflow
1. **Analyze operational context**: Inspect host system telemetry, access controls, or UI accessibility trees.
2. **Formulate implementation plan**: Draft declarative configurations, automation scripts, or remediation markup.
3. **Apply changes**: Execute modifications following standard operating procedures and least-privilege principles.
4. **Audit and verify outcomes**: Run diagnostics, automated audits (axe, Lighthouse, sar), or command assertions.
5. **Establish ongoing telemetry**: Configure monitoring rules, periodic health checks, or CI regression gates.

## Commands / code examples
```bash
# Operational command and verification workflow for database-slow-query-logging-optimization
echo "Executing verification check for database-slow-query-logging-optimization"
```

## Common mistakes & pitfalls
- Disabling security controls or bypassing accessibility standards to achieve rapid fixes.
- Modifying production systems without automated verification checks or rollback scripts.
- Relying on manual testing instead of embedding automated assertions into CI/CD pipelines.

## Verification checklist
- [ ] Implementations satisfy security, accessibility, or observability standards.
- [ ] Automated checks pass with zero high-severity warnings or failures.
- [ ] Diagnostic logs and telemetry confirm expected operational state.
- [ ] Operational runbooks and documentation are updated.

## Related skills
- wcag-22-guidelines-conformance-levels
- linux-permissions-chmod-chown-acls
- distributed-tracing-opentelemetry-sdk
- site-reliability-engineering-slo-sla-error-budgets