Ditutup

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

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.

Kemahiran: MySQL, PHP, Redis

Lihat lagi: how to identify slow running queries in sql server 2008, mysql performance tuning, mysql slow query log example, how to find slow running query in sql server, mysql slow query log, sql query taking long time to execute, sql server query suddenly takes too long, query running slow in sql server 2012, mysql slow oscommerce site, mysql slow login, mysql slow query scripts, mysql slow write, mysql slow query count, whm mysql slow sql queries log, optimize php mysql apache cakephp, optimize mysql slow queries, optimize mysql slow query, mysql slow query, godaddy mysql slow, linux mysql slow

Tentang Majikan:
( 6 ulasan ) Las Vegas, Thailand

ID Projek: #16464417

15 pekerja bebas membida secara purata $11/jam untuk pekerjaan ini

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 Lagi

$8 USD / jam
(194 Ulasan)
7.3
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. Lagi

$8 USD / jam
(39 Ulasan)
5.0
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 / jam
(42 Ulasan)
5.1
$8 USD / jam
(22 Ulasan)
5.1
fastwebsoft

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

$8 USD / jam
(8 Ulasan)
4.4
$12 USD / jam
(21 Ulasan)
4.6
$8 USD / jam
(54 Ulasan)
4.1
SolaceInfotech

Hello, Hope you are doing well. It looks like you are looking for an experienced PHP & MySQL developer expertise who can dedicatedly work on your ongoing project to make optimization with many complicated queries us Lagi

$16 USD / jam
(3 Ulasan)
3.7
Rohit157

Dear Client, Greetings for the day! I am individual who has expertise in various technologies to satisfy all needs of my clients. I have developed a range of websites, so I know the industry and have in-depth Lagi

$12 USD / jam
(6 Ulasan)
3.3
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 Lagi

$16 USD / jam
(1 Ulasan)
0.9
$16 USD / jam
(1 Ulasan)
0.6
Trusted12

A proposal has not yet been provided

$12 USD / jam
(0 Ulasan)
0.0
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 Lagi

$12 USD / jam
(0 Ulasan)
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 Lagi

$11 USD / jam
(0 Ulasan)
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 Lagi

$12 USD / jam
(0 Ulasan)
0.0