6 articles
Every article tagged MySQL, newest first. Search all articles
Development8 min read
WordPress custom tables vs custom post types for plugin data
For a WordPress custom table vs custom post type decision, use a custom post type when your data behaves like editable WordPress content. Use a custom table when the data is high-volume, query-heavy, or needs typed columns and indexes that match your plugin's access patterns.
Performance7 min read
WooCommerce HPOS: migrate to High-Performance Order Storage safely
WooCommerce HPOS moves core order data out of WordPress post storage into dedicated WooCommerce tables. Migrate safely by checking extension compatibility, synchronizing both data stores, verifying them, switching HPOS to authoritative, then testing every order workflow before you disable synchronization.
Development5 min read
WordPress plugin database migrations with dbDelta, done safely
WordPress plugin database migrations should compare a stored schema version with the version your plugin expects, then run only the missing steps. Use dbDelta() for table creation and supported schema changes, and use explicit, guarded migrations for destructive or unsupported changes.
Performance8 min read
How to find and fix slow WordPress database queries
WordPress slow database queries are usually found by measuring the actual SQL, its execution time, and how often it runs before changing indexes or code.
Performance7 min read
How to reduce WordPress TTFB: a diagnostic guide
To reduce WordPress TTFB, measure the same request at each layer instead of tuning WordPress blindly. Separate DNS, connection and TLS time from time to first byte, compare CDN hits with origin requests, then profile PHP, database work and external calls on the slow path.
Performance8 min read
WordPress autoloaded options: measure and review wp_options
WordPress autoloaded options are rows in wp_options that WordPress loads into the alloptions array during a normal request. Measure the core autoload set, identify the largest rows and their owners, then disable autoload only for options that are not needed broadly.