MySql Database Expert requires URGENTLY

$250-750 USD

Completed

Posted

over 7 years ago

$250-750 USD

Paid on delivery

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.

Database Administration

Project ID: 11407557

About the project

15 proposals

Remote project

Active 8 yrs ago

Looking to make some money?

Email address

Benefits of bidding on Freelancer

Set your budget and timeframe

Get paid for your work

Outline your proposal

It's free to sign up and bid on jobs

Awarded to:

@sergioes

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.

$400 USD in 10 days

5.0

(277 reviews)

7.4

15 freelancers are bidding on average $541 USD for this job

@akash9958

Hello, "I read through the job details carefully and I can do this job perfectly. Please come in chat so we can discuss it further". We are the team of 8 employees and over past 6 years we have completed 500+ projects in web application projects. We also work on Android application development. Please check my profile review for your ready reference: https://www.freelancer.com/u/akash9958.html Looking forward to hearing from you. Thanks. Puja Singh

$1,000 USD in 10 days

5.0

(261 reviews)

8.5

@baberzaman

Hi Sir, I am an expert of MySql And PHP. I have about 5+years working experience in both said skills. I can do anything with these skills.

$444 USD in 2 days

4.7

(141 reviews)

6.6

@usamae

Hi. I understand your requirements and I can inspect your db usage, your script and fix / improve it wherever possible. I have been managing SaaS apps since a long time on AWS and can assure you that i can fix your issue :) Waiting to hear from you, usamae

$555 USD in 10 days

4.9

(84 reviews)

6.1

@sharmin283

Hello, i am very interested to do your project. i can fix all your database issue properly. I am a hard working, motivated worker, who have great php with mysql skills. I know what is required in terms of work and the pressures I have to deal with. I am available to chat by IM, email or Skype. i have own PC First internet I will be able to start immediately and i will complete this job within time. Regards Sharmin

$722 USD in 1 day

5.0

(29 reviews)

5.4

@teguhpanjaitan

Hi, I'm experienced web developer and able to help you to tune up and fix your mysql server. I ever managed morethan 1 million data for affiliate data feed with high performance. I believe I can help you on this, to optimize your mysql. I have alot of experienced in developing web as at the past I was a technical manager of an affiliate company. I'm able to make a complicated web apps and combine with mobile apps with a good structure. Let's talk more detail over chat. Please feel free to check my portfolio in my profile https://www.freelancer.com/u/teguhpanjaitan.html so you get a clear view about me. Hopefully I can see your positive response over chat and don't hesitate to ask me something about me/project requirement if you need. Regards, Teguh

$600 USD in 10 days