Добрый день. сегодня жутко стал тормозить сайт https://selamebel.ru сейчас практически вообще не открывается хостинг прислал лог медленных запросов помогите пожалуйста разобраться
Longest syscalls:
TIME LINE SYSCALL
-------------------------------
5.449261 3367 poll([{fd=12, events=POLLIN|POLLERR|POLLHUP}], 1, 1471228928) = 1 ([{fd=12, revents=POLLIN}])
16.850235 2821 poll([{fd=12, events=POLLIN|POLLERR|POLLHUP}], 1, 1471228928) = 1 ([{fd=12, revents=POLLIN}])
0.935642 6104 poll([{fd=10, events=POLLIN}], 1, 1000) = 1 ([{fd=10, revents=POLLIN}])
0.831669 364 poll([{fd=12, events=POLLIN|POLLERR|POLLHUP}], 1, 1471228928) = 1 ([{fd=12, revents=POLLIN}])
0.109185 2824 poll([{fd=12, events=POLLIN|POLLERR|POLLHUP}], 1, 1471228928) = 1 ([{fd=12, revents=POLLIN}])
0.082204 3659 poll([{fd=12, events=POLLIN|POLLERR|POLLHUP}], 1, 1471228928) = 1 ([{fd=12, revents=POLLIN}])
0.081781 2994 poll([{fd=12, events=POLLIN|POLLERR|POLLHUP}], 1, 1471228928) = 1 ([{fd=12, revents=POLLIN}])
0.081608 3463 poll([{fd=12, events=POLLIN|POLLERR|POLLHUP}], 1, 1471228928) = 1 ([{fd=12, revents=POLLIN}])
0.081587 3466 poll([{fd=12, events=POLLIN|POLLERR|POLLHUP}], 1, 1471228928) = 1 ([{fd=12, revents=POLLIN}])
0.081518 3709 poll([{fd=12, events=POLLIN|POLLERR|POLLHUP}], 1, 1471228928) = 1 ([{fd=12, revents=POLLIN}])
Вот тут видно что почти 6 секунд работает запрос в базу:
cdenisa@henry:~/mebel2/public_html [0] $ sed -n 3366,3367p log_2021-06-11_18-03-23.43371 +3367
18:03:45.853684 [ 7fb319c7796a] sendto(12, "\243\1\0\0\3SELECT op.product_id, SUM(op.quantity) AS total FROM `oc_14order_product` op LEFT JOIN `oc_14order` o ON (op.order_id = o.order_id) LEFT JOIN `oc_14product` p ON (op.product_id = p.product_id) LEFT JOIN `oc_14product_to_store` p2s ON (p.product_id = p2s.product_id) WHERE o.order_status_id > '0' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' GROUP BY op.product_id ORDER BY total DESC LIMIT 8", 423, MSG_DONTWAIT, NULL, 0) = 423 <0.000016>
18:03:45.853806 [ 7fb319989bc4] poll([{fd=12, events=POLLIN|POLLERR|POLLHUP}], 1, 1471228928) = 1 ([{fd=12, revents=POLLIN}]) <5.449261>
А тут запрос в базу работал 16 секунд:
cdenisa@henry:~/mebel2/public_html [2] $ sed -n 2820,2821p log_2021-06-11_18-03-23.43371
18:03:27.025364 [ 7fb319c7796a] sendto(12, "\277\1\0\0\3SELECT DISTINCT ps.product_id FROM `oc_14product_special` ps LEFT JOIN `oc_14product` p ON (ps.product_id = p.product_id) LEFT JOIN oc_14product_to_store p2s ON (p.product_id = p2s.product_id) WHERE p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' 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())) GROUP BY ps.product_id LIMIT 5", 451, MSG_DONTWAIT, NULL, 0) = 451 <0.000019>
18:03:27.025460 [ 7fb319989bc4] poll([{fd=12, events=POLLIN|POLLERR|POLLHUP}], 1, 1471228928) = 1 ([{fd=12, revents=POLLIN}]) <16.850235>