3 ms·
A modern and properly implemented database engine should be bottlenecked on network saturation for these types of workloads even if backed by disk storage, neve
by jandrewrogers 12y ago
A modern and properly implemented database engine should be bottlenecked on network saturation for these types of workloads even if backed by disk storage, never mind in-memory. These workloads are trivially distributable, so scale-out is expected unless you are doing something really wrong.
In that sense, similar "look how fast my simple lookups are" benchmarks published by other database vendors are really a function of their hardware budget for the benchmark assuming the implementation is competent. Queries with complex constraints or joins would be a more interesting indication of implementation scalability and performance.
- toomuchtodo 12y agoI'd be interested to see a benchmark test suite for ACID-compliant databases with, as you mentioned, complex constraints and joins. Get as close to real-world workloads as possible. I don't want to see the quarter mile, I want to see you road rally.
- wwwted 12y agoThere are some more complex benchmarks here: http://www.mysql.com/why-mysql/benchmarks/mysql-cluster/ http://www.mysql.com/why-mysql/benchmarks/mysql-cluster/ Best way as always is by running benchmark on your specific workload, there is lot's of help to be found here: http://mikaelronstrom.blogspot.se/ http://mikaelronstrom.blogspot.se/ if you want to get started benchmarking MySQL Cluster.