Looking for a Programmer that is an expert in Woo Commerce, Wordpress, PHP, Mysql Databases, Apache as well as working with a Plesk Server. I have worked with two other GAF programmers and they could not offer any solutions. One programmer said it was a Database problem, the other said it is a Plesk problem. Below is a description of the problems that I am having and need to have them fixed asap. If you cannot start this job immediately please do not bid. I will only pay if the problem is fixed, so do not bid unless you have expertise in all the fields I mentioned in the job description. When you respond to this job order, you must state your course of action to repair this and if you have worked on similar problem for another client I would like to hear more about the solutions you came up with!
1.) The site runs very slow on the back end. Just changing the price in a product listing can take up to 54 seconds to refresh. Sometimes it times out and I get 504-Gateway Timeout message or a connection loss to server message.
2.) My hosting company has blamed this on various things- see below.
a. Found in the [login to view URL] that the max children were being exceeded. Set the children to the following based on Plesk suggestion:
pm = dynamic
pm.max_children = 25
pm.start_servers = 10
pm.min_spare_servers = 5
pm.max_spare_servers = 20
pm.max_requests = 498
b.) I logged in to your server and saw the CPU pegged at 100%. The MySQL process was what was consuming the CPU. This was causing your processes to hang and give the 504 error. More processors will help. I would suggest 8 processors and 8GB of memory to start with.
c.)I'm also seeing out of memory entries in the log for php and mysql. Bump the memory up to 16GB and 8 CPU cores. If you can get to this now, we can monitor throughout the day.
3.) Now when my customers check out they are getting time out message or the screen locks up and they are not sure if the order went through.
21 freelancers are bidding on average $166 for this job
I deal with these types of issues all the time, I've been in the business for 17 years full-time. This won't be a guesswork project for me, I will execute quickly and professionally. Message me so we can chat!