Fermé

Magento: mysql optimization and sort all the query, sql putting alot of load on server.

Hi Every one,

i have 2 magento sites running on one server, but i am having some issue with DATA base optimization. as there are quite a lot of query running all the time, which are putting a lot of strain on server.

some of those query runs more then 17 hours which isnt good for server and some of the query going to sleep.

which all add up to slow the site and put a lot of stress on CPU.

i need some one who can optimize all of the slow running queries and sort all the sql related issue with my sites.

here is an exemple of query which is putting stress in server: SELECT DISTINCT COUNT(DISTINCT e.entity_id) FROM `catalog_product_entity

SELECT DISTINCT `e`.`attribute_set_id` FROM `catalog_product_entity

running without a LIMIT clause. The tuning recommendation is that you run this with a LIMIT statement

and there are few more as well which need to be solved.

please find attach list of slow running queries.

another issue i facing is this: [url removed, login to view]

please open this link and check the error.

Note: you must be a data administrator to bid on this, have fair amount of skills in sql to solve this issue.

lower price will get the job.

please dont bid without reading.

happy bidding.

Compétences : Administration de Bases de données, Programmation de bases de données, MySQL, PHP

Voir plus : sql server price list, all state, server load mysql optimization, apache mysql load server

Concernant l'employeur :
( 0 commentaires ) braford, United Kingdom

N° du projet : #8463029

11 freelance ont fait une offre moyenne de 131 £ pour ce travail

anamaria1979

Propunerea nu a fost încă furnizată

164 £ GBP en 0 jours
(96 Commentaires)
6.1
adicoman

Hi, I am very interested to work on your project. I have 10 years experience in Web Development and few of my projects related with yours can be seen on my freelancer.com portfolio. Let's start our collaboratio Plus

457 £ GBP en 13 jours
(39 Commentaires)
5.3
danale72

Hello Please feel free to pick me for this task. Mysql optimization is my specialization on this site. See my project history for references. As a bonus for you I can give you some tips regarding query and co Plus

50 £ GBP en 3 jours
(55 Commentaires)
5.5
acronymsolutions

Hi, I am 19+ years experienced Database Programmer at CMMI-5 level company. I am Personally working on : RDBMS : MS Access,Oracle,MySQL, MSSQL Server 7.0/2000/2008R2 and Onwards. Database Tools : Database Config Plus

150 £ GBP en 1 jour
(42 Commentaires)
5.3
Websitemaestro

Hi I have gone through the details of your project and we find it well within our capabilities. I can create and deliver the project as per the information.I have skilled, expert programmers I'm very excite Plus

84 £ GBP en 9 jours
(24 Commentaires)
3.8
vinaysinghh

I am mysql DBA having more then 5 yrs of experience in mysql.. I am bidding more because it is not necessary that that query will. Not only be reason of server load.. Other things might be possible.. Can we discuss

166 £ GBP en 1 jour
(8 Commentaires)
4.0
WebTechGal

Hello, I've been studying everything from your job description, the attached text file as well as your live site since you posted this job. This is a troublesome situation indeed (the first byte load time is simp Plus

75 £ GBP en 7 jours
(15 Commentaires)
3.7
itwebworld

Respected sir > , VI World is Indian base company. You can see our work at www.visainfoworld.com or in portfolio section. We provide best solution in low cost . So we want to discuss about your requirement. If you shor Plus

139 £ GBP en 3 jours
(45 Commentaires)
4.2
grundahl

Hi, I'm an expert database administrator. I can help you solve your performance problems by tuning the database itself. Rewriting queries is a good idea only if you use "house maintained" code, if so i can do it Plus

50 £ GBP en 3 jours
(1 Commentaire)
2.6
jinankthakker

Hi I have over 2.5 years of experience in PHP, Wordpress, Magento, Codeigniter, CakePHP ,HTML, Bootstrap, AngularJS , AJAX and I would like to work with you for your project. I can give daily reports to you and e Plus

150 £ GBP en 3 jours
(2 Commentaires)
2.4
CHREHAN

I have almost 3+ years of experience in Application Development,Database Development, Database Optimizations, Database Design. Currently I am responsible for implementing complex business of this client at database Plus

50 £ GBP en 3 jours
(3 Commentaires)
1.5
prikshat99

I have 18 years experience in Databases optimizations and query tuning , Can do this easily. Also, can suggest recommendations for future as well.

44 £ GBP en 4 jours
(0 Commentaires)
0.0