We need an MYSQL/MariaDB with php skill expert to help us on our database.
Our current script (CRM) is causing our database server to MAX out.
Our database is using AWS RDS (db.r3.8xlarge) and with just 512 connections , the cpu usage is 100% max out at all time. Something is wrong with our script or database. We also understand we got one issue is that we did not have any proper index and when it hit the database continuously, most of the query wait for infinite time , that’s why it creates a deadlock and maximising out the cpu.
So we need an expert to help us on indexing and also mysql optimization . Also help us go through aws mysql configuration to maximum it’s usage.
Hi, Probably you need to add an index first, but the issue may be in looped queries. I have optimized MySQL many times and i'm available right now for the work. Regards, Sergio.
17 freelancers are bidding on average $536 for this job
JUST START CHAT , i am ready to start your project . We can discuss more details on chat . i assure you that i will provide you quality work. Waiting for your reply...
Hello, Can I get more details about the project? It will help us to get you a better quote. Please see our portfolio: [url removed, login to view] Lets Discuss Team OMS Coders