Question
500 server errors when updating more than 50 products with variations
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(‘WPMEMORYLIMIT’, “2048M”);
iniset('memorylimit’, “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( 'WPALLOWMULTISITE’, true );
define('MULTISITE’, true);
define('SUBDOMAININSTALL’, false);
define('DOMAINCURRENTSITE’, 'mysite.co.uk’);
define('PATHCURRENTSITE’, ’/’);
define('SITEIDCURRENTSITE’, 1);
define('BLOGIDCURRENT_SITE’, 1);
Also have this
/** Sets up WordPress vars and included files. */
requireonce(ABSPATH . 'wp-settings.php’);
define('CONCATENATESCRIPTS’, false);
My PHP.ini has silly settings such as
maxexecutiontime = 30000
maxinputtime = 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
These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.
×