These tables have keys set some way other than this plugin

  • Resolved bibberle

    (@bibberle)


    1 year, 1 month ago

    Hey,

    I used your plugin to update all keys possible, which worked perfectly fine for me. Now, after updating wordpress und plugins (including your plugin), the following message appears:

    These tables have keys set some way other than this plugin. You can convert those tables to this plugin’s latest high-performance keys or revert them to WordPress’s standard keys.

    wp_commentmeta, wp_comments, wp_options, wp_postmeta, wp_termmeta, wp_usermeta

    Having a look at phpMyAdmin Backend I can see, that the mentioned tables have your performance keys still enabled, for example wp_postmeta has 3 golden keys (“meta_id”, “post_id”, “meta_key”) and 4 silver keys (“meta_id”, “post_id”, “meta_key”, “meta_value”).

    What does this message mean? Is there anything I should do or worry? The queries itself still work superfast…

Viewing 1 replies (of 1 total)
  • Plugin Author OllieJones

    (@olliejones)

    Thanks for the question. When you update WordPress, the core update process detects that the keys on those tables are not the same as its standard ones. It tries to restore the standard ones, and does so incompletely. The results are some extra keys.

    I’ve struggled to prevent the core update process from doing this, with not much success as you see. Sorry about that.

    These extra keys slightly slow down the adding of content to your site. They do not slow down the viewing of content. They take some extra hard-drive / SSD space for your database.

    If you follow the instructions on the Tools -> Index MySQL page, you can remove the extra keys. It’s a quick operation.

Viewing 1 replies (of 1 total)
  • The topic ‘These tables have keys set some way other than this plugin’ is closed to new replies.