100% CPU Usage

Hi,

Thanks for using our plugin and reaching out to us.

When our plugin is running into server configuration limitations, such as for CPU usage, you can try lowering the batch size of the plugin from the default 750 products per batch to a much lower number. Try a batch size of 250.

This is how you can change the batch size:
https://adtribes.io/batch-size-configuration-product-feed/

Hope this helps.

Hello,

We use a cloud server and we run 4 website, all of them using Product feed pro.

We never had any problem of performance before with any of them, and there is just only one of them concerned by this database connection error and server cpu going to 100%.

Why the other site are on the same server, have equal amount of product and doesn’t go in the database connection error and server cpu to 100%.

The batch size reduce is already in place, but again, the other site haven’t batch size configured and didn’t go to any database connection error and etc… So why this one is problematic ? What happen ? This problem is not just a batch size reducing solution.

We already reduce it to 500 before contacting you and it didn’t resolve anything + our feed have like 300 products inside. This is another problem, for sure.

+ on this alone site who have that problem, we was able to generate product feed just 2 day ago without any problem, and this problem just come to appear only yesterday.

EDIT after : We try with batch size to 250 and still error database connection and server cpu to 100%….

Thanks

• This reply was modified 2 years ago by awaaxyb.
• This reply was modified 2 years ago by awaaxyb.

Hi,

Thanks for using our plugin and reaching out to us.

Did you already check out the WooCommerce fatal error logs of the last couple of days to see if there is anything in there that could explain this? This is where you can find the WooCommerce fatal error logs: https://woocommerce.com/document/finding-php-error-logs/

We already checked log and there is nothing

Could it be a database connection setting that is causing the issue at hand for this one website? Perhaps there is a restriction on who/what can connect to your database and how many connections are allowed?

Database connection is correct and i use definetely the same settings for sql limitations etc than the other site that are running product feed generation without any problem.

EDIT : just for your concern we just now replicate a feed to another popular feed plugin and the feed is generating in 20 seconds without any batch size edit, no database connection problem and server cpu to 100%… something is really wrong with product feed pro I think you should really take a look at our problem if you want to be great again..?

• This reply was modified 2 years ago by awaaxyb.

We have over 100k active users and none of those are currently experiencing similar issues (otherwise our support mail would have exploded) so we really think this is related to that one website you are running. Like you mentioned, for your other websites it is running fine. So what is different for the one website that is experiencing issues, does it have a different set-up, running other/heavier plugins, firewalls and so on? Anything you can think of.

Nothing the site use the same plugins and configuration
Why then it’s working with another popular feed plugin ?