MySQL DB needs optimization & maintenance

Closed

Description

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

Project ID: #5917433

Awarded to:

wildlily980

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

$41 USD / hour
(52 Reviews)
6.4

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

krishdts

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 : http://dreamztechusa.com/Portfolio More

$49 USD / hour
(83 Reviews)
8.3
kchg

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)
8.1
PSSPL2000

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)
7.6
rajeshsonisl

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)
7.5
ValueCoders

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)
7.1
ecomscripts

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)
7.1
AcuityInfotech

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)
6.8
eComOS

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)
6.5
leomedina01

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)
6.5
phpmysqlrocks

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)
5.7
musashi42

"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)
5.7
ruimaxwell

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)
5.7
rockeinstone

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

$35 USD / hour
(65 Reviews)
5.6
dikgenius

A proposal has not yet been provided

$25 USD / hour
(11 Reviews)
4.8
patrickjjs

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)
4.2
remotemysqldba

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)
3.5
joseluiselp

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

$30 USD / hour
(3 Reviews)
3.2
manionweb

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)
3.1
smartng

Hello, I'm a french software engineer, and I'm interested to work with you. Since 2006 I work on databases (Oracle, SQL Server and MySQL). I think I can help you for this job. If you have any questions, please se More

$33 USD / hour
(0 Reviews)
0.0
silverbladerex

A proposal has not yet been provided

$41 USD / hour
(0 Reviews)
0.0