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.
11 freelance ont fait une offre moyenne de 131 £ pour ce travail
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