Заказ закрыт
Нужен специалист со знанием PHP 5.3, MySQL 5.5 и выше.

Бюджет: по договоренности
Для оптимизации запросов к базам данных и снижения нагрузки на сервер ищется специалист со знанием PHP 5.3, MySQL 5.5 и выше.
Есть работающий интернет-магазин. Примерно полгода все работало хорошо, и вот недавно пришло сообщение от техподдержки хостинга, что сайт заблокирован из-за чрезмерной нагрузки на сервер баз данных запросами вида:
| 274861963 | host1371029_0153 | localhost | host1371029_0153 | Query | 2 | Sending data | SELECT COUNT(DISTINCT p.product_id) AS total FROM category_path cp LEFT JOIN product_to_category p2c | 0 | 0 | 0 | 
| 274862060 | host1371029_0153 | localhost | host1371029_0153 | Query | 2 | Sending data | SELECT COUNT(DISTINCT p.product_id) AS total FROM category_path cp LEFT JOIN product_to_category p2c | 0 | 0 | 0 | 
| 274862242 | host1371029_0153 | localhost | host1371029_0153 | Query | 2 | Sending data | SELECT COUNT(DISTINCT p.product_id) AS total FROM category_path cp LEFT JOIN product_to_category p2c | 0 | 0 | 0 | 
| 274862255 | host1371029_0153 | localhost | host1371029_0153 | Query | 2 | Sending data | SELECT COUNT(DISTINCT p.product_id) AS total FROM category_path cp LEFT JOIN product_to_category p2c | 0 | 0 | 0 | 
| 274862258 | host1371029_0153 | localhost | host1371029_0153 | Query | 1 | Sending data | SELECT COUNT(DISTINCT p.product_id) AS total FROM category_path cp LEFT JOIN product_to_category p2c | 0 | 0 | 0 | 
| 274862575 | host1371029_0153 | localhost | host1371029_0153 | Query | 2 | Sending data | SELECT COUNT(DISTINCT p.product_id) AS total FROM category_path cp LEFT JOIN product_to_category p2c | 0 | 0 | 0 | 
| 274862595 | host1371029_0153 | localhost | host1371029_0153 | Query | 2 | Sending data | SELECT COUNT(DISTINCT p.product_id) AS total FROM category_path cp LEFT JOIN product_to_category p2c | 0 | 0 | 0 | 
| 274862601 | host1371029_0153 | localhost | host1371029_0153 | Query | 1 | Sending data | SELECT COUNT(DISTINCT p.product_id) AS total FROM category_path cp LEFT JOIN product_to_category p2c | 0 | 0 | 0 | 
| 274862957 | host1371029_0153 | localhost | host1371029_0153 | Query | 2 | Sending data | SELECT COUNT(DISTINCT p.product_id) AS total FROM category_path cp LEFT JOIN product_to_category p2c | 0 | 0 | 0 | 
| 274862979 | host1371029_0153 | localhost | host1371029_0153 | Query | 2 | Sending data | SELECT COUNT(DISTINCT p.product_id) AS total FROM category_path cp LEFT JOIN product_to_category p2c | 0 | 0 | 0 | 
| 274862985 | host1371029_0153 | localhost | host1371029_0153 | Query | 2 | Sending data | SELECT COUNT(DISTINCT p.product_id) AS total FROM category_path cp LEFT JOIN product_to_category p2c | 0 | 0 | 0 | 
| 274863110 | host1371029_0153 | localhost | host1371029_0153 | Query | 2 | Sending data | SELECT COUNT(DISTINCT p.product_id) AS total FROM category_path cp LEFT JOIN product_to_category p2c | 0 | 0 | 0 | 
| 274863145 | host1371029_0153 | localhost | host1371029_0153 | Query | 2 | Sending data | SELECT COUNT(DISTINCT p.product_id) AS total FROM category_path cp LEFT JOIN product_to_category p2c | 0 | 0 | 0 | 
| 274863182 | host1371029_0153 | localhost | host1371029_0153 | Query | 2 | Sending data | SELECT COUNT(DISTINCT p.product_id) AS total FROM category_path cp LEFT JOIN product_to_category p2c | 0 | 0 | 0 | 
| 274863363 | host1371029_0153 | localhost | host1371029_0153 | Query | 2 | Sending data | SELECT COUNT(DISTINCT p.product_id) AS total FROM category_path cp LEFT JOIN product_to_category p2c | 0 | 0 | 0 | 
| 274863426 | host1371029_0153 | localhost | host1371029_0153 | Query | 1 | Sending data | SELECT COUNT(DISTINCT p.product_id) AS total FROM category_path cp LEFT JOIN product_to_category p2c | 0 | 0 | 0 | 
| 274863694 | host1371029_0153 | localhost | host1371029_0153 | Query | 2 | Sending data | SELECT COUNT(DISTINCT p.product_id) AS total FROM category_path cp LEFT JOIN product_to_category p2c | 0 | 0 | 0 | 
| 274863704 | host1371029_0153 | localhost | host1371029_0153 | Query | 2 | Sending data | SELECT COUNT(DISTINCT p.product_id) AS total FROM category_path cp LEFT JOIN product_to_category p2c | 0 | 0 | 0 | 
| 274863851 | host1371029_0153 | localhost | host1371029_0153 | Query | 2 | Sending data | SELECT COUNT(DISTINCT p.product_id) AS total FROM category_path cp LEFT JOIN product_to_category p2c | 0 | 0 | 0 | 
| 274864370 | host1371029_0153 | localhost | host1371029_0153 | Query | 1 | Sending data | SELECT COUNT(DISTINCT p.product_id) AS total FROM category_path cp LEFT JOIN product_to_category p2c | 0 | 0 | 0 | 
| 274864428 | host1371029_0153 | localhost | host1371029_0153 | Query | 2 | Sending data | SELECT COUNT(DISTINCT p.product_id) AS total FROM category_path cp LEFT JOIN product_to_category p2c | 0 | 0 | 0 | 
| 274864555 | host1371029_0153 | localhost | host1371029_0153 | Query | 2 | Sending data | SELECT COUNT(DISTINCT p.product_id) AS total FROM category_path cp LEFT JOIN product_to_category p2c | 0 | 0 | 0 |  
И было рекомендовано оптимизировать SQL запросы
Опубликован 19.08.2015 в 10:56
Заказ находится в архиве

Выберите способ верификации:

Обновите страницу после прохождения верификации.