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

종료 등록 시간: 6년 전 착불
종료

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.

MySQL PHP Redis

프로젝트 ID: #16464417

프로젝트 소개

14 건(제안서) 재택 근무형 프로젝트 서비스 이용 중: 5년 전

이 일자리에 대한 프리랜서 14 명의 평균 입찰가: $11 (1시간 기준)

Euphontec

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. Look 기타

$8 USD / (1시간 기준)
(195 리뷰)
7.4
pakistansolution

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. 기타

$8 USD / (1시간 기준)
(66 리뷰)
5.7
fastwebsoft

hello sir, I have great knowledge in core development and more than 4 year experience . thanks

$8 USD / (1시간 기준)
(22 리뷰)
5.1
vinaysinghh

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 / (1시간 기준)
(46 리뷰)
5.2
vaidyag

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 v 기타

$16 USD / (1시간 기준)
(2 리뷰)
1.4
fernandocardim

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 기타

$12 USD / (1시간 기준)
(1 리뷰)
0.8
Trusted12

A proposal has not yet been provided

$12 USD / (1시간 기준)
(0 리뷰)
0.0
ivanot

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 datab 기타

$11 USD / (1시간 기준)
(0 리뷰)
0.0
bkwas

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 specifi 기타

$12 USD / (1시간 기준)
(0 리뷰)
0.0