What mysql engine for huge amount of data (logging)?
What mysql engine would be best suited for handling huge amount (many rows) of (small) data? I talking ab开发者_StackOverflowout 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.
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.
精彩评论