A
A
Alexey2018-02-08 08:51:17
opencart
Alexey, 2018-02-08 08:51:17

Installed the template on opencart 2.3. The site began to slow down, how to solve the problem?

I received a response from the hoster, help how to solve?
According to the strace utility, when accessing the site shopsalemoscow.ru, there is a high number of database accesses:
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,
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)
A
Ainur Valiev, 2018-02-08
@vaajnur

https://www.hostcms.ru/documentation/server/mysql/

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question