Plugin consums all my server resources even when just being idle

  • Resolved gloqon

    (@gloqon)


    4 years, 7 months ago

    I have installed the plugin and set up the website and I really liked what I was seeing.

    However, I got a warning of my host that I have gone beyond my server resource limits. The site is hosted with Siteground GoGeek plan.

    I have tested the plugin extensively the past week, but at the moment I cannot actually launch the site. For what I see the plugin makes constantly requests to admin-ajax.php when an admin or store owner is logged in – fronted or backend. It seems this is to get notifications about new messages (order, inquiries etc.). I have deactivated the live notifications on the website, so you would only get e-mails, but the issue remains: If there are a few admin tabs open, the CPU usage just goes beyond the roof.

    I have a done test the past hours – you can see the ride it does (it is to mention that I just opened the pages as I mention below – I haven’t done anything else on the site during all this time): https://prnt.sc/rp4z2j

    – at 23.00: I opened a few admin tabs in the marketplace frontend view
    – at 12.00: I switched to the admin backend view
    – at 01.00: I opened normal frontend pages (still logged in) – sorry that I didn’t mention in the screenshot above
    – at 03.00: I logged out and opened the pages

    My main concern is that even if I don’t use a page, just leave it open, the plugin uses a lot of resources – just being idle. What will happen if a few vendors are logged in and leave the computer running and a few tabs open? That will add up quite quickly.

    So here are my questions:
    1. What is the number of vendors the plugin can handle?
    2. Is there any way to prevent the overload of server resources? In particular to reduce the admin-ajax.php requests which are not essential? Is it for example possible to make the request to get new messages only once an hour or something like this? Or to eliminate them altogether, so vendors only get notifications via e-mail?

    You probably can better explain what the plugin does and what is going on, so I am happy to hear that.

    I see you take requests here very seriously, so your help on this is very much appreciated.

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

Viewing 13 replies - 1 through 13 (of 13 total)
  • Plugin Author WC Lovers

    (@wclovers)

    Hi,

    1. What is the number of vendors the plugin can handle?

    – Well, WCFM has no such limitation. We have tested this with 10k vendors and 1 million products. It works perfectly.

    For what I see the plugin makes constantly requests to admin-ajax.php when an admin or store owner is logged in – fronted or backend.

    – WCFM does not call anything from site backend. It calls admin-ajax.php on interval of 6 seconds to check whether any new notification is there or not.

    But it’s impossible this will overloads server.

    Is there any error happening to your site? Please check at wp-admin -> WooCommerce -> Status -> Logs -> fatal_erros log -> is any error generated?

    Is there any other “admin-ajax.php” calls initialing periodcially?

    Thank You

    Thread Starter gloqon

    (@gloqon)

    Thanks for your reply and help! Much appreciated!

    I have now deactivated all the plugins (except the WCFM, Woocommerce and Limit Heartbeat) and let it run with a few admin pages open. The issues remains the same: https://prnt.sc/rpmxhy

    Is it possible to delay the ajax-admin.php calls in order to see if this is causing the issue (a script or something)? Or maybe block them altogether if new messages are deactivated anyways? Would be great to see if this is the issue? Or maybe leave it deactivated if new messages are not activated. Or automatically logout users after X minutes?

    I have checked for error logs, actually there are a few (they all appear a few times and originated by WCFM). I am sending a few here, is there a place I can send them to you? There is only one from today – I post it below.

    Thank you very much for your help!

    2020-03-23T02:16:23+00:00 CRITICAL Cannot redeclare wcfmmp_vendor_order_customer_payment_options() (previously declared in /wp-content/plugins/code-snippets/php/snippet-ops.php(446) : eval()’d code:40) in /home/travelg3/public_html/club-farming.com/wp-content/plugins/code-snippets/php/snippet-ops.php(446) : eval()’d code in Zeile 61

    2020-03-25T17:13:59+00:00 DEBUG Mail Check Status:: 1

    2020-03-30T16:10:06+00:00 CRITICAL Uncaught PDOException: SQLSTATE[HY000]: General error: 2006 MySQL server has gone away in /wp-content/plugins/mailpoet/vendor-prefixed/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:101
    Stack trace:
    #0 /wp-content/plugins/mailpoet/vendor-prefixed/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php(101): PDOStatement->execute(NULL)
    #1 /wp-content/plugins/mailpoet/lib-3rd-party/Idiorm/idiorm.php(520): MailPoetVendor\Doctrine\DBAL\Driver\PDOStatement->execute()
    #2 /wp-content/plugins/mailpoet/lib-3rd-party/Idiorm/idiorm.php(1924): MailPoetVendor\Idiorm\ORM::_execute(‘SELECT * FROM `…’, Array, ‘default’)
    #3 /wp-content/plugins/mailpoet/lib-3rd-party/Idiorm/idiorm.php(754): MailPoetVendor\Idiorm\ORM->_run()
    #4 [internal function]: MailPoetVendor\Idiorm\ORM->find_array()
    #5 /home/travelg3/ in /home/travelg3/public_html/club-farming.com/wp-content/plugins/mailpoet/vendor-prefixed/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php in Zeile 103

    Plugin Author WC Lovers

    (@wclovers)

    Hi,

    Can you please contact your hosting support and ask them check which resources consuming such memory?

    Between, as I see mailpoet plugin throwing error.

    Thank You

    Thread Starter gloqon

    (@gloqon)

    Ok, I will check again with them. Anyways, it is an issue if WCFM is activated, even if all other plugins are deactivated. So not sure if I inserted a script that is incompatible or something like that.

    Does the plugin the wp-cron job require to work? I substituted it with a real cron-job from the server.

    I noticed that every 60 seconds a request is made to admin-ajax.php, it is initiated by WCFM: https://www.dropbox.com/s/7vcsak07gmyn9sb/Kopie%20requests.jpg?dl=0

    Has that anything to do with it?

    I will wait for the host to reply and I am testing it on 2 new sites – on one I would like it to use and on a fresh new clean wordpress install.

    Thank you

    Thread Starter gloqon

    (@gloqon)

    Is there a way to block these requests? Can you share a code snippet for that?

    Thread Starter gloqon

    (@gloqon)

    This is the response of the host again “excessive hits on admin-ajax.php” https://prnt.sc/rprhlo

    If you could share a snippet to block or delay the requests (to make them every minute or even 5 minutes), that would be awesome, as it seems these requests are responsible for the admin-ajax.php requests.

    Thank you very much!

    Plugin Author WC Lovers

    (@wclovers)

    Hi,

    Do you have checked which ajax calls these are?

    WCFM never request that much.

    You may add this code to your site to disable WCFM request –

    add_filter( 'wcfm_is_allow_desktop_notification', '__return_false' );

    Add this code to your child theme’s functions.php
    In case you do not have child theme then add code using this plugin –?https://www.ads-software.com/plugins/code-snippets/

    Thank You

    Thread Starter gloqon

    (@gloqon)

    Hi!

    I tried this on a complete new install.

    I installed the 3 WCFM plugins, inserted the code in code snippets plugin, in stalled Limit Heartbeat plugin and deactivated the heartbeat – no success.

    You can see in this graphic: https://prnt.sc/rqjb3f

    1. The issue doesn’t appear with the WC Marketplace plugin
    2. When the frontend manager plugin is deactivated, the issue does not appear.

    If you want I can give you access to this install so you can see for yourself?

    Thank you for your help on this!

    Plugin Author WC Lovers

    (@wclovers)

    Hi,

    We have debug this in our environment but not able to generate this.

    Please contact us directly here – https://wclovers.com/setup-guidance/

    We will debug this in more depth for you.

    Thank You

    I think I found a reason, and need a solution asap:

    store-manager/settings/ is performing a massive 2,964 Queries to DB EACH time the page is hit.

    the query:
    SELECT option_name, option_value
    FROM wp_options
    WHERE autoload = ‘yes’

    I have 500 vendors. 8 CPUs, 32Gb, 360GbSSD AWS beast. As soon as a few vendors enters the page to manage their products, watch their orders… boom, CPUs goes ballistically to 100%.

    Plugin Author WC Lovers

    (@wclovers)

    Ho to WCFM Admin settings -> Modules -> set off unnecessary modules

    @nashitor Could you fix the problem? We have the same problem with massive server load from wcfm.
    Thanks in advance.

    Plugin Author WC Lovers

    (@wclovers)

    It’s something impossible right now.

    Please talk to your hosting provider why your server overloaded?

Viewing 13 replies - 1 through 13 (of 13 total)
  • The topic ‘Plugin consums all my server resources even when just being idle’ is closed to new replies.