So I've created a new installation and I'm having issues creating configurable products
I'm using magento version 2.2.3ts a new installation on a site ground cloud serversettings6corememory 8gbssd 60gbPhp version 7.0.29php.ini set through php variable managerupload_max_filesize:1000Mmax_execution_time:18000memory_limit:2048Mmax_input_time:18000max_input_vars:3000post_max_size:1000M
Not using the ssl at the moment, to see if that was the problem, but the problem is still therewhen we do a readiness check its only registering 1024M not 2048MBut when we were installing magento on the server it did see the php version change.
initally we were having a ERROR 504 - GATEWAY TIMEOUT nginx
But that was solved by the very helpful advice of @ManthanDave by adding
fastcgi_read_timeout 600;proxy_read_timeout 600;
But it still takes forever for magento to communicate with the database by the time it times out
the maximum products it saves is 40 variations in 10 mins and then fails the rest
My hosting provider has said
“There is a script within the application that causes the database to generate slow MySQL queries.”
But it’s a brand new installation, so I don’t understand why that would happen.
Regardless I installed magento again using another a fresh installation files and the problem happened again
I put it in production mode and I’ve used static deploy, but the problem is still persists
Some help would be great