index-wp-mysql-for-speed

index-wp-mysql-for-speed copied to clipboard

MKhalid reports: My wp_options table is present both in revert key and convert key, and when i try to either convert or revert using the plugin page or wp-cli i...

OllieJones

Using 100% CPU while creating indexes after enabling Index for Speed plugins

4

We added both Index WP MYSQL for Speed and Index WP Users for Speed to our woocommerce site, which had become slow due to very large usermeta (1.6MM rows) and...

petergerard

LearnDash Support

6

I also have a few LearnDash sites setup with a HUGE number of users/postmeta, etc, and I think this could be very beneficial as well especially on LearnDash's custom tables...

tripflex

WPML plugin: see if we can make its tables any faster.

20

Can we look at the WPML plugin's indexes to find opportunities for speedups? https://wpml.org/ Per this request. https://wordpress.org/support/topic/please-add-wpml-support/

OllieJones

Index BuddyPress tables.

6

A user asked for indexes on BuddyPress tables. https://wordpress.org/support/topic/index-buddypress-and-other-meta-tables/ More information is needed, about the bad queries.

OllieJones

taxonomy indexing

5

From a user: Would it be possible to add keys for an eCommerce Store that has product filtering with lots of attributes? wp_terms wp_term_taxonomy wp_term_relationships wp_woocommerce_termmeta wp_woocommerce_attribute_taxonomies (for product attributes)...

OllieJones

slist like ilist

3

And, make ilonglist and slonglist for > 20 items.

OllieJones

ALTER TABLE wp_sitemeta DROP KEY site_id, ADD KEY site_id (site_id, meta_key, meta_value(32))

OllieJones

Newest version throwing fatal on /wp-admin/tools.php?page=imfs_settings&tab=monitor_database_operations and /wp-admin/tools.php?page=imfs_settings&tab=high_performance_keys ``` [09-Apr-2024 23:18:24 UTC] PHP Fatal error: Uncaught TypeError: log(): Argument #1 ($num) must be of type float, string given in /app/web/wp-content/plugins/index-wp-mysql-for-speed/afp/factory/_common/utility/base_utility/AdminPageFramework_Utility.php:138...

midweste

Work around a shortcoming in Query Monitor

1

Admin Page Framework registers a 'current_screen' action handler that's invoked via php's __call magic method rather than by being defined in the class. But Query Monitor's Hooks and Actions display...

OllieJones