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