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.
10 freelancer chào giá trung bình ₹1120/giờ cho công việc này
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