Plugin causing increased load on server

  • Resolved lindsay.smith

    (@lindsaysmith)


    2 years ago

    Hi there

    We received a message from our hosting providered that we experinced and increase load on our server due to this plugin. Are you able to take a look at their message to help us resolve the issue?

    The increased load is caused by a single query which is being generated by the molongui-authorship plugin:
    SELECT wpJSrc_users.ID
    FROM wpJSrc_users INNER JOIN wpJSrc_usermeta ON ( wpJSrc_users.ID = wpJSrc_usermeta.user_id )
    WHERE 1=1 AND (
    (
    ( wpJSrc_usermeta.meta_key = ‘wpJSrc_capabilities’ AND wpJSrc_usermeta.meta_value LIKE ‘%\”administrator\”%’ )
    OR
    ( wpJSrc_usermeta.meta_key = ‘wpJSrc_capabilities’ AND wpJSrc_usermeta.meta_value LIKE ‘%\”editor\”%’ )
    OR
    ( wpJSrc_usermeta.meta_key = ‘wpJSrc_capabilities’ AND wpJSrc_usermeta.meta_value LIKE ‘%\”author\”%’ )
    OR
    ( wpJSrc_usermeta.meta_key = ‘wpJSrc_capabilities’ AND wpJSrc_usermeta.meta_value LIKE ‘%\”contributor\”%’ )
    )
    )
    ORDER BY display_name ASC

    We started seeing a large number of 503 errors being returned by the gateway between 13:09 and 13:34 UTC. This typically means that the app’s FPM workers aren’t able to process requests quickly enough so they get dropped instead. Response times were very high during this time and the DB load started affecting other apps on the server so we’ve gone ahead and disabled the molongui-authorship plugin for now. The site still appears to be loading normally but please let us know if the plugin is necessary for the site to function normally and we’ll re-enable it – it can also be re-enabled via the WP admin dashboard if needed. Note that re-enabling it will likely immediately cause performance issues for the site again.

    We recommend reaching out to its developers to see if they can optimise the query above in any way – possibly by removing the wildcard matching on the meta_value column which may allow the query to utilise indexes on the usermeta table. Reducing the number of queries that it generates or storing the results of the query in the object cache may also work since a single request seemed to spawn several queries.

    Please let me know if there’s any other information I can provide.

    The page I need help with: [log in to see the link]

Viewing 6 replies - 1 through 6 (of 6 total)
  • Plugin Author Molongui

    (@molongui)

    Hi @lindsaysmith,

    Could you please go to: Authors > Help! screen and scroll down the page until the bottom. There you will see a panel named “System Status Report”. Please click on the button labeled “Send Report”. We will get an email with some info about your installation that will provide us a little more context on this.

    And could you tell what type of activity was being carried on your site while getting those 503 errors? I’d say those must have affected your backend/WP dashboard, not your public site. But it would be helpful you to confirm.

    Also, are you able to reproduce the issue? That would be really helpful to track down the issue.

    Please let us know.

    Plugin Author Molongui

    (@molongui)

    We got your System Status Report, thanks! Could you please also answer these questions:

    1) Did you get any 503 error while working on your Dashboard or it was your hosting provider the one who let you know about them?

    2) If you got the 503 error, what were you doing before getting it? Editing a post maybe?

    3) Are you able to reproduce the issue?

    4) Do you have custom code hooking into our plugin?

    5) Do you have a staging/testing site we can use to test?

    6) I see you have been using the plugin for quite a long time. Is this the first time you experience this errors? What has changed, maybe you installed a new plugin recently? Or any change you have introduced?

    Please let us know so we can assist.

    Thread Starter lindsay.smith

    (@lindsaysmith)

    Thank you for the quick response. I’ll do my best to answer your questions.

    1 and 2) We are not seeing any actual errors on the front or backend of the WP site. It was the hosting provider who let us know.

    3) We haven’t been able to reproduce the error but we’ve reenabled the plugin to see if Pagely (hosting provided) gets the load issues again and we can let you know. Would it help to send a system report while we’re getting load error issues?

    4) We have not added any custom code.

    5) We don’t have a staging site but we can give you an admin account to access the site if there’s a way to send you the information privately.

    6) We have been using the plugin for quite sometime without issue. We also use it on a number of other sites at the school (hosted with the same provider) and don’t seem to be experiencing any issues. We did install a new cookie notice plugin in early October but didn’t experience any issues with the site until last week.

    Please let me know if you’d like access to the site and a way for me to privately send you the information.

    Thanks,

    Plugin Author Molongui

    (@molongui)

    3) With “system report” do you mean the error log from your web server? If so, yes please!

    5) That would work too, yes. But only if the issue comes back. In such case, please send credentials opening a support ticket with us here.

    6) Good to know. Maybe it was just an isolated issue. Let’s see what happens now that you have re-enabled the plugin. And I don’t think that cookie plugin might be causing any issue here.

    Thanks for all the information. You did answer everything we needed to know!

    Thread Starter lindsay.smith

    (@lindsaysmith)

    Hi there

    We haven’t seen a reoccurrence yet. Our host has set up a “trap” on this site and our other four sites that are using the plugin.

    We will let you know if we see anything again. It’s possible it was just an isolated issue.

    Thanks for your help.

    Plugin Author Molongui

    (@molongui)

    Hi @lindsaysmith,

    Thanks for getting back and letting us know. That’s good news! It might have been a glitch or something, yes.

    I’m closing this ticket now, but feel free to re-open it if the issue occurs again. We’ll be happy to assist.

Viewing 6 replies - 1 through 6 (of 6 total)
  • The topic ‘Plugin causing increased load on server’ is closed to new replies.