The number of page views. How best to implement?

Question

MySQL

There is a project.
25,000 hosts per day.
It is necessary to record in the database the number of views of the article for the last 7 days.
There is an option to enter a separate table in which each view with time will be recorded.
But as you understand - the load on the database.
Perhaps there are other options?
Perhaps google analytics or Yandex.metrics allow you to receive such information?

Answer 1

Yandex.Metrica allows .
And Google Analytics can .
Did you search?

Answer 2

What do you think the purpose of these tools was?
Of course they will help.

Answer 3

Analysis of nginx or apache logs
as a Redis option and already with Redis in the database.

Answer 4

Here is a similar question: How to make a counter of article views?