Completed

Optimize MySQL queries, to resolve errors with MySQL queries in Magento web site

This project was successfully completed by matlidigital for $147 USD in 3 days.

Get free quotes for a project like this
Employer working
Completed by:
Project Budget
$30 - $250 USD
Completed In
3 days
Total Bids
15
Project Description

Hello, we need a quote for some optimization of our site "[url removed, login to view]", in the past days we experience some errors in our site, the support guys of our hosting tell us that we need to make some changes in the MySQL queries because there is a lot of slow queries that the MySQL service had to process and the site goes down every once in a week.

So, I want to know if anyone can help us with this issues. Next is a copy of the support ticket of the host:

"We investigated the performance of your VPS very carefully.

There was high load on the whole server. The load was generated by the MySQL service. After further analyzing the performance of the MySQL service, we noticed that there are a lot of slow queries that the MySQL service had to process.

We have placed a copy of the slow queries log file of the MySQL service in /home/kidsware/. The log file is mysql-slow.log.

We have also placed a link in /home/kidsware/ called slow-queries-realtime which you can use to analyze the MySQL slow queries in real time.

We have restarted the MySQL service and the server load appears to be reducing for the moment.

In order to not let this happen in the future, I strongly recommend you that you contact a developer, who can help you optimize your website's MySQL [url removed, login to view] investigated the performance of your VPS very carefully.

There was high load on the whole server. The load was generated by the MySQL service. After further analyzing the performance of the MySQL service, we noticed that there are a lot of slow queries that the MySQL service had to process.

We have placed a copy of the slow queries log file of the MySQL service in /home/kidsware/. The log file is mysql-slow.log.

We have also placed a link in /home/kidsware/ called slow-queries-realtime which you can use to analyze the MySQL slow queries in real time.

We have restarted the MySQL service and the server load appears to be reducing for the moment.

In order to not let this happen in the future, I strongly recommend you that you contact a developer, who can help you optimize your website's MySQL queries."

Also we have problems in some sections of the site where the images are not displaying, in some cases when we access in a sub category (2nd or 3rd level) the page is very slow to display the products, for example: Main menu - bebes -> mobiliario -> colecciones -> colecciones (the images doesn't display) -> Coleccion Bella.

We don't know if this problems are caused of MySQL queries issues, so it's important for us to resolve this troubles to.

Attached you will see screen-shoot images were the error of MySQL queries are.

If you need more information about the errors or where the errors are present, please contact me. Thank you in advance.

Looking to make some money?

  • Set your budget and the timeframe
  • Outline your proposal
  • Get paid for your work

Hire Freelancers who also bid on this project

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online