We are running one PHP application with an MYSQL database.
PHP server has 8GB ram and MYSQL is a digital ocean managed database.
Everything works fine if we don't have traffic, if we have more than 1500 live users our DB server not working, it reached 100% CPU usage and throughput is very high, we already upgraded the server lot of time, but it's not working, We need some DB expert help to figure out and fix that issue.
Once it's figured, we need to know how to test this without spending our money on promotion, for now whenever we are doing promotion, we are getting lost.
Bu iş için 10 freelancer ortalamada ₹1120/saat teklif veriyor
Hi, I will check server and will fix this CPU consumption on server. I have 11 years of experience in server and hosting. Please discuss. Thank you
I can qualitatively assist with troubleshooting of database performance issues because I am exceptionally well qualified SQL developer with 10+ years' seniority and with long term professional experience in implementat Daha Fazla
Hi I have 15 years of experience in SQL server Database development, MySQL, Postgress development, C#, Python, power bi. I will be able to help you with the project. please ping me offline to discuss further
hey there, i hope you are well aware of load balancer, in php queries you mush need load balancer. if you dont mind, can you tell me which framework of php you used for your application? its my first time online but i Daha Fazla