Оптимизация базы данных mysql

8 ответов

• популярные
• новые

• 1

  Syrnik.com Партнер-эксперт Партнер-разработчик 26 декабря 2018 01:15 #

  плагин сео-регионы установлен? Если да, то сколько поддоменов?

  ответить
  • +1

    Константин Власов 26 декабря 2018 01:17 #

    да, плагин установлен. 177 регионов. Было 1000. 823 удалили.

    ответить
    • +2

      creativit.ru Партнер-эксперт Партнер-разработчик 26 декабря 2018 13:47 #

      Константин, вам нужно понять. 177 регионов = 177 сайтов. То есть теоретически, возможна ситуация, когда Яндекс, Гугл и т.п. одновременно индексируют эти сайты, то есть у вас 177 посетителей на сайте в одно время (цифры условные, может быть и 354 - если Гугл и Яндекс вообще сговорятся). Цифры не важны, важно понимать, что возможная пиковая нагрузка у вас потенциально в 177 раз выше, чем если бы был только основной домен. Поэтому не удивляйтесь, если сегодня у вас хостинг умирает, а завтра более-менее шуршит. В очередной день, когда будет пик индексирования, то ваш сайт снова заболеет. Если вы решили пойти по пути продвижения поддоменами, то должны понимать побочные эффекты.

      
      P.S. Больше 10 регионов на хостинге - это проблема. Больше 50 - это уже проблема для VPS. Цифры условные, так как зависит от плагинов и т.д. и.т.п. Просто учтите, что раз вы сказали поисковикам, что это сайты регионов, то они рассматривают их как отдельные сайты и могут индексировать одновременно. И когда ваш сайт в основное время работает с нагрузкой 5-20 клиентов одновременно (если у вас от 1000 клиентов в сутки) и тут приходит еще 100-200 ботов, которые начинают активно индексировать, то хостинг не готов к этому. 

      ответить
      • +2

        waResearchLab Партнер-эксперт Партнер-разработчик 26 декабря 2018 15:22 #

        Все это надо написать в описании плагина сео-регионы =)

        ответить
        • +3

          creativit.ru Партнер-эксперт Партнер-разработчик 26 декабря 2018 16:48 #

          Боюсь тут как с курением - минздрав предупреждал предупреждал, да не предупредил. 

          ответить
• 1

  Константин Власов 26 декабря 2018 19:13 #

  Вот ответ с хостинга: 

  К сожалению, оптимизация не приносит результата, поскольку проблема именно в запросах к базе, а именно в их количестве, сайт при загрузке только одной страницы с товаром отправляет к базе 153 запроса, которые выполняются последовательно и это приводит к ожиданию у других пользователей и росту нагрузки на mysql, в вашем случае единственным выходом может стать кэширование запросов к базе данных на стороне сайта, по примеру плагина wp-super-cache для wordpress вам может помочь похожий плагин для webasyst.
  
  Пример запросов, которые выполняются в момент обращения к 1-ой странице с товаром:
  
  | 11740 | vapeshop | localhost | vapeshop | Query | 0 | Sending data | SELECT id, full_url FROM shop_page WHERE (domain = 'vape-shoper.ru' AND route = '*') AND (status = 1 |
  | 11740 | vapeshop | localhost | vapeshop | Query | 0 | Creating sort index | SELECT c.* FROM shop_category_products cp JOIN shop_category c ON cp.category_id = c.id
  | 11740 | vapeshop | localhost | vapeshop | Query | 0 | Sending data | SELECT COUNT(DISTINCT p.id) FROM shop_product p
  | 11740 | vapeshop | localhost | vapeshop | Query | 0 | query end | SELECT * FROM shop_category WHERE (
  | 11740 | vapeshop | localhost | vapeshop | Query | 0 | starting | SELECT f.id AS feature_id, f.code, f.type, f.multiple, tf.sort
  | 11740 | vapeshop | localhost | vapeshop | Query | 0 | closing tables | INSERT INTO shop_seoredirect_shop_urls
  | 11740 | vapeshop | localhost | vapeshop | Query | 0 | Opening tables | SELECT * FROM shop_seo_settings WHERE `group_id` = 'product' AND `storefront_id` = 'vape-shoper.ru/* |
  | 11740 | vapeshop | localhost | vapeshop | Query | 0 | Sending data | SELECT * FROM shop_seo_field_product_value WHERE `storefront_id` = 'vape-shoper.ru/*' AND `product_i |
  | 11740 | vapeshop | localhost | vapeshop | Query | 0 | Sending data | SELECT MIN(`ps1`.price * `c1`.rate) min, MAX(`ps1`.price * `c1`.rate) max FROM shop_product p
  | 11740 | vapeshop | localhost | vapeshop | Query | 0 | statistics | SELECT COUNT(DISTINCT p.id) FROM shop_product p
  | 11740 | vapeshop | localhost | vapeshop | Query | 0 | starting | SELECT DISTINCT p.id,p.currency,p.url,p.category_id,(p.count > 0 || p.count IS NULL) AS in_stock FRO |
  | 11740 | vapeshop | localhost | vapeshop | Query | 0 | Sending data | SELECT COUNT(DISTINCT p.id) FROM shop_product p
  | 11740 | vapeshop | localhost | vapeshop | Query | 0 | starting | |
  | 11740 | vapeshop | localhost | vapeshop | Query | 0 | Opening tables | SELECT * FROM shop_dp_storefront_groups |
  | 11740 | vapeshop | localhost | vapeshop | Query | 0 | Sending data | SELECT * FROM shop_dp_points WHERE `country_code` = 'rus' AND `region_code` = '77' AND `city_name` = |
  | 11740 | vapeshop | localhost | vapeshop | Query | 0 | Sending data | SELECT * FROM shop_dp_points_worktime WHERE `point_hash` = 'a07cebbd1aef5414a30c1d2b9bbba425' |
  | 11740 | vapeshop | localhost | vapeshop | Query | 0 | Sending data | SELECT * FROM shop_dp_points_worktime WHERE `point_hash` = '8cec8e2f8bda837aa4c66a20292de205' |
  | 11740 | vapeshop | localhost | vapeshop | Query | 0 | closing tables | SELECT * FROM shop_dp_points_worktime WHERE `point_hash` = 'f2b19a90342abfce32991d990260739a' |
  | 11740 | vapeshop | localhost | vapeshop | Query | 0 | Sending data | SELECT * FROM shop_dp_points_worktime WHERE `point_hash` = '7db162cf56dce23fd8da8bc7f0493488' |
  | 11740 | vapeshop | localhost | vapeshop | Query | 0 | starting | SELECT * FROM shop_dp_points_worktime WHERE `point_hash` = '75dbe5b1fab5e1ec81ae47a7e43a8596' |
  | 11740 | vapeshop | localhost | vapeshop | Query | 0 | Sending to client | SELECT * FROM shop_dp_points WHERE `country_code` = 'rus' AND `region_code` = '77' AND `city_name` = |
  | 11740 | vapeshop | localhost | vapeshop | Query | 0 | statistics | SELECT * FROM shop_dp_points_worktime WHERE `point_hash` = '9961c1bf1ddabf470ecee7a603d2a664' |
  | 11740 | vapeshop | localhost | vapeshop | Query | 0 | Sending to client | SELECT * FROM shop_dp_points_worktime WHERE `point_hash` = '29cbd1ed1442cb9f5a60bd2f8d831016' |
  | 11740 | vapeshop | localhost | vapeshop | Query | 0 | freeing items | SELECT * FROM shop_dp_points_worktime WHERE `point_hash` = 'e1bf82c6021e1c8f4935fce185c5e1c7' |
  | 11740 | vapeshop | localhost | vapeshop | Query | 0 | freeing items | SELECT * FROM shop_dp_points_worktime WHERE `point_hash` = 'dd0b3e17d11ea7f9f7a95fc7f23ed3c3' |
  | 11740 | vapeshop | localhost | vapeshop | Query | 0 | Sending data | SELECT * FROM shop_dp_points_worktime WHERE `point_hash` = 'c6aad754fe2fdd9ad971b692fd7daa54' |
  | 11740 | vapeshop | localhost | vapeshop | Query | 0 | preparing | SELECT * FROM shop_dp_points_worktime WHERE `point_hash` = 'b0e87b22f45bb02b09e922ee47d1cd53' |
  | 11740 | vapeshop | localhost | vapeshop | Query | 0 | Sending data | SELECT * FROM shop_dp_points_worktime WHERE `point_hash` = '7632b01adc5e7ab7899415748ef308ce' |
  | 11740 | vapeshop | localhost | vapeshop | Query | 0 | Sending data | SELECT * FROM shop_dp_points_worktime WHERE `point_hash` = 'e1d63e6bb900aab1b7d42116a921a0fa' |
  | 11740 | vapeshop | localhost | vapeshop | Query | 0 | statistics | SELECT * FROM shop_dp_points_worktime WHERE `point_hash` = '33d09490a9bf4bdc77c111bd6af5224e' |
  | 11740 | vapeshop | localhost | vapeshop | Query | 0 | statistics | SELECT * FROM shop_dp_points_worktime WHERE `point_hash` = '26898dfe92050d820f66c9f036e9dbe8' |
  | 11740 | vapeshop | localhost | vapeshop | Query | 0 | Sending to client | SELECT * FROM shop_plugin WHERE `type` = 'payment' |
  | 11740 | vapeshop | localhost | vapeshop | Query | 0 | Creating sort index | SELECT c.* FROM `shop_category` c LEFT JOIN shop_category_routes cr ON c.id = cr.category_id WHERE ` |
  | 11740 | vapeshop | localhost | vapeshop | Query | 0 | Sending data | SELECT DISTINCT p.*,p.id,(p.count > 0 || p.count IS NULL) AS in_stock
  | 11740 | vapeshop | localhost | vapeshop | Query | 0 | init | SELECT COUNT(DISTINCT p.id) FROM shop_product p
  | 11740 | vapeshop | localhost | vapeshop | Query | 0 | Sending data | SELECT COUNT(DISTINCT p.id) FROM shop_product p
  | 11740 | vapeshop | localhost | vapeshop | Query | 0 | Sending data | SELECT COUNT(DISTINCT p.id) FROM shop_product p
  | 11740 | vapeshop | localhost | vapeshop | Query | 0 | Sending data | SELECT COUNT(DISTINCT p.id) FROM shop_product p
  | 11740 | vapeshop | localhost | vapeshop | Query | 0 | Sending data | SELECT COUNT(DISTINCT p.id) FROM shop_product p
  | 11740 | vapeshop | localhost | vapeshop | Query | 0 | Sending data | SELECT COUNT(DISTINCT p.id) FROM shop_product p
  | 11740 | vapeshop | localhost | vapeshop | Query | 0 | Sending data | SELECT COUNT(DISTINCT p.id) FROM shop_product p
  | 11740 | vapeshop | localhost | vapeshop | Query | 0 | Sending data | SELECT COUNT(DISTINCT p.id) FROM shop_product p
  | 11740 | vapeshop | localhost | vapeshop | Query | 0 | Sending data | SELECT * FROM shop_category WHERE (
  | 11740 | vapeshop | localhost | vapeshop | Query | 0 | starting | SELECT * FROM shop_product_skus WHERE `id` IN ('11440') |
  | 11740 | vapeshop | localhost | vapeshop | Query | 0 | Opening tables | SELECT * FROM shop_product_skus WHERE `id` IN ('10753') |
  | 11740 | vapeshop | localhost | vapeshop | Query | 0 | Creating sort index | SELECT * FROM shop_seofilter_productfilters_category_feature_rule WHERE (storefront IN ('*','vape-sh |
  | 11740 | vapeshop | localhost | vapeshop | Query | 0 | starting | SELECT name, value FROM shop_seofilter_productfilters_category_settings WHERE (storefront = 'vape-sh |
  | 11740 | vapeshop | localhost | vapeshop | Query | 0 | Creating sort index | SELECT p.*,p.id,(ABS(p.price - 6879)/6879) AS upselling_deviation,(p.count > 0 || p.count IS NULL) A |
  | 11740 | vapeshop | localhost | vapeshop | Query | 0 | Sending data | SELECT * FROM shop_category WHERE (
  | 11740 | vapeshop | localhost | vapeshop | Query | 0 | Sending data | SELECT COUNT(DISTINCT p.id) FROM shop_product p
  | 11740 | vapeshop | localhost | vapeshop | Query | 0 | Sending data | SELECT COUNT(DISTINCT p.id) FROM shop_product p
  | 11740 | vapeshop | localhost | vapeshop | Query | 0 | Sending data | SELECT COUNT(DISTINCT p.id) FROM shop_product p
  | 11740 | vapeshop | localhost | vapeshop | Query | 0 | Sending data | SELECT COUNT(DISTINCT p.id) FROM shop_product p
  | 11740 | vapeshop | localhost | vapeshop | Query | 0 | Sending data | SELECT COUNT(DISTINCT p.id) FROM shop_product p
  | 11740 | vapeshop | localhost | vapeshop | Query | 0 | Sending data | SELECT COUNT(DISTINCT p.id) FROM shop_product p
  | 11740 | vapeshop | localhost | vapeshop | Query | 0 | Sending data | SELECT COUNT(DISTINCT p.id) FROM shop_product p
  | 11740 | vapeshop | localhost | vapeshop | Query | 0 | Sending data | SELECT COUNT(DISTINCT p.id) FROM shop_product p
  | 11740 | vapeshop | localhost | vapeshop | Query | 0 | Sending data | SELECT COUNT(DISTINCT p.id) FROM shop_product p
  | 11740 | vapeshop | localhost | vapeshop | Query | 0 | Sending data | SELECT COUNT(DISTINCT p.id) FROM shop_product p
  | 11740 | vapeshop | localhost | vapeshop | Query | 0 | statistics | SELECT COUNT(DISTINCT p.id) FROM shop_product p
  | 11740 | vapeshop | localhost | vapeshop | Query | 0 | Sending data | SELECT COUNT(DISTINCT p.id) FROM shop_product p
  | 11740 | vapeshop | localhost | vapeshop | Query | 0 | starting | SELECT COUNT(DISTINCT p.id) FROM shop_product p
  | 11740 | vapeshop | localhost | vapeshop | Query | 0 | Sending to client | SELECT DISTINCT p.id,p.currency,p.url,p.category_id,(p.count > 0 || p.count IS NULL) AS in_stock FRO |
  | 11740 | vapeshop | localhost | vapeshop | Query | 0 | Sending to client | SELECT * FROM shop_product_skus WHERE `id` IN ('3626') |
  | 11740 | vapeshop | localhost | vapeshop | Query | 0 | Sending data | SELECT * FROM shop_category WHERE (
  | 11740 | vapeshop | localhost | vapeshop | Query | 0 | Sending data | SELECT DISTINCT p.*,p.id,(p.count > 0 || p.count IS NULL) AS in_stock
  | 11740 | vapeshop | localhost | vapeshop | Query | 0 | Sending data | SELECT DISTINCT p.*,p.id,(p.count > 0 || p.count IS NULL) AS in_stock
  | 11740 | vapeshop | localhost | vapeshop | Query | 0 | Sending data | SELECT DISTINCT p.*,p.id,(p.count > 0 || p.count IS NULL) AS in_stock
  | 11740 | vapeshop | localhost | vapeshop | Query | 0 | Sending data | SELECT DISTINCT p.*,p.id,(p.count > 0 || p.count IS NULL) AS in_stock
  | 11740 | vapeshop | localhost | vapeshop | Query | 0 | Sending data | SELECT DISTINCT p.*,p.id,(p.count > 0 || p.count IS NULL) AS in_stock
  | 11740 | vapeshop | localhost | vapeshop | Query | 0 | Sending data | SELECT DISTINCT p.*,p.id,(p.count > 0 || p.count IS NULL) AS in_stock
  | 11740 | vapeshop | localhost | vapeshop | Query | 0 | Sending data | SELECT DISTINCT p.*,p.id,(p.count > 0 || p.count IS NULL) AS in_stock
  | 11740 | vapeshop | localhost | vapeshop | Query | 0 | Sending data | SELECT DISTINCT p.*,p.id,(p.count > 0 || p.count IS NULL) AS in_stock
  | 11740 | vapeshop | localhost | vapeshop | Query | 0 | Sending data | SELECT DISTINCT p.*,p.id,(p.count > 0 || p.count IS NULL) AS in_stock
  | 11740 | vapeshop | localhost | vapeshop | Query | 0 | Sending data | SELECT DISTINCT p.*,p.id,(p.count > 0 || p.count IS NULL) AS in_stock
  | 11740 | vapeshop | localhost | vapeshop | Query | 0 | Sending data | SELECT DISTINCT p.*,p.id,(p.count > 0 || p.count IS NULL) AS in_stock
  | 11740 | vapeshop | localhost | vapeshop | Query | 0 | Sending data | SELECT DISTINCT p.*,p.id,(p.count > 0 || p.count IS NULL) AS in_stock
  | 11740 | vapeshop | localhost | vapeshop | Query | 0 | Sending data | SELECT DISTINCT p.*,p.id,(p.count > 0 || p.count IS NULL) AS in_stock
  | 11740 | vapeshop | localhost | vapeshop | Query | 0 | Sending data | SELECT DISTINCT p.*,p.id,(p.count > 0 || p.count IS NULL) AS in_stock
  | 11740 | vapeshop | localhost | vapeshop | Query | 0 | Sending data | SELECT DISTINCT p.*,p.id,(p.count > 0 || p.count IS NULL) AS in_stock
  | 11740 | vapeshop | localhost | vapeshop | Query | 0 | Sending data | SELECT DISTINCT p.*,p.id,(p.count > 0 || p.count IS NULL) AS in_stock
  | 11740 | vapeshop | localhost | vapeshop | Query | 0 | statistics | SELECT COUNT(DISTINCT p.id) FROM shop_product p
  | 11740 | vapeshop | localhost | vapeshop | Query | 0 | Sending data | SELECT COUNT(DISTINCT p.id) FROM shop_product p
  | 11740 | vapeshop | localhost | vapeshop | Query | 0 | Sending data | SELECT COUNT(DISTINCT p.id) FROM shop_product p
  | 11740 | vapeshop | localhost | vapeshop | Query | 0 | Sending data | SELECT COUNT(DISTINCT p.id) FROM shop_product p
  | 11740 | vapeshop | localhost | vapeshop | Query | 0 | Sending data | SELECT COUNT(DISTINCT p.id) FROM shop_product p
  | 11740 | vapeshop | localhost | vapeshop | Query | 0 | Sending data | SELECT COUNT(DISTINCT p.id) FROM shop_product p
  | 11740 | vapeshop | localhost | vapeshop | Query | 0 | Sending data | SELECT COUNT(DISTINCT p.id) FROM shop_product p
  | 11740 | vapeshop | localhost | vapeshop | Query | 0 | Sending data | SELECT COUNT(DISTINCT p.id) FROM shop_product p
  | 11740 | vapeshop | localhost | vapeshop | Query | 0 | Sending data | SELECT COUNT(DISTINCT p.id) FROM shop_product p
  | 11740 | vapeshop | localhost | vapeshop | Query | 0 | Sending data | SELECT COUNT(DISTINCT p.id) FROM shop_product p
  | 11740 | vapeshop | localhost | vapeshop | Query | 0 | Sending data | SELECT COUNT(DISTINCT p.id) FROM shop_product p
  | 11740 | vapeshop | localhost | vapeshop | Query | 0 | Sending data | SELECT COUNT(DISTINCT p.id) FROM shop_product p
  | 11740 | vapeshop | localhost | vapeshop | Query | 0 | Sending data | SELECT COUNT(DISTINCT p.id) FROM shop_product p
  | 11740 | vapeshop | localhost | vapeshop | Query | 0 | init | SELECT DISTINCT p.id,p.currency,p.url,p.category_id,(p.count > 0 || p.count IS NULL) AS in_stock FRO |
  | 11740 | vapeshop | localhost | vapeshop | Query | 0 | Sending data | SELECT COUNT(DISTINCT p.id) FROM shop_product p
  | 11740 | vapeshop | localhost | vapeshop | Query | 0 | starting | SELECT DISTINCT p.id,p.currency,p.url,p.category_id,(p.count > 0 || p.count IS NULL) AS in_stock FRO |
  | 11740 | vapeshop | localhost | vapeshop | Query | 0 | init | SELECT * FROM shop_product_skus WHERE `id` IN ('3669') |
  | 11740 | vapeshop | localhost | vapeshop | Query | 0 | init | SELECT * FROM shop_product_skus WHERE `id` IN ('11553') |
  | 11740 | vapeshop | localhost | vapeshop | Query | 0 | starting | SELECT * FROM shop_product_skus WHERE `id` IN ('5800') |
  | 11740 | vapeshop | localhost | vapeshop | Query | 0 | statistics | SELECT * FROM shop_product_images WHERE `product_id` = '5954' ORDER BY product_id, sort |
  | 11740 | vapeshop | localhost | vapeshop | Query | 0 | Creating sort index | SELECT * FROM shop_product_images WHERE `product_id` = '3012' ORDER BY product_id, sort |
  | 11740 | vapeshop | localhost | vapeshop | Query | 0 | preparing | SELECT * FROM shop_product WHERE `id` = '7427' LIMIT 1 |
  | 11740 | vapeshop | localhost | vapeshop | Query | 0 | Creating sort index | SELECT id, parent_id, name, title, full_url, url, create_datetime, update_datetime FROM shop_page
  | 11740 | vapeshop | localhost | vapeshop | Query | 0 | Creating sort index | SELECT id, parent_id, name, title, full_url, url, create_datetime, update_datetime FROM shop_page
  | 11740 | vapeshop | localhost | vapeshop | Query | 0 | Creating sort index | SELECT c.* FROM shop_category c LEFT JOIN shop_category_routes cr ON c.id = cr.category_id WHERE (c. |
  | 11740 | vapeshop | localhost | vapeshop | Query | 0 | statistics | SELECT * FROM shop_category_params WHERE `category_id` IN ('1','858','859','807','373','372','769',' |
  | 11740 | vapeshop | localhost | vapeshop | Query | 0 | Creating sort index | SELECT c.* FROM shop_category c LEFT JOIN shop_category_routes cr ON c.id = cr.category_id WHERE (c. |
  | 12094 | vapeshop | localhost | vapeshop | Query | 0 | Sending data | SELECT c.id, c.full_url FROM shop_category c
  | 12094 | vapeshop | localhost | vapeshop | Query | 0 | Sending data | SELECT id, full_url FROM shop_page WHERE (domain = 'vape-shoper.ru' AND route = '*') AND (status = 1 |
  | 12094 | vapeshop | localhost | vapeshop | Query | 0 | Sending data | SELECT id, full_url FROM shop_page WHERE (domain = 'vape-shoper.ru' AND route = '*') AND (status = 1 |
  | 12240 | vapeshop | localhost | vapeshop | Query | 0 | starting | SELECT * FROM shop_flexdiscount_settings |
  | 12240 | vapeshop | localhost | vapeshop | Query | 0 | statistics | SELECT id, full_url FROM shop_page WHERE (domain = 'vape-shoper.ru' AND route = '*') AND (status = 1 |
  | 12240 | vapeshop | localhost | vapeshop | Query | 0 | Sending data | SELECT id, full_url FROM shop_page WHERE (domain = 'vape-shoper.ru' AND route = '*') AND (status = 1 |
  | 12240 | vapeshop | localhost | vapeshop | Query | 0 | starting | SELECT * FROM shop_product WHERE `url` = 'joyetech-espion-solo-80w-vandy-vape-berserker-mtl-rta-nite |
  | 12240 | vapeshop | localhost | vapeshop | Query | 0 | Sending data | SELECT * FROM shop_category WHERE (
  | 12240 | vapeshop | localhost | vapeshop | Query | 0 | Sending data | SELECT COUNT(DISTINCT p.id) FROM shop_product p
  | 12240 | vapeshop | localhost | vapeshop | Query | 0 | init | SELECT DISTINCT p.id,p.currency,p.url,p.category_id,(p.count > 0 || p.count IS NULL) AS in_stock FRO |
  | 12240 | vapeshop | localhost | vapeshop | Query | 0 | Creating sort index | SELECT c.* FROM shop_category_products cp JOIN shop_category c ON cp.category_id = c.id
  | 12240 | vapeshop | localhost | vapeshop | Query | 0 | updating | DELETE FROM shop_seoredirect_shop_urls WHERE `hash` = '3111e92351aea6989cf1d65a3754e6b5' |
  | 12240 | vapeshop | localhost | vapeshop | Query | 0 | preparing | SELECT * FROM shop_seo_template WHERE `group_id` = 'data' AND `storefront_id` = 'vape-shoper.ru/*' |
  | 12240 | vapeshop | localhost | vapeshop | Query | 0 | starting | SELECT * FROM `shop_category`
  | 12240 | vapeshop | localhost | vapeshop | Query | 0 | Sending data | SELECT MIN(`ps1`.price * `c1`.rate) min, MAX(`ps1`.price * `c1`.rate) max FROM shop_product p
  | 12240 | vapeshop | localhost | vapeshop | Query | 0 | statistics | SELECT * FROM shop_category WHERE `id` = '873' LIMIT 1 |
  | 12240 | vapeshop | localhost | vapeshop | Query | 0 | statistics | SELECT * FROM shop_seo_template_category WHERE `group_id` = 'data' AND `storefront_id` = 'vape-shope |
  | 12240 | vapeshop | localhost | vapeshop | Query | 0 | optimizing | SELECT * FROM shop_product_skus WHERE `id` IN ('5795') |
  | 12240 | vapeshop | localhost | vapeshop | Query | 0 | Sending data | SELECT COUNT(DISTINCT p.id) FROM shop_product p
  | 12240 | vapeshop | localhost | vapeshop | Query | 0 | starting | SELECT * FROM shop_category WHERE `id` = '12' LIMIT 1 |
  | 12240 | vapeshop | localhost | vapeshop | Query | 0 | Sending data | SELECT * FROM shop_category WHERE (
  | 12240 | vapeshop | localhost | vapeshop | Query | 0 | Sending data | SELECT * FROM shop_dp_points WHERE `country_code` = 'rus' AND `region_code` = '77' AND `city_name` = |
  | 12240 | vapeshop | localhost | vapeshop | Query | 0 | statistics | SELECT * FROM shop_dp_points_worktime WHERE `point_hash` = '86374c458cf1a5c52a8cc6eeb300ad92' |
  | 12240 | vapeshop | localhost | vapeshop | Query | 0 | Sending data | SELECT * FROM shop_dp_points_worktime WHERE `point_hash` = '7890ef302cd7706eaf41da8504c3ab6f' |
  | 12240 | vapeshop | localhost | vapeshop | Query | 0 | Sending to client | SELECT * FROM shop_dp_points_worktime WHERE `point_hash` = 'fd0e43b7da7e836a262a4120c1a3c211' |
  | 12240 | vapeshop | localhost | vapeshop | Query | 0 | statistics | SELECT * FROM shop_dp_points_worktime WHERE `point_hash` = '042f166b320941c62f1e550cbd7360ca' |
  | 12240 | vapeshop | localhost | vapeshop | Query | 0 | statistics | SELECT * FROM shop_dp_points_worktime WHERE `point_hash` = 'eb94f1871a52908b60c88c32c0cebd16' |
  | 12240 | vapeshop | localhost | vapeshop | Query | 0 | statistics | SELECT * FROM shop_dp_points_worktime WHERE `point_hash` = '658ad0ce3d196ec673191a14278784fe' |
  | 12240 | vapeshop | localhost | vapeshop | Query | 0 | Sending data | SELECT * FROM shop_dp_points WHERE `country_code` = 'rus' AND `region_code` = '77' AND `city_name` = |
  | 12240 | vapeshop | localhost | vapeshop | Query | 0 | System lock | SELECT * FROM shop_dp_points_worktime WHERE `point_hash` = '8c928c19d62a260dd15445a328e2f17c' |
  | 12240 | vapeshop | localhost | vapeshop | Query | 0 | Sending data | SELECT * FROM shop_dp_points_worktime WHERE `point_hash` = '64ff4d87a4eb103a33d1f124f66b0325' |
  | 12240 | vapeshop | localhost | vapeshop | Query | 0 | starting | |
  | 12240 | vapeshop | localhost | vapeshop | Query | 0 | statistics | SELECT * FROM shop_dp_points_worktime WHERE `point_hash` = '6e420f6f5fd73ff5d2e69fd07d8626a6' |
  | 12240 | vapeshop | localhost | vapeshop | Query | 0 | Sending data | SELECT * FROM shop_dp_points_worktime WHERE `point_hash` = 'abc04d8338e906a17c198b8ed19926ad' |
  | 12240 | vapeshop | localhost | vapeshop | Query | 0 | Opening tables | SELECT * FROM shop_dp_points_worktime WHERE `point_hash` = '90a0a618153876c23d7d6ffa3052b1fc' |
  | 12240 | vapeshop | localhost | vapeshop | Query | 0 | Sending data | SELECT * FROM shop_dp_points_worktime WHERE `point_hash` = '26ebbb0a7fcbbf08fef276848470af19' |
  | 12240 | vapeshop | localhost | vapeshop | Query | 0 | executing | SELECT * FROM shop_dp_storefront_groups |
  | 12240 | vapeshop | localhost | vapeshop | Query | 0 | Sending to client | SELECT * FROM shop_dp_storefront_groups |
  | 12240 | vapeshop | localhost | vapeshop | Query | 0 | Creating sort index | SELECT id, parent_id, name, title, full_url, url, create_datetime, update_datetime FROM shop_page
  | 12240 | vapeshop | localhost | vapeshop | Query | 0 | Creating sort index | SELECT id, parent_id, name, title, full_url, url, create_datetime, update_datetime FROM shop_page
  | 12240 | vapeshop | localhost | vapeshop | Query | 0 | Creating sort index | SELECT c.* FROM shop_category c LEFT JOIN shop_category_routes cr ON c.id = cr.category_id WHERE (c. |
  | 12240 | vapeshop | localhost | vapeshop | Query | 0 | starting | SELECT * FROM shop_category_params WHERE `category_id` IN ('1','858','859','807','373','372','769',' |
  | 12240 | vapeshop | localhost | vapeshop | Query | 0 | Creating sort index | SELECT c.* FROM shop_category c LEFT JOIN shop_category_routes cr ON c.id = cr.category_id WHERE (c. |
  | 12524 | vapeshop | localhost | vapeshop | Query | 0 | Sending data | SELECT id, full_url FROM shop_page WHERE (domain = 'vape-shoper.ru' AND route = '*') AND (status = 1 |
  | 12524 | vapeshop | localhost | vapeshop | Query | 0 | Creating sort index | SELECT t.*, wr1.name region_name, wc1.name country_name

  ответить
  • +2

    Михаил 15 января 2019 14:32 #

    Добрый день.

    Та же проблема, около 50 поддоменов, товаров более 10000, хостинг ihc, тариф ssdVPS проц.12000 МГц память 8 ГБ. В вебмастере всегда 2-3 поддомена с пометкой "Долгий ответ сервера".

    Вы решили вопрос с кэшированием запросов к базе данных на стороне сайта?

    ответить
    • +1

      Евгений | Светим.рф | Люструм.рф 5 августа 2019 10:12 #

      Ждемс, тариф FirsVDS проще (не сильно), товаров меньше. Поддоменов меньше, стоят больше для теста, чтобы понять, какой трафик может пойти с них. Пока добавлять больше не планируем из-за нагрузки. 

      ответить