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(‘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