Title: mysql performance feedback?
Last modified: October 24, 2025

---

# mysql performance feedback?

 *  Resolved [hurry](https://wordpress.org/support/users/extremist87/)
 * (@extremist87)
 * [7 months, 2 weeks ago](https://wordpress.org/support/topic/mysql-performance-feedback/)
 * did anyone see a performance increase after doing this?
 * i tried but it still feels the same ..

Viewing 6 replies - 1 through 6 (of 6 total)

 *  Plugin Author [OllieJones](https://wordpress.org/support/users/olliejones/)
 * (@olliejones)
 * [7 months, 2 weeks ago](https://wordpress.org/support/topic/mysql-performance-feedback/#post-18694243)
 * Thanks for the question. The performance gains can be subtle, and depend on the
   kinds of things happening in your site.
 * Plenty of folks see big gains. I wrote the plugin for a WooCommerce store I maintain,
   and I see big gains.
 * You might try using a persistent object cache if you need better gains than you
   see now. [https://developer.wordpress.org/reference/classes/wp_object_cache/#persistent-cache-plugins](https://developer.wordpress.org/reference/classes/wp_object_cache/#persistent-cache-plugins)
 * If I can help you further, please upload your metadata following the instructions
   in the pinned topic on this forum.
 *  Thread Starter [hurry](https://wordpress.org/support/users/extremist87/)
 * (@extremist87)
 * [7 months, 2 weeks ago](https://wordpress.org/support/topic/mysql-performance-feedback/#post-18694249)
 * Hey there
 * I’ve enabled redis object cache and also used your plugin to index the tables
   along with using wp optimize to optimize and clean up the tables. My database
   is 2.5gb. I read up online and people say that size isn’t the problem so not 
   sure what else to try
 *  Plugin Author [OllieJones](https://wordpress.org/support/users/olliejones/)
 * (@olliejones)
 * [6 months, 1 week ago](https://wordpress.org/support/topic/mysql-performance-feedback/#post-18736007)
 * I’d like to see your metadata to help you further.
 *  [elkrat](https://wordpress.org/support/users/elkrat/)
 * (@elkrat)
 * [6 months, 1 week ago](https://wordpress.org/support/topic/mysql-performance-feedback/#post-18741752)
 * This plugin makes a very big difference when you have hundreds of sites on a 
   single server. I have a cPanel site with about 120 accounts on it, and this plugin
   has put some real pep in the old girl’s step.
 * That said, I had made an error in my app that wasn’t immediately apparent to 
   me. Check this out:
 *     ```wp-block-code
       $appointments = $wpdb->get_results("SELECT * FROM $meta_table WHERE meta_key = 'appt_timestamp' && meta_value = $timestamp");
       ```
   
 * Meta values are always strings, but if $timestamp IS AN INTEGER, then you get
   a full table scan and the query will crush your db server. All I had to do was
   add single quotes around $timestamp:
 *     ```wp-block-code
       $appointments = $wpdb->get_results("SELECT * FROM $meta_table WHERE meta_key = 'appt_timestamp' && meta_value = '$timestamp'");
       ```
   
 * I searched my entire app for “meta_value = $” and fixed less than 10 instances.
   It cut my database load in half. If you’re doing fancy searches you can create
   indices based on multiple columns as well.
 *  Plugin Author [OllieJones](https://wordpress.org/support/users/olliejones/)
 * (@olliejones)
 * [6 months ago](https://wordpress.org/support/topic/mysql-performance-feedback/#post-18744229)
 * Thanks for the followup. You’re quite right about the `meta_value = integer` 
   filtering. The [WP_Meta_Query](https://developer.wordpress.org/reference/classes/wp_meta_query/)
   code does handle this use case as well as the wonderful stringly-typed metadata
   tables allow.
 * And, beware, searching for equality rather than a range on timestamps is an error-
   prone procedure. Off by one second means no results.
 * Thanks again for the followup. I bet this problem would have showed up in Query
   Monitor or in one of the monitors in this plugin.
 *  Plugin Author [OllieJones](https://wordpress.org/support/users/olliejones/)
 * (@olliejones)
 * [6 months ago](https://wordpress.org/support/topic/mysql-performance-feedback/#post-18744232)
 * Please don’t hesitate to start another thread if I can help further.

Viewing 6 replies - 1 through 6 (of 6 total)

The topic ‘mysql performance feedback?’ is closed to new replies.

 * ![](https://ps.w.org/index-wp-mysql-for-speed/assets/icon-128x128.png?rev=2652667)
 * [Index WP MySQL For Speed](https://wordpress.org/plugins/index-wp-mysql-for-speed/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/index-wp-mysql-for-speed/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/index-wp-mysql-for-speed/)
 * [Active Topics](https://wordpress.org/support/plugin/index-wp-mysql-for-speed/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/index-wp-mysql-for-speed/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/index-wp-mysql-for-speed/reviews/)

 * 6 replies
 * 3 participants
 * Last reply from: [OllieJones](https://wordpress.org/support/users/olliejones/)
 * Last activity: [6 months ago](https://wordpress.org/support/topic/mysql-performance-feedback/#post-18744232)
 * Status: resolved