How to organize timelines (history) and their storage in the database (and interaction in general)?

Question

MySQL

I have conditionally 3 types of pages (order, building, client).
Each of them has a timeline (Chronology of actions with an order / building / client).
How can I organize the storage of logs?
So far, it seems to me like this:

With any change, an action is recorded (to determine the visual style, for example), text (for further output).

Answer 1

If the logs, then mysql immediately disappears, hundreds of millions of records run up there pretty quickly, take elastic, usually it’s enough to store id, date, type in and json the necessary data.