Потребление много ресурсов на eVPS

[Faking]

Здравствуйте. Написал хостинг про потребление много ресурсов моим интернет-магазином. Пишет:

Повышенное потребление ресурсов сайтом, связано с увеличением нагрузки на процессор сервера при индексации сайта поисковыми роботами.

Также большая нагрузка создается sql запросами к базе tstore вида:

# Query_time: 281.937515 Lock_time: 0.010928 Rows_sent: 11335 Rows_examined: 256343969

SET timestamp=1344835848;

SELECT p.product_id, pd.name, GROUP_CONCAT( DISTINCT CAST(pc.category_id AS CHAR(11)) SEPARATOR "," ) AS categories, p.sku, p.upc, p.location, p.quantity, p.model, m.name AS manufacturer, p.image AS image_name, p.shipping, p.price, p.points, p.date_added, p.date_modified, p.date_available, p.weight, wc.unit, p.length, p.width, p.height, p.status, p.tax_class_id, p.viewed, p.sort_order, pd.language_id, ua.keyword, pd.description, pd.meta_description, pd.meta_keyword, pd.seo_title, pd.seo_h1, p.stock_status_id, mc.unit AS length_unit, p.subtract, p.minimum, GROUP_CONCAT( DISTINCT CAST(pr.related_id AS CHAR(11)) SEPARATOR "," ) AS related, GROUP_CONCAT( DISTINCT pt.tag SEPARATOR "," ) AS tags FROM `oct_product` p LEFT JOIN `oct_product_description` pd ON p.product_id=pd.product_id AND pd.language_id=1 LEFT JOIN `oct_product_to_category` pc ON p.product_id=pc.product_id LEFT JOIN `oct_url_alias` ua ON ua.query=CONCAT('product_id=',p.product_id) LEFT JOIN `oct_manufacturer` m ON m.manufacturer_id = p.manufacturer_id LEFT JOIN `oct_weight_class_description` wc ON wc.weight_class_id = p.weight_class_id AND wc.language_id=1 LEFT JOIN `oct_length_class_description` mc ON mc.length_class_id=p.length_class_id AND mc.language_id=1 LEFT JOIN `oct_product_related` pr ON pr.product_id=p.product_id LEFT JOIN `oct_product_tag` pt ON pt.product_id=p.product_id AND pt.language_id=1 GROUP BY p.product_id ORDER BY p.product_id, pc.category_id;

# Query_time: 148.866178 Lock_time: 0.000164 Rows_sent: 20 Rows_examined: 138615735

SET timestamp=1344842671;

SELECT p.product_id AS product_id, pd.name AS name, p.image AS image, p.sort_order AS sort_order, m.name AS manufacturer, p.model AS model, p.sku AS sku, p.upc AS upc, p.location AS location, p.quantity AS quantity, p.minimum AS minimum, ss.name AS stock_status, p.subtract AS subtract, p.status AS status, p.shipping AS shipping, p.price AS price, tc.title AS tax_class, p.points AS points, p.weight AS weight, wcd.title AS weight_class, p.length AS length, p.width AS width, p.height AS height, lcd.title AS length_class, ua.keyword AS url_alias FROM oct_product p LEFT JOIN oct_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oct_tax_class tc ON (p.tax_class_id = tc.tax_class_id) LEFT JOIN oct_weight_class_description wcd ON (p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') LEFT JOIN oct_length_class_description lcd ON (p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') LEFT JOIN oct_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) LEFT JOIN oct_stock_status ss ON (p.stock_status_id = ss.stock_status_id AND ss.language_id = '1') LEFT JOIN oct_url_alias ua ON (ua.query = CONCAT('product_id=', p.product_id)) WHERE pd.language_id = '1' GROUP BY p.product_id ORDER BY pd.name ASC LIMIT 0,20;

# Query_time: 182.319303 Lock_time: 0.000249 Rows_sent: 20 Rows_examined: 138615735

SET timestamp=1344842862;

SELECT p.product_id AS product_id, pd.name AS name, p.image AS image, p.sort_order AS sort_order, m.name AS manufacturer, p.model AS model, p.sku AS sku, p.upc AS upc, p.location AS location, p.quantity AS quantity, p.minimum AS minimum, ss.name AS stock_status, p.subtract AS subtract, p.status AS status, p.shipping AS shipping, p.price AS price, tc.title AS tax_class, p.points AS points, p.weight AS weight, wcd.title AS weight_class, p.length AS length, p.width AS width, p.height AS height, lcd.title AS length_class, ua.keyword AS url_alias FROM oct_product p LEFT JOIN oct_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oct_tax_class tc ON (p.tax_class_id = tc.tax_class_id) LEFT JOIN oct_weight_class_description wcd ON (p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') LEFT JOIN oct_length_class_description lcd ON (p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') LEFT JOIN oct_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) LEFT JOIN oct_stock_status ss ON (p.stock_status_id = ss.stock_status_id AND ss.language_id = '1') LEFT JOIN oct_url_alias ua ON (ua.query = CONCAT('product_id=', p.product_id)) WHERE pd.language_id = '1' GROUP BY p.product_id ORDER BY pd.name ASC LIMIT 0,20;

# Query_time: 11.224904 Lock_time: 0.001581 Rows_sent: 883 Rows_examined: 10796441

SET timestamp=1344835565;

SELECT c.* , cd.*, ua.keyword FROM `oct_category` c INNER JOIN `oct_category_description` cd ON cd.category_id = c.category_id AND cd.language_id=1 LEFT JOIN `oct_url_alias` ua ON ua.query=CONCAT('category_id=',c.category_id) ORDER BY c.`parent_id`, `sort_order`, c.`category_id`;

Подобные sql запросы выполняются по 3 и более минуты, нагружая при этом процессор, а также эти запросы создают на диске временные таблицы, размером по 200Мбайт, которые создают дополнительную нагрузку на дисковую подсистему.

Стоит тариф eVPS-8 . Товаров на сайте ~12000

Помогите пожалуйста кто знает.

[rb2]

См. https://opencartforum.com/topic/5778-ошибка-админки-в-товарах-когда-их-много/