Find Jobs
Hire Freelancers

Optimize and diagnose MySQL slow queries including adding indexes, re-writing queries and adjusting code logic to optimize efficiency

$8-15 USD / hour

Closed
Posted about 6 years ago

$8-15 USD / hour

I need someone who is experienced in MySQL specifically advanced optimization with many complicated queries using multiple joins, wheres, and etc. This person should know best practices to maximize efficiency when it comes to indexes and how to write optimal queries. (example which of "not in", "left join", and "not exists" is the optimal query type to maximize speed). This person should also be able to look at my code and suggest re-writes to increase code optimization in combination with MySQL optimization so that the code + mysql work as quickly as possible together to achieve fastest response times. Code is PHP and some NodeJS MySQL 5.6 Experience with Redis in combination with PHP and NodeJS is a plus, if you have this experience please note that in your bid.
Project ID: 16464417

About the project

14 proposals
Remote project
Active 6 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
14 freelancers are bidding on average $11 USD/hour for this job
User Avatar
hi there I am experienced over 6 years in PHP MySQL 5.6 Node JS and is confident working on the optimization. Kindly view my profile in freelancer Please feel free to be in touch with further details. Looking forward hearing from you. Thanks and Regards Ramesh
$8 USD in 40 days
5.0 (195 reviews)
7.4
7.4
User Avatar
I am a professional web designer and developer. Experience in with HTML, CSS, JS, jQuery, PHP, Laravel,MySQL. Very familiar with WordPress , MAgento , wooCommerce , Bootstrap ,Plugins ,API's and its customization. I have a lot of experience in designing and development works. We can discuss any details over chat, Thanks :)
$8 USD in 10 days
4.9 (66 reviews)
5.7
5.7
User Avatar
hello sir, I have great knowledge in core development and more than 4 year experience . thanks
$8 USD in 40 days
4.9 (22 reviews)
5.1
5.1
User Avatar
i am mysql dba having more then 8 yrs of exp..............i am expert in optimization database on server level and also query level..........................................
$11 USD in 40 days
4.9 (46 reviews)
5.2
5.2
User Avatar
Hi I have extensive working knowledge in database related programs . I have worked in MYSQL also. Do you have any benchmark that you want to achieve as part of this tuning process? that will help regards vaidy
$16 USD in 40 days
5.0 (2 reviews)
1.4
1.4
User Avatar
Hello, Database normalization is a task for someone experienced with huge databases and it is something not very usual, unless if you work in industries as banks and engineering. I have the experience that you need to optimize your queries and normalize your database setting all necessary parameters (keys, indexes and so on) in order to make your performance better. - I have huge experience with PHP and Mysql - I've been working with NodeJS for IoT projects Let me know more information about your database (size and number of tables) in order to estimate time to conclude the works. Best Regards, Fernando.
$12 USD in 40 days
4.0 (1 review)
0.8
0.8
User Avatar
A proposal has not yet been provided
$12 USD in 10 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi I have optimized codes and programs. I've treated with slow queries and I fixed its. I have experience about algorithms analysis and design.i Do no have redis experience but I learn fast and i've experience on database design, sql databases, mysql, postgres and php wrappers to BDs.
$11 USD in 20 days
0.0 (0 reviews)
0.0
0.0
User Avatar
An experienced Database Administrator having expertise in Oracle, MySQL and MS SQL knowledgeable in all aspects of database administration; specialized in high-visibility production and development environments specifically within the financial, software, telecom/ISP and education industry. Experience in database design, build, optimization, complex SQL query writing and experience with high-availability, business critical application databases. Frequently work with Developers, Project Managers, Enterprise Architects, and Release Management to ensure delivery of quality and timely solutions. Comprehensive knowledge of disaster recovery planning and techniques, including: Data Guard, RAC, MySQL & SQL replication, MySQL NDB cluster, Log Shipping, Mirroring, Alwayson Availability Group, SQL Fail-over Clustering, RMAN, ASM,ACFS, GRID INFRASTRUCTURE
$12 USD in 40 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of THAILAND
Las Vegas, Thailand
5.0
8
Payment method verified
Member since May 6, 2016

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.