High Mysql CPU usage due to Adrotate

  • Resolved cnxsoft

    (@cnxsoft)


    9 years, 4 months ago

    I could not register @ https://ajdg.solutions/my-account/, so I’m posting here.

    I have a very high Myqsl CPU usage on my server, which slows it down a lot.
    So I used Debug Objects to find out, and I can see many transient requests from Adrotate such as:

        Time: 739.2ms (0.73922801017761s)
    Query:

    INSERT INTO <code>wp_options</code> (<code>option_name</code>, <code>option_value</code>, <code>autoload</code>) VALUES ('_transient_adrotate_impression_be80d88c70cf20f21d89711405cb8782', '1485366604', 'no') ON DUPLICATE KEY UPDATE <code>option_name</code> = VALUES(<code>option_name</code>), <code>option_value</code> = VALUES(<code>option_value</code>), <code>autoload</code> = VALUES(<code>autoload</code>)

    Function: add_option()

    The forums messes up with the code above, so here’s a pastebin: http://pastebin.com/MD3pHh7Q
    I think it may be the same issue as reported @ https://ajdg.solutions/forums/topic/wp_options-table-entries/

    • This topic was modified 9 years, 4 months ago by cnxsoft.
    • This topic was modified 9 years, 4 months ago by cnxsoft.
    • This topic was modified 9 years, 4 months ago by cnxsoft. Reason: Added pastebin link
Viewing 4 replies - 1 through 4 (of 4 total)
  • Thread Starter cnxsoft

    (@cnxsoft)

    9 years, 4 months ago

    Here’s the output of mysql slow which seems related: http://pastebin.com/prPfWu7D

    Plugin Author Arnan

    (@adegans)

    9 years, 4 months ago

    Make sure you have the latest version of AdRotate and check in AdRotate Settings > Maintenance that the transient cleanup function is there and active.

    Thread Starter cnxsoft

    (@cnxsoft)

    9 years, 4 months ago

    Thanks for the prompt answer.
    I’m not sure how to check the version number, but there’s no new version in WordPress plugins.
    I can’t see specific options to enable/disable transient cleanups, but just:

    Optimize Database

    Cleans up overhead data in the AdRotate tables.
    Overhead data is accumulated garbage resulting from many changes you’ve made. This can vary from nothing to hundreds of KiB of data.
    Clean-up Database

    Delete stats older than 356 days (Optional).
    Delete old tracker data. (Does nothing if you use a memcached plugin)
    For when you create an advert, group or schedule and it does not save or keep changes you make.
    Additionally you can clean up old schedules, tracker data and/or statistics. This will improve the speed of your site.
    Re-evaluate Ads

    This will apply all evaluation rules to all ads to see if any error slipped in. Normally you should not need this feature.

    Further down it shows transients have been cleaned:

    Advert evaluation January 26, 2017 12:30 Clean Transients January 26, 2017 04:49

    This morning I don’t have high CPU usage all the time like last evening, maybe because there’s less traffic at that time, but I can still see 100% mysql CPU from time to time for several seconds.

    Plugin Author Arnan

    (@adegans)

    9 years, 3 months ago

    Todays update fixes an issue with transient cleaning affecting some setups.
    If your hosting is particular cheap/slow/’lightweight’ it may just not be good enough to deal with stats collection.

    That said – I’m not super convinced anymore that the transient api is fast enough overall to deal with a thing like this. Even though it should be 🙁

    • This reply was modified 9 years, 3 months ago by Arnan.
Viewing 4 replies - 1 through 4 (of 4 total)

The topic ‘High Mysql CPU usage due to Adrotate’ is closed to new replies.

Tags