Evaluating bids

Mysql performance improvement in Prestashop - Mejoras de rendimiento Mysql de Prestashop

Published on the May 03, 2020 in IT & Programming

About this project

Open

Analyze the slow queries we have and improve them by changing the query and/or code as well as improvements in the indexes and/or other improvements in the database.

It has to be someone with good experience in MySQL and Prestashop optimization.

The project does NOT include other performance improvements in Prestashop such as caching, etc. It is restricted only to the performance improvement of the slow queries.

Project target is a significant reduction in CPU usage by the mysql server which quite often is going over 100% (in a 4 cores server)
---

Analizar las "slow queries" que tengamos y mejorarlas ya sea cambiando la query y/o el código así como mejoras en los índices y/u otras mejoras en la base de datos.

Tiene que ser alguien con mucha experiencia en optimización de MySQL y Prestashop.

El proyecto NO incluye otras mejoras de rendimiento en Prestashop como cache, etc. Es exclusívamente para la mejora de rendimiento de las queries.

El objetivo del proyecto es una reducción significativa del uso de la CPU por el servidor mysql, que a menudo supera el 100% (en un servidor de 4 núcleos)

Category IT & Programming
Subcategory E-commerce
What is the scope of the project? Small change or bug
Is this a project or a position? Project
I currently have Not applicable
Required availability As needed
Roles needed Developer

Delivery term: Not specified

Skills needed

Other projects posted by J.