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

en voir plus : sql server price list, sort sort sort, sort sort, get the job, all state, server load mysql optimization, load xml file sql server vbnet, load xml file sql server via vbnet, convert sql server bak file mysql, mysql cpu load server hangs, load binary files sql server, linux load server apache mysql, server type sql mysql data transfer, convert sql server backup file mysql, apache mysql load server

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

Nº du projet : #8463029

11 freelance font une offre moyenne de £131 pour ce travail


Propunerea nu a fost încă furnizată

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% GBP en 0 jours
(96 Commentaires)

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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% GBP en 13 jours
(39 Commentaires)

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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% GBP en 3 jours
(55 Commentaires)

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

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% GBP en 1 jour
(42 Commentaires)

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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% GBP en 9 jours
(24 Commentaires)

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

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% GBP en 1 jour
(8 Commentaires)

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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% GBP en 7 jours
(15 Commentaires)

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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% GBP en 3 jours
(45 Commentaires)

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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% GBP en 3 jours
(1 Évaluation)

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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% GBP en 3 jours
(2 Commentaires)

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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% GBP en 3 jours
(3 Commentaires)

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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% GBP en 4 jours
(0 Commentaires)