Support » Plugin: Index WP MySQL For Speed » Stuck at revert and reset keys without any progress

  • Resolved Rookie

    (@alriksson)


    Keep getting this on revert and reset keys without any progress. Not sure if it managed to revert it’s own generated indexes? And left is only from another plugin? Should be possible as other plugins I see adding two indexes are just executing creation on action like your plugin so why can’t I proceed via your plugin. Not sure if this plugins indexes are reverted or not running SHOW INDEX FROM wp_posts; for example, it doesn’t seem like any of the ones was reverted.

    Keys on 2 tables reset.

    Problems Rekeying	
    You cannot rekey some tables without resetting their keys first.
    This often means they have already been rekeyed by some other plugin or workflow.
    
    Reset Keys	
    Reset the keys on these tables: remove the keys set by some other plugin or workflow.
    
    wp_postmeta has unexpected keys, so you cannot rekey it without resetting it first.
     The expected key PRIMARY KEY does not exist.
    wp_usermeta has unexpected keys, so you cannot rekey it without resetting it first.
     The expected key PRIMARY KEY does not exist.
Viewing 8 replies - 1 through 8 (of 8 total)
  • Plugin Author OllieJones

    (@olliejones)

    PLease upload your metadata from the About panel and let me know the upload id value.

    This problem often crops up on big sites running on budget hosts with short timeouts. We’re working on making the rekeying process faster and more reliable.

    If you can use wp-cli and do

    wp index-mysql disable wp-postmeta
    wp index-mysql disable wp-usermeta

    you should get back to WordPress’s standard state. If you do

    wp index-mysql enable wp-postmeta
    wp index-mysql enable wp-usermeta

    you should get the faster keys.

    Thanks for your patience.

    • This reply was modified 6 months, 3 weeks ago by OllieJones.
    • This reply was modified 6 months, 3 weeks ago by OllieJones.
    Thread Starter Rookie

    (@alriksson)

    Not too big and not shared hosting, but this site is on Cloudways and not woocomerce.

    Metadata uploaded to id BGMVVadmzC

    Shared wp-cli output over email and same issue persist

    • This reply was modified 6 months, 3 weeks ago by Rookie.
    Plugin Author OllieJones

    (@olliejones)

    Please try v 1.4.1, just released. And, for your big tables:

    * do them one at a time
    * do them from wp-cli.

    In a shell do

    wp index-mysql enable wp_posts
    wp index-mysql enable wp_postmeta
    wp index-mysql enable wp_users
    wp index-mysql enable wp_usermeta
    wp index-mysql enable –all
    wp index-mysql status

    wp index-mysql enable wp_postmeta

    Thread Starter Rookie

    (@alriksson)

    Many thanks Ollie,

    I will update and check it out. Do you have an easy shell or sql script to drop all indexes to start from a clean slate? I only know the specific ones to drop specific indexes on the specific columns.

    Thread Starter Rookie

    (@alriksson)

    public_html$ wp index-mysql enable –all
    Index WP MySQL For Speed 1.4.1
    Versions  Plugin:1.4.1 MySQL:10.4.20-MariaDB-1:10.4.20+maria~stretch-log WordPress:5.8.3 WordPress database:49752 php:7.4.27
    Error: These tables are not found or not eligible to enable: –all.
    Thread Starter Rookie

    (@alriksson)

    The plugin seems to show all fine now here:

    Success
    You have added high-performance keys to these tables. You can revert them to WordPress’s standard keys.
    wp_commentmeta, wp_comments, wp_options, wp_postmeta, wp_posts, wp_termmeta, wp_usermeta, wp_users

    Haven’t tried to revert yet with wpcli. But would like to prefer to clean up all performance keys/indexes and only use the ones from your plugin to not have duplicates.

    Plugin Author OllieJones

    (@olliejones)

    You need two dashes before --all in the wp-cli command.

    I can’t begin to count how many times I’ve made that kind of mistake.

    Sigh.

    Thread Starter Rookie

    (@alriksson)

    Ah yeah! Thanks Ollie! Amazing support so far.

Viewing 8 replies - 1 through 8 (of 8 total)
  • The topic ‘Stuck at revert and reset keys without any progress’ is closed to new replies.