Skip to content
deploy-and.run

deploy-and.run

Who merges so late, past midnight's chime, still pushing bugs to master's line?

  • WordPress & Performance
  • Server & Infrastructure
  • DevOps & Automation
  • Tooling & AI
  • Notes

mysql

Automating Index-Existence Guards So a Deploy Can’t Race Its Own Migration

August 29, 2026July 24, 2026 by halimat

The runtime existence check that kept one index rewrite safe to deploy in either order was a one-off. Here’s the same pattern turned into a reusable pre-deploy CI gate for a whole network.

Categories DevOps & Automation Tags automation, ci-cd, devops, mysql, wordpress

Turning a Multi-Step Dependency Bump Into an Autonomous Agent Loop

August 29, 2026July 22, 2026 by halimat

A shared plugin version bump, a branch-validation step, a version-skew incident, five index migrations across a network, and a documented PR — run as one supervised agent loop instead of six separate manual steps.

Categories DevOps & Automation Tags automation, devops, mysql, wordpress

Sizing a Covering Index on Shared Multisite MySQL

August 29, 2026July 21, 2026 by halimat

An index that fixes one site’s slow query has a write cost paid by every site sharing that database tier. A checklist for deciding whether a covering index actually pays for itself, before adding it.

Categories Server & Infrastructure Tags devops, infrastructure, mysql, performance, wordpress

Shipping a Database Index Without an Outage on WordPress VIP

August 29, 2026July 19, 2026 by halimat

A shared plugin update needed five new indexes across a multisite network. The bug that almost shipped wasn’t in the indexes — it was in assuming a diff between two versions was the same thing as the full version.

Categories DevOps & Automation Tags devops, mysql, performance, wordpress

Turning a Debugging Script Into a WP-CLI Profiler

August 29, 2026July 17, 2026 by halimat

The SAVEQUERIES mu-plugin from the last post left you with a raw log file and a promise to wrap WP-CLI commands around it. Here’s the tool, not just the promise.

Categories WordPress & Performance Tags devops, mysql, performance, wordpress

Two More Sitemap Bugs, and How to Fix a Plugin’s Internals Without Forking It

August 29, 2026July 12, 2026 by halimat

An N+1 query pattern and a pagination batch-size mismatch, both inside a popular SEO plugin’s sitemap code — fixed by swapping internal objects at runtime, not by maintaining a fork.

Categories WordPress & Performance Tags devops, mysql, performance, seo, wordpress

MySQL Ignored Two Good Indexes: A WordPress Sitemap Performance Deep Dive

August 29, 2026July 11, 2026 by halimat

A hardcoded USE INDEX hint deep inside Yoast SEO core was sorting tens of thousands of rows the slow way. Here’s how to find a bug like that, fix it without forking the plugin, and ship the fix safely.

Categories WordPress & Performance Tags devops, mysql, performance, seo, wordpress

Why Your Slow-Query Log Is Lying to You (a Little)

August 29, 2026July 10, 2026 by halimat

Production slow-query logs only show what happened to run during their capture window. Here’s how to find what they miss — and a measurement mistake that almost shipped a bad fix.

Categories WordPress & Performance Tags devops, mysql, performance, wordpress

Recent Posts

  • Terraform Applied Cleanly and Measured Nothing
  • k6 Only Reports LCP for the Last Page You Close
  • Ten Browser Checks, Sixty-One URLs, and One Terraform Loop
  • We Designed a Monitoring Stack, Then Decided Not to Build It
  • The File Watcher That Looked Like a Permissions Problem

About deploy-and.run

© 2026 deploy-and.run • Built with GeneratePress