In Progress

MySQL DB needs optimization & maintenance

I currently have a family of php scripts that feed data to a MySQL instance, the data can then be read by JSON requests. Recently the query performance has taken a hit and JSON requests time out. The tables need to be properly indexed and fields typed for performance; in addition, some sort of automated maintenance initiated that prunes older data.

Skills: Database Administration, MySQL, PHP

See more: mysql db, Query optimization, json and mysql, db query, mysql performance optimization, mysql sort, automated scripts mysql, php read json, mysql family, query performance, json query, php json mysql, mysql query optimization, json feed query mysql, mysql json feed, Performance Optimization, json mysql feed, mysql json fields, maintenance tables, mysql php json, feed json, json feed, php mysql json, automated php scripts, feed mysql data json

About the Employer:
( 5 reviews ) Berkeley, United States

Project ID: #5917433

Awarded to:


Hi I'm a mysql optimize expert. Let me help you. .................................................................................................................... Best Regards Bill

$41 USD / hour
(52 Reviews)

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


Greetings, This is Kris from DreamzTechUSA. Please open the chat room so we can discuss this in details. To get an idea of the quality of our work you can check the below link : [url removed, login to view] More

$49 USD / hour
(83 Reviews)

Hi Sir! I am very interested in your job. Please get in touch. I can start it right now and can complete perfectly. My rank in freelancer is 8th and I am not broker, only developer. I hope you to work with me. Yo More

$51 USD / hour
(201 Reviews)

Hi Greetings!! Thank you very much for giving me opportunity to bid on your project. i Have gone through your requirement and can surely help you with this wonderful project. We are having team of experienced More

$39 USD / hour
(46 Reviews)

Hello, Confidence Is High With 99% completion rate, 700 successfully completed projects, and a 5.00 reputation (maximum possible, 5.0) (Yes, not even 4.99 average rating, can be verified on my profile page !!)... More

$52 USD / hour
(508 Reviews)

Hi, Greetings of the day! Thanks for posting the project on Freelancer; this project completely falls under our area of interest and specialization. We are excited to work for you. Project Requirement: -With refe More

$29 USD / hour
(116 Reviews)

Dear Client, Greetings!! As per the requirements, I am glad to assist you for this project as we have huge expertise custom back-end development using PHP/MySQL. So would like know what all sort of problem you ar More

$25 USD / hour
(11 Reviews)

Hi,    We’ve had a good look at your project description and we’re very interested in providing a solution. How big the DB is in MB? The largest table is containing how many rows? Please PM us more about the job. More

$26 USD / hour
(33 Reviews)

Dear sir, I will complete your project within 0 day, LIFETIME free bug guarantee and provide ONE YEAR support... I have gone through your outsourced requirement "MySQL DB needs optimization & maintenance" and ha More

$33 USD / hour
(83 Reviews)

Hello, My name is Leonardo and I represent Medina Technologies, a web company focused in design and web development, located in Rio de Janeiro, Brazil. For your project, we can either use another solution like Sphi More

$25 USD / hour
(112 Reviews)

Hello sir, I am PHP , MYsql expert having 5+ year of experience Let me optimized your database and script. Thanks Chirag

$39 USD / hour
(43 Reviews)

"Confidence Is High" Hi, I'm very interested in Your offer. I have over 10 years of experience in the field of coding(php/mysql, c/c++, perl, python and basics of assembly). I have done coding from scratch, custom codi More

$27 USD / hour
(21 Reviews)

Hi there, I have good experience with MySQL and optimization, millions of rows, indexes and performance are no problem for me. Thanks Rui

$25 USD / hour
(57 Reviews)

Hello, can I see the current script and/or table structure? Regards, Rocky .......................

$35 USD / hour
(65 Reviews)

A proposal has not yet been provided

$25 USD / hour
(11 Reviews)

Hi, We are experts in PHP & MySql. We can handle your project and give you the optimized solution. We have been in offshore software development more than a decade. We can assure you a good result. Let me know when More

$25 USD / hour
(2 Reviews)

Hi Team, I am a expert MySQL DBA in optimization. Based on your requirement i believe that databases was not installed with right variables. I can help you in optimizing the queries and indexing them forthe best per More

$30 USD / hour
(5 Reviews)

Confidence Is High. Hello, can you pm so we can talk about this?. .

$30 USD / hour
(3 Reviews)

Sir, Lets start the work. Please send your detail so that i can start the wonk as soon as possibele I am professional php developer with 7 years of experience. I can handle your project efficiently with support. More

$25 USD / hour
(9 Reviews)

Hi, I'm a professional DataBase Administrator. It shouldn't take very long unless your database is not surprisingly complex. A few hours should do. I put a low bid because i have to establish my reputation in thi More

$25 USD / hour
(0 Reviews)

My confidence is high that I will be able to help you because I have worked with both large and small databases. The largest database I dealt with was for a forum that had over 1 million posts. Between editing the se More

$27 USD / hour
(0 Reviews)