A
A
Alexey2018-02-10 16:40:30
opencart
Alexey, 2018-02-10 16:40:30

The site slows down on the muto opencart 2.3 template, is it possible to help solve the problem?

opencart 2.3. Muto template. The site slows down, hosting technical support said that the problem is in frequent queries to the database.
On another hosting, the same template works quickly, but after some time a 504 error occurs. They cannot solve the problem.
the first site is muto.konkord24.ru
the second site is shopsalemoscow.ru
Below is the response from the hoster
According to the strace utility, when accessing the site shopsalemoscow.ru, a high number of database accesses are observed:
poll([{fd=6, events=POLLIN|POLLERR|POLLHUP} ], 1, 1471228928) = 1 ([{fd=6, revents=POLLIN}])
recvfrom(6, "\1\0\0\1\3S\0\0\2\3def\ru0462405_muto\foc_url_alias\foc_url_alias\furl_alias_id\furl_alias_id\f?\0\v\0\0\0\3\3B \0\0\0E\0\0\3\3def\ru0462405_muto\foc_url_alias\foc_url_alias\5query\5query\f!\0\375\2\0\0\375\tP\0\0\0I\0\ 0\4\3def\ru0462405_muto\foc_url_alias\foc_url_alias\7keyword\7keyword\f!\0\375\2\0\0\375\tP\0\0\0\5\0\0\5\376\0 \0\2\0\5\0\0\6"..., 13551, MSG_DONTWAIT, NULL, NULL) = 260
sendto(6, "<\0\0\0\3SELECT * FROM oc_url_alias WHERE `query` = 'category_id=18'", 64, MSG_DONTWAIT, NULL, 0) = 64
poll([{fd=6, events=POLLIN|POLLERR|POLLHUP}], 1, 1471228928) = 1 ([{fd=6, revents =POLLIN}])
recvfrom(6, "\1\0\0\1\3S\0\0\2\3def\ru0462405_muto\foc_url_alias\foc_url_alias\furl_alias_id\furl_alias_id\f?\0\v\0\0\0\3\3B \0\0\0E\0\0\3\3def\ru0462405_muto\foc_url_alias\foc_url_alias\5query\5query\f!\0\375\2\0\0\375\tP\0\0\0I\0\ 0\4\3def\ru0462405_muto\foc_url_alias\foc_url_alias\7keyword\7keyword\f!\0\375\2\0\0\375\tP\0\0\0\5\0\0\5\376\0 \0\2\0#\0\0\6"..., 13291, MSG_DONTWAIT, NULL, NULL) = 299
sendto(6, "<\0\0\0\3SELECT * FROM oc_url_alias WHERE `query` = 'category_id=87'", 64, MSG_DONTWAIT, NULL, 0) = 64
poll([{fd=6, events=POLLIN|POLLERR|POLLHUP}], 1, 1471228928) = 1 ([{fd=6, revents= POLLIN}])
recvfrom(6, "\1\0\0\1\3S\0\0\2\3def\ru0462405_muto\foc_url_alias\foc_url_alias\furl_alias_id\furl_alias_id\f?\0\v\0\0\0\3\3B \0\0\0E\0\0\3\3def\ru0462405_muto\foc_url_alias\foc_url_alias\5query\5query\f!\0\375\2\0\0\375\tP\0\0\0I\0\ 0\4\3def\ru0462405_muto\foc_url_alias\foc_url_alias\7keyword\7keyword\f!\0\375\2\0\0\375\tP\0\0\0\5\0\0\5\376\0 \0\2\0\35\0\0\6"..., 12992, MSG_DONTWAIT, NULL, NULL) = 293
sendto(6, ">\0\0\0\3SELECT * FROM oc_url_alias WHERE `query` = 'product/category'", 66, MSG_DONTWAIT, NULL, 0) = 66
poll([{fd=6, events=POLLIN|POLLERR|POLLHUP}], 1, 1471228928) = 1 ([{fd=6, revents =POLLIN}])
recvfrom(6, "\1\0\0\1\3S\0\0\2\3def\ru0462405_muto\foc_url_alias\foc_url_alias\furl_alias_id\furl_alias_id\f?\0\v\0\0\0\3\3B \0\0\0E\0\0\3\3def\ru0462405_muto\foc_url_alias\foc_url_alias\5query\5query\f!\0\375\2\0\0\375\tP\0\0\0I\0\ 0\4\3def\ru0462405_muto\foc_url_alias\foc_url_alias\7keyword\7keyword\f!\0\375\2\0\0\375\tP\0\0\0\5\0\0\5\376\0 \0\2\0\5\0\0\6"..., 12699, MSG_DONTWAIT, NULL, NULL) = 260
sendto(6, "<\0\0\0\3SELECT * FROM oc_url_alias WHERE `query` = 'category_id=18'", 64, MSG_DONTWAIT, NULL, 0) = 64
poll([{fd=6, events=POLLIN|POLLERR|POLLHUP}], 1, 1471228928) = 1 ([{fd=6, revents =POLLIN}])
recvfrom(6, "\1\0\0\1\3S\0\0\2\3def\ru0462405_muto\foc_url_alias\foc_url_alias\furl_alias_id\furl_alias_id\f?\0\v\0\0\0\3\3B \0\0\0E\0\0\3\3def\ru0462405_muto\foc_url_alias\foc_url_alias\5query\5query\f!\0\375\2\0\0\375\tP\0\0\0I\0\ 0\4\3def\ru0462405_muto\foc_url_alias\foc_url_alias\7keyword\7keyword\f!\0\375\2\0\0\375\tP\0\0\0\5\0\0\5\376\0 \0\2\0#\0\0\6"..., 12439, MSG_DONTWAIT, NULL, NULL) = 299
sendto(6, "0\1\0\0\3SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '57' AND cd.language_id = '1' AND c2s.store_id = '0' AND" ..., 308, MSG_DONTWAIT, NULL, 0) = 308
poll([{fd=6, events=POLLIN|POLLERR|POLLHUP}], 1, 1471228928) = 1 ([{fd=6,revents=POLLIN}])
recvfrom(6, "\1\0\0\1\25E\0\0\2\3def\ru0462405_muto\1c\voc_category\vcategory_id\vcategory_id\f?\0\v\0\0\0\3\1 \0\0\0\0009\0\0\3\3def\ru0462405_muto\1c\voc_category\5image\5image\f!\0\375\2\0\0\375\0\0\0\0\ 0A\0\0\4\3def\ru0462405_muto\1c\voc_category\tparent_id\tparent_id\f?\0\v\0\0\0\3\1\0\0\0\0005\0\0\5 \3def\ru0462405_muto\1c\voc_category\3top\3top\f?\0"..., 12140, MSG_DONTWAIT, NULL, NULL) = 1617
sendto(6, ">\0\0\0\3SELECT * FROM oc_url_alias WHERE `query` = 'product/category'", 66, MSG_DONTWAIT, NULL, 0) = 66
poll([{fd=6, events=POLLIN|POLLERR|POLLHUP}], 1, 1471228928) = 1 ([{fd= 6, revents=POLLIN}])
recvfrom(6, "\1\0\0\1\3S\0\0\2\3def\ru0462405_muto\foc_url_alias\foc_url_alias\furl_alias_id\furl_alias_id\f?\0\v\0\0\0\3\3B \0\0\0E\0\0\3\3def\ru0462405_muto\foc_url_alias\foc_url_alias\5query\5query\f!\0\375\2\0\0\375\tP\0\0\0I\0\ 0\4\3def\ru0462405_muto\foc_url_alias\foc_url_alias\7keyword\7keyword\f!\0\375\2\0\0\375\tP\0\0\0\5\0\0\5\376\0 \0\2\0\5\0\0\6"..., 10523, MSG_DONTWAIT, NULL, NULL) = 260
sendto(6, "<\0\0\0\3SELECT * FROM oc_url_alias WHERE `query` = 'category_id=57'", 64, MSG_DONTWAIT, NULL, 0) = 64
poll([{fd=6, events=POLLIN|POLLERR|POLLHUP}], 1, 1471228928) = 1 ([{fd=6, revents =POLLIN}])
recvfrom(6, "\1\0\0\1\3S\0\0\2\3def\ru0462405_muto\foc_url_alias\foc_url_alias\furl_alias_id\furl_alias_id\f?\0\v\0\0\0\3\3B \0\0\0E\0\0\3\3def\ru0462405_muto\foc_url_alias\foc_url_alias\5query\5query\f!\0\375\2\0\0\375\tP\0\0\0I\0\ 0\4\3def\ru0462405_muto\foc_url_alias\foc_url_alias\7keyword\7keyword\f!\0\375\2\0\0\375\tP\0\0\0\5\0\0\5\376\0 \0\2\0\32\0\0\6"..., 10263, MSG_DONTWAIT, NULL, NULL) = 290
sendto(6, "0\1\0\0\3SELECT * FROM oc_category with LEFT JOIN

Answer the question

In order to leave comments, you need to log in

1 answer(s)
W
web-mechanic, 2018-03-26
@Gnanw

write to [email protected], in the coming evenings we will solve the issue, though not for free, but payment upon completion

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question