WordPress Database Archives

A WordPress Site Health notice reading Outdated SQL server beside a timeline showing MariaDB 10.6 reaching end of life in July 2026 and MySQL 8.0 in April 2026

Outdated SQL Server in Site Health After WordPress 7.1

WordPress 7.1 raised its MariaDB recommendation from 10.6 to 10.11, so Site Health now flags servers that reached end of life in July. MySQL 8.0 is end of life too, but still passes. How to check what you run and upgrade safely.

Varun Dubey · September 17, 2026 · 3 min read

WordPress database connection constants: DB_CHARSET, DB_COLLATE, MYSQL_CLIENT_FLAGS, and WP_ALLOW_REPAIR shown with a WP-CLI TLS verification terminal

Database Optimization

WordPress Database Connection: SSL, Charset, Collation, and Repair Constants

Master the wp-config.php database block: DB_CHARSET, DB_COLLATE, WP_ALLOW_REPAIR, MYSQL_CLIENT_FLAGS, a custom db.php drop-in for TLS pinning, and WP-CLI checks to verify encoding and SSL on every connection.

Varun Dubey · April 18, 2026 · 3 min read

Performance

How to Find and Fix Slow Database Queries in WordPress

Slow database queries hide inside plugin loops and poorly-written WP_Query calls. This guide covers SAVEQUERIES, Query Monitor, fixing N+1 loops, update_post_meta_cache, MySQL EXPLAIN, adding wp_postmeta indexes, and transient caching.

Varun Dubey · February 27, 2026 · 3 min read

How To

WP-CLI Search-Replace: The Complete Guide With Real Examples

Master wp-cli search-replace with real examples for domain migration, HTTP to HTTPS, staging to production, and fixing broken URLs. Includes a complete cheat sheet with every flag and option.

Shashank Dubey · February 12, 2026 · 3 min read

Tag: WordPress Database

Outdated SQL Server in Site Health After WordPress 7.1

WordPress Database Connection: SSL, Charset, Collation, and Repair Constants

How to Find and Fix Slow Database Queries in WordPress

WP-CLI Search-Replace: The Complete Guide With Real Examples