gms_options spammed with duplicate BetterLinks rows

  • Resolved Alex

    (@lanzettacadenza)


    1 year, 11 months ago

    We noticed a very significant performance degradation of our website following an update to the plugin. We discovered that BetterLinks was adding duplicate rows into gms_options every time a request was made, leading to hundreds of thousands of rows loading with the site.

    We removed the plugin and cleaned it up with the following queries:

    DELETE FROM gms_options WHERE option_name LIKE 'wp_betterlinks_%';
    DELETE FROM gms_options WHERE option_name LIKE 'betterlinks_%';

    We’re unsure which update caused this regression, but it just doesn’t check for existing rows in our database before adding a new row (which doesn’t appear to be indexed).

    If you discover the fix, you may want to clean up affected instances by removing duplicate rows during your version upgrade routine.

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

  • Hello @lanzettacadenza,

    I hope you are doing well.

    I have checked this issue and tried to reproduce it on my end. But I couldn’t get the same. Can you please tell me from which version you updated to the latest version? Also, it will be helpful if you please share your Site Info. So that I can give it another try. Please go to your WordPress Dashboard -> Tools -> Site Health -> Info -> Copy Site Info to Clipboard. Then paste it in PasteBin and share the link with us.

    Thank you

    Hello there,

    Greetings. Hope you are doing well.

    I haven’t heard from you since then. So, I was wondering if your issue has been resolved or not. Please let us know. I wish you a good day.

    Thank you

    Thread Starter Alex

    (@lanzettacadenza)

    We tested our original hunch in a Staging environment, and it does appear that it was caused by the database lacking a primary autoincrement index on option_id.

    In case our WP database is not the only one to have somehow ended up without an index over the years, you may still wish to address this problem, since it was the only plugin out of 50 that didn’t handle our database misconfiguration in that way.

    We hope this info helps!

    Hello @lanzettacadenza,

    I hope you are doing well.

    Thanks for describing this in detail. I have talked with our Dev Team and actually, this is a default behaviour of WordPress. So actually we can do nothing from our side. But we will keep this in mind for future releases.

    Thank you!

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘gms_options spammed with duplicate BetterLinks rows’ is closed to new replies.