什么MySQL引擎可用于海量数据(日志记录)? [英] What mysql engine for huge amount of data (logging)?

问题描述

哪种mysql引擎最适合处理大量(小行)(小)数据?我在谈论日志记录.

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.

推荐答案

归档存储引擎旨在存储日志并进行了压缩.它仅支持INSERT和SELECT，不支持UPDATE或DELETE.我从未使用过，但它可能符合您的需求.

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.

这篇关于什么MySQL引擎可用于海量数据(日志记录)?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！