Kapalı

MySQL Performance tuning + frontend speed optimization for huge Magento CE site

I am looking for a DBA top expert in optimizing and performance tuning of mysql server and deep knowledge of PHP7.

Here is basic detail for what I am looking for:

1) We have huge magento catalog of 200k products in 3 languages (600k in total)

2) Daily there is insert/updation of 200000 products

3) This insertion/updation is taking too much time (around 2 hours main import + 1 hour for indexing)

4) Frontend loading is slow, means read queries are also slow.

5) You should know all about innodb and EAV (Entity Attribute Value) structure.

6) CPU takes 500% of cpu while doing magento indexing processes.

7) Reduce TTFB, reduce connect time, reduce full onload time

8) Solve Nginx 504 error connection timeout

Site is running on dedicated server with code profiler enabled at bottom of each page. DB and webserver running on same machine and this can not be changed.

Server specifications: Intel Xeon 8 cores @ 3.30GHz, 128GB Memory, Samsung Pro ssd's, Magento CE 1.9.3.4, PHP7, MySQL, Varnish Cache + Turpentine, Nginx

[login to view URL]

attached: example slow queries home page and 1 single product page

It is mandatory you provide a road map how you will achive the above requirements and a portfolio of past clients where you worked solely on speed optimisation tuning.

If you break the current functionality you need to fix it. Payment will be done in parts and only after major improvements. I will not pay anything if no major tuning is done or if you waste my time.

Do not bid if you have no experience with this sort of large catalogs.

A big plus is having in depth expertise in tuning varnish + turpentine and nginx also!

When your quote is accepted you will need to sign NDA.

We have already done basic optimization, so only expert apply please thank you.

Beceriler: Veri Tabanı Yönetimi, MySQL, Nginx, PHP, Varnish Cache

Daha fazlasını gör: jboss optimization & performance tuning freelance corporate trainer, mysql performance optimization, mysql performance tuning, magento performance optimization, magento2 php.ini settings, speed up magento 2, how to reduce page load time in magento, magento website loading very slow, magento speed optimization extension, magento mysql optimization, how to make magento website faster, php, html, website design, magento, wordpress, shopping carts, database administration, database development, magento developer

İşveren Hakkında:
( 11 değerlendirme ) Asse, Belgium

Proje NO: #15602491

Bu iş için 31 freelancer ortalamada $737 teklif veriyor

BlueBoxWeb

Hi, my name is Josh, I'm based in San Diego CA and would love to work with you on your project. I specialize in design as well as development. Check out my portfolio at blueboxinteractive.com. Relevant Skills and Expe Daha Fazla

in %bids___i_period_sub_35% gün içinde694%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(28 Değerlendirme)
7.6
surabhirathi21

We're a Pvt. Ltd. company based in New Delhi, India with more than 8 years of experience on Magento. We've gone through your project details and can do this task efficiently and accurately for you. Kindly check o Daha Fazla

in %bids___i_period_sub_35% gün içinde750%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(167 Değerlendirme)
7.6
DigiWhizz

London (UK), based developer who specialises in Magento development. Would love to discuss your project in more detail. Relevant Skills and Experience: Studied, and mastered: Magento, MySQL, Nginx, PHP, Varnish Cache P Daha Fazla

in %bids___i_period_sub_35% gün içinde660%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(41 Değerlendirme)
7.5
mascotindia123

Hello, We specialize in custom PHP, MySQL solutions and services. PLAMP is our favourite tool to use for any website. We can work with you on any level of your project that you may need support with. As a team Daha Fazla

in %bids___i_period_sub_35% gün içinde700%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(235 Değerlendirme)
7.4
JoomlaVogue

Please have a look at our portfolio for Magento based projects: Relevant Skills and Experience [login to view URL] Proposed Miles Daha Fazla

in %bids___i_period_sub_35% gün içinde694%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(111 Değerlendirme)
7.6
in %bids___i_period_sub_35% gün içinde694%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(24 Değerlendirme)
7.0
magento2expert

Hello >> I am Magento 2 Expert developer and we have created approx 35+ Magento 2 store,magento 2 migration Magento 2 customize store, Magento 2theme customize, Magento 2 theme development ,magento 2 speed optimi Daha Fazla

in %bids___i_period_sub_35% gün içinde820%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(92 Değerlendirme)
6.9
alwaysanshuman

Hi, I am a web development expert. I have a lot of experience in building websites and I also have a team of expert web developers who work with me on different projects. We have been creating awesome websites for vari Daha Fazla

in %bids___i_period_sub_35% gün içinde500%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(45 Değerlendirme)
6.9
buzzz

Hello, have very big experience in magento optimization and server management. ready to solve your trouble with speed. Relevant Skills and Experience magento, server management Proposed Milestones $777 USD - end work

in %bids___i_period_sub_35% gün içinde777%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(415 Değerlendirme)
7.7
zyeloncomputech

Hi sir, we have gone through your requirements and we can MySQL Performance tuning + frontend speed optimization for huge Magento CE site according to your exact requirements. Relevant Skills and Experience We have m Daha Fazla

in %bids___i_period_sub_35% gün içinde722%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(114 Değerlendirme)
6.5
Designbackoffice

Ready to sign the NDA. OUR PORTFOLIO [login to view URL] I would love to discuss your project over chat. Sincerely Regards David

in %bids___i_period_sub_35% gün içinde1500%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(57 Değerlendirme)
6.7
shreeyait

[login to view URL] [login to view URL] [login to view URL] [login to view URL] [login to view URL] [login to view URL] Relevant Skills and Experience http://oncla Daha Fazla

in %bids___i_period_sub_35% gün içinde780%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(68 Değerlendirme)
7.1
AzzkaNoor

I have read your project details. I have to ask a few questions. Can you please message me via chat so we can discuss all the details to elicit all the requirements and hence start the development? Relevant Skills and Daha Fazla

in %bids___i_period_sub_35% gün içinde694%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(14 Değerlendirme)
5.8
tsseu

Hi, PLEASE SHARE NDA. As we have limited space over here, so please find our work details here [login to view URL] Kindly check our Portfolio at [login to view URL] Relevant Skills and Experience We h Daha Fazla

in %bids___i_period_sub_35% gün içinde1000%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(23 Değerlendirme)
5.6
schoudhary1553

Greeting, I have understood your MySQL Performance tuning + frontend speed optimization for huge Magento CE site task and can do it with your 100% satisfaction. Please ping me for more discussion. Relevant Skills an Daha Fazla

in %bids___i_period_sub_35% gün içinde700%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(30 Değerlendirme)
5.4
waqas193

Hi, I have gone through your project requirements and enthusiastic to work on it. I have extensive experience for this kind of projects & I will customize and do best in class IT solutions. Relevant Skills and Expe Daha Fazla

in %bids___i_period_sub_35% gün içinde944%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(14 Değerlendirme)
5.4
wpmonsters

Hello, We are the team of professionals called WordPress Monsters and we would be happy to help with your project! About 2 years ago we realized that WP is exactly what customers need when they ask for a modern UI prod Daha Fazla

in %bids___i_period_sub_35% gün içinde750%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(19 Değerlendirme)
5.2
FutureTechno1

Lets have a call Relevant Skills and Experience Web and mobile Proposed Milestones $888 USD - 20% upfront lets discuss

in %bids___i_period_sub_35% gün içinde888%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(12 Değerlendirme)
5.1
sunrisewebtech

Respected Sir, From last 10 year I am only working on magento. I have good experience in magento customization, module creation, product import and SEO etc. Relevant Skills and Experience 10 year Proposed Milestones Daha Fazla

in %bids___i_period_sub_35% gün içinde694%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(12 Değerlendirme)
4.9
in %bids___i_period_sub_35% gün içinde694%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(54 Değerlendirme)
5.4