How to Find Slow WordPress Queries: Query Monitor and Slow Query Logs
Query helps you find WordPress with Query Monitor, MySQL logs and execution plan, and modify the actual caller without profiling the production.
BIPIDA / IDEAS INTO PRACTICE
Bipida blog
Read deeper. Diagnose better. Build with confidence.
Technical analysis and practical experience for your next challenge.
WORDPRESS
LINUX / DEVOPSLooking for a term or account guide?Visit the knowledge base
LINUX / DEVOPSLooking for a term or account guide?Visit the knowledge base
Search and filter articles
WordPress performance
13 articles · Tag: MySQLShowing 1–12
Why Does the wp_options Table Grow, and How Does It Affect Performance?
The reason for the growth of the wp_options table is to check the size of the autoload and transient data and to modify WordPress slow without removing the necessary…
How to Optimize a Large WordPress Database Safely
Find the actual size of WordPress tables, clearable data, and slow queries, and optimize the database without removing the necessary order or settings.
Object Cache vs. Page Cache: What Is the Difference?
What layer does Page Cache and Object Cache work on, what is the difference between public and dynamic pages, and when is Redis or full page cache needed?
When Is Redis Useful for WooCommerce, and When Can It Cause Problems?
Examine the use of Redis in checkout, user account and WooCommerce catalog, focusing on invalidation of inventory, session, RAM and actual measurement.
What Is Redis for WordPress and When Does It Improve Performance?
How does Redis Object Cache reduce WordPress's repetitive queries, when is it not useful, and how is it evaluated by hit rate, memory, and cache accuracy?
Why Is the Website Fast but wp-admin Slow?
If the public site is fast but wp-admin is slow, check the targeted bypass caches, AJAX, REST, cron, management queries and PHP workers.
How to Reduce WordPress TTFB: From the Network to PHP and MySQL
Divide the TTFB of top WordPress between DNS, TLS, CDN, cache, PHP-FPM, database and external API and reduce it with valid measurements.
How to Find Which WordPress Plugin Is Slowing Down Your Site
Find the WordPress slower with baseline, Query Monitor, log, HTTP call and controlled testing in staging; without breaking the live site.
Why Does WordPress Use So Much RAM? From Linux Cache to PHP-FPM and MySQL
Divide the RAM usage of WordPress between Linux, PHP-FPM, MySQL, Redis, and job caches and measure the capacity and cause of memory growth before OOM.
Why Does WordPress Use So Much CPU?
Divide the high CPU usage of WordPress between traffic, bot, PHP, wp-cron, plugin, and MySQL, and find the real factor before you know it.
Why Is the WordPress Dashboard Slow? Diagnosing wp-admin Performance
Identify the widget of a wp-admin from AJAX, plugins, wp-cron, databases, external API and PHP workers, even when public pages are fast.