Jump to content
Sign in to follow this  
tyber

очень долго грузятся главные категории

Recommended Posts

Ребят помогите уже незнаю что творить очень долго прогружаются главные категориии доходит то 15 секунд что тока не делал а именно

oSStore 1.5.5.1.1 на ВПС 20000 товаров

подсчет товаров в категориях отключен

"скрытый" подсчет товаров в категории я так понял в этой версии оптимизирован

mysql оптимизирован через конфиг

key_buffer = 400Mmax_allowed_packet = 48Mtable_cache = 1024sort_buffer_size = 4mread_buffer_size = 4mread_rnd_buffer_size = 2mmyisam_sort_buffer_size = 64mtmp_table_size = 96mquery_cache_type = 1query_cache_size = 64mthread_cache_size = 16max_connections = 300wait_timeout = 120

чекбоксы с главных категорий сняты

на сайте найдете в верхнем правом углу дебагер на нем все видно

особенно жутко долго грузится категория Р/У МОДЕЛИ по ней и ориентируюсь

rc-tachki.ru

 

Парни выручайте

 

 

Share this post


Link to post
Share on other sites

вот точно уже установил что грузятся долго только главные категорие особенно почему то категория Р/У МОДЕЛИ по 10 сек минимум, все остальное в виде подкатегорий или продуктов грузится шустро в чем может быть проблема долгой загрузки главных категорий

Share this post


Link to post
Share on other sites

незнаю может полезно будет вот что красным рисуется

201 SELECT COUNT(DISTINCT p.product_id) AS total FROM category_path cp LEFT JOIN product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN product p ON (p2c.product_id = p.product_id) LEFT JOIN product_description pd ON (p.product_id = pd.product_id) LEFT JOIN product_to_store p2s ON (p.pr 0.55986200 s 202 SELECT COUNT(DISTINCT p.product_id) AS total FROM category_path cp LEFT JOIN product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN product p ON (p2c.product_id = p.product_id) LEFT JOIN product_description pd ON (p.product_id = pd.product_id) LEFT JOIN product_to_store p2s ON (p.pr 0.46948400 s 203 SELECT COUNT(DISTINCT p.product_id) AS total FROM category_path cp LEFT JOIN product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN product p ON (p2c.product_id = p.product_id) LEFT JOIN product_description pd ON (p.product_id = pd.product_id) LEFT JOIN product_to_store p2s ON (p.pr 0.38535500 s 204 SELECT COUNT(DISTINCT p.product_id) AS total FROM category_path cp LEFT JOIN product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN product p ON (p2c.product_id = p.product_id) LEFT JOIN product_description pd ON (p.product_id = pd.product_id) LEFT JOIN product_to_store p2s ON (p.pr 0.42906500 s 205 SELECT COUNT(DISTINCT p.product_id) AS total FROM category_path cp LEFT JOIN product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN product p ON (p2c.product_id = p.product_id) LEFT JOIN product_description pd ON (p.product_id = pd.product_id) LEFT JOIN product_to_store p2s ON (p.pr 0.42598800 s 206 SELECT COUNT(DISTINCT p.product_id) AS total FROM category_path cp LEFT JOIN product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN product p ON (p2c.product_id = p.product_id) LEFT JOIN product_description pd ON (p.product_id = pd.product_id) LEFT JOIN product_to_store p2s ON (p.pr 0.45030400 s 207 SELECT COUNT(DISTINCT p.product_id) AS total FROM category_path cp LEFT JOIN product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN product p ON (p2c.product_id = p.product_id) LEFT JOIN product_description pd ON (p.product_id = pd.product_id) LEFT JOIN product_to_store p2s ON (p.pr 0.49222900 s 208 SELECT COUNT(DISTINCT p.product_id) AS total FROM category_path cp LEFT JOIN product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN product p ON (p2c.product_id = p.product_id) LEFT JOIN product_description pd ON (p.product_id = pd.product_id) LEFT JOIN product_to_store p2s ON (p.pr 0.44503100 s 209 SELECT COUNT(DISTINCT p.product_id) AS total FROM category_path cp LEFT JOIN product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN product p ON (p2c.product_id = p.product_id) LEFT JOIN product_description pd ON (p.product_id = pd.product_id) LEFT JOIN product_to_store p2s ON (p.pr 0.42630100 s 210 SELECT COUNT(DISTINCT p.product_id) AS total FROM category_path cp LEFT JOIN product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN product p ON (p2c.product_id = p.product_id) LEFT JOIN product_description pd ON (p.product_id = pd.product_id) LEFT JOIN product_to_store p2s ON (p.pr 0.45919300 s 211 SELECT COUNT(DISTINCT p.product_id) AS total FROM category_path cp LEFT JOIN product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN product p ON (p2c.product_id = p.product_id) LEFT JOIN product_description pd ON (p.product_id = pd.product_id) LEFT JOIN product_to_store p2s ON (p.pr 0.40127000 s 212 SELECT SQL_CALC_FOUND_ROWS p.product_id, (SELECT AVG(rating) AS total FROM review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT price FROM product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity 0.49157400 s

Share this post


Link to post
Share on other sites

хостер подключил логирование запросов к MySQL я полазил по сайту и вот что лог записал

/usr/libexec/mysqld, Version: 5.1.52-log (Source distribution). started with:
Tcp port: 3306  Unix socket: /var/lib/mysql/mysql.sock
Time                 Id Command    Argument
/usr/libexec/mysqld, Version: 5.1.52-log (Source distribution). started with:
Tcp port: 3306  Unix socket: /var/lib/mysql/mysql.sock
Time                 Id Command    Argument
# Time: 131105 11:02:01
# User@Host: root[root] @ localhost []
# Query_time: 21.174060  Lock_time: 0.000093 Rows_sent: 2  Rows_examined: 843
SET timestamp=1383634921;
SELECT ENGINE,SUM(DATA_LENGTH),COUNT(ENGINE) FROM information_schema.TABLES WHERE TABLE_SCHEMA NOT IN ('information_schema','mysql') AND ENGINE IS NOT NULL GROUP BY ENGINE ORDER BY ENGINE ASC;

 так же вот их рекомендации

Запросы от движков сайта к базе данных большие. Рекомендуем включить кэш движков.

 

Ребят подскажите что сделать

Share this post


Link to post
Share on other sites

Ребят ну подскажите в чем может быть проблема. Ну хоть намек какой

Share this post


Link to post
Share on other sites

все понятно кароче

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
You are posting as a guest. If you have an account, please sign in.
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Sign in to follow this  

  • Recently Browsing   0 members

    No registered users viewing this page.

×

Important Information

On our site, cookies are used and personal data is processed to improve the user interface. To find out what and what personal data we are processing, please go to the link. If you click "I agree," it means that you understand and accept all the conditions specified in this Privacy Notice.