Huge amount of autoloaded data for massive multisite

  • Resolved AdamWPE

    (@adamwpe)


    9 years ago

    Hey Sidekick team,

    Recently a user with a giant multisite with 3000+ subsites found things were getting progressively slower. After some troubleshooting, we found that a large amount of autoloaded data was pointing to the Sidekick plugin:

    mysql> SELECT LENGTH(option_value),option_name FROM wp_options WHERE autoload='yes' ORDER BY length(option_value) DESC LIMIT 20;

898658	sk_checked_blogs

    The code related to sk_checked_blogs:

    sidekick/libs/licensing.php
19:            $checked_blogs = get_option('sk_checked_blogs');
26:                update_option('sk_checked_blogs', $checked_blogs);
73:                update_option('sk_checked_blogs', $checked_blogs);
107:            $checked_blogs = get_option('sk_checked_blogs');
132:            $checked_blogs = get_option('sk_checked_blogs');
138:                update_option('sk_checked_blogs', $checked_blogs);
328:            $checked_blogs   = get_option('sk_checked_blogs');
374:            update_option('sk_checked_blogs', $checked_blogs);

    Is there any way to avoid autoloading ~900k of data? This is potentially creating a lot of overhead for larger multisites. Thanks!

    https://www.ads-software.com/plugins/sidekick/

Viewing 5 replies - 1 through 5 (of 5 total)
  • Plugin Author Ben Fox

    (@benfox)

    Hi Adam,

    Thank you for bringing this to our attention. I am going to open a ticket on it. If you’d like to be on the ticket, please email me at [email protected] and I will add you so you can stay up to date. Otherwise, I will post here on Monday or Tuesday with an update.

    Ben

    Plugin Author Ben Fox

    (@benfox)

    Adam,

    Good news, I just spoke with our devs and this issue was actually just addressed in our latest platform / plugin release.

    Please make sure the client is using the latest plugin version and that they clear cache. They should see version number 3.16.0 or later in the right corner of the play bar when they open the SIDEKICK drawer.

    I’m waiting for an answer still on whether or not there needs to be anything done to clear out the old data. Please standby on that.

    Apologies for the issue.

    Ben

    Plugin Author Ben Fox

    (@benfox)

    Adam,

    One last update. In order to clear out the old data you just need to delete the sk_checked_blogs field from the DB once you’ve updated. That should fix the issue completely.

    OK. I think we’re good now. If not, let me know here or at [email protected].

    Have a great weekend.

    Ben

    Thread Starter AdamWPE

    (@adamwpe)

    Thanks Ben! You guys are amazing!

    Plugin Author Ben Fox

    (@benfox)

    Well. Bart is. ??

    Have a great weekend.

Viewing 5 replies - 1 through 5 (of 5 total)
  • The topic ‘Huge amount of autoloaded data for massive multisite’ is closed to new replies.