Consuming CPU via MySQL

  • Resolved iprogress

    (@iprogress)


    9 years, 3 months ago

    This plugin is consuming all our servers CPU. It appears to run MySQL queries that flood MySQL. We have tested this on 4 VPS servers on Digital Ocean with Serverpilot and with the plugin disabled all server immediately worked perfectly.

Viewing 3 replies - 1 through 3 (of 3 total)
  • Devin Vinson

    (@dvinson)

    9 years, 3 months ago

    Hi iprogress,

    Do you have an open ticket with support? This definitely should not be happening and we don’t have any reported tickets with this issue that I can see.

    For quick reference here is a link to our support form: https://app.optinmonster.com/account/support/

    Aaron Holbrook

    (@aaronholbrook)

    9 years, 3 months ago

    I believe this is due to the plugin’s ajax POST call back to the server in an attempt to track the optin impression.

    Unfortunately this has a very negative effect on large scale sites as it bypasses most caching and causes a MySQL write on every stat AJAX request.

    http://d.pr/i/xTE/4WQKy0Q9

    It appears to attempt to detect Google Analytics and use that, however the self.getProp( 'ga_uaid' ) does not work effectively.

    I would love to see a way to completely disable this @dvinson – as it stands right now we had to disable the plugin.

    Devin Vinson

    (@dvinson)

    9 years, 3 months ago

    Hi Aaron,

    That code looks like the pre-saas version of the plugin which stopped being supported at the end of 2015. We do still have an update path on to the new platform which takes any server side processing off of your own server and moves it on to the OptinMonster servers.

    I’m not sure which version you are working from for sure so if it is the current version hosted here on ww.wp.xz.cn submitting a ticket will be the best way to get things solved for you.

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

The topic ‘Consuming CPU via MySQL’ is closed to new replies.