P
P
Pavel2015-07-09 10:09:49
1C-Bitrix
Pavel, 2015-07-09 10:09:49

How to optimize Bitrix internal traffic statistics?

Hello. There is a project on Bitrix with attendance of 15k people per day, I accepted the project from other developers.
Now managers use the internal statistics of Bitrix, the database with it already takes up quite a few gigabytes, and requests to it take a lot of time, and they can even put the site down, although the site is spinning on a separate server. The performance monitor shows a very small value of 8-10 at various times. Is it possible to somehow optimize the statistics module and speed up queries to it? Previously, the tables were in MyISAM, they were recently transferred to the InnoDB engine, as I found in the tips on the Bitrix website, but it seems to work slower, on the contrary.

Answer the question

In order to leave comments, you need to log in

2 answer(s)
E
Eugene, 2015-07-09
@e-antonov

my personal opinion is that Bitrix statistics (as you already understood) is a rather difficult thing. I would cut out the collection of statistics on a project with your attendance, and switch to GA and Yandex.metrics.
you just need to pay attention, if you have work with the functionality of banners and advertising campaigns, then this business is connected with itrix analytics.

V
vitaly_keng, 2017-11-28
@vitaly_keng

The best web analytics optimization in Bitrix is ​​to remove this module.
Collect statistics by external services like Yandex.metrics and google analytics.

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question