WordPress.org

Ready to get started?Download WordPress

Forums

Pinterest "Pin It" Button
[resolved] Plugin's upgrade-plugin.php slowing down server (2 posts)

  1. awhig
    Member
    Posted 5 months ago #

    Hi,

    I've been reviewing my db logs the last few days and found an issue with this plugin. I am using verison 2.0.2 of the plugin.

    I saw a lot of queries for "pib_old_version" in the options table in my log. These were happening very very often.

    I tracked down the query to the upgrade-plugin.php file.

    The main issue I have is that this code is constantly doing the following:

    add_option( 'pib_old_version', get_option( 'pib_version' ) );

    on line 18.

    In addition to doing a DB insert/update, this causes the object cache, which contains all of the mostly static options, to be flushed (I'm using W3TC with Object Caching On).

    This has a chain reaction and causes other plugins, etc. to re-populate the cache by doing expensive queries all over again.

    In general, the options are relatively stable. They are only updated once in awhile by the admin, etc. By having this plugin constantly updating the options table, it is eroding performance.

    Please consider reviewing and changing this code to not constantly update the options table.

    I've currently fixed this issue by commenting out the upgrade-plugin.php file. The object cache is no longer being constantly flushed, and the load on my DB server has dropped.

    Thanks,
    Rich

    https://wordpress.org/plugins/pinterest-pin-it-button/

  2. Nick Young
    Member
    Plugin Author

    Posted 5 months ago #

    @awhig

    Thanks for checking out the plugin. We actually found out about this issue recently also. We should be pushing out an update soon and this issue will be fixed.

    Thanks for your additional notes and troubleshooting.

    Nick Young

Reply

You must log in to post.

About this Plugin

About this Topic

Tags

No tags yet.