What mysql engine for huge amount of data (logging)?

Question

What mysql engine would be best suited for handling huge amount (many rows) of (small) data? I talking about logging.

I'm thinking about logging whenever I do things on my page, like calling a function, calling a file and so on.

A tip of how I should structure the table is also appreciated.

Answer 1

The Archive storage engine is geared toward storing logs, and is compressed. It supports INSERT and SELECT only, no UPDATE or DELETE. I have never used it, but it may fit your needs.