快速的写入性能，即使读取速度很慢 [英] Fast write performance, even if reads are very slow

问题描述

很抱歉，如果已经有了答案，我就搜索了它，但没有找到我想要的方案.

Sorry if there's already an answer for this, I searched for it and I didn't find exactly my scenario.

再次出现诸如什么是最快/最佳性能数据库?"之类的问题.但是由于答案取决于情况，所以我的情况是这样的:我想将许多日志每秒写入数千个数据库.但是我不会经常阅读它们.的确，它们中的99,99％将永远不会再被读取，但有时我需要阅读.模式并不复杂，只是键/值.有时我会按值读取，如果读取需要几分钟，我将完全不在乎.读取的正确性至关重要，但性能并不重要.

Once again is a question like "What is the fastest/best performance DB?". But since the answer depends on the scenario, my scenario is this: I want to write many logs to DB, thousands per second. But I will not read them often. Indeed 99,99% of them will never be read again, but once in a while I will need to read. Schema is not complex, just key/value. Once in a while I will read by value and I will not care at all if this read takes minutes. The correctness of the read will be critical, but not the performance.

到目前为止，似乎最好的解决方案是MongoDB，Cassandra等……也许是最好的DynamoDB?

So far it seems the best solutions are things like MongoDB, Cassandra... and perhaps the best DynamoDB?

推荐答案

我想说任何DBMS都切换到最低的隔离级别并且没有索引.如果将其与良好的存储系统结合在一起，则可能是带有SSD的RAID 0.斋戒永远写.

Any DBMS, i would say, switch to the lowest isolation level and no index. If you put that together with a good storage system, maybe a RAID 0 with SSDs. Fastes writes ever.

很难说DBMS是最好的，通常您想要最好的dbms，特别是擅长做某事的dbms，但是您需要一个dbms，它基本上只写一些限制最少的东西，我听说过mysql可以做到这一点

Its hard to say wich DBMS is best, usually you want the best dbms that is good in doing something in particular but you need a dbms that basically just write something with the least of restriction, ive heard mysql can be great in this.

这篇关于快速的写入性能，即使读取速度很慢的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！