Index WP MySQL For Speed vs W3 Total Cache

How do I use this plugin? After you install and activate this plugin, visit the Index MySQL Tool under the Tools menu. From there you can press the Add Keys Now button. If you have large tables, use it with WP-CLI instead to avoid timeouts. See the WP-CLI section to learn more. What does it do for my site? This plugin works to make your MySQL database work more efficiently by adding high-performance keys to the tables you choose. On request it monitors your site’s use of your MySQL database to detect which database operations are slowest. It is most useful for large sites: sites with many users, posts, pages, and / or products. You can use it to restore WordPress’s default keys if need be. What is this all about? Where does WordPress store all that stuff that makes your site great? Where are your pages, posts, products, media, users, custom fields, metadata, and all your valuable content? All that data is in the MySQL relational database management system. (Many hosting providers and servers use the MariaDB fork of the MySQL software; it works exactly the same way as MySQL itself.) As your site grows, your MySQL tables grow. Giant tables can make your page loads slow down, frustrate your users, and even hurt your search-engine rankings. And, bulk imports can take absurd amounts of time. What can you do about this? You can install and use a database cleaner plugin to get rid of old unwanted data and reorganize your tables. That makes them smaller, and therefore faster. That is a good and necessary task. That is not the task of this plugin. You can, if your hosting provider supports it, install and use a Persistent Object Cache plugin to reduce traffic to your database. That is not the task of this plugin either. This plugin adds database keys (also called indexes) to your MySQL tables to make it easier for WordPress to find the information it needs. All relational database management systems store your information in long-lived tables. For example, WordPress stores your posts and other content in a table called wp_posts, and custom post fields in another table called wp_postmeta. A successful site can have thousands of posts and hundreds of thousands of custom post fields. MySQL has two jobs: Keep all that data organized. Find the data it needs quickly. To do its second job, MySQL uses database keys. Each table has one or more keys. For example, wp_posts has a key to let it quickly find posts when you know the author. Without its post_author key MySQL would have to scan every one of your posts looking for matches to the author you want. Our users know what that looks like: slow. With the key, MySQL can jump right to the matching posts. In a new WordPress site with a couple of users and a dozen posts, the keys don’t matter very much. As the site grows the keys start to matter, a lot. Database management systems are designed to have their keys updated, adjusted, and tweaked as their tables grow. They’re designed to allow the keys to evolve without changing the content of the underlying tables. In organizations with large databases adding, dropping, or altering keys doesn’t change the underlying data. It is a routine maintenance task in many data centers. If changing keys caused databases to lose data, the MySQL and MariaDB developers would hear howling not just from you and me, but from many heavyweight users. (You should still back up your WordPress instance of course.) Better keys allow WordPress’s code to run faster without any code changes. Experience with large sites shows that many MySQL slowdowns can be improved by better keys. Code is poetry, data is treasure, and database keys are grease that makes code and data work together smoothly. Which tables does the plugin add keys to? This plugin adds and updates keys in these WordPress and WooCommerce tables. wp_comments wp_commentmeta wp_posts wp_postmeta wp_termmeta wp_users wp_usermeta wp_options wp_wc_orders_meta wp_woocommerce_order_itemmeta wp_automatewoo_log_meta You only need run this plugin once to get its benefits. How can I monitor my database’s operation? On the Index MySQL page (from your Tools menu on your dashboard), you will find the “Monitor Database Operations” tab. Use it to request monitoring for a number of minutes you choose. You can monitor either the site (your user-visible pages) or the dashboard, or both. all pageviews, or a random sample. (Random samples are useful on very busy sites to reduce monitoring overhead.) Once you have gathered monitoring information, you can view the captured queries, and sort them by how long they take. Or you can save the monitor information to a file and show it to somebody who knows about database operations. Or you can upload the monitor to the plugin’s servers so the authors can look at it. It’s a good idea to monitor for a five-minute interval at a time of day when your site is busy. Once you’ve completed a monitor, you can examine it to determine which database operations are slowing you down the most. Please consider uploading your saved monitors to the plugin’s servers. It’s how we learn from your experience to keep improving. Push the Upload button on the monitor’s tab. WP-CLI command line operation This plugin supports WP-CLI. When your tables are large this is the best way to add the high-performance keys: it doesn’t time out. Give the command wp help index-mysql for details. A few examples: wp index-mysql status shows the current status of high-performance keys. wp index-mysql enable --all adds the high-performance keys to all tables that don’t have them. wp index-mysql enable wp_postmeta adds the high-performance keys to the postmeta table. wp index-mysql disable --all removes the high-performance keys from all tables that have them, restoring WordPress’s default keys. wp index-mysql enable --all --dryrun writes out the SQL statements necessary to add the high-performance keys to all tables, but does not run them. wp index-mysql enable --all --dryrun | wp db query writes out the SQL statements and pipes them to wp db to run them. Note: avoid saving the –dryrun output statements to run later. The plugin generates them to match the current state of your tables. Why use this plugin? Three reasons (maybe four): to save carbon footprint. to save carbon footprint. to save carbon footprint. to save people time. Seriously, the microwatt hours of electricity saved by faster web site technologies add up fast, especially at WordPress’s global scale. How can I learn more about making my WordPress site more efficient? We offer several plugins to help with your site’s database efficiency. You can read about them here. Credits Michael Uno for Admin Page Framework. Marco Cesarato for LiteSQLParser. Allan Jardine for Datatables.net. Leho Kraav and Sebastian Sommer for suggesting the WooCommerce tables. Japreet Sethi for advice, and for testing on his large installation. Rick James for everything. Jetbrains for their IDE tools, especially PhpStorm. It’s hard to imagine trying to navigate an epic code base without their tools.

W3 Total Cache (W3TC) improves the SEO, Core Web Vitals and overall user experience of your site by increasing website performance and reducing load times by leveraging features like content delivery network (CDN) integration and the latest best practices. W3TC is the only web host agnostic Web Performance Optimization (WPO) framework for WordPress trusted by millions of publishers, web developers, and web hosts worldwide for more than a decade. It is the total performance solution for optimizing WordPress Websites. BENEFITS Improvements in search engine result page rankings, especially for mobile-friendly websites and sites that use SSL At least 10x improvement in overall site performance (Grade A in WebPagetest or significant Google PageSpeed improvements) when fully configured Improved conversion rates and “site performance” which affect your site’s rank on Google.com “Instant” repeat page views: browser caching Optimized progressive render: pages start rendering quickly and can be interacted with more quickly Reduced page load time: increased visitor time on site; visitors view more pages Improved web server performance; sustain high traffic periods Up to 80% bandwidth savings when you minify HTML, minify CSS and minify JS files. KEY FEATURES Compatible with shared hosting, virtual private / dedicated servers and dedicated servers / clusters Transparent content delivery network (CDN) management with Media Library, theme files and WordPress itself Mobile support: respective caching of pages by referrer or groups of user agents including theme switching for groups of referrers or user agents Accelerated Mobile Pages (AMP) support Secure Socket Layer (SSL/TLS) support Caching of (minified and compressed) pages and posts in memory or on disk or on (FSD) CDN (by user agent group) Caching of (minified and compressed) CSS and JavaScript in memory, on disk or on CDN Caching of feeds (site, categories, tags, comments, search results) in memory or on disk or on CDN Caching of search results pages (i.e., URIs with query string variables) in memory or on disk Caching of database objects in memory or on disk Caching of objects in memory or on disk Caching of fragments in memory or on disk Caching methods include local Disk, Redis, Memcached, APC, APCu, eAccelerator, XCache, and WinCache Minify CSS, Minify JavaScript and Minify HTML with granular control Minification of posts and pages and RSS feeds Minification of inline, embedded or 3rd party JavaScript with automated updates to assets Minification of inline, embedded or 3rd party CSS with automated updates to assets Defer non-critical CSS and JavaScript for rendering pages faster than ever before Defer offscreen images using Lazy Load to improve the user experience Browser caching using cache-control, future expire headers and entity tags (ETag) with “cache-busting” JavaScript grouping by template (home page, post page etc) with embed location control Non-blocking JavaScript embedding Import post attachments directly into the Media Library (and CDN) Leverage our multiple CDN integrations to optimize images WP-CLI support for cache purging, query string updating and more Various security features to help ensure website safety Caching statistics for performance insights of any enabled feature Extension framework for customization or extensibility for Cloudflare, WPML and much more Reverse proxy integration via Nginx or Varnish Image Converter extension provides modern image format conversion (e.g., WebP, AVIF) from common image formats (on upload and on demand) W3 Total Cache Pro Features With over a million active installs, W3 Total Cache is the most comprehensive WordPress caching plugin available and has robust premium features that help deliver an exceptional user experience. Full Site Delivery: Serve your entire site from a Content Delivery Network (CDN), ensuring faster load times worldwide. Fragment Cache: Optimize the caching of dynamic content while still improving performance. REST API Caching: Speed up your headless WordPress site by caching REST API calls. Eliminate Render-Blocking CSS: Ensure your CSS doesn’t hold up page loading, providing faster initial paint. Delay Scripts: Improve performance by delaying the loading of non-essential scripts until they are needed. Preload Requests: Boost page performance by preloading critical resources before they’re requested. Remove CSS/JS: Clean up unnecessary CSS and JavaScript files that slow down your pages. Lazy Load Google Maps: Load Google Maps only when it’s visible, reducing unnecessary requests. WPML Extension: Optimize performance on multilingual sites powered by WPML. Caching Statistics: Get detailed insights on cache usage and performance improvements. Purge Logs: Keep your site clean by automatically purging unnecessary cache logs. 30-Day Money-Back Guarantee Try W3 Total Cache Pro risk-free with our 30-day money-back guarantee. If you’re not satisfied, we will refund your purchase. PAGESPEED SCORE IMPROVEMENTS To help you understand the impact of individual features on your website’s performance, we’ve tested each feature separately to see its effect on Google PageSpeed scores. While optimal results come from configuring several different caching tools together, the following individual features also show significant improvements on their own: Remove Unused CSS/JS This feature removes CSS and JavaScript files that are not needed for the current page, reducing the load time. Added over 27 points to the Google PageSpeed score (Before: 57.2 / After: 86.7) Reduced the Potential Savings From Unused JavaScript from 127.5 KiB to 84 KiB View the test results Full Site Delivery Full Site Delivery optimizes the delivery of your entire site, enhancing the server response time. Added a 99% performance enhancement to the Average Server Response Time (Before: 3413 ms / After: 34 ms) View the test results Eliminate Render Blocking CSS This feature eliminates CSS that blocks the rendering of your page, speeding up the initial load time. Added over 17 points to the Google PageSpeed score (Before: 53.75 / After: 71) Reduced the Potential Savings From Render-Blocking Resources by over 94% (Before: 2432.5 ms / After: 125 ms) Improved the Largest Contentful Paint time by over 56% (Before: 7s / After: 3.04s) View the test results Delay Scripts Delay Scripts postpones the loading of certain scripts until they are needed, reducing initial load times. Added 14 points to the Google PageSpeed Performance score (Before: 54.25 / After: 68.5) Reduced the Time Third-Party Code Blocked The Main Thread For by 62% (Before: 825 ms / After: 197.5 ms) View the test results Rest API Caching This feature caches API responses, reducing server load and speeding up API interactions. Reduced the Average Server Load by 40% (Before: 0.62 / After: 0.37) Sped up API Responses by 84.5% (Before: 968ms / After: 150ms) Reduced the Average Server Load by 24% under during a major traffic spike (Before: 34.55 / After: 26.19) View the test results Modern Image Formats Converts images to modern formats like WebP or AVIF, which are more efficient and faster to load. Added over 9 points to the Google PageSpeed score (Before: 84.67 / After: 93.83) View the test results Lazy Load Google Maps Delays the loading of Google Maps until the user interacts with them, reducing initial load time. Added 10 points to the Google PageSpeed score (Before: 66 / After: 76) Reduced the Total Blocking Time Performance score by 72% (Before: 287.5 ms / After: 80 ms) View the test results Speed up your site tremendously, improve core web vitals and the overall user experience for your visitors without having to change your WordPress host, theme, plugins or your content production workflow. What users have to say: Read testimonials from W3TC users. Who do I thank for all of this? It’s quite difficult to recall all of the innovators that have shared their thoughts, code and experiences in the blogosphere over the years, but here are some names to get you started: Steve Souders Steve Clay Ryan Grove Nicholas Zakas Ryan Dean Andrei Zmievski George Schlossnagle Daniel Cowgill Rasmus Lerdorf Gopal Vijayaraghavan Bart Vanbraban mOo [villu164] (https://www.wordfence.com/threat-intel/vulnerabilities/researchers/villu164) Please reach out to all of these people and support their projects if you’re so inclined.