нагрузка на Б\Д

kratelig · 9 січня 2014

По поиску прочел несколько тем о нагрузке, но так и не понял в чем смысл.

Моя проблема такая.

15.12 вдруг началась большая нагрузка на бд

Сегодня хостер выдал бан.

Интернет-Магазин примерно на 200-300 уников в сутки.

Стоит всего 2 модуля и те давно! И никогда проблем не давали.

Отписал хостеру, тот выслал логи такого вида

Ниже представлен лог медленных запросов к базе данных p118192_db , в данном файле ресурсоемкие запросы обработка которых вызвало превышение лимита:

# 388.3s user time, 1.7s system time, 25.59M rss, 204.46M vsz
# Current date: Fri Jan 10 01:19:40 2014
# Hostname: mysql3.ihc.ru
# Files: /var/log/mysql-slow.log-20140108
# Overall: 21 total, 10 unique, 0.00 QPS, 0.00x concurrency ______________
# Time range: 2014-01-07 04:02:55 to 2014-01-08 02:09:18
# Attribute total min max avg 95% stddev median
# ============ ======= ======= ======= ======= ======= ======= =======
# Exec time 124ms 2ms 16ms 6ms 9ms 4ms 5ms
# Lock time 23ms 23us 13ms 1ms 1ms 3ms 316us
# Rows sent 8.15k 0 3.85k 397.43 80.10 1.08k 3.89
# Rows examine 42.03k 1.04k 3.93k 2.00k 3.88k 1.31k 1.04k
# Rows affecte 0 0 0 0 0 0 0
# Rows read 42.03k 1.04k 3.93k 2.00k 3.88k 1.31k 1.04k
# Bytes sent 251.37k 60 113.13k 11.97k 4.71k 32.65k 158.58
# Query size 8.57k 71 746 418.10 685.39 249.63 487.09

# Profile
# Rank Query ID Response time Calls R/Call V/M Item
# ==== ================== ============= ===== ====== ===== ===============
# 1 0x6D4DAC78312CE5B4 0.0270 21.8% 3 0.0090 0.00 SELECT product product_description product_to_store product_tag
# 2 0x368D90E5FDCEAD9C 0.0235 19.0% 5 0.0047 0.01 SELECT zone
# 3 0xA9129758DF99928D 0.0147 11.9% 2 0.0074 0.00 SELECT review product product_description product_to_store product_tag
# 4 0x959C946F510DC900 0.0118 9.5% 2 0.0059 0.00 SELECT product product_description product_to_store product_tag
# 5 0x53A20864BDFF7427 0.0114 9.2% 2 0.0057 0.00 SELECT product product_description product_to_store product_tag
# 6 0xEBAFCAE7B381744F 0.0110 8.9% 2 0.0055 0.00 SELECT review product product_description product_to_store product_tag
# 7 0x3BCEC1307EAD2B39 0.0071 5.8% 1 0.0071 0.00 SELECT review product product_description product_to_store product_tag
# 8 0x2D93F61C379932D4 0.0071 5.7% 2 0.0035 0.00 SELECT zone
# 9 0x9418326C76CED1CE 0.0055 4.4% 1 0.0055 0.00 SELECT review product product_description product_to_store product_tag
# MISC 0xMISC 0.0049 3.9% 1 0.0049 0.0 <1 ITEMS>

# Query 1: 0.00 QPS, 0.00x concurrency, ID 0x6D4DAC78312CE5B4 at byte 403281560
# Scores: V/M = 0.00
# Time range: 2014-01-07 14:17:13 to 16:44:07
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 14 3
# Exec time 21 27ms 6ms 15ms 9ms 15ms 4ms 6ms
# Lock time 3 835us 102us 405us 278us 403us 128us 316us
# Rows sent 0 3 1 1 1 1 0 1
# Rows examine 7 3.12k 1.04k 1.04k 1.04k 1.04k 0 1.04k
# Rows affecte 0 0 0 0 0 0 0 0
# Rows read 7 3.12k 1.04k 1.04k 1.04k 1.04k 0 1.04k
# Bytes sent 0 180 60 60 60 60 0 60
# Query size 17 1.50k 508 522 512.67 511.45 7 487.09
# String:
# Databases p118192_db
# Hosts
# Last errno 0
# Users p118192_db
# Query_time distribution
# 1us
# 10us
# 100us
# 1ms ################################################################
# 10ms ################################
# 100ms
# 1s
# 10s+
# Tables
# SHOW TABLE STATUS FROM `p118192_db` LIKE 'product'\G
# SHOW CREATE TABLE `p118192_db`.`product`\G
# SHOW TABLE STATUS FROM `p118192_db` LIKE 'product_description'\G
# SHOW CREATE TABLE `p118192_db`.`product_description`\G
# SHOW TABLE STATUS FROM `p118192_db` LIKE 'product_to_store'\G
# SHOW CREATE TABLE `p118192_db`.`product_to_store`\G
# SHOW TABLE STATUS FROM `p118192_db` LIKE 'product_tag'\G
# SHOW CREATE TABLE `p118192_db`.`product_tag`\G
# EXPLAIN /*!50100 PARTITIONS*/
SELECT COUNT(DISTINCT p.product_id) AS total FROM product p LEFT JOIN product_description pd ON (p.product_id = pd.product_id) LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN product_tag pt ON (p.product_id = pt.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND ( LCASE(pd.name) LIKE '%neo%' OR LCASE(pd.name) LIKE '%pro-65%' OR LCASE(pt.tag) LIKE '%neo%' OR LCASE(pt.tag) LIKE '%pro-65%' AND pt.language_id = '1')\G

Как я понял идет нагрузка, при добавлении товаров и оформлении заказа?

Нигде в найденных мною темах такого не указывалось.

В чем может быть проблема?

kratelig · 9 січня 2014

как я понял из тем, у многих проблема в product_id.

Но у народа еще идет и нагрузка на CPU, а у меня только на БД.

И нигде решение проблемы нету :(

тема с вирусом в response.php вроде не хляет, у меня двиг стоит уже больше года. А взлом был в апреле 13-го

afwollis · 9 січня 2014

то, что в "# Profile" мне не совсем понятно (не считая того, что указан тип запроса и затрагиваемые таблицы (не факт, что все)).

запрос (который в самом конце) это поиск.

Ниже представлен лог медленных запросов к базе данных p118192_db , в данном файле ресурсоемкие запросы обработка которых вызвало превышение лимита:

лог медленных запросов, обычно, выглядит иначе.

у вас есть доступ к "/var/log/mysql-slow.log-20140108" ?

kratelig · 9 січня 2014

лог медленных запросов, обычно, выглядит иначе.
у вас есть доступ к "/var/log/mysql-slow.log-20140108" ?

к сожалению-нет.

Данный лог предоставлен саппортом, через тикеты

Вот есть другой лог

2014-01-06 00:06:42.901 [NOTICE] [95.179.37.180:62960-0#p118192:loudsound.su] Content len: 0, Request line: 'GET /index.php?route=product/product&product_id=88 HTTP/1.1'

2014-01-06 00:08:27.156 [NOTICE] [213.180.206.197:59015-0#p118192:loudsound.su] Content len: 0, Request line: 'GET / HTTP/1.1'

2014-01-08 00:03:48.553 [NOTICE] [62.133.175.217:59429-0#p118192:loudsound.su] Content len: 0, Request line: 'GET /index.php?route=product/category&path=60 HTTP/1.1'

2014-01-08 00:05:05.088 [NOTICE] [5.10.83.75:39786-0#p118192:loudsound.su] Content len: 0, Request line: 'GET /index.php?route=product/product&product_id=228 HTTP/1.1'

2014-01-09 00:12:01.982 [NOTICE] [178.207.131.201:49746-0#p118192:loudsound.su] Content len: 0, Request line: 'GET /image/cache/data/ALPHARD%20Hannibal%20HLS-20-228x228-500x500.jpg HTTP/1.1'

2014-01-09 00:12:05.845 [NOTICE] [178.207.131.201:49746-1#p118192:loudsound.su] Content len: 0, Request line: 'GET /favicon.ico HTTP/1.1'

запрос (который в самом конце) это поиск.

Таких запросов мне саппорт выдал аж 8 штук. Я решил только 1 скопировать. Могу остальные 7 под спойлер загнать.

afwollis · 9 січня 2014

Вот есть другой лог...

это обычный access-log web-сервера. бесполезен в данном случае.

Таких запросов мне саппорт выдал аж 8 штук. Я решил только 1 скопировать. Могу остальные 7 под спойлер загнать.

да, выкладывайте.

kratelig · 9 січня 2014

это обычный access-log web-сервера. бесполезен в данном случае.

К сожалению, выше доступ не имею.

Я решил все скопировать с письма.

Ниже представлен лог медленных запросов к базе данных p118192_db , в данном файле ресурсоемкие запросы обработка которых вызвало превышение лимита:

# 388.3s user time, 1.7s system time, 25.59M rss, 204.46M vsz

# Current date: Fri Jan 10 01:19:40 2014

# Hostname: mysql3.ihc.ru

# Files: /var/log/mysql-slow.log-20140108

# Overall: 21 total, 10 unique, 0.00 QPS, 0.00x concurrency ______________

# Time range: 2014-01-07 04:02:55 to 2014-01-08 02:09:18

# Attribute total min max avg 95% stddev median

# ============ ======= ======= ======= ======= ======= ======= =======

# Exec time 124ms 2ms 16ms 6ms 9ms 4ms 5ms

# Lock time 23ms 23us 13ms 1ms 1ms 3ms 316us

# Rows sent 8.15k 0 3.85k 397.43 80.10 1.08k 3.89

# Rows examine 42.03k 1.04k 3.93k 2.00k 3.88k 1.31k 1.04k

# Rows affecte 0 0 0 0 0 0 0

# Rows read 42.03k 1.04k 3.93k 2.00k 3.88k 1.31k 1.04k

# Bytes sent 251.37k 60 113.13k 11.97k 4.71k 32.65k 158.58

# Query size 8.57k 71 746 418.10 685.39 249.63 487.09

# Profile

# Rank Query ID Response time Calls R/Call V/M Item

# ==== ================== ============= ===== ====== ===== ===============

# 1 0x6D4DAC78312CE5B4 0.0270 21.8% 3 0.0090 0.00 SELECT product product_description product_to_store product_tag

# 2 0x368D90E5FDCEAD9C 0.0235 19.0% 5 0.0047 0.01 SELECT zone

# 3 0xA9129758DF99928D 0.0147 11.9% 2 0.0074 0.00 SELECT review product product_description product_to_store product_tag

# 4 0x959C946F510DC900 0.0118 9.5% 2 0.0059 0.00 SELECT product product_description product_to_store product_tag

# 5 0x53A20864BDFF7427 0.0114 9.2% 2 0.0057 0.00 SELECT product product_description product_to_store product_tag

# 6 0xEBAFCAE7B381744F 0.0110 8.9% 2 0.0055 0.00 SELECT review product product_description product_to_store product_tag

# 7 0x3BCEC1307EAD2B39 0.0071 5.8% 1 0.0071 0.00 SELECT review product product_description product_to_store product_tag

# 8 0x2D93F61C379932D4 0.0071 5.7% 2 0.0035 0.00 SELECT zone

# 9 0x9418326C76CED1CE 0.0055 4.4% 1 0.0055 0.00 SELECT review product product_description product_to_store product_tag

# MISC 0xMISC 0.0049 3.9% 1 0.0049 0.0 <1 ITEMS>

# Query 1: 0.00 QPS, 0.00x concurrency, ID 0x6D4DAC78312CE5B4 at byte 403281560

# Scores: V/M = 0.00

# Time range: 2014-01-07 14:17:13 to 16:44:07

# Attribute pct total min max avg 95% stddev median

# ============ === ======= ======= ======= ======= ======= ======= =======

# Count 14 3

# Exec time 21 27ms 6ms 15ms 9ms 15ms 4ms 6ms

# Lock time 3 835us 102us 405us 278us 403us 128us 316us

# Rows sent 0 3 1 1 1 1 0 1

# Rows examine 7 3.12k 1.04k 1.04k 1.04k 1.04k 0 1.04k

# Rows affecte 0 0 0 0 0 0 0 0

# Rows read 7 3.12k 1.04k 1.04k 1.04k 1.04k 0 1.04k

# Bytes sent 0 180 60 60 60 60 0 60

# Query size 17 1.50k 508 522 512.67 511.45 7 487.09

# String:

# Databases p118192_db

# Hosts

# Last errno 0

# Users p118192_db

# Query_time distribution

# 1us

# 10us

# 100us

# 1ms ################################################################

# 10ms ################################

# 100ms

# 1s

# 10s+

# Tables

# SHOW TABLE STATUS FROM `p118192_db` LIKE 'product'\G

# SHOW CREATE TABLE `p118192_db`.`product`\G

# SHOW TABLE STATUS FROM `p118192_db` LIKE 'product_description'\G

# SHOW CREATE TABLE `p118192_db`.`product_description`\G

# SHOW TABLE STATUS FROM `p118192_db` LIKE 'product_to_store'\G

# SHOW CREATE TABLE `p118192_db`.`product_to_store`\G

# SHOW TABLE STATUS FROM `p118192_db` LIKE 'product_tag'\G

# SHOW CREATE TABLE `p118192_db`.`product_tag`\G

# EXPLAIN /*!50100 PARTITIONS*/

SELECT COUNT(DISTINCT p.product_id) AS total FROM product p LEFT JOIN product_description pd ON (p.product_id = pd.product_id) LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN product_tag pt ON (p.product_id = pt.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND ( LCASE(pd.name) LIKE '%neo%' OR LCASE(pd.name) LIKE '%pro-65%' OR LCASE(pt.tag) LIKE '%neo%' OR LCASE(pt.tag) LIKE '%pro-65%' AND pt.language_id = '1')\G

# Query 2: 0.00 QPS, 0.00x concurrency, ID 0x368D90E5FDCEAD9C at byte 479158998

# Scores: V/M = 0.01

# Time range: 2014-01-07 15:39:45 to 2014-01-08 01:20:49

# Attribute pct total min max avg 95% stddev median

# ============ === ======= ======= ======= ======= ======= ======= =======

# Count 23 5

# Exec time 18 24ms 2ms 16ms 5ms 16ms 6ms 2ms

# Lock time 60 14ms 156us 13ms 3ms 13ms 5ms 204us

# Rows sent 4 415 83 83 83 83 0 83

# Rows examine 46 19.66k 3.93k 3.93k 3.93k 3.93k 0 3.93k

# Rows affecte 0 0 0 0 0 0 0 0

# Rows read 46 19.66k 3.93k 3.93k 3.93k 3.93k 0 3.93k

# Bytes sent 9 23.62k 4.72k 4.72k 4.72k 4.72k 0 4.72k

# Query size 4 370 74 74 74 74 0 74

# String:

# Databases p118192_db

# Hosts

# Last errno 0

# Users p118192_db

# Query_time distribution

# 1us

# 10us

# 100us

# 1ms ################################################################

# 10ms ################

# 100ms

# 1s

# 10s+

# Tables

# SHOW TABLE STATUS FROM `p118192_db` LIKE 'zone'\G

# SHOW CREATE TABLE `p118192_db`.`zone`\G

# EXPLAIN /*!50100 PARTITIONS*/

SELECT * FROM zone WHERE country_id = '176' AND status = '1' ORDER BY name\G

# Query 3: 0.00 QPS, 0.00x concurrency, ID 0xA9129758DF99928D at byte 746943162

# Scores: V/M = 0.00

# Time range: 2014-01-07 20:52:24 to 2014-01-08 02:09:18

# Attribute pct total min max avg 95% stddev median

# ============ === ======= ======= ======= ======= ======= ======= =======

# Count 9 2

# Exec time 11 15ms 5ms 10ms 7ms 10ms 3ms 7ms

# Lock time 12 3ms 385us 3ms 1ms 3ms 2ms 1ms

# Rows sent 0 8 4 4 4 4 0 4

# Rows examine 4 2.10k 1.05k 1.05k 1.05k 1.05k 0 1.05k

# Rows affecte 0 0 0 0 0 0 0 0

# Rows read 4 2.10k 1.05k 1.05k 1.05k 1.05k 0 1.05k

# Bytes sent 0 320 160 160 160 160 0 160

# Query size 14 1.28k 657 657 657 657 0 657

# String:

# Databases p118192_db

# Hosts

# Last errno 0

# Users p118192_db

# Query_time distribution

# 1us

# 10us

# 100us

# 1ms ################################################################

# 10ms

# 100ms

# 1s

# 10s+

# Tables

# SHOW TABLE STATUS FROM `p118192_db` LIKE 'review'\G

# SHOW CREATE TABLE `p118192_db`.`review`\G

# SHOW TABLE STATUS FROM `p118192_db` LIKE 'product'\G

# SHOW CREATE TABLE `p118192_db`.`product`\G

# SHOW TABLE STATUS FROM `p118192_db` LIKE 'product_description'\G

# SHOW CREATE TABLE `p118192_db`.`product_description`\G

# SHOW TABLE STATUS FROM `p118192_db` LIKE 'product_to_store'\G

# SHOW CREATE TABLE `p118192_db`.`product_to_store`\G

# SHOW TABLE STATUS FROM `p118192_db` LIKE 'product_tag'\G

# SHOW CREATE TABLE `p118192_db`.`product_tag`\G

# EXPLAIN /*!50100 PARTITIONS*/

SELECT 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 FROM product p LEFT JOIN product_description pd ON (p.product_id = pd.product_id) LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN product_tag pt ON (p.product_id = pt.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND ( LCASE(pt.tag) LIKE '%aq%' OR LCASE(pt.tag) LIKE '%2.512%' OR LCASE(pt.tag) LIKE '%d4%' AND pt.language_id = '1') GROUP BY p.product_id ORDER BY p.sort_order ASC, LCASE(pd.name) ASC LIMIT 0,15\G

# Query 4: 0.15 QPS, 0.00x concurrency, ID 0x959C946F510DC900 at byte 981013687

# Scores: V/M = 0.00

# Time range: 2014-01-08 00:38:57 to 00:39:10

# Attribute pct total min max avg 95% stddev median

# ============ === ======= ======= ======= ======= ======= ======= =======

# Count 9 2

# Exec time 9 12ms 5ms 7ms 6ms 7ms 2ms 6ms

# Lock time 6 1ms 325us 1ms 711us 1ms 546us 711us

# Rows sent 0 2 1 1 1 1 0 1

# Rows examine 4 2.08k 1.04k 1.04k 1.04k 1.04k 0 1.04k

# Rows affecte 0 0 0 0 0 0 0 0

# Rows read 4 2.08k 1.04k 1.04k 1.04k 1.04k 0 1.04k

# Bytes sent 0 122 61 61 61 61 0 61

# Query size 12 1.09k 558 558 558 558 0 558

# String:

# Databases p118192_db

# Hosts

# Last errno 0

# Users p118192_db

# Query_time distribution

# 1us

# 10us

# 100us

# 1ms ################################################################

# 10ms

# 100ms

# 1s

# 10s+

# Tables

# SHOW TABLE STATUS FROM `p118192_db` LIKE 'product'\G

# SHOW CREATE TABLE `p118192_db`.`product`\G

# SHOW TABLE STATUS FROM `p118192_db` LIKE 'product_description'\G

# SHOW CREATE TABLE `p118192_db`.`product_description`\G

# SHOW TABLE STATUS FROM `p118192_db` LIKE 'product_to_store'\G

# SHOW CREATE TABLE `p118192_db`.`product_to_store`\G

# SHOW TABLE STATUS FROM `p118192_db` LIKE 'product_tag'\G

# SHOW CREATE TABLE `p118192_db`.`product_tag`\G

# EXPLAIN /*!50100 PARTITIONS*/

SELECT COUNT(DISTINCT p.product_id) AS total FROM product p LEFT JOIN product_description pd ON (p.product_id = pd.product_id) LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN product_tag pt ON (p.product_id = pt.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND ( LCASE(pt.tag) LIKE '%alphard%' OR LCASE(pt.tag) LIKE '%ps-8%' OR LCASE(pt.tag) LIKE '%8ом%' OR LCASE(pt.tag) LIKE '%эстрадка%' OR LCASE(pt.tag) LIKE '%мидбас%' AND pt.language_id = '1')\G

# Query 5: 0.00 QPS, 0.00x concurrency, ID 0x53A20864BDFF7427 at byte 1055160597

# Scores: V/M = 0.00

# Time range: 2014-01-07 20:52:24 to 2014-01-08 02:09:18

# Attribute pct total min max avg 95% stddev median

# ============ === ======= ======= ======= ======= ======= ======= =======

# Count 9 2

# Exec time 9 11ms 6ms 6ms 6ms 6ms 242us 6ms

# Lock time 9 2ms 678us 1ms 1ms 1ms 501us 1ms

# Rows sent 0 2 1 1 1 1 0 1

# Rows examine 4 2.08k 1.04k 1.04k 1.04k 1.04k 0 1.04k

# Rows affecte 0 0 0 0 0 0 0 0

# Rows read 4 2.08k 1.04k 1.04k 1.04k 1.04k 0 1.04k

# Bytes sent 0 120 60 60 60 60 0 60

# Query size 10 938 469 469 469 469 0 469

# String:

# Databases p118192_db

# Hosts

# Last errno 0

# Users p118192_db

# Query_time distribution

# 1us

# 10us

# 100us

# 1ms ################################################################

# 10ms

# 100ms

# 1s

# 10s+

# Tables

# SHOW TABLE STATUS FROM `p118192_db` LIKE 'product'\G

# SHOW CREATE TABLE `p118192_db`.`product`\G

# SHOW TABLE STATUS FROM `p118192_db` LIKE 'product_description'\G

# SHOW CREATE TABLE `p118192_db`.`product_description`\G

# SHOW TABLE STATUS FROM `p118192_db` LIKE 'product_to_store'\G

# SHOW CREATE TABLE `p118192_db`.`product_to_store`\G

# SHOW TABLE STATUS FROM `p118192_db` LIKE 'product_tag'\G

# SHOW CREATE TABLE `p118192_db`.`product_tag`\G

# EXPLAIN /*!50100 PARTITIONS*/

SELECT COUNT(DISTINCT p.product_id) AS total FROM product p LEFT JOIN product_description pd ON (p.product_id = pd.product_id) LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN product_tag pt ON (p.product_id = pt.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND ( LCASE(pt.tag) LIKE '%aq%' OR LCASE(pt.tag) LIKE '%2.512%' OR LCASE(pt.tag) LIKE '%d4%' AND pt.language_id = '1')\G

# Query 6: 0.00 QPS, 0.00x concurrency, ID 0xEBAFCAE7B381744F at byte 403282368

# Scores: V/M = 0.00

# Time range: 2014-01-07 14:17:13 to 16:44:07

# Attribute pct total min max avg 95% stddev median

# ============ === ======= ======= ======= ======= ======= ======= =======

# Count 9 2

# Exec time 8 11ms 5ms 6ms 6ms 6ms 202us 6ms

# Lock time 1 285us 120us 165us 142us 165us 31us 142us

# Rows sent 0 3 0 3 1.50 3 2.12 1.50

# Rows examine 4 2.09k 1.04k 1.05k 1.04k 1.05k 4.95 1.04k

# Rows affecte 0 0 0 0 0 0 0 0

# Rows read 4 2.09k 1.04k 1.05k 1.04k 1.05k 4.95 1.04k

# Bytes sent 0 271 119 152 135.50 152 23.33 135.50

# Query size 16 1.37k 696 710 703 710 9.90 703

# String:

# Databases p118192_db

# Hosts

# Last errno 0

# Users p118192_db

# Query_time distribution

# 1us

# 10us

# 100us

# 1ms ################################################################

# 10ms

# 100ms

# 1s

# 10s+

# Tables

# SHOW TABLE STATUS FROM `p118192_db` LIKE 'review'\G

# SHOW CREATE TABLE `p118192_db`.`review`\G

# SHOW TABLE STATUS FROM `p118192_db` LIKE 'product'\G

# SHOW CREATE TABLE `p118192_db`.`product`\G

# SHOW TABLE STATUS FROM `p118192_db` LIKE 'product_description'\G

# SHOW CREATE TABLE `p118192_db`.`product_description`\G

# SHOW TABLE STATUS FROM `p118192_db` LIKE 'product_to_store'\G

# SHOW CREATE TABLE `p118192_db`.`product_to_store`\G

# SHOW TABLE STATUS FROM `p118192_db` LIKE 'product_tag'\G

# SHOW CREATE TABLE `p118192_db`.`product_tag`\G

# EXPLAIN /*!50100 PARTITIONS*/

SELECT 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 FROM product p LEFT JOIN product_description pd ON (p.product_id = pd.product_id) LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN product_tag pt ON (p.product_id = pt.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND ( LCASE(pd.name) LIKE '%neo%' OR LCASE(pd.name) LIKE '%pro-65%' OR LCASE(pt.tag) LIKE '%neo%' OR LCASE(pt.tag) LIKE '%pro-65%' AND pt.language_id = '1') GROUP BY p.product_id ORDER BY p.sort_order ASC, LCASE(pd.name) ASC LIMIT 0,15\G

# Query 7: 0 QPS, 0x concurrency, ID 0x3BCEC1307EAD2B39 at byte 980770230

# Scores: V/M = 0.00

# Time range: all events occurred at 2014-01-08 00:38:57

# Attribute pct total min max avg 95% stddev median

# ============ === ======= ======= ======= ======= ======= ======= =======

# Count 4 1

# Exec time 5 7ms 7ms 7ms 7ms 7ms 0 7ms

# Lock time 1 357us 357us 357us 357us 357us 0 357us

# Rows sent 0 15 15 15 15 15 0 15

# Rows examine 2 1.08k 1.08k 1.08k 1.08k 1.08k 0 1.08k

# Rows affecte 0 0 0 0 0 0 0 0

# Rows read 2 1.08k 1.08k 1.08k 1.08k 1.08k 0 1.08k

# Bytes sent 0 254 254 254 254 254 0 254

# Query size 8 746 746 746 746 746 0 746

# String:

# Databases p118192_db

# Hosts

# Last errno 0

# Users p118192_db

# Query_time distribution

# 1us

# 10us

# 100us

# 1ms ################################################################

# 10ms

# 100ms

# 1s

# 10s+

# Tables

# SHOW TABLE STATUS FROM `p118192_db` LIKE 'review'\G

# SHOW CREATE TABLE `p118192_db`.`review`\G

# SHOW TABLE STATUS FROM `p118192_db` LIKE 'product'\G

# SHOW CREATE TABLE `p118192_db`.`product`\G

# SHOW TABLE STATUS FROM `p118192_db` LIKE 'product_description'\G

# SHOW CREATE TABLE `p118192_db`.`product_description`\G

# SHOW TABLE STATUS FROM `p118192_db` LIKE 'product_to_store'\G

# SHOW CREATE TABLE `p118192_db`.`product_to_store`\G

# SHOW TABLE STATUS FROM `p118192_db` LIKE 'product_tag'\G

# SHOW CREATE TABLE `p118192_db`.`product_tag`\G

# EXPLAIN /*!50100 PARTITIONS*/

SELECT 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 FROM product p LEFT JOIN product_description pd ON (p.product_id = pd.product_id) LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN product_tag pt ON (p.product_id = pt.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND ( LCASE(pt.tag) LIKE '%alphard%' OR LCASE(pt.tag) LIKE '%ps-8%' OR LCASE(pt.tag) LIKE '%8ом%' OR LCASE(pt.tag) LIKE '%эстрадка%' OR LCASE(pt.tag) LIKE '%мидбас%' AND pt.language_id = '1') GROUP BY p.product_id ORDER BY p.sort_order ASC, LCASE(pd.name) ASC LIMIT 0,15\G

# Query 8: 0.00 QPS, 0.00x concurrency, ID 0x2D93F61C379932D4 at byte 514739

# Scores: V/M = 0.00

# Time range: 2014-01-07 04:02:55 to 22:30:01

# Attribute pct total min max avg 95% stddev median

# ============ === ======= ======= ======= ======= ======= ======= =======

# Count 9 2

# Exec time 5 7ms 3ms 4ms 4ms 4ms 323us 4ms

# Lock time 0 48us 23us 25us 24us 25us 1us 24us

# Rows sent 94 7.70k 3.85k 3.85k 3.85k 3.85k 0 3.85k

# Rows examine 18 7.70k 3.85k 3.85k 3.85k 3.85k 0 3.85k

# Rows affecte 0 0 0 0 0 0 0 0

# Rows read 18 7.70k 3.85k 3.85k 3.85k 3.85k 0 3.85k

# Bytes sent 90 226.26k 113.13k 113.13k 113.13k 113.13k 0 113.13k

# Query size 1 142 71 71 71 71 0 71

# String:

# Databases p118192_db

# Hosts localhost

# Last errno 0

# Users mysql_backup

# Query_time distribution

# 1us

# 10us

# 100us

# 1ms ################################################################

# 10ms

# 100ms

# 1s

# 10s+

# Tables

# SHOW TABLE STATUS FROM `p118192_db` LIKE 'zone'\G

# SHOW CREATE TABLE `p118192_db`.`zone`\G

# EXPLAIN /*!50100 PARTITIONS*/

SELECT /*!40001 SQL_NO_CACHE */ /*!50084 SQL_NO_FCACHE */ * FROM `zone`\G

# Query 9: 0 QPS, 0x concurrency, ID 0x9418326C76CED1CE at byte 648370818

# Scores: V/M = 0.00

# Time range: all events occurred at 2014-01-07 19:01:46

# Attribute pct total min max avg 95% stddev median

# ============ === ======= ======= ======= ======= ======= ======= =======

# Count 4 1

# Exec time 4 6ms 6ms 6ms 6ms 6ms 0 6ms

# Lock time 1 350us 350us 350us 350us 350us 0 350us

# Rows sent 0 9 9 9 9 9 0 9

# Rows examine 2 1.06k 1.06k 1.06k 1.06k 1.06k 0 1.06k

# Rows affecte 0 0 0 0 0 0 0 0

# Rows read 2 1.06k 1.06k 1.06k 1.06k 1.06k 0 1.06k

# Bytes sent 0 198 198 198 198 198 0 198

# Query size 7 699 699 699 699 699 0 699

# String:

# Databases p118192_db

# Hosts

# Last errno 0

# Users p118192_db

# Query_time distribution

# 1us

# 10us

# 100us

# 1ms ################################################################

# 10ms

# 100ms

# 1s

# 10s+

# Tables

# SHOW TABLE STATUS FROM `p118192_db` LIKE 'review'\G

# SHOW CREATE TABLE `p118192_db`.`review`\G

# SHOW TABLE STATUS FROM `p118192_db` LIKE 'product'\G

# SHOW CREATE TABLE `p118192_db`.`product`\G

# SHOW TABLE STATUS FROM `p118192_db` LIKE 'product_description'\G

# SHOW CREATE TABLE `p118192_db`.`product_description`\G

# SHOW TABLE STATUS FROM `p118192_db` LIKE 'product_to_store'\G

# SHOW CREATE TABLE `p118192_db`.`product_to_store`\G

# SHOW TABLE STATUS FROM `p118192_db` LIKE 'product_tag'\G

# SHOW CREATE TABLE `p118192_db`.`product_tag`\G

# EXPLAIN /*!50100 PARTITIONS*/

SELECT 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 FROM product p LEFT JOIN product_description pd ON (p.product_id = pd.product_id) LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN product_tag pt ON (p.product_id = pt.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND ( LCASE(pt.tag) LIKE '%ground%' OR LCASE(pt.tag) LIKE '%zero%' OR LCASE(pt.tag) LIKE '%gzna%' OR LCASE(pt.tag) LIKE '%1.2500dxii%' AND pt.language_id = '1') GROUP BY p.product_id ORDER BY p.sort_order ASC, LCASE(pd.name) ASC LIMIT 0,15\G

afwollis · 9 січня 2014

уточню - это поиск по тэгам.

подсчет кол-ва подходящих товаров и, собственно, выборка.

судя по всему - как и всем, не хватает индексов на столбцах.

покажите пару примеров ваших тэгов.

есть такое (пробелы; запятых нет)?

ground zero gzna 1.2500dxii

+

что-то там с регионами (то ли регистрация, то ли оформление заказа, то ли добавление/редактирование адресов)...

kratelig · 10 січня 2014

покажите пару примеров ваших тэгов.
есть такое (пробелы; запятых нет)?

Каким образом? Подскажите.

что-то там с регионами (то ли регистрация, то ли оформление заказа, то ли добавление/редактирование адресов)...

Регистрация очень сильно урезана вручную мною. Лишних полей убрал. Но это все было сделано давно.

freelancer · 10 січня 2014

у меня две версии.

- у вас очень тормозной поиск, т.к. той статистике что вы привели только запрос на поиск и приведен

- кривой хостинг. т.к. из той же статистики(возможно я её не так трактую) на 2м месте с 19.0% SELECT zone

# 1 0x6D4DAC78312CE5B4 0.0270 21.8% 3 0.0090 0.00 SELECT product product_description product_to_store product_tag
# 2 0x368D90E5FDCEAD9C 0.0235 19.0% 5 0.0047 0.01 SELECT zone

как совет, полностью отключите поиск и посмотрите нагрузку, заодно установите https://opencartforum.com/files/file/786-db-log/ что бы понимать ситуацию

kratelig · 10 січня 2014

как совет, полностью отключите поиск и посмотрите нагрузку, заодно установите http://opencartforum...ile/786-db-log/ что бы понимать ситуацию

Поиск отключить через админ-панель, или убрать из шаблона форму вообще?

freelancer · 10 січня 2014

в методе index контроллера поиска прописать 301 редирект на главную например или на error/not_found

public function index() {
$this->redirect($this->url->link('error/not_found'));

kratelig · 10 січня 2014

в методе index контроллера поиска прописать 301 редирект на главную например или на error/not_found

catalog/controller/product/search.php тут я так понял?

Есть, магазин через тикеты запустил.

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

Позже отпишусь.

Нужно еще дебагер поставить

kratelig · 10 січня 2014

Итак!

По прошествияю 1 час 20 минут имеем следующее.

Нагрузка на БД идет все так же сильно. Не помогло даже удаление формы поиска как таковой(скрыл в стилях ее просто).

Далее поставил дебагер.

Отчет за последние 20 минут под спойлером.

2014-01-10 12:40:44 - --------------------
2014-01-10 12:40:45 - 0.15230 | 86 | /index.php?route=product/category&path=20_26
2014-01-10 12:41:05 - --------------------
2014-01-10 12:41:05 - 0.17904 | 80 | /index.php?route=product/category&path=81_82
2014-01-10 12:41:05 - --------------------
2014-01-10 12:41:06 - 0.16488 | 85 | /index.php?route=product/category&path=81
2014-01-10 12:41:09 - --------------------
2014-01-10 12:41:09 - 0.14287 | 81 | /
2014-01-10 12:41:21 - --------------------
2014-01-10 12:41:21 - 0.14839 | 84 | /index.php?route=product/category&path=20_27
2014-01-10 12:41:51 - --------------------
2014-01-10 12:41:51 - 0.16760 | 86 | /index.php?route=product/category&path=20_62
2014-01-10 12:42:33 - --------------------
2014-01-10 12:42:33 - 0.18080 | 89 | /index.php?route=product/product&product_id=109
2014-01-10 12:42:33 - --------------------
2014-01-10 12:42:33 - 0.00382 | 6 | /index.php?route=product/product/captcha
2014-01-10 12:42:33 - --------------------
2014-01-10 12:42:33 - 0.00458 | 8 | /index.php?route=product/product/review&product_id=109
2014-01-10 12:42:51 - --------------------
2014-01-10 12:42:51 - 0.16221 | 84 | /index.php?route=product/category&path=87
2014-01-10 12:42:59 - --------------------
2014-01-10 12:42:59 - 0.15239 | 80 | /index.php?route=product/category&path=87_88
2014-01-10 12:43:18 - --------------------
2014-01-10 12:43:18 - 0.17285 | 84 | /index.php?route=product/category&path=87
2014-01-10 12:43:21 - --------------------
2014-01-10 12:43:21 - 0.23428 | 80 | /index.php?route=product/category&path=87_90
2014-01-10 12:43:30 - --------------------
2014-01-10 12:43:31 - 0.23188 | 84 | /index.php?route=product/category&path=87
2014-01-10 12:43:32 - --------------------
2014-01-10 12:43:32 - 0.23836 | 94 | /index.php?route=product/category&path=60
2014-01-10 12:43:32 - --------------------
2014-01-10 12:43:32 - 0.17506 | 82 | /index.php?route=product/category&path=87_89
2014-01-10 12:43:36 - --------------------
2014-01-10 12:43:36 - 0.16002 | 81 | /index.php?route=common/home
2014-01-10 12:43:57 - --------------------
2014-01-10 12:43:57 - 0.17253 | 83 | /index.php?route=product/category&path=80
2014-01-10 12:45:21 - --------------------
2014-01-10 12:45:21 - 0.17594 | 88 | /index.php?route=product/product&product_id=109
2014-01-10 12:45:26 - --------------------
2014-01-10 12:45:26 - 0.32995 | 83 | /index.php?route=product/category&path=63_134
2014-01-10 12:47:35 - --------------------
2014-01-10 12:47:35 - 0.25502 | 76 | /index.php?route=product/product&product_id=109
2014-01-10 12:47:48 - --------------------
2014-01-10 12:47:48 - --------------------
2014-01-10 12:47:48 - 0.14560 | 80 | /index.php?route=product/category&path=63_133
2014-01-10 12:47:48 - 0.13719 | 76 | /index.php?route=product/product&amp
2014-01-10 12:47:54 - --------------------
2014-01-10 12:47:54 - 0.15198 | 83 | /index.php?route=product/category&path=80
2014-01-10 12:48:01 - --------------------
2014-01-10 12:48:01 - 0.18180 | 90 | /index.php?route=product/category&path=63
2014-01-10 12:48:30 - --------------------
2014-01-10 12:48:30 - 0.18097 | 82 | /index.php?route=product/category&path=87_89
2014-01-10 12:48:44 - --------------------
2014-01-10 12:48:44 - 0.15167 | 83 | /index.php?route=product/category&path=80
2014-01-10 12:48:53 - --------------------
2014-01-10 12:48:53 - 0.19038 | 84 | /index.php?route=product/category&path=87
2014-01-10 12:49:58 - --------------------
2014-01-10 12:49:58 - 0.18137 | 81 | /
2014-01-10 12:50:01 - --------------------
2014-01-10 12:50:02 - 0.19782 | 94 | /index.php?route=product/category&path=60
2014-01-10 12:50:32 - --------------------
2014-01-10 12:50:32 - 0.18061 | 88 | /index.php?route=product/product&path=60&product_id=173
2014-01-10 12:50:32 - --------------------
2014-01-10 12:50:32 - 0.00369 | 6 | /index.php?route=product/product/captcha
2014-01-10 12:50:32 - --------------------
2014-01-10 12:50:32 - 0.00432 | 8 | /index.php?route=product/product/review&product_id=173
2014-01-10 12:50:44 - --------------------
2014-01-10 12:50:44 - 0.16406 | 94 | /index.php?route=product/category&path=60
2014-01-10 12:50:47 - --------------------
2014-01-10 12:50:47 - 0.17121 | 94 | /index.php?route=product/category&path=60&page=2
2014-01-10 12:50:58 - --------------------
2014-01-10 12:50:58 - 0.00738 | 17 | /index.php?route=product/category&path=75
2014-01-10 12:50:59 - --------------------
2014-01-10 12:51:00 - 0.18540 | 94 | /index.php?route=product/category&path=60&page=3
2014-01-10 12:51:15 - --------------------
2014-01-10 12:51:15 - 0.16286 | 88 | /index.php?route=product/product&path=60&product_id=122
2014-01-10 12:51:15 - --------------------
2014-01-10 12:51:15 - 0.00276 | 6 | /index.php?route=product/product/captcha
2014-01-10 12:51:15 - --------------------
2014-01-10 12:51:15 - 0.00401 | 8 | /index.php?route=product/product/review&product_id=122
2014-01-10 12:51:51 - --------------------
2014-01-10 12:51:51 - 0.20076 | 81 | /
2014-01-10 12:53:52 - --------------------
2014-01-10 12:53:52 - 0.02300 | 17 | /index.php?route=product/category&path=75
2014-01-10 12:54:44 - --------------------
2014-01-10 12:54:44 - 0.17901 | 84 | /index.php?route=product/category&path=87
2014-01-10 12:55:04 - --------------------
2014-01-10 12:55:04 - 0.20419 | 82 | /index.php?route=product/category&path=87_89
2014-01-10 12:55:23 - --------------------
2014-01-10 12:55:23 - 0.15020 | 81 | /
2014-01-10 12:55:30 - --------------------
2014-01-10 12:55:31 - 0.16505 | 88 | /index.php?route=product/product&path=87_89&product_id=155
2014-01-10 12:55:36 - --------------------
2014-01-10 12:55:36 - 0.14766 | 88 | /index.php?route=product/product&path=63&product_id=161
2014-01-10 12:55:38 - --------------------
2014-01-10 12:55:38 - 0.00429 | 6 | /index.php?route=product/product/captcha
2014-01-10 12:55:43 - --------------------
2014-01-10 12:55:43 - 0.00336 | 6 | /index.php?route=product/product/captcha
2014-01-10 12:55:43 - --------------------
2014-01-10 12:55:43 - 0.00480 | 8 | /index.php?route=product/product/review&product_id=155
2014-01-10 12:55:49 - --------------------
2014-01-10 12:55:50 - 0.14940 | 82 | /index.php?route=product/category&path=87_89
2014-01-10 12:55:51 - --------------------
2014-01-10 12:55:51 - 0.00430 | 8 | /index.php?route=product/product/review&product_id=161
2014-01-10 12:55:58 - --------------------
2014-01-10 12:55:58 - 0.16608 | 83 | /index.php?route=product/category&path=151
2014-01-10 12:56:16 - --------------------
2014-01-10 12:56:16 - 0.16603 | 85 | /index.php?route=product/category&path=20
2014-01-10 12:56:27 - --------------------
2014-01-10 12:56:27 - 0.22378 | 110 | /index.php?route=product/category&path=60
2014-01-10 12:56:40 - --------------------
2014-01-10 12:56:40 - 0.19141 | 102 | /index.php?route=product/category&path=20_62
2014-01-10 12:56:45 - --------------------
2014-01-10 12:56:45 - 0.16453 | 81 | /
2014-01-10 12:56:50 - --------------------
2014-01-10 12:56:50 - 0.25344 | 94 | /index.php?route=product/category&path=60
2014-01-10 12:57:05 - --------------------
2014-01-10 12:57:06 - 0.16073 | 80 | /index.php?route=product/category&path=60_73
2014-01-10 12:57:26 - --------------------
2014-01-10 12:57:26 - 0.15915 | 88 | /index.php?route=product/product&path=60_73&product_id=177
2014-01-10 12:57:26 - --------------------
2014-01-10 12:57:26 - 0.00403 | 6 | /index.php?route=product/product/captcha
2014-01-10 12:57:27 - --------------------
2014-01-10 12:57:27 - 0.00604 | 8 | /index.php?route=product/product/review&product_id=177
2014-01-10 12:57:36 - --------------------
2014-01-10 12:57:36 - 0.23124 | 88 | /index.php?route=product/product&path=20_62&product_id=158
2014-01-10 12:57:38 - --------------------
2014-01-10 12:57:38 - 0.14395 | 80 | /index.php?route=product/category&path=60_73
2014-01-10 12:57:41 - --------------------
2014-01-10 12:57:41 - 0.15963 | 88 | /index.php?route=product/product&path=60_73&product_id=89
2014-01-10 12:57:41 - --------------------
2014-01-10 12:57:41 - 0.00302 | 6 | /index.php?route=product/product/captcha
2014-01-10 12:57:41 - --------------------
2014-01-10 12:57:41 - 0.00424 | 8 | /index.php?route=product/product/review&product_id=89
2014-01-10 12:57:43 - --------------------
2014-01-10 12:57:43 - 0.21482 | 106 | /index.php?route=product/category&path=63
2014-01-10 12:57:44 - --------------------
2014-01-10 12:57:44 - 0.00248 | 6 | /index.php?route=product/product/captcha
2014-01-10 12:57:48 - --------------------
2014-01-10 12:57:48 - 0.00441 | 8 | /index.php?route=product/product/review&product_id=158
2014-01-10 12:57:57 - --------------------
2014-01-10 12:57:57 - 0.16627 | 80 | /index.php?route=product/category&path=60_73
2014-01-10 12:58:02 - --------------------
2014-01-10 12:58:03 - 0.17705 | 81 | /
2014-01-10 12:58:06 - --------------------
2014-01-10 12:58:06 - 0.15210 | 80 | /index.php?route=product/category&path=63_76
2014-01-10 12:58:16 - --------------------
2014-01-10 12:58:16 - 0.16238 | 86 | /index.php?route=product/category&path=20_62
2014-01-10 12:58:18 - --------------------
2014-01-10 12:58:18 - 0.20206 | 81 | /index.php?route=common/home
2014-01-10 12:58:23 - --------------------
2014-01-10 12:58:23 - 0.17565 | 85 | /index.php?route=product/category&path=20
2014-01-10 12:58:25 - --------------------
2014-01-10 12:58:25 - 0.16860 | 101 | /index.php?route=product/category&path=20_123
2014-01-10 12:58:27 - --------------------
2014-01-10 12:58:27 - 0.20329 | 86 | /index.php?route=product/category&path=20_62
2014-01-10 12:58:32 - --------------------
2014-01-10 12:58:32 - 0.17835 | 88 | /index.php?route=product/product&path=20_62&product_id=71
2014-01-10 12:58:33 - --------------------
2014-01-10 12:58:33 - 0.00389 | 6 | /index.php?route=product/product/captcha
2014-01-10 12:58:33 - --------------------
2014-01-10 12:58:33 - 0.00519 | 8 | /index.php?route=product/product/review&product_id=71
2014-01-10 12:58:35 - --------------------
2014-01-10 12:58:35 - 0.16495 | 88 | /index.php?route=product/product&path=63_76&product_id=232
2014-01-10 12:58:35 - --------------------
2014-01-10 12:58:35 - 0.00354 | 6 | /index.php?route=product/product/captcha
2014-01-10 12:58:36 - --------------------
2014-01-10 12:58:36 - 0.00458 | 8 | /index.php?route=product/product/review&product_id=232
2014-01-10 12:58:46 - --------------------
2014-01-10 12:58:47 - 0.21013 | 86 | /index.php?route=product/category&path=20_62
2014-01-10 12:58:50 - --------------------
2014-01-10 12:58:51 - 0.27160 | 85 | /index.php?route=product/category&path=20
2014-01-10 12:58:52 - --------------------
2014-01-10 12:58:53 - 0.18380 | 85 | /index.php?route=product/category&path=20
2014-01-10 12:58:53 - --------------------
2014-01-10 12:58:53 - 0.17929 | 94 | /index.php?route=product/category&path=60
2014-01-10 12:58:54 - --------------------
2014-01-10 12:58:54 - 0.21737 | 99 | /index.php?route=product/category&path=81
2014-01-10 12:58:54 - --------------------
2014-01-10 12:58:54 - --------------------
2014-01-10 12:58:54 - 0.20947 | 82 | /index.php?route=product/category&path=60_116
2014-01-10 12:58:55 - 0.17887 | 84 | /index.php?route=product/category&path=87
2014-01-10 12:58:58 - --------------------
2014-01-10 12:58:58 - 0.16578 | 82 | /index.php?route=product/category&path=87_89
2014-01-10 12:58:59 - --------------------
2014-01-10 12:58:59 - 0.14440 | 80 | /index.php?route=product/category&path=87_90
2014-01-10 12:59:00 - --------------------
2014-01-10 12:59:00 - 0.15200 | 84 | /index.php?route=product/category&path=87_88
2014-01-10 12:59:04 - --------------------
2014-01-10 12:59:04 - 0.16709 | 82 | /index.php?route=product/category&path=60_112
2014-01-10 12:59:09 - --------------------
2014-01-10 12:59:09 - 0.19031 | 88 | /index.php?route=product/product&path=87_88&product_id=295
2014-01-10 12:59:10 - --------------------
2014-01-10 12:59:10 - 0.00310 | 6 | /index.php?route=product/product/captcha
2014-01-10 12:59:10 - --------------------
2014-01-10 12:59:10 - 0.00482 | 8 | /index.php?route=product/product/review&product_id=295
2014-01-10 12:59:11 - --------------------
2014-01-10 12:59:11 - 0.16825 | 80 | /index.php?route=product/category&path=60_92
2014-01-10 12:59:14 - --------------------
2014-01-10 12:59:15 - 0.20929 | 97 | /index.php?route=product/category&path=20_26
2014-01-10 12:59:17 - --------------------
2014-01-10 12:59:17 - 0.20690 | 86 | /index.php?route=product/category&path=20_26
2014-01-10 12:59:24 - --------------------
2014-01-10 12:59:24 - 0.22458 | 88 | /index.php?route=product/product&path=20_26&product_id=242
2014-01-10 12:59:25 - --------------------
2014-01-10 12:59:25 - 0.00322 | 6 | /index.php?route=product/product/captcha
2014-01-10 12:59:25 - --------------------
2014-01-10 12:59:25 - 0.00532 | 8 | /index.php?route=product/product/review&product_id=242
2014-01-10 12:59:37 - --------------------
2014-01-10 12:59:37 - 0.25792 | 88 | /index.php?route=product/product&path=87_88&product_id=132
2014-01-10 12:59:38 - --------------------
2014-01-10 12:59:38 - 0.00449 | 6 | /index.php?route=product/product/captcha
2014-01-10 12:59:38 - --------------------
2014-01-10 12:59:38 - 0.00502 | 8 | /index.php?route=product/product/review&product_id=132
2014-01-10 12:59:48 - --------------------
2014-01-10 12:59:48 - 0.19763 | 86 | /index.php?route=product/category&path=20_26
2014-01-10 12:59:50 - --------------------
2014-01-10 12:59:50 - 0.15915 | 88 | /index.php?route=product/product&product_id=198
2014-01-10 12:59:52 - --------------------
2014-01-10 12:59:52 - 0.00318 | 6 | /index.php?route=product/product/captcha
2014-01-10 12:59:53 - --------------------
2014-01-10 12:59:53 - 0.00781 | 8 | /index.php?route=product/product/review&product_id=198
2014-01-10 12:59:59 - --------------------
2014-01-10 12:59:59 - 0.24785 | 100 | /index.php?route=product/category&path=20_27
2014-01-10 13:00:10 - --------------------
2014-01-10 13:00:10 - --------------------
2014-01-10 13:00:10 - 0.24197 | 88 | /index.php?route=product/product&path=87_88&product_id=156
2014-01-10 13:00:10 - 0.26214 | 94 | /index.php?route=product/product&path=20_27&product_id=80
2014-01-10 13:00:11 - --------------------
2014-01-10 13:00:11 - 0.00337 | 6 | /index.php?route=product/product/captcha
2014-01-10 13:00:11 - --------------------
2014-01-10 13:00:11 - 0.01148 | 8 | /index.php?route=product/product/review&product_id=80
2014-01-10 13:00:11 - --------------------
2014-01-10 13:00:11 - 0.01266 | 6 | /index.php?route=product/product/captcha
2014-01-10 13:00:11 - --------------------
2014-01-10 13:00:11 - 0.20808 | 8 | /index.php?route=product/product/review&product_id=156
2014-01-10 13:00:25 - --------------------
2014-01-10 13:00:25 - --------------------
2014-01-10 13:00:25 - 0.39218 | 84 | /index.php?route=product/category&path=20_27
2014-01-10 13:00:25 - 0.56753 | 88 | /index.php?route=product/product&path=87_88&product_id=295
2014-01-10 13:00:26 - --------------------
2014-01-10 13:00:27 - 0.00338 | 6 | /index.php?route=product/product/captcha
2014-01-10 13:00:27 - --------------------
2014-01-10 13:00:27 - 0.00513 | 8 | /index.php?route=product/product/review&product_id=295
2014-01-10 13:00:30 - --------------------
2014-01-10 13:00:30 - 0.18354 | 84 | /index.php?route=product/category&path=20_27
2014-01-10 13:00:36 - --------------------
2014-01-10 13:00:36 - 0.19211 | 88 | /index.php?route=product/product&path=87_90&product_id=115
2014-01-10 13:00:37 - --------------------
2014-01-10 13:00:37 - 0.00318 | 6 | /index.php?route=product/product/captcha
2014-01-10 13:00:37 - --------------------
2014-01-10 13:00:37 - 0.00419 | 8 | /index.php?route=product/product/review&product_id=115
2014-01-10 13:00:39 - --------------------
2014-01-10 13:00:39 - 0.19816 | 88 | /index.php?route=product/product&path=87_90&product_id=131
2014-01-10 13:00:39 - --------------------
2014-01-10 13:00:39 - 0.00470 | 6 | /index.php?route=product/product/captcha
2014-01-10 13:00:39 - --------------------
2014-01-10 13:00:39 - 0.00445 | 8 | /index.php?route=product/product/review&product_id=131
2014-01-10 13:00:45 - --------------------
2014-01-10 13:00:45 - 0.18198 | 89 | /index.php?route=product/category&path=20_123
2014-01-10 13:00:54 - --------------------
2014-01-10 13:00:54 - 0.19147 | 80 | /index.php?route=product/category&path=63_133
2014-01-10 13:00:57 - --------------------
2014-01-10 13:00:57 - 0.18614 | 88 | /index.php?route=product/product&path=63_133&product_id=226
2014-01-10 13:00:57 - --------------------
2014-01-10 13:00:57 - 0.00327 | 6 | /index.php?route=product/product/captcha
2014-01-10 13:00:57 - --------------------
2014-01-10 13:00:57 - 0.00441 | 8 | /index.php?route=product/product/review&product_id=226
2014-01-10 13:00:58 - --------------------
2014-01-10 13:00:58 - 0.17812 | 88 | /index.php?route=product/product&product_id=198
2014-01-10 13:00:59 - --------------------
2014-01-10 13:00:59 - 0.00333 | 6 | /index.php?route=product/product/captcha
2014-01-10 13:00:59 - --------------------
2014-01-10 13:00:59 - 0.00399 | 8 | /index.php?route=product/product/review&product_id=198
2014-01-10 13:01:02 - --------------------
2014-01-10 13:01:02 - 0.19369 | 81 | /index.php?route=common/home
2014-01-10 13:01:03 - --------------------
2014-01-10 13:01:03 - 0.18357 | 88 | /index.php?route=product/product&path=20_26&product_id=70
2014-01-10 13:01:07 - --------------------
2014-01-10 13:01:08 - 0.19975 | 85 | /index.php?route=product/category&path=20
2014-01-10 13:01:09 - --------------------
2014-01-10 13:01:09 - --------------------
2014-01-10 13:01:09 - 0.00440 | 6 | /index.php?route=product/product/captcha
2014-01-10 13:01:09 - 0.19499 | 87 | /index.php?route=product/category&path=80_85
2014-01-10 13:01:09 - --------------------
2014-01-10 13:01:09 - 0.00449 | 8 | /index.php?route=product/product/review&product_id=70
2014-01-10 13:01:11 - --------------------
2014-01-10 13:01:11 - 0.15138 | 86 | /index.php?route=product/category&path=20_26
2014-01-10 13:01:14 - --------------------
2014-01-10 13:01:14 - 0.22801 | 86 | /index.php?route=product/category&path=20_62
2014-01-10 13:01:20 - --------------------
2014-01-10 13:01:21 - 0.18153 | 80 | /index.php?route=product/category&path=80_84
2014-01-10 13:01:23 - --------------------
2014-01-10 13:01:24 - 0.18064 | 80 | /index.php?route=product/category&path=20_26_103
2014-01-10 13:01:26 - --------------------
2014-01-10 13:01:27 - 0.19770 | 88 | /index.php?route=product/product&path=80_84&product_id=103
2014-01-10 13:01:27 - --------------------
2014-01-10 13:01:27 - 0.00305 | 6 | /index.php?route=product/product/captcha
2014-01-10 13:01:27 - --------------------
2014-01-10 13:01:27 - 0.00412 | 8 | /index.php?route=product/product/review&product_id=103
2014-01-10 13:01:33 - --------------------
2014-01-10 13:01:34 - 0.17732 | 90 | /index.php?route=product/category&path=63
2014-01-10 13:01:34 - --------------------
2014-01-10 13:01:34 - 0.17541 | 88 | /index.php?route=product/product&path=20_26_103&product_id=68
2014-01-10 13:01:35 - --------------------
2014-01-10 13:01:35 - 0.00475 | 8 | /index.php?route=product/product/review&product_id=68
2014-01-10 13:01:35 - --------------------
2014-01-10 13:01:35 - 0.00342 | 6 | /index.php?route=product/product/captcha
2014-01-10 13:01:42 - --------------------
2014-01-10 13:01:42 - 0.22120 | 80 | /index.php?route=product/category&path=60_73
2014-01-10 13:01:51 - --------------------
2014-01-10 13:01:52 - 0.20086 | 88 | /index.php?route=product/product&path=87_89&product_id=139
2014-01-10 13:01:52 - --------------------
2014-01-10 13:01:52 - 0.00312 | 6 | /index.php?route=product/product/captcha
2014-01-10 13:01:52 - --------------------
2014-01-10 13:01:52 - 0.00356 | 8 | /index.php?route=product/product/review&product_id=139
2014-01-10 13:01:54 - --------------------
2014-01-10 13:01:54 - 0.17230 | 88 | /index.php?route=product/product&path=87_89&product_id=133
2014-01-10 13:01:55 - --------------------
2014-01-10 13:01:55 - 0.00265 | 6 | /index.php?route=product/product/captcha
2014-01-10 13:01:55 - --------------------
2014-01-10 13:01:55 - 0.00457 | 8 | /index.php?route=product/product/review&product_id=133
2014-01-10 13:01:58 - --------------------
2014-01-10 13:01:58 - 0.17267 | 80 | /index.php?route=product/category&path=20_26_103
2014-01-10 13:01:58 - --------------------
2014-01-10 13:01:59 - 0.21600 | 85 | /index.php?route=product/category&path=20
2014-01-10 13:02:04 - --------------------
2014-01-10 13:02:04 - 0.43033 | 88 | /index.php?route=product/product&path=20_26_103&product_id=199
2014-01-10 13:02:05 - --------------------
2014-01-10 13:02:05 - 0.00350 | 6 | /index.php?route=product/product/captcha
2014-01-10 13:02:05 - --------------------
2014-01-10 13:02:05 - 0.00545 | 8 | /index.php?route=product/product/review&product_id=199
2014-01-10 13:02:09 - --------------------
2014-01-10 13:02:09 - 0.17602 | 80 | /index.php?route=product/category&path=20_26_103
2014-01-10 13:02:12 - --------------------
2014-01-10 13:02:12 - 0.19287 | 86 | /index.php?route=product/category&path=20_26
2014-01-10 13:02:12 - --------------------
2014-01-10 13:02:12 - 0.15342 | 86 | /index.php?route=product/category&path=20_26
2014-01-10 13:02:17 - --------------------
2014-01-10 13:02:17 - 0.17260 | 80 | /index.php?route=product/category&path=60_116
2014-01-10 13:02:21 - --------------------
2014-01-10 13:02:21 - 0.20548 | 88 | /index.php?route=product/product&path=60_116&product_id=189
2014-01-10 13:02:21 - --------------------
2014-01-10 13:02:22 - 0.00354 | 6 | /index.php?route=product/product/captcha
2014-01-10 13:02:22 - --------------------
2014-01-10 13:02:22 - 0.00419 | 8 | /index.php?route=product/product/review&product_id=189
2014-01-10 13:02:22 - --------------------
2014-01-10 13:02:22 - 0.18180 | 82 | /index.php?route=product/category&path=20_26_139
2014-01-10 13:02:25 - --------------------
2014-01-10 13:02:25 - 0.17384 | 88 | /index.php?route=product/product&path=20_26_139&product_id=242
2014-01-10 13:02:26 - --------------------
2014-01-10 13:02:26 - 0.00371 | 6 | /index.php?route=product/product/captcha
2014-01-10 13:02:27 - --------------------
2014-01-10 13:02:27 - 0.00793 | 8 | /index.php?route=product/product/review&product_id=242
2014-01-10 13:02:27 - --------------------
2014-01-10 13:02:27 - 0.19486 | 84 | /index.php?route=product/category&path=20_27
2014-01-10 13:02:31 - --------------------
2014-01-10 13:02:32 - 0.17112 | 86 | /index.php?route=product/category&path=20_62
2014-01-10 13:02:36 - --------------------
2014-01-10 13:02:36 - 0.17514 | 88 | /index.php?route=product/product&path=81&product_id=135
2014-01-10 13:02:36 - --------------------
2014-01-10 13:02:36 - 0.00323 | 6 | /index.php?route=product/product/captcha
2014-01-10 13:02:36 - --------------------
2014-01-10 13:02:37 - 0.13706 | 88 | /index.php?route=product/product&path=20_26&product_id=111
2014-01-10 13:02:37 - --------------------
2014-01-10 13:02:37 - 0.00393 | 8 | /index.php?route=product/product/review&product_id=135
2014-01-10 13:02:38 - --------------------
2014-01-10 13:02:38 - 0.00315 | 6 | /index.php?route=product/product/captcha
2014-01-10 13:02:38 - --------------------
2014-01-10 13:02:38 - 0.00388 | 8 | /index.php?route=product/product/review&product_id=111
2014-01-10 13:02:41 - --------------------
2014-01-10 13:02:41 - 0.00587 | 7 | /index.php?route=product/compare/add
2014-01-10 13:02:44 - --------------------
2014-01-10 13:02:44 - 0.20865 | 86 | /index.php?route=product/category&path=20_26
2014-01-10 13:02:44 - --------------------
2014-01-10 13:02:44 - 0.00749 | 7 | /index.php?route=product/compare/add
2014-01-10 13:02:46 - --------------------
2014-01-10 13:02:47 - 0.19240 | 88 | /index.php?route=product/product&path=20_26&product_id=209
2014-01-10 13:02:49 - --------------------
2014-01-10 13:02:49 - --------------------
2014-01-10 13:02:49 - 0.20773 | 88 | /index.php?route=product/product&path=81&product_id=250
2014-01-10 13:02:49 - 0.18863 | 81 | /
2014-01-10 13:02:50 - --------------------
2014-01-10 13:02:50 - 0.00363 | 6 | /index.php?route=product/product/captcha
2014-01-10 13:02:50 - --------------------
2014-01-10 13:02:50 - 0.00417 | 8 | /index.php?route=product/product/review&product_id=250
2014-01-10 13:02:51 - --------------------
2014-01-10 13:02:51 - 0.00368 | 6 | /index.php?route=product/product/captcha
2014-01-10 13:02:52 - --------------------
2014-01-10 13:02:52 - 0.00395 | 8 | /index.php?route=product/product/review&product_id=209
2014-01-10 13:02:56 - --------------------
2014-01-10 13:02:56 - 0.19779 | 85 | /index.php?route=product/category&path=20
2014-01-10 13:02:59 - --------------------
2014-01-10 13:03:00 - 0.14047 | 80 | /index.php?route=product/category&path=20_26_139
2014-01-10 13:03:00 - --------------------
2014-01-10 13:03:00 - 0.22264 | 86 | /index.php?route=product/category&path=20_62
2014-01-10 13:03:02 - --------------------
2014-01-10 13:03:02 - 0.46003 | 86 | /index.php?route=product/category&path=20_26
2014-01-10 13:03:04 - --------------------
2014-01-10 13:03:04 - 0.21313 | 83 | /index.php?route=product/category&path=20_26_101
2014-01-10 13:03:05 - --------------------
2014-01-10 13:03:05 - 0.18448 | 88 | /index.php?route=product/product&path=81&product_id=212
2014-01-10 13:03:05 - --------------------
2014-01-10 13:03:06 - 0.23386 | 88 | /index.php?route=product/product&path=81&product_id=213
2014-01-10 13:03:08 - --------------------
2014-01-10 13:03:08 - 0.22744 | 81 | /index.php?route=common/home
2014-01-10 13:03:08 - --------------------
2014-01-10 13:03:08 - --------------------
2014-01-10 13:03:08 - 0.28050 | 86 | /index.php?route=product/category&path=20_26
2014-01-10 13:03:09 - 0.21961 | 82 | /index.php?route=product/category&path=20_62_98
2014-01-10 13:03:11 - --------------------
2014-01-10 13:03:11 - 0.37911 | 88 | /index.php?route=product/product&path=20_26&product_id=111
2014-01-10 13:03:12 - --------------------
2014-01-10 13:03:12 - 0.00324 | 6 | /index.php?route=product/product/captcha
2014-01-10 13:03:12 - --------------------
2014-01-10 13:03:12 - 0.00378 | 8 | /index.php?route=product/product/review&product_id=111
2014-01-10 13:03:14 - --------------------
2014-01-10 13:03:14 - 0.25490 | 86 | /index.php?route=product/category&path=20_26
2014-01-10 13:03:15 - --------------------
2014-01-10 13:03:15 - --------------------
2014-01-10 13:03:15 - --------------------
2014-01-10 13:03:15 - 0.00524 | 6 | /index.php?route=product/product/captcha
2014-01-10 13:03:15 - --------------------
2014-01-10 13:03:15 - 0.00482 | 8 | /index.php?route=product/product/review&product_id=213
2014-01-10 13:03:15 - 0.22371 | 89 | /index.php?route=product/category&path=20_123
2014-01-10 13:03:15 - 0.21239 | 88 | /index.php?route=product/product&path=20_26_101&product_id=111
2014-01-10 13:03:15 - --------------------
2014-01-10 13:03:15 - 0.00534 | 8 | /index.php?route=product/product/review&product_id=212
2014-01-10 13:03:16 - --------------------
2014-01-10 13:03:16 - 0.00283 | 6 | /index.php?route=product/product/captcha
2014-01-10 13:03:16 - --------------------
2014-01-10 13:03:16 - 0.00429 | 8 | /index.php?route=product/product/review&product_id=111
2014-01-10 13:03:16 - --------------------
2014-01-10 13:03:17 - 0.20822 | 86 | /index.php?route=product/category&path=20_26
2014-01-10 13:03:21 - --------------------
2014-01-10 13:03:21 - 0.17199 | 88 | /index.php?route=product/product&path=20_27&product_id=95
2014-01-10 13:03:21 - --------------------
2014-01-10 13:03:21 - 0.00360 | 6 | /index.php?route=product/product/captcha
2014-01-10 13:03:22 - --------------------
2014-01-10 13:03:22 - 0.00438 | 8 | /index.php?route=product/product/review&product_id=95
2014-01-10 13:03:24 - --------------------
2014-01-10 13:03:24 - 0.26233 | 88 | /index.php?route=product/product&path=20_26&product_id=199
2014-01-10 13:03:25 - --------------------
2014-01-10 13:03:25 - 0.00289 | 6 | /index.php?route=product/product/captcha
2014-01-10 13:03:25 - --------------------
2014-01-10 13:03:25 - 0.00386 | 8 | /index.php?route=product/product/review&product_id=199
2014-01-10 13:03:26 - --------------------
2014-01-10 13:03:26 - 0.15720 | 88 | /index.php?route=product/product&path=20_123&product_id=258
2014-01-10 13:03:26 - --------------------
2014-01-10 13:03:26 - 0.00303 | 6 | /index.php?route=product/product/captcha
2014-01-10 13:03:26 - --------------------
2014-01-10 13:03:27 - --------------------
2014-01-10 13:03:27 - 0.16133 | 84 | /index.php?route=product/category&path=20_27
2014-01-10 13:03:27 - 0.14941 | 80 | /index.php?route=product/category&path=20_26_101
2014-01-10 13:03:27 - --------------------
2014-01-10 13:03:27 - --------------------
2014-01-10 13:03:27 - 0.00428 | 8 | /index.php?route=product/product/review&product_id=258
2014-01-10 13:03:27 - 0.17432 | 84 | /index.php?route=product/category&path=20_27
2014-01-10 13:03:31 - --------------------
2014-01-10 13:03:31 - 0.23214 | 86 | /index.php?route=product/category&path=20_26
2014-01-10 13:03:31 - --------------------
2014-01-10 13:03:32 - 0.19269 | 86 | /index.php?route=product/category&path=20_26
2014-01-10 13:03:34 - --------------------
2014-01-10 13:03:34 - 0.37999 | 85 | /index.php?route=product/category&path=20
2014-01-10 13:03:35 - --------------------
2014-01-10 13:03:35 - 0.18481 | 82 | /index.php?route=product/category&path=20_26_102
2014-01-10 13:03:36 - --------------------
2014-01-10 13:03:36 - --------------------
2014-01-10 13:03:36 - 0.16234 | 84 | /index.php?route=product/category&path=20_27
2014-01-10 13:03:36 - 0.18063 | 88 | /index.php?route=product/product&path=20_27&product_id=72
2014-01-10 13:03:37 - --------------------
2014-01-10 13:03:37 - 0.01295 | 8 | /index.php?route=product/product/review&product_id=72
2014-01-10 13:03:37 - --------------------
2014-01-10 13:03:37 - 0.00414 | 6 | /index.php?route=product/product/captcha
2014-01-10 13:03:38 - --------------------
2014-01-10 13:03:39 - 0.19224 | 88 | /index.php?route=product/product&path=20_26_102&product_id=70
2014-01-10 13:03:39 - --------------------
2014-01-10 13:03:39 - --------------------
2014-01-10 13:03:39 - 0.00360 | 6 | /index.php?route=product/product/captcha
2014-01-10 13:03:39 - --------------------
2014-01-10 13:03:39 - 0.00513 | 8 | /index.php?route=product/product/review&product_id=70
2014-01-10 13:03:39 - 0.17741 | 85 | /index.php?route=product/category&path=20_27_106
2014-01-10 13:03:44 - --------------------
2014-01-10 13:03:44 - 0.19346 | 84 | /index.php?route=product/category&path=20_27
2014-01-10 13:03:44 - --------------------
2014-01-10 13:03:45 - 0.21334 | 89 | /index.php?route=product/category&path=20_123
2014-01-10 13:03:47 - --------------------
2014-01-10 13:03:47 - 0.22987 | 86 | /index.php?route=product/category&path=20_26
2014-01-10 13:03:55 - --------------------
2014-01-10 13:03:55 - 0.17234 | 80 | /index.php?route=product/category&path=80_84
2014-01-10 13:03:55 - --------------------
2014-01-10 13:03:55 - 0.16519 | 84 | /index.php?route=product/category&path=20_27
2014-01-10 13:03:56 - --------------------
2014-01-10 13:03:57 - 0.37166 | 86 | /index.php?route=product/category&path=20_26
2014-01-10 13:03:57 - --------------------
2014-01-10 13:03:57 - 0.18626 | 86 | /index.php?route=product/category&path=20_62
2014-01-10 13:03:57 - --------------------
2014-01-10 13:03:58 - 0.20286 | 88 | /index.php?route=product/product&path=80_84&product_id=103
2014-01-10 13:03:58 - --------------------
2014-01-10 13:03:58 - 0.00368 | 6 | /index.php?route=product/product/captcha
2014-01-10 13:03:58 - --------------------
2014-01-10 13:03:58 - 0.00420 | 8 | /index.php?route=product/product/review&product_id=103
2014-01-10 13:04:05 - --------------------
2014-01-10 13:04:06 - 0.15981 | 88 | /index.php?route=product/product&path=20_123&product_id=256
2014-01-10 13:04:07 - --------------------
2014-01-10 13:04:07 - 0.22837 | 88 | /index.php?route=product/product&path=20_26&product_id=70
2014-01-10 13:04:08 - --------------------
2014-01-10 13:04:08 - 0.22533 | 88 | /index.php?route=product/product&product_id=130
2014-01-10 13:04:08 - --------------------
2014-01-10 13:04:08 - 0.00284 | 6 | /index.php?route=product/product/captcha
2014-01-10 13:04:08 - --------------------
2014-01-10 13:04:08 - 0.00459 | 8 | /index.php?route=product/product/review&product_id=70
2014-01-10 13:04:08 - --------------------
2014-01-10 13:04:09 - --------------------
2014-01-10 13:04:09 - 0.00351 | 6 | /index.php?route=product/product/captcha
2014-01-10 13:04:09 - --------------------
2014-01-10 13:04:09 - 0.00474 | 8 | /index.php?route=product/product/review&product_id=256
2014-01-10 13:04:09 - 0.30117 | 120 | /index.php?route=product/category&path=63&limit=100
2014-01-10 13:04:13 - --------------------
2014-01-10 13:04:13 - 0.28850 | 86 | /index.php?route=product/category&path=20_26
2014-01-10 13:04:14 - --------------------
2014-01-10 13:04:14 - 0.00327 | 6 | /index.php?route=product/product/captcha
2014-01-10 13:04:14 - --------------------
2014-01-10 13:04:14 - 0.17635 | 86 | /index.php?route=product/category&path=20_26
2014-01-10 13:04:14 - --------------------
2014-01-10 13:04:14 - 0.00404 | 8 | /index.php?route=product/product/review&product_id=130
2014-01-10 13:04:15 - --------------------
2014-01-10 13:04:15 - 0.24471 | 88 | /index.php?route=product/product&path=20_26&product_id=242
2014-01-10 13:04:16 - --------------------
2014-01-10 13:04:16 - 0.00414 | 6 | /index.php?route=product/product/captcha
2014-01-10 13:04:16 - --------------------
2014-01-10 13:04:16 - 0.00484 | 8 | /index.php?route=product/product/review&product_id=242
2014-01-10 13:04:18 - --------------------
2014-01-10 13:04:18 - 0.18744 | 89 | /index.php?route=product/category&path=20_123
2014-01-10 13:04:19 - --------------------
2014-01-10 13:04:19 - 0.15978 | 94 | /index.php?route=product/product&path=20_26&product_id=84
2014-01-10 13:04:19 - --------------------
2014-01-10 13:04:19 - 0.00454 | 6 | /index.php?route=product/product/captcha
2014-01-10 13:04:20 - --------------------
2014-01-10 13:04:20 - 0.00439 | 8 | /index.php?route=product/product/review&product_id=84
2014-01-10 13:04:22 - --------------------
2014-01-10 13:04:23 - 0.15045 | 80 | /index.php?route=product/category&path=80_84
2014-01-10 13:04:24 - --------------------
2014-01-10 13:04:25 - 0.21227 | 88 | /index.php?route=product/product&path=20_123&product_id=218
2014-01-10 13:04:28 - --------------------
2014-01-10 13:04:28 - --------------------
2014-01-10 13:04:28 - 0.23130 | 80 | /index.php?route=product/category&path=20_26_102
2014-01-10 13:04:28 - 0.26111 | 86 | /index.php?route=product/category&path=20_26
2014-01-10 13:04:33 - --------------------
2014-01-10 13:04:34 - 0.19293 | 85 | /index.php?route=product/category&path=20
2014-01-10 13:04:34 - --------------------
2014-01-10 13:04:34 - 0.15766 | 88 | /index.php?route=product/product&path=80_84&product_id=259
2014-01-10 13:04:35 - --------------------
2014-01-10 13:04:35 - 0.00295 | 6 | /index.php?route=product/product/captcha
2014-01-10 13:04:35 - --------------------
2014-01-10 13:04:35 - --------------------
2014-01-10 13:04:35 - 0.00562 | 8 | /index.php?route=product/product/review&product_id=259
2014-01-10 13:04:35 - 0.16603 | 86 | /index.php?route=product/category&path=20_26
2014-01-10 13:04:36 - --------------------
2014-01-10 13:04:36 - 0.19647 | 86 | /index.php?route=product/category&path=20_62
2014-01-10 13:04:39 - --------------------
2014-01-10 13:04:40 - 0.17423 | 88 | /index.php?route=product/product&product_id=198
2014-01-10 13:04:41 - --------------------
2014-01-10 13:04:41 - 0.17931 | 84 | /index.php?route=product/category&path=20_27
2014-01-10 13:04:45 - --------------------
2014-01-10 13:04:45 - 0.14549 | 80 | /index.php?route=product/category&path=80_84
2014-01-10 13:04:47 - --------------------
2014-01-10 13:04:47 - 0.18829 | 88 | /index.php?route=product/product&path=20_26&product_id=112
2014-01-10 13:04:48 - --------------------
2014-01-10 13:04:48 - 0.00507 | 6 | /index.php?route=product/product/captcha
2014-01-10 13:04:48 - --------------------
2014-01-10 13:04:48 - 0.00383 | 8 | /index.php?route=product/product/review&product_id=112
2014-01-10 13:04:55 - --------------------
2014-01-10 13:04:56 - 0.22105 | 88 | /index.php?route=product/product&path=20_26&product_id=198
2014-01-10 13:04:56 - --------------------
2014-01-10 13:04:56 - 0.00457 | 6 | /index.php?route=product/product/captcha
2014-01-10 13:04:56 - --------------------
2014-01-10 13:04:56 - 0.00536 | 8 | /index.php?route=product/product/review&product_id=198
2014-01-10 13:05:00 - --------------------
2014-01-10 13:05:00 - 0.16651 | 88 | /index.php?route=product/product&path=20_27&product_id=95
2014-01-10 13:05:01 - --------------------
2014-01-10 13:05:02 - 0.17990 | 80 | /index.php?route=product/category&path=63_76
2014-01-10 13:05:02 - --------------------
2014-01-10 13:05:02 - 0.16464 | 88 | /index.php?route=product/product&path=20_26&product_id=112
2014-01-10 13:05:02 - --------------------
2014-01-10 13:05:03 - 0.00453 | 6 | /index.php?route=product/product/captcha
2014-01-10 13:05:03 - --------------------
2014-01-10 13:05:03 - 0.00396 | 8 | /index.php?route=product/product/review&product_id=112
2014-01-10 13:05:05 - --------------------
2014-01-10 13:05:05 - 0.21796 | 88 | /index.php?route=product/product&path=20_123&product_id=218
2014-01-10 13:05:05 - --------------------
2014-01-10 13:05:05 - 0.00390 | 6 | /index.php?route=product/product/captcha
2014-01-10 13:05:06 - --------------------
2014-01-10 13:05:06 - 0.00578 | 8 | /index.php?route=product/product/review&product_id=218
2014-01-10 13:05:09 - --------------------
2014-01-10 13:05:09 - 0.00353 | 6 | /index.php?route=product/product/captcha
2014-01-10 13:05:18 - --------------------
2014-01-10 13:05:18 - 0.00653 | 8 | /index.php?route=product/product/review&product_id=95
2014-01-10 13:05:20 - --------------------
2014-01-10 13:05:21 - 0.19524 | 86 | /index.php?route=product/category&path=20_26
2014-01-10 13:05:25 - --------------------
2014-01-10 13:05:25 - 0.18560 | 88 | /index.php?route=product/product&path=63_76&product_id=147
2014-01-10 13:05:25 - --------------------
2014-01-10 13:05:25 - 0.00304 | 6 | /index.php?route=product/product/captcha
2014-01-10 13:05:25 - --------------------
2014-01-10 13:05:25 - 0.00369 | 8 | /index.php?route=product/product/review&product_id=147
2014-01-10 13:05:28 - --------------------
2014-01-10 13:05:28 - 0.17367 | 80 | /index.php?route=product/category&path=151
2014-01-10 13:05:32 - --------------------
2014-01-10 13:05:32 - 0.16999 | 88 | /index.php?route=product/product&path=20_26&product_id=199
2014-01-10 13:05:33 - --------------------
2014-01-10 13:05:33 - 0.00486 | 6 | /index.php?route=product/product/captcha
2014-01-10 13:05:33 - --------------------
2014-01-10 13:05:33 - 0.00491 | 8 | /index.php?route=product/product/review&product_id=199
2014-01-10 13:05:33 - --------------------
2014-01-10 13:05:34 - 0.18282 | 88 | /index.php?route=product/product&path=151&product_id=272
2014-01-10 13:05:34 - --------------------
2014-01-10 13:05:34 - 0.00439 | 6 | /index.php?route=product/product/captcha
2014-01-10 13:05:35 - --------------------
2014-01-10 13:05:35 - 0.00456 | 8 | /index.php?route=product/product/review&product_id=272
2014-01-10 13:05:39 - --------------------
2014-01-10 13:05:40 - 0.24264 | 96 | /index.php?route=product/category&path=80
2014-01-10 13:05:44 - --------------------
2014-01-10 13:05:44 - --------------------
2014-01-10 13:05:45 - 0.21645 | 90 | /index.php?route=product/category&path=63
2014-01-10 13:05:45 - 0.19940 | 80 | /index.php?route=product/category&path=151
2014-01-10 13:05:49 - --------------------
2014-01-10 13:05:49 - 0.16339 | 88 | /index.php?route=product/product&path=151&product_id=273
2014-01-10 13:05:49 - --------------------
2014-01-10 13:05:49 - 0.00325 | 6 | /index.php?route=product/product/captcha
2014-01-10 13:05:50 - --------------------
2014-01-10 13:05:50 - --------------------
2014-01-10 13:05:50 - 0.00605 | 8 | /index.php?route=product/product/review&product_id=273
2014-01-10 13:05:50 - --------------------
2014-01-10 13:05:50 - 0.22946 | 84 | /index.php?route=product/category&path=20_27
2014-01-10 13:05:50 - 0.19198 | 80 | /index.php?route=product/category&path=63_133
2014-01-10 13:05:53 - --------------------
2014-01-10 13:05:53 - 0.17415 | 81 | /
2014-01-10 13:05:55 - --------------------
2014-01-10 13:05:56 - 0.17505 | 90 | /index.php?route=product/category&path=63
2014-01-10 13:05:57 - --------------------
2014-01-10 13:05:57 - 0.14436 | 88 | /index.php?route=product/product&path=63_133&product_id=226
2014-01-10 13:05:57 - --------------------
2014-01-10 13:05:57 - 0.00415 | 6 | /index.php?route=product/product/captcha
2014-01-10 13:05:58 - --------------------
2014-01-10 13:05:58 - 0.00378 | 8 | /index.php?route=product/product/review&product_id=226
2014-01-10 13:05:58 - --------------------
2014-01-10 13:05:59 - 0.16117 | 83 | /index.php?route=product/category&path=64_153
2014-01-10 13:06:01 - --------------------
2014-01-10 13:06:01 - 0.16708 | 88 | /index.php?route=product/product&path=64_153&product_id=276
2014-01-10 13:06:01 - --------------------
2014-01-10 13:06:01 - 0.00297 | 6 | /index.php?route=product/product/captcha
2014-01-10 13:06:01 - --------------------
2014-01-10 13:06:01 - 0.00593 | 8 | /index.php?route=product/product/review&product_id=276
2014-01-10 13:06:09 - --------------------
2014-01-10 13:06:10 - 0.14622 | 84 | /index.php?route=product/category&path=64_74
2014-01-10 13:06:11 - --------------------
2014-01-10 13:06:11 - 0.18496 | 80 | /index.php?route=product/category&path=151
2014-01-10 13:06:12 - --------------------
2014-01-10 13:06:12 - 0.14958 | 80 | /index.php?route=product/category&path=63_76
2014-01-10 13:06:13 - --------------------
2014-01-10 13:06:13 - --------------------
2014-01-10 13:06:14 - 0.75837 SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price FROM product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM product_reward pr WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name FROM stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit FROM length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (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 COUNT(*) AS total FROM review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM product p LEFT JOIN product_description pd ON (p.product_id = pd.product_id) LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '108' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
2014-01-10 13:06:14 - 0.59989 SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price FROM product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM product_reward pr WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name FROM stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit FROM length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (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 COUNT(*) AS total FROM review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM product p LEFT JOIN product_description pd ON (p.product_id = pd.product_id) LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '272' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
2014-01-10 13:06:14 - 0.89072 | 88 | /index.php?route=product/product&path=151&product_id=272
2014-01-10 13:06:14 - ----------
2014-01-10 13:06:14 - 0.04821 | 9 | /home/p118192/www/loudsound.su/catalog/controller/module/category.php(67)
2014-01-10 13:06:14 - 0.21700 | 49 | /home/p118192/www/loudsound.su/catalog/controller/module/category.php(45)
2014-01-10 13:06:14 - 0.75837 | 1 | /home/p118192/www/loudsound.su/catalog/controller/product/product.php(94)
2014-01-10 13:06:14 - ----------
2014-01-10 13:06:14 - 1.09301 | 88 | /index.php?route=product/product&path=20_27&product_id=108
2014-01-10 13:06:15 - --------------------
2014-01-10 13:06:15 - 0.00517 | 6 | /index.php?route=product/product/captcha
2014-01-10 13:06:15 - --------------------
2014-01-10 13:06:15 - 0.00479 | 8 | /index.php?route=product/product/review&product_id=272
2014-01-10 13:06:15 - --------------------
2014-01-10 13:06:16 - 0.16366 | 88 | /index.php?route=product/product&path=63_76&product_id=231
2014-01-10 13:06:16 - --------------------
2014-01-10 13:06:16 - 0.00350 | 6 | /index.php?route=product/product/captcha
2014-01-10 13:06:16 - --------------------
2014-01-10 13:06:16 - 0.00368 | 8 | /index.php?route=product/product/review&product_id=231
2014-01-10 13:06:17 - --------------------
2014-01-10 13:06:17 - 0.18165 | 84 | /index.php?route=product/category&path=87
2014-01-10 13:06:18 - --------------------
2014-01-10 13:06:18 - 0.17522 | 80 | /index.php?route=product/category&path=151
2014-01-10 13:06:20 - --------------------
2014-01-10 13:06:20 - 0.14692 | 80 | /index.php?route=product/category&path=87_90
2014-01-10 13:06:21 - --------------------
2014-01-10 13:06:21 - 0.00430 | 6 | /index.php?route=product/product/captcha
2014-01-10 13:06:26 - --------------------
2014-01-10 13:06:26 - 0.20207 | 88 | /index.php?route=product/product&path=87_90&product_id=115
2014-01-10 13:06:27 - --------------------
2014-01-10 13:06:27 - 0.00308 | 6 | /index.php?route=product/product/captcha
2014-01-10 13:06:27 - --------------------
2014-01-10 13:06:27 - 0.00408 | 8 | /index.php?route=product/product/review&product_id=115
2014-01-10 13:06:31 - --------------------
2014-01-10 13:06:31 - 0.15358 | 80 | /index.php?route=product/category&path=87_88
2014-01-10 13:06:34 - --------------------
2014-01-10 13:06:34 - 0.14874 | 80 | /index.php?route=product/category&path=87_90
2014-01-10 13:06:36 - --------------------
2014-01-10 13:06:36 - 0.17289 | 88 | /index.php?route=product/product&path=87_90&product_id=131
2014-01-10 13:06:36 - --------------------
2014-01-10 13:06:36 - 0.01305 | 6 | /index.php?route=product/product/captcha
2014-01-10 13:06:36 - --------------------
2014-01-10 13:06:36 - 0.00404 | 8 | /index.php?route=product/product/review&product_id=131
2014-01-10 13:06:37 - --------------------
2014-01-10 13:06:37 - 0.17064 | 94 | /index.php?route=product/product&path=20_26&product_id=84
2014-01-10 13:06:38 - --------------------
2014-01-10 13:06:38 - 0.00294 | 6 | /index.php?route=product/product/captcha
2014-01-10 13:06:38 - --------------------
2014-01-10 13:06:38 - 0.00411 | 8 | /index.php?route=product/product/review&product_id=84
2014-01-10 13:06:38 - --------------------
2014-01-10 13:06:38 - 0.18499 | 90 | /index.php?route=product/category&path=63
2014-01-10 13:06:41 - --------------------
2014-01-10 13:06:41 - 0.14133 | 80 | /index.php?route=product/category&path=63_133
2014-01-10 13:06:42 - --------------------
2014-01-10 13:06:42 - 0.00688 | 8 | /index.php?route=product/product/review&product_id=108

Далее!

Решил залесть в логи хостинга. И вот что увидел.

Идет куча запросов ежесекундных с одинаковых ip.

Такое ощущение, что какие то боты носятся по всему магазину.

Может быть можно как то запретить эти айпи? Или поставить так, чтобы время запросов было больше. Что бы убрать такое. Или сделать ограничение запросов?

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

А теперь вопрос? Что делать дальше? Помогут ли мои методы?

kratelig · 10 січня 2014

нет, но это с ума сойти можно!

Я на минуту включил сайт!

freelancer · 10 січня 2014

нагрузка на базу допустимая. похоже вас кто-то парсит/grab'ить

kratelig · 10 січня 2014

нагрузка на базу допустимая. похоже вас кто-то парсит/grab'ить

И тем не менее, нагрузка на БД идет! Как можно ограничить частату запросов? Я нашел скрипт через гугл, но судя по работе, он не дает эфекта.

http://www.php-example.ru/ogranichenie-kolichestva-zaprosov-s-odnogo-ip/

Быть может я что-то не то делаю.

kratelig · 10 січня 2014

/home/p118192/logs/loudsound.su_access.log:178.154.175.251 - - [07/Jan/2014:14:36:19 +0400] "GET /index.php?route=product/product&product_id=150 HTTP/1.1" 200 7433 "-" "Mozilla/5.0 (compatible; YandexDirect/3.0; +http://yandex.com/bots)"
/home/p118192/logs/loudsound.su_access.log:178.154.175.251 - - [07/Jan/2014:14:46:04 +0400] "GET /index.php?route=product/category&path=20 HTTP/1.1" 200 5769 "-" "Mozilla/5.0 (compatible; YandexDirect/3.0; +http://yandex.com/bots)"

/home/p118192/logs/loudsound.su_access.log:178.154.175.251 - - [07/Jan/2014:15:32:42 +0400] "GET /index.php?route=product/product&product_id=152 HTTP/1.1" 200 7540 "-" "Mozilla/5.0 (compatible; YandexDirect/3.0; +http://yandex.com/bots)"

/home/p118192/logs/loudsound.su_access.log:178.154.175.251 - - [07/Jan/2014:16:01:28 +0400] "GET /index.php?route=product/category&path=87_88 HTTP/1.1" 200 6602 "-" "Mozilla/5.0 (compatible; YandexBot/3.0; +http://yandex.com/bots)"

/home/p118192/logs/loudsound.su_access.log:178.154.175.251 - - [07/Jan/2014:16:01:31 +0400] "GET /index.php?route=product/product&product_id=88 HTTP/1.1" 200 8168 "-" "Mozilla/5.0 (compatible; YandexBot/3.0; +http://yandex.com/bots)"

/home/p118192/logs/loudsound.su_access.log:178.154.175.251 - - [07/Jan/2014:16:01:33 +0400] "GET /index.php?route=product/product&product_id=95 HTTP/1.1" 200 7633 "-" "Mozilla/5.0 (compatible; YandexBot/3.0; +http://yandex.com/bots)"

/home/p118192/logs/loudsound.su_access.log:178.154.175.251 - - [07/Jan/2014:16:01:36 +0400] "GET /index.php?route=product/category&path=60_116 HTTP/1.1" 200 6387 "-" "Mozilla/5.0 (compatible; YandexBot/3.0; +http://yandex.com/bots)"

/home/p118192/logs/loudsound.su_access.log:178.154.175.251 - - [07/Jan/2014:16:01:40 +0400] "GET /index.php?route=product/product&product_id=65 HTTP/1.1" 200 8032 "-" "Mozilla/5.0 (compatible; YandexBot/3.0; +http://yandex.com/bots)"

/home/p118192/logs/loudsound.su_access.log:178.154.175.251 - - [07/Jan/2014:16:01:43 +0400] "GET /index.php?route=product/category&path=64 HTTP/1.1" 200 5826 "-" "Mozilla/5.0 (compatible; YandexBot/3.0; +http://yandex.com/bots)"

/home/p118192/logs/loudsound.su_access.log:178.154.175.251 - - [07/Jan/2014:16:01:46 +0400] "GET /index.php?route=product/category&path=86 HTTP/1.1" 200 6245 "-" "Mozilla/5.0 (compatible; YandexBot/3.0; +http://yandex.com/bots)"

Вот что пришло от саппорта.

Саппорт говорит, что это поисковые боты, и якобы лучше в роботс.txt закрыть некоторые папки от индексирования!

Но он же тогда вылетит из поиска?

freelancer · 10 січня 2014

loudsound.su ваш сайт? открывается довольно шустро

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

а что за хостинг у вас? яндекс сайт индексирует, а хостер его закрывает :ugeek:

kratelig · 10 січня 2014

loudsound.su ваш сайт? открывается довольно шустро

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

а что за хостинг у вас? яндекс сайт индексирует, а хостер его закрывает :ugeek:

Да, мой. ihc.ru хостинг.

shpunt · 10 січня 2014

Меняйте хостинг для начала, например таймвеб...

kratelig · 10 січня 2014

Меняйте хостинг для начала, например таймвеб...

про него я тоже тут прочитал много не очень хороших отзывов+ ограничения по загузке БД такие же.

Пробовал в robots.txt сделать тайм-аут для поисковых ботов через дерективу Crawl-Delay.

Толку никакого.

Как сделать ограничение на кол-во запросов?

kratelig · 10 січня 2014

Я просто в недоумении!!!

Я уже поставил скрипт, которые блокирует частые сессии и просмотры страниц. Сам щелкаю по сайту быстро, меня кидает на 503 ошибку, вроде все работает!

Но блин, открываю логи! А там все та же картина! По 20 запросов в секунду!

l.slava · 10 січня 2014

Я просто в недоумении!!!

Я уже поставил скрипт, которые блокирует частые сессии и просмотры страниц. Сам щелкаю по сайту быстро, меня кидает на 503 ошибку, вроде все работает!

Но блин, открываю логи! А там все та же картина! По 20 запросов в секунду!

Никогда не слушайте тех кто рекомендуют менять хостинг. В данном случае ваш сайт хорошо индексирует бот яндекса, поставьте Crawl-Delay 5, но бот эту директиву будет использовать не сразу.

Сколько у вас в базе товаров? Если больше 10к. то нужно оптимизировать sql запросы и как минимум выставить индексы на базу. По умолчанию в опенкарте не все индексы проставлены.

kratelig · 10 січня 2014

Какие там 10 тыс)

223 товара всего.

msergey11 · 12 січня 2014

Та же беда с нагрузкой, правда товаров несколько тысяч и все находится на VDS. Хостер пишет, что нужен полный анализ и оптимизация сайта, пока не рекомендует переходить на выделенный сервер.

Может есть здесь хорошие специалисты на форуме?

Вхід

нагрузка на Б\Д

Recommended Posts

Надіслати

Поділитися на інших сайтах

Надіслати

Поділитися на інших сайтах

Надіслати

Поділитися на інших сайтах

Надіслати

Поділитися на інших сайтах

Надіслати

Поділитися на інших сайтах

Надіслати

Поділитися на інших сайтах

Надіслати

Поділитися на інших сайтах

Надіслати

Поділитися на інших сайтах

Надіслати

Поділитися на інших сайтах

Надіслати

Поділитися на інших сайтах

Надіслати

Поділитися на інших сайтах

Надіслати

Поділитися на інших сайтах

Надіслати

Поділитися на інших сайтах

Надіслати

Поділитися на інших сайтах

Надіслати

Поділитися на інших сайтах

Надіслати

Поділитися на інших сайтах

Надіслати

Поділитися на інших сайтах

Надіслати

Поділитися на інших сайтах

Надіслати

Поділитися на інших сайтах

Надіслати

Поділитися на інших сайтах

Надіслати

Поділитися на інших сайтах

Надіслати

Поділитися на інших сайтах

Надіслати

Поділитися на інших сайтах

Надіслати

Поділитися на інших сайтах

Надіслати

Поділитися на інших сайтах

Створіть аккаунт або увійдіть для коментування

Створити обліковий запис

Вхід

Зараз на сторінці 0 користувачів

Покупцям

Розробникам

Корисна інформація

Останні розширення

Important Information