Find Jobs
Hire Freelancers

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

$500-750 USD

Fermé
Publié il y a plus de 6 ans

$500-750 USD

Payé lors de la livraison
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.
N° de projet : 15602491

Concernant le projet

29 propositions
Projet à distance
Actif à il y a 6 ans

Cherchez-vous à gagner de l'argent ?

Avantages de faire une offre sur Freelancer

Fixez votre budget et vos délais
Soyez payé pour votre travail
Surlignez votre proposition
Il est gratuit de s'inscrire et de faire des offres sur des travaux
29 freelances proposent en moyenne $711 USD pour ce travail
Avatar de l'utilisateur
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 Experience I will showcase all the skills and my experience for this project over the chat. Please message me so we can resume this discussion. Proposed Milestones $694 USD - default Can you provide me all the functional/Non-functional requirements via a document?
$694 USD en 10 jours
5,0 (53 commentaires)
7,7
7,7
Avatar de l'utilisateur
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 having 11 + years of experience in this field we can assure you that you will get a high-quality Solution in respect of design and functionality. Looking forward to providing you best work. To know more about us and to view our past works, kindly check our portfolio on https://www.freelancer.com/u/mascotindia123 We look forward to hear from you soon. Thanks and regards, Harpreet Singh
$700 USD en 7 jours
4,9 (277 commentaires)
7,7
7,7
Avatar de l'utilisateur
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 Proposed Milestones: 660 - MySQL Performance tuning + frontend speed optimization for huge Magento CE site didel, many questions - send me a message and let's discuss. Cheer, James
$660 USD en 8 jours
4,6 (45 commentaires)
7,7
7,7
Avatar de l'utilisateur
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 various clients around the world. We focus on great user experience and efficient code in order to optimize the sites both for speed and performance. I have gone through your requirements and I feel that I am the perfect candidate for this project as I am a Magento expert. My team's expertise areas are - PHP, HTML, CSS, Javascript, Jquery, Angular JS, Node JS, C programming, Python, Java. We also have fine hands on open source frameworks like Wordpress, Drupal, Joomla, Laravel, Zend, Symphony, Django, Express NodeJS, MVC, ASP.Net etc. I will ensure great communication throughout the project and since I will be working with my team, we will be able to work on your project keeping the strict deadline in mind. Teamwork accelerates the workflow and ensures success. I am looking forward to working with you on this project. Ping me and let's discuss. Thanks a lot.
$500 USD en 10 jours
4,8 (48 commentaires)
7,4
7,4
Avatar de l'utilisateur
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 more than 180+ 5 stars feedback on freelancer.com you can check our profile. We can give you 4+ years experience dedicated magento developer whose work very closely with you. Proposed Milestones $250 USD - Initial milestone to start work $250 USD - project done 50% $222 USD - project done
$722 USD en 15 jours
4,9 (136 commentaires)
6,7
6,7
Avatar de l'utilisateur
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
$777 USD en 3 jours
4,3 (415 commentaires)
7,7
7,7
Avatar de l'utilisateur
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 and Experience I have more than 5 years of experience in Database Administration, MySQL, Nginx, PHP, Varnish Cache Proposed Milestones $700 USD - MySQL Performance tuning + frontend speed optimization for huge Magento CE site
$700 USD en 10 jours
4,9 (92 commentaires)
6,9
6,9
Avatar de l'utilisateur
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 Experience Expertise include .Net, Graphic designing, AJAX, Android/iOS app, PHP, laravel, Codeiginiter, YII, WordPress, Magento, Shopify, Woocommerce, Drupal 8, HTML5, CSS, Bootstrap, Javascript & much more. Proposed Milestones $944 USD - MySQL Performance tuning + frontend speed optimization for huge Magento CE site Contact Us: We can discuss details on chat here or on Skype. Regards, M. Waqas
$944 USD en 15 jours
5,0 (51 commentaires)
6,8
6,8
Avatar de l'utilisateur
I have 7+ years in database - eCommerce - website design & development with very good experience. Relevant Skills and Experience I am good in Magento, MySQL, Nginx, PHP, Varnish Cache Proposed Milestones $700 USD - Cost
$700 USD en 10 jours
4,9 (13 commentaires)
6,4
6,4
Avatar de l'utilisateur
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 product. Since then, a special team of programmers have mastered their skills in this sphere. Today we use WP to build thoroughly thought projects of all kinds - from landing pages to custom solutions. Let me know when you would like to discuss the details. I will be happy to answer any questions and give an accurate project estimation. Best regards.
$750 USD en 7 jours
5,0 (23 commentaires)
5,7
5,7
Avatar de l'utilisateur
Dear friend, We read through the job details extremely carefully. We wish to have a discussion with you. We have some questions for you. Bluecoded Team Relevant Skills and Experience Magento, MySQL, Nginx, PHP, Varnish Cache Proposed Milestones $150 USD - Milestone 1 $320 USD - Milestone 2 $218 USD - Milestone 3
$688 USD en 20 jours
4,8 (6 commentaires)
5,3
5,3
Avatar de l'utilisateur
Lets have a call Relevant Skills and Experience Web and mobile Proposed Milestones $888 USD - 20% upfront lets discuss
$888 USD en 10 jours
4,8 (15 commentaires)
5,3
5,3
Avatar de l'utilisateur
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 $294 USD - In Milestone $200 USD - After 50% complete $200 USD - After 100% complete Please let me know when are you available on chat to discuss more about the project?
$694 USD en 10 jours
5,0 (13 commentaires)
4,9
4,9
Avatar de l'utilisateur
I will write program to multi threaded insert and update to increase performance time beside advance performance tuning as DBA Relevant Skills and Experience software engineering Proposed Milestones $200 USD - to start $494 USD - after finish Additional Services Offered $1 USD - maintenance and testing $1 USD - support
$694 USD en 20 jours
4,9 (6 commentaires)
3,1
3,1
Avatar de l'utilisateur
I guarantee you a first class service with the quality and in the time it deserves by putting at your disposal all my knowledge and years of practice. Habilidades y experiencia relevante I've more than 6 years of experience in the role of data architecture, working theoretically and practically with the concepts proposed and others such as: replication, migration, ETL, big data, etc. Htos propuestos $694 USD - Development and materialization of the requirements
$694 USD en 4 jours
5,0 (2 commentaires)
1,0
1,0
Avatar de l'utilisateur
i need only 15 minutes to see what is wrong. free magento and server checkup. Relevant Skills and Experience magento optimization 10 years experience. php, mysql, varnish and nginx optimization expert. working with magento only. Proposed Milestones $500 USD - server and magento checkup + optimization
$500 USD en 3 jours
0,0 (0 commentaires)
0,0
0,0

À propos du client

Drapeau de BELGIUM
Asse, Belgium
5,0
11
Méthode de paiement vérifiée
Membre depuis mai 21, 2012

Vérification du client

Merci ! Nous vous avons envoyé un lien par e-mail afin de réclamer votre crédit gratuit.
Une erreur a eu lieu lors de l'envoi de votre e-mail. Veuillez réessayer.
Utilisateurs enregistrés Total des travaux publiés
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Chargement de l'aperçu
Permission donnée pour la géolocalisation.
Votre session de connexion a expiré et vous avez été déconnecté. Veuillez vous connecter à nouveau.