Find Jobs
Hire Freelancers

MySQL DB needs optimization & maintenance

$25-50 USD / hour

Completed
Posted about 10 years ago

$25-50 USD / hour

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.
Project ID: 5917433

About the project

27 proposals
Remote project
Active 10 yrs ago

Looking to make some money?

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:
User Avatar
Hi I'm a mysql optimize expert. Let me help you. .................................................................................................................... Best Regards Bill
$41 USD in 2 days
5.0 (60 reviews)
6.9
6.9
27 freelancers are bidding on average $33 USD/hour for this job
User Avatar
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 !!)... you can never go wrong choosing me :) I look forward to your reply. Thanks. Kind Regards, Rajesh Soni
$52 USD in 20 days
5.0 (923 reviews)
8.5
8.5
User Avatar
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 PHP developers and they have good sound on MYSQL, JSon etc. We are excited to take effective steps further, to make this assignment as first footprint for our long-term healthy business relationship in coming days. Assuring you a Best service all the time. Look forward for working with you. Thanks and regards Sandeep Ghodasara Prakash Software Solutions Pvt Ltd (Microsoft Silver certified Company)
$39 USD in 1 day
4.9 (50 reviews)
7.6
7.6
User Avatar
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 Sphinx to store data and optmize searches and indexing, or make some changes to MySQL queries like delayed insert, and by creating some indices in the mysql tables. Please let me know your thoughts. I have read all the requirements of this project and my team can provide high quality professional results at a low cost. Please contact us for more details. Our team consists of 10 programmers/designers with over 5 years’ experience and a vast area of expertise (XHTML, CSS, PHP, JavaScript, MySQL, ASP, Logo design, banner design and much more, including CMS like WordPress, OpenCart, Drupal, Magento etc). Please check our profile, for more info. We can do this for you. I am looking forward to work on this project! Regards, Leo.
$25 USD in 1 day
4.9 (150 reviews)
6.8
6.8
User Avatar
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 in 40 days
5.0 (64 reviews)
5.7
5.7
User Avatar
A proposal has not yet been provided
$25 USD in 20 days
5.0 (30 reviews)
5.1
5.1
User Avatar
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 we can start. Looking forward to work with you. thanks
$25 USD in 10 days
5.0 (8 reviews)
4.9
4.9
User Avatar
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. i will strictly follow time limit of the project. we need to further discussion about your project. thanks & regards
$25 USD in 10 days
5.0 (18 reviews)
4.6
4.6
User Avatar
Confidence Is High. Hello, can you pm so we can talk about this?. .
$30 USD in 4 days
5.0 (12 reviews)
4.4
4.4
User Avatar
Hello, I am IT engineer with European diploma since 2005 Certified as Technical specialist in Microsoft SQL Server databases BI, i have more than 8 years in IT projects with 5 years working around databases and BI development. My last job was senior BI consultant within Accenture ,for more than 4 years .I worked for several database projects and advanced SQL development on behalf of European Customers (Carrefour, LOREAL,Eurovia ..). I have strong skills in database and Business Intelligence to develop all types of requirements related ,and given my experience, I am persuaded to give you High quality of work delivery withing budget and time Best regards,
$26 USD in 4 days
4.9 (7 reviews)
3.8
3.8
User Avatar
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 this site, it's an opportunity for you to have high quality for low price. Sincerely yours, Eric
$25 USD in 1 day
5.0 (1 review)
2.6
2.6
User Avatar
It seems that you have a very large number of records, or there might be problems on Partition and Indexing. We shall use dynamic search query procedure and indexing, if you have a very large number of records. If there are problems in Partitioning, then lets divide the data into trunks and do the summarization using the "key values", after this process retrieving the "raw data" will be much more sooner. Let me take care of this project and do the performance tuning. My confidence is high in this proposal, I am waiting with eagerness for the approval of this bid.
$25 USD in 20 days
0.0 (0 reviews)
0.0
0.0
User Avatar
A proposal has not yet been provided
$41 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
Ainda não foi fornecida uma proposta
$41 USD in 1 day
0.0 (1 review)
0.0
0.0
User Avatar
Confidence Is High Experienced software architect with 20 years in design, development and maintenance of applications. Expert in performance improvement of applications. IF you can provide me access to your database, will be able to help you improve the performance
$30 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I'm experienced full-stack Web Application Developer and having 7 years of experience in the developing, troubleshooting and maintaining the various web-projects using PHP5, MySQL, CodeIgniter, Drupal, WordPress, HTML5, CSS3, Bootstrap, JavaScript, Jquery, AJAX, JSON, Photoshop etc.
$50 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
i made a big project with large databases involved (millions of records, hundreds of tables with hundreds of fields, postgresql and mysql with innodb engine + barracuda filesystems), so i have the required experience. Regards
$42 USD in 25 days
0.0 (0 reviews)
0.0
0.0
User Avatar
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 send me a private message. Of course "Confidence Is High", as you wish. Best regards, SmartNG
$33 USD in 20 days
0.0 (0 reviews)
0.0
0.0
User Avatar
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 search file and fixing the tables, I was able to get searches able to execute within a couple seconds instead of a minute plus or failing. I have also used PHP and SQL for nearly a decade and have some of the highest scores in a variety of categories related to websites. My plan is to first actually look at what queries are being performed first. This way I can be sure the tables are actually using the most optimal engine for storing the data. I also need to review the queries because then it will help me figure out how to best index the tables. I will then clear any overhead which can accumulate over time, particularly when deleting records. You would need to specify how old data has to be for it to be pruned.
$27 USD in 5 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED STATES
Berkeley, United States
5.0
6
Payment method verified
Member since Feb 17, 2013

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.