What database is used to collect game statistics?

Question

Database

There is a game on node.js, there can be a maximum of 5000 slots.

It is necessary to implement the collection of game data (statistics):
- online statistics;
- character's actions;
- technical data;
- statistics of premium privileges;
- logs;
- etc.

Questions:
1. What databases might be best suited for this?
2. Where can I find information about how this data is best stored (designed)?
3. How to structure this data in the database? So that later you can easily use them on the site to display charts.

Answer 1

Any column database or for collecting metrics. Also, such systems are called Data Warehouse. The first examples I came across are ClickHouse and Snowflake