What database is better to use for storing events?

Question

Database

What database is better to use for storing events?
In general, there is a card game, it is necessary to save all the actions of the players, and some "conclusions" of the logic of the table, which DBMS is best suited for this and will not start to limp after several million records?
first tried mysql but got brutal delays when trying to collect stats about single player actions

Answer 1

MySQL with normal structure and indexes.
Your structure should take this possibility into account.
Or - take into account that some of the answers are given to the database quickly (those that are needed immediately, quickly), and some (secondary, not needed often) - slowly.
If you really want to go very fast - see Tarantool.
It belongs to the class of DBMS that give the answer as quickly as possible.
If it will slow you down on it, reconsider your architecture.

Answer 2

Clickhouse is your solution

Answer 3

postgres with normal structure and indexes