Site seems to work OK, with two processors and 4 GB Ram. MySQl on same server at the moment but if I use the standard woo-commerce bulk edit on more than 50 t-shirts each with 65 variations, it runs for ages and eventually fails with simple “this website is not responding” error 500
If I Htop my server, the processors are maxed at 100% and memory around 50%
In my wp-config file at the top I have:
define(‘WP_MEMORY_LIMIT’, “2048M”); ini_set(‘memory_limit’, “2048M”);
Yes thats 2GB to Word-press?? Is that too much and stealing from MySQL?
Its a multi-site install that I haven’t finished the other installs so they are not being hit at all. I have this in my wp-config file: define( ‘WP_ALLOW_MULTISITE’, true ); define(‘MULTISITE’, true); define(‘SUBDOMAIN_INSTALL’, false); define(‘DOMAIN_CURRENT_SITE’, ‘mysite.co.uk’); define(‘PATH_CURRENT_SITE’, ‘/’); define(‘SITE_ID_CURRENT_SITE’, 1); define(‘BLOG_ID_CURRENT_SITE’, 1);
Also have this
/** Sets up WordPress vars and included files. */ require_once(ABSPATH . ‘wp-settings.php’); define(‘CONCATENATE_SCRIPTS’, false);
My PHP.ini has silly settings such as
max_execution_time = 30000 max_input_time = 60000 memory_limit = 512MB
I really get the feeling this is MySQL related but by php.ini settings and word-press memory limits might be creating this issues
Cheers
This textbox defaults to using Markdown to format your answer.
You can type !ref in this text area to quickly search our full set of tutorials, documentation & marketplace offerings and insert the link!
Accepted Answer
You will find that the iniset
is most likely a WordPress wrapper for the php ini_set
function (so it is trying to increase the memory limit to 2GB for PHP at execution time (although most php configurations running in safe mode would block this). As I understand it, WooCommerce
and its bulk
operations are fairly resource intensive.
It might be opportune to try adjusting the settings in php.ini directly:
Here is a good guide on How To Change Your PHP Settings on Ubuntu 14.04, if you are unsure. Don’t forget to restart your web-server after making the change, so they can be applied.
I understand that are also plugins that help with these type of operations, as it is a common theme that they crash the php parser, you might want to check out Sheet Editor for WooCommerce. It seems to be written just for these types of problems.
If all this doesn’t work, just edit the products in smaller batches and see if that completes successfully.
Get paid to write technical tutorials and select a tech-focused charity to receive a matching donation.
Full documentation for every DigitalOcean product.
The Wave has everything you need to know about building a business, from raising funding to marketing your product.
Stay up to date by signing up for DigitalOcean’s Infrastructure as a Newsletter.
New accounts only. By submitting your email you agree to our Privacy Policy
Scale up as you grow — whether you're running one virtual machine or ten thousand.
Sign up and get $200 in credit for your first 60 days with DigitalOcean.*
*This promotional offer applies to new accounts only.