Expected duration: 1 day or less We have recently (10 days ago) migrated our Magento 1 site onto a new Magento 2 site.
Site is: www.backstitch.co.uk
This is a site I have developed myself, admittedly a steep learning curve even after many years managing our Magento 1 site. Since this we have been having major issues with the server being overloaded. We have seen a very low conversion rate compared to normal, and our shop staff are struggling to cope with a slow system.
Even with very low visitors and order numbers being processed (we also have a POS system on the site) all will work OK for a hour or two and then the MySQL usage will rocket up to over 500% of CPU, and server load average will climb to 7, 8 or 9. Restarting the MySQL server solves this.
The site has 12600 products.
We initially thought this was an issue with indexing as many of the indexes were seeming to get stuck. Some suggestions were made by the server support people including upgrading MySQL and reducing frequency of indexing. In the end I have set some indexes to 'update on save' (this may not be the right thing to do!) We have also, at the server supports recommendation doubled the RAM on our server. This doesn't seem to have made any difference to the problem.
Server current specs: Cores 8 x Intel Xeon Processor 1 x Intel Xeon E3 RAM 32GB
PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND 17206 mysql 20 0 13.8g 5.9g 15104 S 503.3 18.9 171:41.96 mysqld
We have booked in for a server upgrade to:
Cores 8 x Intel Xeon 4Ghx Processor 1 x Intel Xeon E3-1270 v5 RAM 64GB - 2133MT/s DDR4
But this will not happen for a few day.
My concern is that there is an underlying issue here, perhaps with some configuration (either in Magento or on the server), or with one of the extensions I've installed.
I would like to find someone who can look at this as soon as possible (ideally tomorrow morning - Tuesday 8th) and spend a few hours trying to figure out what is wrong. We will be also willing to pay for a few hours of fixing any issues found.
We're willing to pay for a prompt response.
We are also looking to build a relationship with someone who can help with customisation in the future. We have a few major features we would like to add to the site over the coming months.