Optimization of slow mySQL queries on Amazon Web Services

Budget $25 - $50 USD / hour
Bids 23
Average Bid $33

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.

Post a Project Like This

This project was awarded to

leadconcept

Overall, working with LeadConcept was a great experience. YK and his team are extremely professional, friendly, and dedicated. They took on my huge project (which a previous company had failed at) and completed it to my satisfaction. If this team could improve one thing, however, it would be testing/quality assurance. To be honest, I was frustrated at some points throughout the project because of the large number of bugs that could have been easily avoided by thorough simple testing prior to sending the build to me. However, the company is very attentive to its clients' needs, so I am sure that, based on my feedback, they will improve this area of their services. They were extremely dedicated to my project even when I had high standards and maintained regular communication with me via email and IM. They always worked with me until the site worked as I wanted it to. I believe that I got excellent value for the services that I paid for, and I would definitely recommend this company.
About the Freelancer
leadconcept Profile Picture

Greetings. LEADconcept is located at Lahore, Pakistan [GMT +5 hours] and our front office is functional in California, US. We are an established Company with experienced team since 2003 and our clients are spread in all over the sphere such as US, UK, Canada, Europe & other countries. We can self-assuredly provide you references of our past client's for you to verify our company reputation. No beating around the bush, please go ahead and verify what our clients declare about LEADconcept from our Freelancer review/ratings. Our team area of expertise & Skills: Web Applications & Custom Development, OpenSource Customization, WordPress CMS Websites, WooCommerce, Joomla, Drupal, OpenCart, Magento, Cs-Cart, Prestashop, Bigcommerce, Shopify etc., Native Mobile Apps (iOS & Android), Responsive websites, Custom eCommerce Solution, PHP/MySQL, CodeIgniter, Zend, Yii, Laravel and other Frameworks, ASP.NET, VB.NET, C#, , JavaScript, jQuery, AJAX. HTML 5, API Integration. Thank you, LEADconcept

Looking to make some money?

  • Set your budget and the time frame
  • Outline your proposal
  • Get paid for your work

Bids on this Project

  • datadiggers Profile Picture

    datadiggers

    Barlinek,  Poland

    I make websites faster. I optimize for speed MySQL and Magento. I work ONLY on projects related to performance optimization. What I can do for You ================ - speed up Your website (1-2 second complete page loads), - optimize MySQL server (includes complete audit, query rewriting etc.) - make Magento super fast (1-2 second complete page loads), - improve Your GTMetrix or PageSpeed score to 90+/90+ or even 100/100, - install and configure Varnish, Memcached, Redis and more, - explain everything I'm doing with Your site/server, - provide work log and reports with list of all changes I've made. I also work on other types of optimization projects - PHP code optimization (with profiler), general HTML/CSS/JavaScript optimization projects. I'm also Java developer and I can speed up Your Java code too. I can set up and tune for best performance Nginx, Apache and MySQL clusters. I've worked with small, medium and huge databases (from 1MB to 100GB of data). Who I am ================ I always work with caution, making backups before touching anything else. I'm reliable person which will work on Sunday (if needed) to make sure that Your site is up and running. We can communicate through email, Skype, phone or Google Hangouts. My English is quite good (contrary to many other freelancers I didn't hire anyone to write this text for me). I never failed on any project and I have exceptionally high repeat hire rate (at least in terms of Freelancer.com standards). How to NOT hire a freelancer ================ Even if You decide to not hire me consider those tips when choosing a freelancer - especially if You don't have much experience: - consider only freelancers who can finish their projects, the ones with 95%+ completion rate, - consider only freelancers with high repeat hire rate ( 20% or more) - if it's lower it means that his/hers clients were not satisfied with their work, - most reviews are SPAM and come from colleagues, - do not be impressed by Freelancer.com green score (the one in 0.0 - 10.0 range) - it does not reflect how often freelancer fails on project, his ratings etc.

    PHP, Javascript, XML, and Website Design

  • remotemysqldba Profile Picture

    remotemysqldba

    Bangalore,  India

    I am a Expert MySQL DBA with 5 plus year of experience on MySQL / MariaDB servers. I have helped many startup to scale well in MySQL . Have a lot interest to in MySQL servers . Have entered this freelancer for challenging activities.

    PHP, Graphic Design, System Admin, and Linux

  • scripish Profile Picture

    scripish

    Colombo,  Sri Lanka

    I am a Software Engineer who works in a reputed company for the last 6 years in .net technologies especially in Amazon Web Services, vb.net, c#.net, Zebra label printer ETL and also MySQL, MS SQL Server Programmings.In the meanwhile I am working on Amazon API, Excel Add In for Amazon and Amazon Crawling scraping (AWS & MWS) which is to produce a csv at the end. I have developed many automation bots for forum, social, feed and article sites for automatic posting.Other than that I also have good experience in SQL Server, MySQL and SQL functions. I have some web experience too in Wordpress, PHP and HTML etc I am very friendly character. Very dynamic and flexible personality in reality

    PHP, XML, Visual Basic, and .NET

  • expertvillage Profile Picture

    expertvillage

    Indore,  India

    Expert Village Media is a professional Shopify Ecommerce Web design, Custom Web Development and Mobile Application Development Company. We provide complete web design and internet marketing solutions. We work on Amazon Webstore, Shopify Apps, Shopify Theme Design, Magento, Bigcommerce, Drupal, Wordpress Responsive web design, Volusion store design, wordpress plugin development, iphone application development and android application development. Facts and Figures - - We have done more than 700 websites so far - We have been approved by Amazon Webstore as their implementation providers - We have more than 500 clients from USA, UK, Australia and all over the world - Our wordpress plugins and mobile apps have reached more than 4000 users so far

    PHP, Javascript, XML, and Script Install

  • proauthor Profile Picture

    proauthor

    Hyderabad,  India

    I've 13+ years of experience in the web application development on various topics. My expertise includes Java/J2EE, web scraping, wordpress and Magento technologies. I always try to ensure that there is excellence in my delivered work. I will even provide support, after completion of the project, for a short span. So, you're assured that you get the best when you choose me.

    PHP, Java, Javascript, and XML

  • quiarit Profile Picture

    quiarit

    La Plata - City Bell,  Argentina

    A través de todos estos años hemos sumado y capitalizado la experiencia en el establecimiento, diseño y desarrollo de soluciones integrales de negocio. Analizamos el entorno del problema de negocio e incorporamos los procesos y la tecnología para brindar una solución completa. Ofrecemos el servicio de consultoría y asesoramiento a empresas ayudando a reducir costos de implementación y mantenimiento como así también la maximización de los recursos disponibles. Consultoria Linux Consultoria Oracle Consultoria Open Source Servicio Técnico Especializado 7x24

    Linux, SQL, Oracle, and Shell Script

  • foreignt Profile Picture

    foreignt

    London,  United Kingdom

    Zeus is an app development studio managed by old mature tech-pros and young technology addicted geeks. Established in 2006. From the very begging we worked on establishment of trustful and fruitful win-win relations with serial entrepreneurs/agencies/startups from across of globe (the USA, Australia, Canada, Western Europe, Eastern Europe, Israel and Far East). Combination of old-gurus' expertise with young energy and talent let us to provide full-cycle mobile & web apps development services. We strive to think different in almost any corner of our service delivery model. Unlike most outsourcing companies we are not working as faceless body-shops or annoying proposal spammers. Our communication model and approach let our clients to move their focus to most essential product related questions such as marketing, and strategy. At that time we are providing to our clients transparent development/QA process combined with our free-of-charge consulting/advices of our clients about possible ways of product improvement and launch strategies. Our international expertise let us to be able to grow together with a client from ground to multimillion sky products.

    PHP, C Programming, Java, and Javascript

  • iteraresearch Profile Picture

    iteraresearch

    Kharkiv,  Ukraine

    Custom software products and applications development | Web and UI design and coding | Managed services and support | Outsourcing, outstaffing | Consulting | Quality assurance and Application testing

    PHP, Javascript, Website Design, and AJAX

  • PSSPL2000 Profile Picture

    PSSPL2000

    Vadodara,  India

    Prakash Software Solutions Pvt. Ltd. is a software development company based in India specialized in Custom Application Development, Quality Check, Analysis and IT consulting. Services: • Cloud based Systems - Architecting, Build, Development, Implementation, Cloud Infra Management • Web Application Design and Development • Microsoft Public Cloud Architect, Design, Build and Deploy. – includes Office365 SharePoint Online, Skype for Business, Exchange Online, Yammer, Delve, Power BI, Visio and Project Online • Office 365 Migration Services for SharePoint • SharePoint Architecting, Design, Development and Implementation. • Microsoft Enterprise Project Management (EPM) Solutions • SharePoint Migration • SharePoint Business Intelligence • SharePoint Branding • SharePoint Work Flow • SharePoint Web Parts • Migration and Re-engineering • Rich Internet Application Development • CMS Development • E-Commerce application development • Mobile Application Development

    PHP, ASP, JSP, and Javascript

  • superior5 Profile Picture

    superior5

    karachi,  Pakistan

    I am expert in Software and IT consultancy. I have got 10+ years of experience in technology.

    PHP, ASP, C Programming, and Java