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

$8-15 USD / hour

Kapalı

İlan edilme:

yaklaşık 6 yıl önce

$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.

MySQL

PHP

Redis

Proje No: 16464417

Proje hakkında

14 teklif

Uzaktan proje

Son aktiviteden bu yana geçen zaman 6 yıl önce

Biraz para mı kazanmak istiyorsunuz?

E-posta adresi

Freelancer'da teklif vermenin faydaları

Bütçenizi ve zaman çerçevenizi belirleyin

Çalışmanız için ödeme alın

Teklifinizin ana hatlarını belirleyin

Kaydolmak ve işlere teklif vermek ücretsizdir

14 freelancer bu proje için ortalama $11 USD/ saat teklif veriyor

@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. Looking forward hearing from you. Thanks and Regards Ramesh

$8 USD 40 gün içinde

5,0

(195 değerlendirme)

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. I have a lot of experience in designing and development works. We can discuss any details over chat, Thanks :)

$8 USD 10 gün içinde

4,9

(66 değerlendirme)

5,7

@fastwebsoft

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

$8 USD 40 gün içinde

4,9

(22 değerlendirme)

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 40 gün içinde

4,9

(46 değerlendirme)

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 vaidy

$16 USD 40 gün içinde

5,0

(2 değerlendirme)

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 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 40 gün içinde

4,0

(1 değerlendirme)

0,8

@Trusted12

A proposal has not yet been provided

$12 USD 10 gün içinde

0,0

(0 değerlendirme)

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 database design, sql databases, mysql, postgres and php wrappers to BDs.

$11 USD 20 gün içinde

0,0

(0 değerlendirme)

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 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 40 gün içinde