What is the mysql engine for a huge amount of data (registration)?

Question

Which mysql engine is best suited to handle a huge amount of (many rows) (small) data? I am talking about logging.

I think about registering when I do something on my page, for example, calling a function, calling a file, etc.

It is also recommended that you evaluate how I should structure the table.

Answer 1

Archive storage engine is designed to store logs and is compressed. It supports only INSERT and SELECT, without UPDATE or DELETE. I have never used it, but it can suit your needs.