Optimization of slow mySQL queries on Amazon Web Services

Closed

Description

We currently have an EC2 and RDS instance with Amazon Web Services. Our site is written in PHP, and the database is mySQL. We're running into slow queries on some pages and want to figure out alternatives to resolving the issues. The queries involve joins of two tables that have about 3 million records each, and a third table that has about 40,000 records. We've managed to improve our query time somewhat by experimenting with the queries, but it was still far too slow. We then tried experimenting with the parameter settings in RDS, but there wasn't any noticeable improvement, and in some cases it was worse. We're on a somewhat limited budget at the moment, and so upgrading our RDS instance is a last-resort option. However, if that's our only option at this point for marked improvement that still meets our business needs, we'd like to verify that as well. So, we're looking for someone who can help us with the following:

1) If possible at the outset, confirm whether our issues would require an upgrade of our instance or other fundamental platform changes to be improved.

2) Examine our queries to see if they can be optimized further

3) Examine our parameter group settings and recommend changes

4) If neither 2) or 3) resolve the issue, recommend changes to the data structure that could improve performance

5) Revisit question of fundamental platform changes

We're also looking for someone who can advise us on how to avoid slowdown of the site while our product import is running, but ability to help with this part of the project will not be necessary in order to be awarded the contract.

Because of the open-ended nature of this project, we would be paying by the hour, but we would have a cap on the number of hours spent on the project that could be extended by mutual agreement. The initial cap would be four hours of work. The data model will be provided once we have selected a contractor.

Skills: Amazon Web Services, MySQL

See more: web site optimization services, web contractor, tables in data structure, services contract model, question of data structure, mutual business agreement, model services agreement, looking for web services, fundamental of data structure in c, fundamental of data structure, far part 27, contract on services, contract of services agreement, contract of agreement for services, contract for it services, contract for business services, business services contract, business contract services, business contract for services, agreement services, agreement of services, web performance optimization, so slow, rds database, how to work for amazon

Project ID: #5365602

Awarded to:

leadconcept

Dear Sir, I have read your Project Description and for such projects, initially we need few hours to understand the existing code, structure etc. So, this initial message is just a formal confirmation that we ar More

$30 USD / hour
(35 Reviews)
8.1

22 freelancers are bidding on average $33/hour for this job

technosystem

Kindly accept my bid for your AWS web services project and be assured of a high quality work with our highly experienced and dedicated developers. Thanks

$41 USD / hour
(12 Reviews)
7.9
PSSPL2000

Hi Greetings !!! Thank you very much for giving me opportunity to bid on your project. We are having team of Microsoft Certified developers and they have good sound on AWS, cloudsearch, elasticsearch. .Net techno More

$25 USD / hour
(44 Reviews)
7.6
coolguyinus2004

php/mysql programmer with 10+ years of exp in programming. to fix tables of million records you cant use join at all in queries. instead you need to use another script in cronjob to put those results in another tabl More

$41 USD / hour
(171 Reviews)
7.0
meet2amitvw

Let's discuss over freelancer Personal Message Box for the proper estimation of cost and time. I am myself doing programming so you will directly work with one person and that's me. No mediators. No managers. No sub More

$25 USD / hour
(53 Reviews)
6.9
superior5

I have done similar project earlier and ready to help you out in it. I am not asking for ANY UPFRONT Money, pay me when you are satisfied with the progress.

$38 USD / hour
(49 Reviews)
7.2
kchg

Hi, Sir I am a member of powerful develop team Before, our team made our own db for NVR(network video system) So , we have db inquiry optimization theory If you want , i will show our own db Now, i want to discu More

$30 USD / hour
(56 Reviews)
6.4
iteraresearch

Hi there! We are developing the project with very huge MySQL DB (about 4 000 000 000 records) and certainly have corresponding experience in fine tuning whole system including OS and DB. We can user our developers/admi More

$25 USD / hour
(31 Reviews)
6.2
foreignt

Hello, My name is Vladimir Shekhovtsov, CTO at Zeus Electronics. We are Ukrainian outsourcing company with 5 years experience in web and mobile applications development. Our portfolio consists of more than 70+ web r More

$25 USD / hour
(17 Reviews)
6.0
datadiggers

Hello, I'm one of those freelancers here who actually read project description... I rarely suggest hardware upgrades to my clients, and I never do it before optimization process. I'm former MySQL database adminis More

$50 USD / hour
(12 Reviews)
5.9
Kilr0y

Hey. I can try to help you. My specializations are small amendments and bugfixes on the sites. If I will not be able to resolve ur problems, will cancel milestone. Ready to start right now. Regards, Alexander.

$33 USD / hour
(13 Reviews)
4.6
esteghlali

A proposal has not yet been provided

$38 USD / hour
(3 Reviews)
4.1
xyzrkt

Hello Sir, Thank you for taking time to have a look on my message. I have core expertise in the technologies like:- - PHP - Wordpress - MYSQL - HTML - CSS - Bootstrap - PSD To HTML - JavaScript - JQuer More

$30 USD / hour
(12 Reviews)
3.9
loufyla

Hello, I'm interested by your project since I have working with PHP and MySQL for more than 8 years now so I have had the opportunity to optimize mysql queries and table structure quite a lot of times. That's why I More

$27 USD / hour
(5 Reviews)
3.8
proauthor

Dear employer, I've good expertize in MySQL query optimization. Please send in further details to proceed with the project. I'm ready to start working on the project. Looking forward to working with you. Awaiting a More

$25 USD / hour
(4 Reviews)
3.6
partsgr12

Hi, I am DB developer with PHP experience I can help with tuning slow queries. I charge $28/hr As proposed try my service for first 4 hours with queries which are taking substantial time If you find acceptab More

$27 USD / hour
(2 Reviews)
3.3
KarolRobens

Hi I can help you with your problem, I got a lot of experience with mysql query turing on terabyte database systems. Please contact with me to discuss details and agree on final price.

$33 USD / hour
(2 Reviews)
2.3
expertvillage

Hello, Greetings from Expert Village Media Technologies! I have gone through all the requirements that you have mentioned. --- Please take a look at our Amazon/Volusion profile on major platform: --- http://webstor More

$39 USD / hour
(1 Review)
2.0
quiarit

We have experience tuning Mysql, Postgres and Oracle Database instance. Based on years of designing and performance experience, we design a performance methodology to resolve tuning problems analyzing... - Memory t More

$38 USD / hour
(0 Reviews)
0.0
remotemysqldba

I am a mysql dba just interested work more.I work as a freelancer for my satisfaction. I used to write and talk about mysql. I am keenly interested to take this work. I never mind even if you does not pay. My blog is More

$25 USD / hour
(0 Reviews)
0.0
scripish

Hi, As I am a professional Tech Lead and having knowledge in AWS, I hope I can fine tune your database, please if you like to award me, let me know

$38 USD / hour
(0 Reviews)
0.0