6 articles
Every article tagged MySQL, newest first. Search all articles
Performance8 min read
Measure WordPress autoloaded options, find the largest wp_options rows and their owners, then change autoload safely with WordPress APIs and WP-CLI.
Performance7 min read
Reduce WordPress TTFB by separating CDN, network, PHP-FPM, database, cache, and WordPress delays with repeatable diagnostic tests.
Performance8 min read
Find WordPress slow database queries, read EXPLAIN plans, fix common query patterns, add safer indexes, and cache expensive results correctly.
Performance7 min read
Migrate WooCommerce HPOS safely, check plugin compatibility, sync and verify orders, switch storage, test workflows, and roll back.
Development5 min read
Run WordPress plugin database migrations safely with dbDelta, schema versions, one-time upgrades, batched data changes, multisite checks and rollback plans.
Development8 min read
Compare a WordPress custom table vs custom post type so you can choose plugin storage by query patterns, scale, editing needs, indexes, and upkeep.