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

In Progress

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.

Skills: Database Administration, MySQL, PHP, Software Architecture, Web Hosting

See more: optimize mysql queries, web site optimization service, web site errors, web site error, web page errors, web optimization service, recommend a website developer, quote web service, magento optimization service, magento developer support, i want order of web developer, high level use cases, help with vps, file service architecture, web site optimization, web performance optimization, vps optimization, vps error, queries, optimize mysql, need magento developer for site, magento web developer, magento slow, magento optimization, magento errors

Project ID: #4927027

Awarded to:

matlidigital

Hi, Please check our PMB.

$147 USD in 3 days
(44 Reviews)
5.3

13 freelancers are bidding on average $305 for this job

jfreyre

Optimization expert.

$421 USD in 3 days
(179 Reviews)
7.1
maxtechsl

Hello, we are ready to help you fix your Magento site Mysql issue. Regards, Evina.

$55 USD in 2 days
(59 Reviews)
6.1
pivn

let expert do this

$444 USD in 3 days
(100 Reviews)
5.7
ThoughtSchool

I work on Magento, Opencart, wordpress, prestashop and very familiar with development, customization,fix of code and theme upgrade. Thanks.

$230 USD in 3 days
(33 Reviews)
5.4
devfactoryvw

I did similiar work in the past and can make your site as you desire.

$200 USD in 3 days
(45 Reviews)
5.2
rmmarconi

Please see my PM.

$155 USD in 3 days
(14 Reviews)
5.0
eComOS

Hello humbertoapac, I have read your requirements, I'm a Magento Expert and I am very confident to do this project. I guarantee COMPLETE satisfaction before payment. Please check PM for more details!

$206 USD in 2 days
(43 Reviews)
4.8
aneesiqbal

Experts here sir, Please see your PM

$315 USD in 1 day
(14 Reviews)
4.7
brajkishoriims

I have about 5 years experience in web development with one of top Elance company like Synapse India Pvt Ltd in and maintaining various projects in Core PHP, Code Igniter and Zend framework, Joomla, Magento and also More

$45 USD in 3 days
(5 Reviews)
3.3
linuxguru01

10 years of experience working with magento in tuning/optimization. I can solve this issue and guarantee results. Check PM!

$55 USD in 1 day
(2 Reviews)
2.1
sombahadurlimbu

Over 12 yrs of db/server/cloud/web admin expert. Highly experienced in mysql performance tuning.

$155 USD in 3 days
(0 Reviews)
0.0
mrsh3757

Hello, I can help you with query optimization. Please check PM. Thanks.

$111 USD in 1 day
(0 Reviews)
0.0
cmirihane

Please check my PM

$2000 USD in 20 days
(0 Reviews)
0.0
Net5kY

I'm experienced Linux administrator (3 yrs), and PHP/MySQL programmer (2 yrs). I worked in few companies, as linux admin in web and game hosting. As programmer (PHP and MySQL) I have experience in OOP, I use technol More

$55 USD in 7 days
(0 Reviews)
0.0