MySQL Operations
Acknowledgement: Shared by Peter Bamuhigire, techguypeter.com, +256 784 464178.
Use this parent skill as the active MySQL operations entrypoint. Operational advice must be tied to observable evidence and a reversible execution path.
Use When
- Troubleshooting slow queries, lock waits, replication lag, connection exhaustion, deadlocks, or storage pressure.
- Designing backup, restore, HA, monitoring, capacity, and maintenance plans for MySQL.
- Reviewing production configuration, operational runbooks, and incident evidence.
Do Not Use When
- The task is unrelated to this parent skill or is better handled by a narrower active parent named in the workflow.
- The request only needs a trivial answer and no reference module needs to be loaded.
Required Inputs
- Gather the concrete system, repository, environment, constraints, and deliverable before loading references.
- Identify which absorbed reference file is needed; do not load every migrated reference by default.
Workflow
- Load
database-reliability for SLOs, recovery objectives, and incident handling.
- Load the task-specific reference:
references/mysql-administration.md for roles, backup, restore, replication, upgrades, and maintenance.references/mysql-query-performance.md for query tuning, indexes, EXPLAIN review, and capacity analysis.
- Pair with
mysql-engineering when schema or SQL changes are part of the work.
- Pair with
observability-monitoring for dashboards, alerts, and production telemetry.
Quality Standards
- State measurement source, rollback path, and verification command before production changes.
- Treat backup restore tests as required evidence, not documentation claims.
- Avoid global tuning changes when query, index, or workload fixes are the real issue.
Anti-Patterns
- Treating absorbed reference files as active skills or separate routing entrypoints.
- Loading every migrated child reference instead of the one that matches the task.
- Producing generic advice without constraints, evidence, or next verification steps.
Outputs
- MySQL runbook, tuning plan, incident review, backup/restore plan, or operational checklist.
References
- Load only the references/.md files named in the workflow when their depth is required.
Inputs
| Input |
Required |
Purpose |
| MySQL version, topology, and workload |
yes |
Bound operations |
| SLO, RPO, and RTO |
yes |
Set recovery policy |
| Metrics, logs, and backup inventory |
yes |
Ground diagnosis |
Capability contract
Diagnose read-only by default. Configuration changes, failover, restores, session termination, and replication repair require explicit production authority and rollback criteria.
Degraded mode
If telemetry or privileged access is unavailable, return safe inspection commands and ranked hypotheses; do not infer root cause or recovery readiness.
Decision rules
| Condition |
Action |
| Data loss is possible |
Preserve evidence and stop writes if authorised |
| Replica lag is growing |
Find workload cause before tuning buffers |
| Restore is untested |
Report RTO and RPO as unverified |
Domain Anti-Patterns
- Restarting before evidence capture. Fix: collect logs and status.
- Tuning global buffers by folklore. Fix: measure memory and workload.
- Repairing replication by skipping errors. Fix: reconcile data first.
- Keeping backups on the same host. Fix: isolate and test copies.
- Running unbounded maintenance on primary. Fix: throttle and monitor.
1---2name: mysql-operations3description: Use when administering, tuning, backing up, restoring, monitoring, or troubleshooting MySQL production systems. Load absorbed MySQL administration and query-performance reference files for operational runbooks, indexes, replication, and incident response.4---56# MySQL Operations7Acknowledgement: Shared by Peter Bamuhigire, techguypeter.com, +256 784 464178.89Use this parent skill as the active MySQL operations entrypoint. Operational advice must be tied to observable evidence and a reversible execution path.1011<!-- dual-compat-start -->12## Use When1314- Troubleshooting slow queries, lock waits, replication lag, connection exhaustion, deadlocks, or storage pressure.15- Designing backup, restore, HA, monitoring, capacity, and maintenance plans for MySQL.16- Reviewing production configuration, operational runbooks, and incident evidence.1718## Do Not Use When1920- The task is unrelated to this parent skill or is better handled by a narrower active parent named in the workflow.21- The request only needs a trivial answer and no reference module needs to be loaded.2223## Required Inputs2425- Gather the concrete system, repository, environment, constraints, and deliverable before loading references.26- Identify which absorbed reference file is needed; do not load every migrated reference by default.27## Workflow28291. Load `database-reliability` for SLOs, recovery objectives, and incident handling.302. Load the task-specific reference:31 - `references/mysql-administration.md` for roles, backup, restore, replication, upgrades, and maintenance.32 - `references/mysql-query-performance.md` for query tuning, indexes, EXPLAIN review, and capacity analysis.333. Pair with `mysql-engineering` when schema or SQL changes are part of the work.344. Pair with `observability-monitoring` for dashboards, alerts, and production telemetry.3536## Quality Standards3738- State measurement source, rollback path, and verification command before production changes.39- Treat backup restore tests as required evidence, not documentation claims.40- Avoid global tuning changes when query, index, or workload fixes are the real issue.4142## Anti-Patterns4344- Treating absorbed reference files as active skills or separate routing entrypoints.45- Loading every migrated child reference instead of the one that matches the task.46- Producing generic advice without constraints, evidence, or next verification steps.47## Outputs4849- MySQL runbook, tuning plan, incident review, backup/restore plan, or operational checklist.5051## References5253- Load only the references/<old-skill>.md files named in the workflow when their depth is required.54<!-- dual-compat-end -->5556## Inputs57| Input | Required | Purpose |58|---|---|---|59| MySQL version, topology, and workload | yes | Bound operations |60| SLO, RPO, and RTO | yes | Set recovery policy |61| Metrics, logs, and backup inventory | yes | Ground diagnosis |6263## Capability contract64Diagnose read-only by default. Configuration changes, failover, restores, session termination, and replication repair require explicit production authority and rollback criteria.6566## Degraded mode67If telemetry or privileged access is unavailable, return safe inspection commands and ranked hypotheses; do not infer root cause or recovery readiness.6869## Decision rules70| Condition | Action |71|---|---|72| Data loss is possible | Preserve evidence and stop writes if authorised |73| Replica lag is growing | Find workload cause before tuning buffers |74| Restore is untested | Report RTO and RPO as unverified |7576## Domain Anti-Patterns77- Restarting before evidence capture. Fix: collect logs and status.78- Tuning global buffers by folklore. Fix: measure memory and workload.79- Repairing replication by skipping errors. Fix: reconcile data first.80- Keeping backups on the same host. Fix: isolate and test copies.81- Running unbounded maintenance on primary. Fix: throttle and monitor.
peterbamuhigire