Need MYSQL DB expert
₹400-750 INR / jam
Hi,
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.
ID Proyek: #30129058
Tentang proyek
9 freelancer rata-rata menawar ₹1189/jam untuk pekerjaan ini
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
Hello, i'm expert Database servers, i can help you and check what exactly hitting your Mysql Server and make this high CPU consuming, in addition to tuning your Mysql Server performance to be able to get more traffic w Lebih banyak
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 Lebih banyak
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
Your queries to read/write DB are not efficient. They need to be fixed. I can take care of them. Also I will take a look into your server configuration if needed or to check if we can do some optimization there as well Lebih banyak
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 Lebih banyak