Добрый день, сильно начал тормозит сайт, он молодой посетителей нет. Всего 3500 товаров. сайт - http://secumarket.ru/
При обращению к поддержки хостинга, они ответили:
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------
При отладке. было выявлено, что долгая загрузка сайта происходит из-за долгой обработки медленных запросов к базе данных. При загрузке сайта, происходит постоянное обращение к базе, запросы очень долго выполняются. Ниже представлены самые тяжелые и медленные запросы: # 190.8s user time, 570ms system time, 27.29M rss, 208.14M vsz # Current date: Tue Jan 13 10:42:29 2015 # Hostname: vip-mysql1.ihc.ru
# Files: /var/log/mysql-slow.log # Overall: 10.60k total, 9 unique, 0.48 QPS, 0.07x concurrency ___________ # Time range: 2015-01-13 04:32:10 to 10:42:13 # Attribute total min max avg 95% stddev median # ============ ======= ======= ======= ======= ======= ======= ======= # Exec time 1497s 2ms 4s 141ms 992ms 345ms 46ms # Lock time 4s 54us 334ms 382us 467us 5ms 98us # Rows sent 52.78k 0 4.72k 5.10 3.89 94.98 0.99 # Rows examine 182.32M 1005 30.69k 17.61k 27.29k 12.52k 27.29k # Rows affecte 0 0 0 0 0 0 0 # Rows read 182.32M 1005 30.69k 17.61k 27.29k 12.52k 27.29k # Bytes sent 7.56M 60 165.68k 747.90 1.86k 3.10k 59.77 # Query size 4.31M 302 1.27k 426.06 463.90 124.43 463.90 # Profile # Rank Query ID Response time Calls R/Call V/M Item # ==== ================== =============== ===== ====== ===== ============= # 1 0x99D242C99FC610D7 1418.2078 94.7% 6270 0.2262 0.79 SELECT oc_category_path oc_product_to_category oc_product oc_product_description oc_product_to_store # 2 0xE993D93A7D01C547 43.5241 2.9% 353 0.1233 0.42 SELECT oc_product_to_category oc_product oc_product_description oc_product_to_store # MISC 0xMISC 35.6649 2.4% 3979 0.0090 0.0 <7 ITEMS> # Query 1: 0.28 QPS, 0.06x concurrency, ID 0x99D242C99FC610D7 at byte 392194572 # This item is included in the report because it matches --limit. # Scores: V/M = 0.79 # Time range: 2015-01-13 04:32:11 to 10:42:13 # Attribute pct total min max avg 95% stddev median # ============ === ======= ======= ======= ======= ======= ======= ======= # Count 59 6270 # Exec time 94 1418s 38ms 2s 226ms 1s 422ms 56ms # Lock time 63 3s 70us 132ms 409us 366us 5ms 103us # Rows sent 11 6.12k 1 1 1 1 0 1 # Rows examine 94 172.58M 28.12k 30.69k 28.19k 27.29k 302.54 27.29k # Rows affecte 0 0 0 0 0 0 0 0 # Rows read 94 172.58M 28.12k 30.69k 28.19k 27.29k 302.54 27.29k # Bytes sent 4 369.91k 60 63 60.41 59.77 0.29 59.77 # Query size 66 2.86M 478 479 478.93 463.90 0 463.90 # String: # Databases p121614_smarket # Hosts # Last errno 0 # Users p121614_smarket # Query_time distribution # 1us # 10us # 100us # 1ms # 10ms ################################################################ # 100ms ############ # 1s ####### # 10s+ # Tables # SHOW TABLE STATUS FROM `p121614_smarket` LIKE 'oc_category_path'\G # SHOW CREATE TABLE `p121614_smarket`.`oc_category_path`\G # SHOW TABLE STATUS FROM `p121614_smarket` LIKE 'oc_product_to_category'\G # SHOW CREATE TABLE `p121614_smarket`.`oc_product_to_category`\G # SHOW TABLE STATUS FROM `p121614_smarket` LIKE 'oc_product'\G # SHOW CREATE TABLE `p121614_smarket`.`oc_product`\G # SHOW TABLE STATUS FROM `p121614_smarket` LIKE 'oc_product_description'\G # SHOW CREATE TABLE `p121614_smarket`.`oc_product_description`\G # SHOW TABLE STATUS FROM `p121614_smarket` LIKE 'oc_product_to_store'\G # SHOW CREATE TABLE `p121614_smarket`.`oc_product_to_store`\G # EXPLAIN /*!50100 PARTITIONS*/ SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_category_path cp LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2015-01-13 10:00:00' AND p2s.store_id = '0' AND cp.path_id = '71'\G # Query 2: 0.02 QPS, 0.00x concurrency, ID 0xE993D93A7D01C547 at byte 390527187 # This item is included in the report because it matches --limit. # Scores: V/M = 0.42 # Time range: 2015-01-13 04:32:11 to 10:42:13 # Attribute pct total min max avg 95% stddev median # ============ === ======= ======= ======= ======= ======= ======= ======= # Count 3 353 # Exec time 2 44s 27ms 1s 123ms 672ms 226ms 38ms # Lock time 6 249ms 69us 102ms 705us 1ms 6ms 98us # Rows sent 0 353 1 1 1 1 0 1 # Rows examine 2 3.68M 10.66k 10.66k 10.66k 10.29k 0 10.29k # Rows affecte 0 0 0 0 0 0 0 0 # Rows read 2 3.68M 10.66k 10.66k 10.66k 10.29k 0 10.29k # Bytes sent 0 20.68k 60 60 60 60 0 60 # Query size 3 143.06k 415 415 415 415 0 415 # String: # Databases p121614_smarket # Hosts # Last errno 0 # Users p121614_smarket # Query_time distribution # 1us # 10us # 100us # 1ms # 10ms ################################################################ # 100ms ######## # 1s # # 10s+ # Tables # SHOW TABLE STATUS FROM `p121614_smarket` LIKE 'oc_product_to_category'\G # SHOW CREATE TABLE `p121614_smarket`.`oc_product_to_category`\G # SHOW TABLE STATUS FROM `p121614_smarket` LIKE 'oc_product'\G # SHOW CREATE TABLE `p121614_smarket`.`oc_product`\G # SHOW TABLE STATUS FROM `p121614_smarket` LIKE 'oc_product_description'\G # SHOW CREATE TABLE `p121614_smarket`.`oc_product_description`\G # SHOW TABLE STATUS FROM `p121614_smarket` LIKE 'oc_product_to_store'\G # SHOW CREATE TABLE `p121614_smarket`.`oc_product_to_store`\G # EXPLAIN /*!50100 PARTITIONS*/ SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_product_to_category p2c LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2015-01-13 10:00:00' AND p2s.store_id = '0' AND p2c.category_id = '59'\G
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Единственные ручные изменения - это в ручную прописали новую позицию модуля. Также установлено множество модулей (см. скриншот).
По началу думали, что тормозит из-за модуля Coolfilter, потом вместо него поставили платный OCFilter.
Подскажите пожалуйста в чём может быть проблема?