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 font une offre moyenne de £131 pour ce travail
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
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
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
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
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
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
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
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
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
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
I have 18 years experience in Databases optimizations and query tuning , Can do this easily. Also, can suggest recommendations for future as well.