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

July 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

July 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

July 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

July 19, 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

July 18, 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

July 18, 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

July 18, 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)

July 18, 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

  • The WordPress Performance Profiling Toolkit We Actually Use
  • What ‘VIP-Style Multisite’ Actually Means for a Performance Bug
  • Automating Index-Existence Guards So a Deploy Can’t Race Its Own Migration
  • The 465-Line Diff That Was Actually a 10-Line Fix
  • Turning a Multi-Step Dependency Bump Into an Autonomous Agent Loop

About deploy-and.run

© 2026 deploy-and.run • Built with GeneratePress