databaseteste

Database Testes

Compare your own system(s) to this result file with the Phoronix Test Suite by running the command: phoronix-test-suite benchmark 2204064-NE-DATABASET63
Jump To Table - Results

Statistics

Remove Outliers Before Calculating Averages

Graph Settings

Prefer Vertical Bar Graphs

Multi-Way Comparison

Condense Multi-Option Tests Into Single Result Graphs

Table

Show Detailed System Result Table

Run Management

Result
Identifier
View Logs
Performance Per
Dollar
Date
Run
  Test
  Duration
Database Teste
March 31 2022
  1 Day, 16 Hours, 58 Minutes
Only show results matching title/arguments (delimit multiple options with a comma):
Do not show results matching title/arguments (delimit multiple options with a comma):


databasetesteOpenBenchmarking.orgPhoronix Test Suite2 x Intel Xeon Gold 6252 (3 Cores)Intel 440BX (6.00 BIOS)Intel 440BX/ZX/DX1 x 2 GB DRAM107GB Virtual diskllvmpipeVMware VMXNET3Debian 115.10.0-13-amd64 (x86_64)KDE Plasma 5.20.5X Server 1.20.114.5 Mesa 20.3.5 (LLVM 11.0.1 256 bits)1.0.2GCC 10.2.1 20210110ext41533x951VMwareProcessorMotherboardChipsetMemoryDiskGraphicsNetworkOSKernelDesktopDisplay ServerOpenGLVulkanCompilerFile-SystemScreen ResolutionSystem LayerDatabaseteste BenchmarksSystem Logs- Transparent Huge Pages: always- --build=x86_64-linux-gnu --disable-vtable-verify --disable-werror --enable-bootstrap --enable-checking=release --enable-clocale=gnu --enable-default-pie --enable-gnu-unique-object --enable-languages=c,ada,c++,go,brig,d,fortran,objc,obj-c++,m2 --enable-libphobos-checking=release --enable-libstdcxx-debug --enable-libstdcxx-time=yes --enable-link-mutex --enable-multiarch --enable-multilib --enable-nls --enable-objc-gc=auto --enable-offload-targets=nvptx-none=/build/gcc-10-Km9U7s/gcc-10-10.2.1/debian/tmp-nvptx/usr,amdgcn-amdhsa=/build/gcc-10-Km9U7s/gcc-10-10.2.1/debian/tmp-gcn/usr,hsa --enable-plugin --enable-shared --enable-threads=posix --host=x86_64-linux-gnu --program-prefix=x86_64-linux-gnu- --target=x86_64-linux-gnu --with-abi=m64 --with-arch-32=i686 --with-build-config=bootstrap-lto-lean --with-default-libstdcxx-abi=new --with-gcc-major-version-only --with-multilib-list=m32,m64,mx32 --with-target-system-zlib=auto --with-tune=generic --without-cuda-driver -v - MQ-DEADLINE / errors=remount-ro,relatime,rw / Block Size: 4096 - CPU Microcode: 0x5003003- OpenJDK Runtime Environment (build 11.0.14+9-post-Debian-1deb11u1) - itlb_multihit: KVM: Mitigation of VMX unsupported + l1tf: Mitigation of PTE Inversion + mds: Vulnerable: Clear buffers attempted no microcode; SMT Host state unknown + meltdown: Mitigation of PTI + spec_store_bypass: Mitigation of SSB disabled via prctl and seccomp + spectre_v1: Mitigation of usercopy/swapgs barriers and __user pointer sanitization + spectre_v2: Mitigation of Retpolines IBPB: conditional IBRS_FW STIBP: disabled RSB filling + srbds: Not affected + tsx_async_abort: Vulnerable: Clear buffers attempted no microcode; SMT Host state unknown

databasetesteleveldb: Hot Readleveldb: Fill Syncleveldb: Fill Syncleveldb: Overwriteleveldb: Overwriteleveldb: Rand Fillleveldb: Rand Fillleveldb: Rand Readleveldb: Seek Randleveldb: Rand Deleteleveldb: Seq Fillleveldb: Seq Fillsqlite: 1couchdb: 100 - 1000 - 24keydb: pgbench: 1 - 1 - Read Onlypgbench: 1 - 1 - Read Only - Average Latencypgbench: 1 - 1 - Read Writepgbench: 1 - 1 - Read Write - Average Latencypgbench: 1 - 50 - Read Onlypgbench: 1 - 50 - Read Only - Average Latencypgbench: 1 - 100 - Read Onlypgbench: 1 - 100 - Read Only - Average Latencypgbench: 1 - 250 - Read Onlypgbench: 1 - 250 - Read Only - Average Latencypgbench: 1 - 50 - Read Writepgbench: 1 - 50 - Read Write - Average Latencypgbench: 1 - 500 - Read Onlypgbench: 1 - 500 - Read Only - Average Latencypgbench: 100 - 1 - Read Onlypgbench: 100 - 1 - Read Only - Average Latencypgbench: 1 - 100 - Read Writepgbench: 1 - 100 - Read Write - Average Latencypgbench: 1 - 250 - Read Writepgbench: 1 - 250 - Read Write - Average Latencypgbench: 1 - 500 - Read Writepgbench: 1 - 500 - Read Write - Average Latencypgbench: 100 - 1 - Read Writepgbench: 100 - 1 - Read Write - Average Latencypgbench: 100 - 50 - Read Onlypgbench: 100 - 50 - Read Only - Average Latencypgbench: 1000 - 1 - Read Onlypgbench: 1000 - 1 - Read Only - Average Latencypgbench: 100 - 100 - Read Onlypgbench: 100 - 100 - Read Only - Average Latencypgbench: 100 - 250 - Read Onlypgbench: 100 - 250 - Read Only - Average Latencypgbench: 100 - 50 - Read Writepgbench: 100 - 50 - Read Write - Average Latencypgbench: 100 - 500 - Read Onlypgbench: 100 - 500 - Read Only - Average Latencypgbench: 1000 - 1 - Read Writepgbench: 1000 - 1 - Read Write - Average Latencypgbench: 1000 - 50 - Read Onlypgbench: 1000 - 50 - Read Only - Average Latencypgbench: 100 - 100 - Read Writepgbench: 100 - 100 - Read Write - Average Latencypgbench: 100 - 250 - Read Writepgbench: 100 - 250 - Read Write - Average Latencypgbench: 100 - 500 - Read Writepgbench: 100 - 500 - Read Write - Average Latencypgbench: 1000 - 100 - Read Onlypgbench: 1000 - 100 - Read Only - Average Latencypgbench: 1000 - 250 - Read Onlypgbench: 1000 - 250 - Read Only - Average Latencypgbench: 1000 - 50 - Read Writepgbench: 1000 - 50 - Read Write - Average Latencypgbench: 1000 - 500 - Read Onlypgbench: 1000 - 500 - Read Only - Average Latencypgbench: 1000 - 100 - Read Writepgbench: 1000 - 100 - Read Write - Average Latencypgbench: 1000 - 250 - Read Writepgbench: 1000 - 250 - Read Write - Average Latencypgbench: 1000 - 500 - Read Writepgbench: 1000 - 500 - Read Write - Average Latencysqlite-speedtest: Timed Time - Size 1,000memtier-benchmark: Redisredis: LPOPredis: SADDredis: LPUSHredis: GETredis: SETcassandra: Writesrocksdb: Rand Fillrocksdb: Rand Readrocksdb: Update Randrocksdb: Seq Fillrocksdb: Rand Fill Syncrocksdb: Read While Writingrocksdb: Read Rand Write Randhbase: Increment - 1hbase: Increment - 1hbase: Increment - 4hbase: Increment - 4hbase: Rand Read - 1hbase: Rand Read - 1hbase: Rand Read - 4hbase: Rand Read - 4hbase: Rand Write - 1hbase: Rand Write - 1hbase: Rand Write - 4hbase: Rand Write - 4hbase: Seq Read - 1hbase: Seq Read - 1hbase: Seq Read - 4hbase: Seq Read - 4hbase: Seq Write - 1hbase: Seq Write - 1hbase: Seq Write - 4hbase: Seq Write - 4hbase: Async Rand Read - 1hbase: Async Rand Read - 1hbase: Async Rand Read - 4hbase: Async Rand Read - 4hbase: Async Rand Write - 4hbase: Async Rand Write - 4influxdb: 4 - 10000 - 2,5000,1 - 10000influxdb: 64 - 10000 - 2,5000,1 - 10000influxdb: 1024 - 10000 - 2,5000,1 - 10000Database Teste1.1610.11935.36420.210.80820.310.7051.2201.72811.21021.010.44522.724173.05893376.54176080.0579911.010338221.478337392.964336567.42996851.6513282415.23458270.172865115.556503497.3482482012.8137801.281202612.47010680.937184305.4291278819.550378213.226882156.6944932.030133873.736352828.354290686.0572012248.601127487.8491102922.681331415.091832260.107317431.518277590.1042138233.898107.289979636.051849734.331473874.711173689.871774285.591326663.58767721212878449771085302275371063181988286892497020061566476259158127043133899925498458078931261206433140202245581071636315657316964669854316349.6284301.53025.6OpenBenchmarking.org

LevelDB

LevelDB is a key-value storage library developed by Google that supports making use of Snappy for data compression and has other modern features. Learn more via the OpenBenchmarking.org test page.

OpenBenchmarking.orgMicroseconds Per Op, Fewer Is BetterLevelDB 1.22Benchmark: Hot ReadDatabase Teste0.26120.52240.78361.04481.306SE +/- 0.008, N = 31.1611. (CXX) g++ options: -O3 -lsnappy -lpthread

OpenBenchmarking.orgMB/s, More Is BetterLevelDB 1.22Benchmark: Fill SyncDatabase Teste0.02250.0450.06750.090.1125SE +/- 0.00, N = 30.11. (CXX) g++ options: -O3 -lsnappy -lpthread

OpenBenchmarking.orgMicroseconds Per Op, Fewer Is BetterLevelDB 1.22Benchmark: Fill SyncDatabase Teste400800120016002000SE +/- 101.25, N = 31935.361. (CXX) g++ options: -O3 -lsnappy -lpthread

OpenBenchmarking.orgMB/s, More Is BetterLevelDB 1.22Benchmark: OverwriteDatabase Teste510152025SE +/- 0.18, N = 320.21. (CXX) g++ options: -O3 -lsnappy -lpthread

OpenBenchmarking.orgMicroseconds Per Op, Fewer Is BetterLevelDB 1.22Benchmark: OverwriteDatabase Teste3691215SE +/- 0.09, N = 310.811. (CXX) g++ options: -O3 -lsnappy -lpthread

OpenBenchmarking.orgMB/s, More Is BetterLevelDB 1.22Benchmark: Random FillDatabase Teste510152025SE +/- 0.15, N = 320.31. (CXX) g++ options: -O3 -lsnappy -lpthread

OpenBenchmarking.orgMicroseconds Per Op, Fewer Is BetterLevelDB 1.22Benchmark: Random FillDatabase Teste3691215SE +/- 0.08, N = 310.711. (CXX) g++ options: -O3 -lsnappy -lpthread

OpenBenchmarking.orgMicroseconds Per Op, Fewer Is BetterLevelDB 1.22Benchmark: Random ReadDatabase Teste0.27450.5490.82351.0981.3725SE +/- 0.012, N = 31.2201. (CXX) g++ options: -O3 -lsnappy -lpthread

OpenBenchmarking.orgMicroseconds Per Op, Fewer Is BetterLevelDB 1.22Benchmark: Seek RandomDatabase Teste0.38880.77761.16641.55521.944SE +/- 0.013, N = 151.7281. (CXX) g++ options: -O3 -lsnappy -lpthread

OpenBenchmarking.orgMicroseconds Per Op, Fewer Is BetterLevelDB 1.22Benchmark: Random DeleteDatabase Teste3691215SE +/- 0.14, N = 411.211. (CXX) g++ options: -O3 -lsnappy -lpthread

OpenBenchmarking.orgMB/s, More Is BetterLevelDB 1.22Benchmark: Sequential FillDatabase Teste510152025SE +/- 0.25, N = 321.01. (CXX) g++ options: -O3 -lsnappy -lpthread

OpenBenchmarking.orgMicroseconds Per Op, Fewer Is BetterLevelDB 1.22Benchmark: Sequential FillDatabase Teste3691215SE +/- 0.17, N = 310.451. (CXX) g++ options: -O3 -lsnappy -lpthread

SQLite

This is a simple benchmark of SQLite. At present this test profile just measures the time to perform a pre-defined number of insertions on an indexed database. Learn more via the OpenBenchmarking.org test page.

OpenBenchmarking.orgSeconds, Fewer Is BetterSQLite 3.30.1Threads / Copies: 1Database Teste510152025SE +/- 0.59, N = 1222.721. (CC) gcc options: -O2 -lz -lm -ldl -lpthread

Apache CouchDB

This is a bulk insertion benchmark of Apache CouchDB. CouchDB is a document-oriented NoSQL database implemented in Erlang. Learn more via the OpenBenchmarking.org test page.

OpenBenchmarking.orgSeconds, Fewer Is BetterApache CouchDB 3.2.1Bulk Size: 100 - Inserts: 1000 - Rounds: 24Database Teste4080120160200SE +/- 0.80, N = 3173.061. (CXX) g++ options: -flto -lstdc++ -shared -lei

KeyDB

A benchmark of KeyDB as a multi-threaded fork of the Redis server. The KeyDB benchmark is conducted using memtier-benchmark. Learn more via the OpenBenchmarking.org test page.

OpenBenchmarking.orgOps/sec, More Is BetterKeyDB 6.2.0Database Teste20K40K60K80K100KSE +/- 627.44, N = 393376.541. (CXX) g++ options: -O2 -levent_openssl -levent -lcrypto -lssl -lpthread -lz -lpcre

MariaDB

This is a MariaDB MySQL database server benchmark making use of mysqlslap. Learn more via the OpenBenchmarking.org test page.

Clients: 1

Database Teste: The test quit with a non-zero exit status. The test quit with a non-zero exit status. The test quit with a non-zero exit status.

Clients: 8

Database Teste: The test quit with a non-zero exit status. The test quit with a non-zero exit status. The test quit with a non-zero exit status.

Clients: 16

Database Teste: The test quit with a non-zero exit status. The test quit with a non-zero exit status. The test quit with a non-zero exit status.

Clients: 32

Database Teste: The test quit with a non-zero exit status. The test quit with a non-zero exit status. The test quit with a non-zero exit status.

Clients: 64

Database Teste: The test quit with a non-zero exit status. The test quit with a non-zero exit status. The test quit with a non-zero exit status.

Clients: 128

Database Teste: The test quit with a non-zero exit status. The test quit with a non-zero exit status. The test quit with a non-zero exit status.

Clients: 256

Database Teste: The test quit with a non-zero exit status. The test quit with a non-zero exit status. The test quit with a non-zero exit status.

Clients: 512

Database Teste: The test quit with a non-zero exit status. The test quit with a non-zero exit status. The test quit with a non-zero exit status.

Clients: 1024

Database Teste: The test quit with a non-zero exit status. The test quit with a non-zero exit status. The test quit with a non-zero exit status.

Clients: 2048

Database Teste: The test quit with a non-zero exit status. The test quit with a non-zero exit status. The test quit with a non-zero exit status.

Clients: 4096

Database Teste: The test quit with a non-zero exit status. The test quit with a non-zero exit status. The test quit with a non-zero exit status.

PostgreSQL pgbench

This is a benchmark of PostgreSQL using pgbench for facilitating the database benchmarks. Learn more via the OpenBenchmarking.org test page.

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 14.0Scaling Factor: 1 - Clients: 1 - Mode: Read OnlyDatabase Teste4K8K12K16K20KSE +/- 53.92, N = 3176081. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpthread -lrt -ldl -lm

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL pgbench 14.0Scaling Factor: 1 - Clients: 1 - Mode: Read Only - Average LatencyDatabase Teste0.01280.02560.03840.05120.064SE +/- 0.000, N = 30.0571. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpthread -lrt -ldl -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 14.0Scaling Factor: 1 - Clients: 1 - Mode: Read WriteDatabase Teste2004006008001000SE +/- 11.94, N = 39911. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpthread -lrt -ldl -lm

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL pgbench 14.0Scaling Factor: 1 - Clients: 1 - Mode: Read Write - Average LatencyDatabase Teste0.22730.45460.68190.90921.1365SE +/- 0.012, N = 31.0101. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpthread -lrt -ldl -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 14.0Scaling Factor: 1 - Clients: 50 - Mode: Read OnlyDatabase Teste7K14K21K28K35KSE +/- 313.65, N = 3338221. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpthread -lrt -ldl -lm

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL pgbench 14.0Scaling Factor: 1 - Clients: 50 - Mode: Read Only - Average LatencyDatabase Teste0.33260.66520.99781.33041.663SE +/- 0.014, N = 31.4781. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpthread -lrt -ldl -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 14.0Scaling Factor: 1 - Clients: 100 - Mode: Read OnlyDatabase Teste7K14K21K28K35KSE +/- 85.56, N = 3337391. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpthread -lrt -ldl -lm

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL pgbench 14.0Scaling Factor: 1 - Clients: 100 - Mode: Read Only - Average LatencyDatabase Teste0.66691.33382.00072.66763.3345SE +/- 0.008, N = 32.9641. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpthread -lrt -ldl -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 14.0Scaling Factor: 1 - Clients: 250 - Mode: Read OnlyDatabase Teste7K14K21K28K35KSE +/- 160.12, N = 3336561. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpthread -lrt -ldl -lm

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL pgbench 14.0Scaling Factor: 1 - Clients: 250 - Mode: Read Only - Average LatencyDatabase Teste246810SE +/- 0.035, N = 37.4291. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpthread -lrt -ldl -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 14.0Scaling Factor: 1 - Clients: 50 - Mode: Read WriteDatabase Teste2004006008001000SE +/- 2.30, N = 39681. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpthread -lrt -ldl -lm

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL pgbench 14.0Scaling Factor: 1 - Clients: 50 - Mode: Read Write - Average LatencyDatabase Teste1224364860SE +/- 0.12, N = 351.651. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpthread -lrt -ldl -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 14.0Scaling Factor: 1 - Clients: 500 - Mode: Read OnlyDatabase Teste7K14K21K28K35KSE +/- 135.56, N = 3328241. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpthread -lrt -ldl -lm

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL pgbench 14.0Scaling Factor: 1 - Clients: 500 - Mode: Read Only - Average LatencyDatabase Teste48121620SE +/- 0.06, N = 315.231. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpthread -lrt -ldl -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 14.0Scaling Factor: 100 - Clients: 1 - Mode: Read OnlyDatabase Teste12002400360048006000SE +/- 83.10, N = 1258271. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpthread -lrt -ldl -lm

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL pgbench 14.0Scaling Factor: 100 - Clients: 1 - Mode: Read Only - Average LatencyDatabase Teste0.03870.07740.11610.15480.1935SE +/- 0.003, N = 120.1721. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpthread -lrt -ldl -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 14.0Scaling Factor: 1 - Clients: 100 - Mode: Read WriteDatabase Teste2004006008001000SE +/- 0.86, N = 38651. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpthread -lrt -ldl -lm

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL pgbench 14.0Scaling Factor: 1 - Clients: 100 - Mode: Read Write - Average LatencyDatabase Teste306090120150SE +/- 0.11, N = 3115.561. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpthread -lrt -ldl -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 14.0Scaling Factor: 1 - Clients: 250 - Mode: Read WriteDatabase Teste110220330440550SE +/- 4.01, N = 35031. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpthread -lrt -ldl -lm

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL pgbench 14.0Scaling Factor: 1 - Clients: 250 - Mode: Read Write - Average LatencyDatabase Teste110220330440550SE +/- 3.99, N = 3497.351. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpthread -lrt -ldl -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 14.0Scaling Factor: 1 - Clients: 500 - Mode: Read WriteDatabase Teste50100150200250SE +/- 1.42, N = 32481. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpthread -lrt -ldl -lm

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL pgbench 14.0Scaling Factor: 1 - Clients: 500 - Mode: Read Write - Average LatencyDatabase Teste400800120016002000SE +/- 11.52, N = 32012.811. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpthread -lrt -ldl -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 14.0Scaling Factor: 100 - Clients: 1 - Mode: Read WriteDatabase Teste2004006008001000SE +/- 2.86, N = 37801. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpthread -lrt -ldl -lm

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL pgbench 14.0Scaling Factor: 100 - Clients: 1 - Mode: Read Write - Average LatencyDatabase Teste0.28820.57640.86461.15281.441SE +/- 0.005, N = 31.2811. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpthread -lrt -ldl -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 14.0Scaling Factor: 100 - Clients: 50 - Mode: Read OnlyDatabase Teste4K8K12K16K20KSE +/- 164.71, N = 12202611. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpthread -lrt -ldl -lm

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL pgbench 14.0Scaling Factor: 100 - Clients: 50 - Mode: Read Only - Average LatencyDatabase Teste0.55581.11161.66742.22322.779SE +/- 0.020, N = 122.4701. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpthread -lrt -ldl -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 14.0Scaling Factor: 1000 - Clients: 1 - Mode: Read OnlyDatabase Teste2004006008001000SE +/- 9.97, N = 710681. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpthread -lrt -ldl -lm

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL pgbench 14.0Scaling Factor: 1000 - Clients: 1 - Mode: Read Only - Average LatencyDatabase Teste0.21080.42160.63240.84321.054SE +/- 0.008, N = 70.9371. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpthread -lrt -ldl -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 14.0Scaling Factor: 100 - Clients: 100 - Mode: Read OnlyDatabase Teste4K8K12K16K20KSE +/- 185.73, N = 6184301. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpthread -lrt -ldl -lm

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL pgbench 14.0Scaling Factor: 100 - Clients: 100 - Mode: Read Only - Average LatencyDatabase Teste1.22152.4433.66454.8866.1075SE +/- 0.053, N = 65.4291. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpthread -lrt -ldl -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 14.0Scaling Factor: 100 - Clients: 250 - Mode: Read OnlyDatabase Teste3K6K9K12K15KSE +/- 20.45, N = 3127881. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpthread -lrt -ldl -lm

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL pgbench 14.0Scaling Factor: 100 - Clients: 250 - Mode: Read Only - Average LatencyDatabase Teste510152025SE +/- 0.03, N = 319.551. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpthread -lrt -ldl -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 14.0Scaling Factor: 100 - Clients: 50 - Mode: Read WriteDatabase Teste8001600240032004000SE +/- 35.22, N = 637821. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpthread -lrt -ldl -lm

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL pgbench 14.0Scaling Factor: 100 - Clients: 50 - Mode: Read Write - Average LatencyDatabase Teste3691215SE +/- 0.13, N = 613.231. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpthread -lrt -ldl -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 14.0Scaling Factor: 100 - Clients: 500 - Mode: Read OnlyDatabase Teste2K4K6K8K10KSE +/- 79.83, N = 388211. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpthread -lrt -ldl -lm

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL pgbench 14.0Scaling Factor: 100 - Clients: 500 - Mode: Read Only - Average LatencyDatabase Teste1326395265SE +/- 0.51, N = 356.691. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpthread -lrt -ldl -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 14.0Scaling Factor: 1000 - Clients: 1 - Mode: Read WriteDatabase Teste110220330440550SE +/- 2.04, N = 34931. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpthread -lrt -ldl -lm

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL pgbench 14.0Scaling Factor: 1000 - Clients: 1 - Mode: Read Write - Average LatencyDatabase Teste0.45680.91361.37041.82722.284SE +/- 0.008, N = 32.0301. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpthread -lrt -ldl -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 14.0Scaling Factor: 1000 - Clients: 50 - Mode: Read OnlyDatabase Teste3K6K9K12K15KSE +/- 180.50, N = 3133871. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpthread -lrt -ldl -lm

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL pgbench 14.0Scaling Factor: 1000 - Clients: 50 - Mode: Read Only - Average LatencyDatabase Teste0.84061.68122.52183.36244.203SE +/- 0.050, N = 33.7361. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpthread -lrt -ldl -lm

Scaling Factor: 10000 - Clients: 1 - Mode: Read Only

Database Teste: The test run did not produce a result. The test run did not produce a result. The test run did not produce a result. E: pgbench: error: client 0 aborted in command 0 (set) of script 0; evaluation of meta-command failed

Scaling Factor: 25000 - Clients: 1 - Mode: Read Only

Database Teste: The test run did not produce a result. The test run did not produce a result. The test run did not produce a result. E: pgbench: error: client 0 aborted in command 0 (set) of script 0; evaluation of meta-command failed

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 14.0Scaling Factor: 100 - Clients: 100 - Mode: Read WriteDatabase Teste8001600240032004000SE +/- 33.17, N = 635281. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpthread -lrt -ldl -lm

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL pgbench 14.0Scaling Factor: 100 - Clients: 100 - Mode: Read Write - Average LatencyDatabase Teste714212835SE +/- 0.27, N = 628.351. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpthread -lrt -ldl -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 14.0Scaling Factor: 100 - Clients: 250 - Mode: Read WriteDatabase Teste6001200180024003000SE +/- 27.84, N = 329061. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpthread -lrt -ldl -lm

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL pgbench 14.0Scaling Factor: 100 - Clients: 250 - Mode: Read Write - Average LatencyDatabase Teste20406080100SE +/- 0.83, N = 386.061. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpthread -lrt -ldl -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 14.0Scaling Factor: 100 - Clients: 500 - Mode: Read WriteDatabase Teste400800120016002000SE +/- 16.96, N = 320121. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpthread -lrt -ldl -lm

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL pgbench 14.0Scaling Factor: 100 - Clients: 500 - Mode: Read Write - Average LatencyDatabase Teste50100150200250SE +/- 2.11, N = 3248.601. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpthread -lrt -ldl -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 14.0Scaling Factor: 1000 - Clients: 100 - Mode: Read OnlyDatabase Teste3K6K9K12K15KSE +/- 118.91, N = 7127481. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpthread -lrt -ldl -lm

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL pgbench 14.0Scaling Factor: 1000 - Clients: 100 - Mode: Read Only - Average LatencyDatabase Teste246810SE +/- 0.075, N = 77.8491. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpthread -lrt -ldl -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 14.0Scaling Factor: 1000 - Clients: 250 - Mode: Read OnlyDatabase Teste2K4K6K8K10KSE +/- 94.70, N = 9110291. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpthread -lrt -ldl -lm

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL pgbench 14.0Scaling Factor: 1000 - Clients: 250 - Mode: Read Only - Average LatencyDatabase Teste510152025SE +/- 0.20, N = 922.681. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpthread -lrt -ldl -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 14.0Scaling Factor: 1000 - Clients: 50 - Mode: Read WriteDatabase Teste7001400210028003500SE +/- 23.03, N = 333141. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpthread -lrt -ldl -lm

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL pgbench 14.0Scaling Factor: 1000 - Clients: 50 - Mode: Read Write - Average LatencyDatabase Teste48121620SE +/- 0.11, N = 315.091. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpthread -lrt -ldl -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 14.0Scaling Factor: 1000 - Clients: 500 - Mode: Read OnlyDatabase Teste2K4K6K8K10KSE +/- 114.77, N = 383221. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpthread -lrt -ldl -lm

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL pgbench 14.0Scaling Factor: 1000 - Clients: 500 - Mode: Read Only - Average LatencyDatabase Teste1326395265SE +/- 0.84, N = 360.111. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpthread -lrt -ldl -lm

Scaling Factor: 10000 - Clients: 1 - Mode: Read Write

Database Teste: The test run did not produce a result. The test run did not produce a result. The test run did not produce a result. E: pgbench: error: client 0 aborted in command 0 (set) of script 0; evaluation of meta-command failed

Scaling Factor: 10000 - Clients: 50 - Mode: Read Only

Database Teste: The test run did not produce a result. The test run did not produce a result. The test run did not produce a result. E: pgbench: error: client 24 aborted in command 0 (set) of script 0; evaluation of meta-command failed

Scaling Factor: 25000 - Clients: 1 - Mode: Read Write

Database Teste: The test run did not produce a result. The test run did not produce a result. The test run did not produce a result. E: pgbench: error: client 0 aborted in command 0 (set) of script 0; evaluation of meta-command failed

Scaling Factor: 25000 - Clients: 50 - Mode: Read Only

Database Teste: The test run did not produce a result. The test run did not produce a result. The test run did not produce a result. E: pgbench: error: client 49 aborted in command 0 (set) of script 0; evaluation of meta-command failed

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 14.0Scaling Factor: 1000 - Clients: 100 - Mode: Read WriteDatabase Teste7001400210028003500SE +/- 38.88, N = 331741. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpthread -lrt -ldl -lm

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL pgbench 14.0Scaling Factor: 1000 - Clients: 100 - Mode: Read Write - Average LatencyDatabase Teste714212835SE +/- 0.39, N = 331.521. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpthread -lrt -ldl -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 14.0Scaling Factor: 1000 - Clients: 250 - Mode: Read WriteDatabase Teste6001200180024003000SE +/- 14.18, N = 327751. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpthread -lrt -ldl -lm

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL pgbench 14.0Scaling Factor: 1000 - Clients: 250 - Mode: Read Write - Average LatencyDatabase Teste20406080100SE +/- 0.46, N = 390.101. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpthread -lrt -ldl -lm

OpenBenchmarking.orgTPS, More Is BetterPostgreSQL pgbench 14.0Scaling Factor: 1000 - Clients: 500 - Mode: Read WriteDatabase Teste5001000150020002500SE +/- 24.44, N = 321381. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpthread -lrt -ldl -lm

OpenBenchmarking.orgms, Fewer Is BetterPostgreSQL pgbench 14.0Scaling Factor: 1000 - Clients: 500 - Mode: Read Write - Average LatencyDatabase Teste50100150200250SE +/- 2.65, N = 3233.901. (CC) gcc options: -fno-strict-aliasing -fwrapv -O2 -lpgcommon -lpgport -lpthread -lrt -ldl -lm

Scaling Factor: 10000 - Clients: 100 - Mode: Read Only

Database Teste: The test run did not produce a result. The test run did not produce a result. The test run did not produce a result. E: pgbench: error: client 99 aborted in command 0 (set) of script 0; evaluation of meta-command failed

Scaling Factor: 10000 - Clients: 250 - Mode: Read Only

Database Teste: The test run did not produce a result. The test run did not produce a result. The test run did not produce a result. E: pgbench: error: client 124 aborted in command 0 (set) of script 0; evaluation of meta-command failed

Scaling Factor: 10000 - Clients: 50 - Mode: Read Write

Database Teste: The test run did not produce a result. The test run did not produce a result. The test run did not produce a result. E: pgbench: error: client 49 aborted in command 0 (set) of script 0; evaluation of meta-command failed

Scaling Factor: 10000 - Clients: 500 - Mode: Read Only

Database Teste: The test run did not produce a result. The test run did not produce a result. The test run did not produce a result. E: pgbench: error: client 499 aborted in command 0 (set) of script 0; evaluation of meta-command failed

Scaling Factor: 25000 - Clients: 100 - Mode: Read Only

Database Teste: The test run did not produce a result. The test run did not produce a result. The test run did not produce a result. E: pgbench: error: client 49 aborted in command 0 (set) of script 0; evaluation of meta-command failed

Scaling Factor: 25000 - Clients: 250 - Mode: Read Only

Database Teste: The test run did not produce a result. The test run did not produce a result. The test run did not produce a result. E: pgbench: error: client 249 aborted in command 0 (set) of script 0; evaluation of meta-command failed

Scaling Factor: 25000 - Clients: 50 - Mode: Read Write

Database Teste: The test run did not produce a result. The test run did not produce a result. The test run did not produce a result. E: pgbench: error: client 24 aborted in command 0 (set) of script 0; evaluation of meta-command failed

Scaling Factor: 25000 - Clients: 500 - Mode: Read Only

Database Teste: The test run did not produce a result. The test run did not produce a result. The test run did not produce a result. E: pgbench: error: client 499 aborted in command 0 (set) of script 0; evaluation of meta-command failed

Scaling Factor: 10000 - Clients: 100 - Mode: Read Write

Database Teste: The test run did not produce a result. The test run did not produce a result. The test run did not produce a result. E: pgbench: error: client 49 aborted in command 0 (set) of script 0; evaluation of meta-command failed

Scaling Factor: 10000 - Clients: 250 - Mode: Read Write

Database Teste: The test run did not produce a result. The test run did not produce a result. The test run did not produce a result. E: pgbench: error: client 124 aborted in command 0 (set) of script 0; evaluation of meta-command failed

Scaling Factor: 10000 - Clients: 500 - Mode: Read Write

Database Teste: The test run did not produce a result. The test run did not produce a result. The test run did not produce a result. E: pgbench: error: client 499 aborted in command 0 (set) of script 0; evaluation of meta-command failed

Scaling Factor: 25000 - Clients: 100 - Mode: Read Write

Database Teste: The test run did not produce a result. The test run did not produce a result. The test run did not produce a result. E: pgbench: error: client 49 aborted in command 0 (set) of script 0; evaluation of meta-command failed

Scaling Factor: 25000 - Clients: 250 - Mode: Read Write

Database Teste: The test run did not produce a result. The test run did not produce a result. The test run did not produce a result. E: pgbench: error: client 124 aborted in command 0 (set) of script 0; evaluation of meta-command failed

Scaling Factor: 25000 - Clients: 500 - Mode: Read Write

Database Teste: The test run did not produce a result. The test run did not produce a result. The test run did not produce a result. E: pgbench: error: client 499 aborted in command 0 (set) of script 0; evaluation of meta-command failed

SQLite Speedtest

This is a benchmark of SQLite's speedtest1 benchmark program with an increased problem size of 1,000. Learn more via the OpenBenchmarking.org test page.

OpenBenchmarking.orgSeconds, Fewer Is BetterSQLite Speedtest 3.30Timed Time - Size 1,000Database Teste20406080100SE +/- 0.22, N = 3107.291. (CC) gcc options: -O2 -ldl -lz -lpthread

Memtier_benchmark

Memtier_benchmark is a NoSQL Redis/Memcache traffic generation plus benchmarking tool. This current test profile currently just stresses the Redis protocol and basic options exposed wotj a 1:1 Set/Get ratio, 30 pipeline, 100 clients per thread, and thread count equal to the number of CPU cores/threads present. Patches to extend the test are welcome as always. Currently this test profile uses Memtier_benchmark 1.3 and Redis 6. Learn more via the OpenBenchmarking.org test page.

OpenBenchmarking.orgOps/sec, More Is BetterMemtier_benchmark 1.3Protocol: RedisDatabase Teste200K400K600K800K1000KSE +/- 4799.96, N = 3979636.051. (CXX) g++ options: -O2 -levent_openssl -levent -lcrypto -lssl -lpthread -lz -lpcre

Redis

Redis is an open-source in-memory data structure store, used as a database, cache, and message broker. Learn more via the OpenBenchmarking.org test page.

OpenBenchmarking.orgRequests Per Second, More Is BetterRedis 6.0.9Test: LPOPDatabase Teste400K800K1200K1600K2000KSE +/- 6520.55, N = 31849734.331. (CXX) g++ options: -MM -MT -g3 -fvisibility=hidden -O3

OpenBenchmarking.orgRequests Per Second, More Is BetterRedis 6.0.9Test: SADDDatabase Teste300K600K900K1200K1500KSE +/- 12443.57, N = 31473874.711. (CXX) g++ options: -MM -MT -g3 -fvisibility=hidden -O3

OpenBenchmarking.orgRequests Per Second, More Is BetterRedis 6.0.9Test: LPUSHDatabase Teste300K600K900K1200K1500KSE +/- 5143.34, N = 31173689.871. (CXX) g++ options: -MM -MT -g3 -fvisibility=hidden -O3

OpenBenchmarking.orgRequests Per Second, More Is BetterRedis 6.0.9Test: GETDatabase Teste400K800K1200K1600K2000KSE +/- 20493.05, N = 31774285.591. (CXX) g++ options: -MM -MT -g3 -fvisibility=hidden -O3

OpenBenchmarking.orgRequests Per Second, More Is BetterRedis 6.0.9Test: SETDatabase Teste300K600K900K1200K1500KSE +/- 14891.66, N = 31326663.581. (CXX) g++ options: -MM -MT -g3 -fvisibility=hidden -O3

Apache Cassandra

This is a benchmark of the Apache Cassandra NoSQL database management system making use of cassandra-stress. Learn more via the OpenBenchmarking.org test page.

Test: Reads

Database Teste: The test run did not produce a result. The test run did not produce a result. The test run did not produce a result.

OpenBenchmarking.orgOp/s, More Is BetterApache Cassandra 4.0Test: WritesDatabase Teste16003200480064008000SE +/- 84.25, N = 47677

Test: Mixed 1:1

Database Teste: The test run did not produce a result. The test run did not produce a result. The test run did not produce a result.

Test: Mixed 1:3

Database Teste: The test run did not produce a result. The test run did not produce a result. The test run did not produce a result.

Facebook RocksDB

This is a benchmark of Facebook's RocksDB as an embeddable persistent key-value store for fast storage based on Google's LevelDB. Learn more via the OpenBenchmarking.org test page.

OpenBenchmarking.orgOp/s, More Is BetterFacebook RocksDB 7.0.1Test: Random FillDatabase Teste50K100K150K200K250KSE +/- 2127.86, N = 32121281. (CXX) g++ options: -O3 -march=native -pthread -fno-builtin-memcmp -fno-rtti -lpthread

OpenBenchmarking.orgOp/s, More Is BetterFacebook RocksDB 7.0.1Test: Random ReadDatabase Teste2M4M6M8M10MSE +/- 23754.91, N = 378449771. (CXX) g++ options: -O3 -march=native -pthread -fno-builtin-memcmp -fno-rtti -lpthread

OpenBenchmarking.orgOp/s, More Is BetterFacebook RocksDB 7.0.1Test: Update RandomDatabase Teste20K40K60K80K100KSE +/- 916.93, N = 31085301. (CXX) g++ options: -O3 -march=native -pthread -fno-builtin-memcmp -fno-rtti -lpthread

OpenBenchmarking.orgOp/s, More Is BetterFacebook RocksDB 7.0.1Test: Sequential FillDatabase Teste50K100K150K200K250KSE +/- 771.09, N = 32275371. (CXX) g++ options: -O3 -march=native -pthread -fno-builtin-memcmp -fno-rtti -lpthread

OpenBenchmarking.orgOp/s, More Is BetterFacebook RocksDB 7.0.1Test: Random Fill SyncDatabase Teste2004006008001000SE +/- 4.04, N = 310631. (CXX) g++ options: -O3 -march=native -pthread -fno-builtin-memcmp -fno-rtti -lpthread

OpenBenchmarking.orgOp/s, More Is BetterFacebook RocksDB 7.0.1Test: Read While WritingDatabase Teste40K80K120K160K200KSE +/- 1400.06, N = 31819881. (CXX) g++ options: -O3 -march=native -pthread -fno-builtin-memcmp -fno-rtti -lpthread

OpenBenchmarking.orgOp/s, More Is BetterFacebook RocksDB 7.0.1Test: Read Random Write RandomDatabase Teste60K120K180K240K300KSE +/- 2247.99, N = 152868921. (CXX) g++ options: -O3 -march=native -pthread -fno-builtin-memcmp -fno-rtti -lpthread

Apache HBase

This is a benchmark of the Apache HBase non-relational distributed database system inspired from Google's Bigtable. Learn more via the OpenBenchmarking.org test page.

OpenBenchmarking.orgRows Per Second, More Is BetterApache HBase 2.2.3Test: Increment - Clients: 1Database Teste11002200330044005500SE +/- 43.18, N = 124970

OpenBenchmarking.orgMicroseconds - Average Latency, Fewer Is BetterApache HBase 2.2.3Test: Increment - Clients: 1Database Teste4080120160200SE +/- 1.79, N = 12200

OpenBenchmarking.orgRows Per Second, More Is BetterApache HBase 2.2.3Test: Increment - Clients: 4Database Teste13002600390052006500SE +/- 75.84, N = 36156

OpenBenchmarking.orgMicroseconds - Average Latency, Fewer Is BetterApache HBase 2.2.3Test: Increment - Clients: 4Database Teste140280420560700SE +/- 7.84, N = 3647

Test: Increment - Clients: 16

Database Teste: The test run did not produce a result. The test run did not produce a result. The test run did not produce a result.

Test: Increment - Clients: 32

Database Teste: The test run did not produce a result. The test run did not produce a result. The test run did not produce a result.

Test: Increment - Clients: 64

Database Teste: The test run did not produce a result. The test run did not produce a result. The test run did not produce a result.

Test: Increment - Clients: 128

Database Teste: The test run did not produce a result. The test run did not produce a result. The test run did not produce a result.

Test: Increment - Clients: 256

Database Teste: The test run did not produce a result. The test run did not produce a result. The test run did not produce a result.

OpenBenchmarking.orgRows Per Second, More Is BetterApache HBase 2.2.3Test: Random Read - Clients: 1Database Teste13002600390052006500SE +/- 61.94, N = 156259

OpenBenchmarking.orgMicroseconds - Average Latency, Fewer Is BetterApache HBase 2.2.3Test: Random Read - Clients: 1Database Teste306090120150SE +/- 1.53, N = 15158

OpenBenchmarking.orgRows Per Second, More Is BetterApache HBase 2.2.3Test: Random Read - Clients: 4Database Teste3K6K9K12K15KSE +/- 155.82, N = 1512704

OpenBenchmarking.orgMicroseconds - Average Latency, Fewer Is BetterApache HBase 2.2.3Test: Random Read - Clients: 4Database Teste70140210280350SE +/- 4.11, N = 15313

Test: Random Read - Clients: 16

Database Teste: The test run did not produce a result. The test run did not produce a result. The test run did not produce a result.

Test: Random Read - Clients: 32

Database Teste: The test run did not produce a result. The test run did not produce a result. The test run did not produce a result.

Test: Random Read - Clients: 64

Database Teste: The test run did not produce a result. The test run did not produce a result. The test run did not produce a result.

OpenBenchmarking.orgRows Per Second, More Is BetterApache HBase 2.2.3Test: Random Write - Clients: 1Database Teste8K16K24K32K40KSE +/- 965.77, N = 1538999

OpenBenchmarking.orgMicroseconds - Average Latency, Fewer Is BetterApache HBase 2.2.3Test: Random Write - Clients: 1Database Teste612182430SE +/- 0.80, N = 1525

OpenBenchmarking.orgRows Per Second, More Is BetterApache HBase 2.2.3Test: Random Write - Clients: 4Database Teste11K22K33K44K55KSE +/- 1511.07, N = 1549845

OpenBenchmarking.orgMicroseconds - Average Latency, Fewer Is BetterApache HBase 2.2.3Test: Random Write - Clients: 4Database Teste20406080100SE +/- 2.55, N = 1580

Test: Random Read - Clients: 128

Database Teste: The test run did not produce a result. The test run did not produce a result. The test run did not produce a result.

Test: Random Read - Clients: 256

Database Teste: The test run did not produce a result. The test run did not produce a result. The test run did not produce a result.

Test: Random Write - Clients: 16

Database Teste: The test run did not produce a result. The test run did not produce a result. The test run did not produce a result.

Test: Random Write - Clients: 32

Database Teste: The test run did not produce a result. The test run did not produce a result. The test run did not produce a result.

Test: Random Write - Clients: 64

Database Teste: The test run did not produce a result. The test run did not produce a result. The test run did not produce a result.

Test: Random Write - Clients: 128

Database Teste: The test run did not produce a result. The test run did not produce a result. The test run did not produce a result.

Test: Random Write - Clients: 256

Database Teste: The test run did not produce a result. The test run did not produce a result. The test run did not produce a result.

OpenBenchmarking.orgRows Per Second, More Is BetterApache HBase 2.2.3Test: Sequential Read - Clients: 1Database Teste2K4K6K8K10KSE +/- 188.94, N = 157893

OpenBenchmarking.orgMicroseconds - Average Latency, Fewer Is BetterApache HBase 2.2.3Test: Sequential Read - Clients: 1Database Teste306090120150SE +/- 3.88, N = 15126

OpenBenchmarking.orgRows Per Second, More Is BetterApache HBase 2.2.3Test: Sequential Read - Clients: 4Database Teste3K6K9K12K15KSE +/- 190.14, N = 1512064

OpenBenchmarking.orgMicroseconds - Average Latency, Fewer Is BetterApache HBase 2.2.3Test: Sequential Read - Clients: 4Database Teste70140210280350SE +/- 5.64, N = 15331

Test: Sequential Read - Clients: 16

Database Teste: The test run did not produce a result. The test run did not produce a result. The test run did not produce a result.

Test: Sequential Read - Clients: 32

Database Teste: The test run did not produce a result. The test run did not produce a result. The test run did not produce a result.

Test: Sequential Read - Clients: 64

Database Teste: The test run did not produce a result. The test run did not produce a result. The test run did not produce a result.

OpenBenchmarking.orgRows Per Second, More Is BetterApache HBase 2.2.3Test: Sequential Write - Clients: 1Database Teste9K18K27K36K45KSE +/- 999.07, N = 1540202

OpenBenchmarking.orgMicroseconds - Average Latency, Fewer Is BetterApache HBase 2.2.3Test: Sequential Write - Clients: 1Database Teste612182430SE +/- 0.76, N = 1524

OpenBenchmarking.orgRows Per Second, More Is BetterApache HBase 2.2.3Test: Sequential Write - Clients: 4Database Teste12K24K36K48K60KSE +/- 1644.41, N = 1555810

OpenBenchmarking.orgMicroseconds - Average Latency, Fewer Is BetterApache HBase 2.2.3Test: Sequential Write - Clients: 4Database Teste1632486480SE +/- 2.25, N = 1571

OpenBenchmarking.orgRows Per Second, More Is BetterApache HBase 2.2.3Test: Async Random Read - Clients: 1Database Teste14002800420056007000SE +/- 130.94, N = 156363

OpenBenchmarking.orgMicroseconds - Average Latency, Fewer Is BetterApache HBase 2.2.3Test: Async Random Read - Clients: 1Database Teste306090120150SE +/- 3.80, N = 15156

OpenBenchmarking.orgRows Per Second, More Is BetterApache HBase 2.2.3Test: Async Random Read - Clients: 4Database Teste12002400360048006000SE +/- 63.79, N = 125731

OpenBenchmarking.orgMicroseconds - Average Latency, Fewer Is BetterApache HBase 2.2.3Test: Async Random Read - Clients: 4Database Teste150300450600750SE +/- 8.48, N = 12696

Test: Sequential Read - Clients: 128

Database Teste: The test run did not produce a result. The test run did not produce a result. The test run did not produce a result.

Test: Sequential Read - Clients: 256

Database Teste: The test run did not produce a result. The test run did not produce a result. The test run did not produce a result.

Test: Sequential Write - Clients: 16

Database Teste: The test run did not produce a result. The test run did not produce a result. The test run did not produce a result.

Test: Sequential Write - Clients: 32

Database Teste: The test run did not produce a result. The test run did not produce a result. The test run did not produce a result.

Test: Sequential Write - Clients: 64

Database Teste: The test run did not produce a result. The test run did not produce a result. The test run did not produce a result.

Test: Async Random Read - Clients: 16

Database Teste: The test run did not produce a result. The test run did not produce a result. The test run did not produce a result.

Test: Async Random Read - Clients: 32

Database Teste: The test run did not produce a result. The test run did not produce a result. The test run did not produce a result.

Test: Async Random Read - Clients: 64

Database Teste: The test run did not produce a result. The test run did not produce a result. The test run did not produce a result.

Test: Async Random Write - Clients: 1

Database Teste: The test run did not produce a result. The test run did not produce a result. The test run did not produce a result.

OpenBenchmarking.orgRows Per Second, More Is BetterApache HBase 2.2.3Test: Async Random Write - Clients: 4Database Teste10002000300040005000SE +/- 50.35, N = 44669

OpenBenchmarking.orgMicroseconds - Average Latency, Fewer Is BetterApache HBase 2.2.3Test: Async Random Write - Clients: 4Database Teste2004006008001000SE +/- 9.32, N = 4854

Test: Sequential Write - Clients: 128

Database Teste: The test run did not produce a result. The test run did not produce a result. The test run did not produce a result.

Test: Sequential Write - Clients: 256

Database Teste: The test run did not produce a result. The test run did not produce a result. The test run did not produce a result.

Test: Async Random Read - Clients: 128

Database Teste: The test run did not produce a result. The test run did not produce a result. The test run did not produce a result.

Test: Async Random Read - Clients: 256

Database Teste: The test run did not produce a result. The test run did not produce a result. The test run did not produce a result.

Test: Async Random Write - Clients: 16

Database Teste: The test run did not produce a result. The test run did not produce a result. The test run did not produce a result.

Test: Async Random Write - Clients: 32

Database Teste: The test run did not produce a result. The test run did not produce a result. The test run did not produce a result.

Test: Async Random Write - Clients: 64

Database Teste: The test run did not produce a result. The test run did not produce a result. The test run did not produce a result.

Test: Async Random Write - Clients: 128

Database Teste: The test run did not produce a result. The test run did not produce a result. The test run did not produce a result.

Test: Async Random Write - Clients: 256

Database Teste: The test run did not produce a result. The test run did not produce a result. The test run did not produce a result.

InfluxDB

This is a benchmark of the InfluxDB open-source time-series database optimized for fast, high-availability storage for IoT and other use-cases. The InfluxDB test profile makes use of InfluxDB Inch for facilitating the benchmarks. Learn more via the OpenBenchmarking.org test page.

OpenBenchmarking.orgval/sec, More Is BetterInfluxDB 1.8.2Concurrent Streams: 4 - Batch Size: 10000 - Tags: 2,5000,1 - Points Per Series: 10000Database Teste70K140K210K280K350KSE +/- 827.86, N = 3316349.6

OpenBenchmarking.orgval/sec, More Is BetterInfluxDB 1.8.2Concurrent Streams: 64 - Batch Size: 10000 - Tags: 2,5000,1 - Points Per Series: 10000Database Teste60K120K180K240K300KSE +/- 21085.03, N = 9284301.5

OpenBenchmarking.orgval/sec, More Is BetterInfluxDB 1.8.2Concurrent Streams: 1024 - Batch Size: 10000 - Tags: 2,5000,1 - Points Per Series: 10000Database Teste6001200180024003000SE +/- 573.98, N = 123025.6

119 Results Shown

LevelDB:
  Hot Read
  Fill Sync
  Fill Sync
  Overwrite
  Overwrite
  Rand Fill
  Rand Fill
  Rand Read
  Seek Rand
  Rand Delete
  Seq Fill
  Seq Fill
SQLite
Apache CouchDB
KeyDB
PostgreSQL pgbench:
  1 - 1 - Read Only
  1 - 1 - Read Only - Average Latency
  1 - 1 - Read Write
  1 - 1 - Read Write - Average Latency
  1 - 50 - Read Only
  1 - 50 - Read Only - Average Latency
  1 - 100 - Read Only
  1 - 100 - Read Only - Average Latency
  1 - 250 - Read Only
  1 - 250 - Read Only - Average Latency
  1 - 50 - Read Write
  1 - 50 - Read Write - Average Latency
  1 - 500 - Read Only
  1 - 500 - Read Only - Average Latency
  100 - 1 - Read Only
  100 - 1 - Read Only - Average Latency
  1 - 100 - Read Write
  1 - 100 - Read Write - Average Latency
  1 - 250 - Read Write
  1 - 250 - Read Write - Average Latency
  1 - 500 - Read Write
  1 - 500 - Read Write - Average Latency
  100 - 1 - Read Write
  100 - 1 - Read Write - Average Latency
  100 - 50 - Read Only
  100 - 50 - Read Only - Average Latency
  1000 - 1 - Read Only
  1000 - 1 - Read Only - Average Latency
  100 - 100 - Read Only
  100 - 100 - Read Only - Average Latency
  100 - 250 - Read Only
  100 - 250 - Read Only - Average Latency
  100 - 50 - Read Write
  100 - 50 - Read Write - Average Latency
  100 - 500 - Read Only
  100 - 500 - Read Only - Average Latency
  1000 - 1 - Read Write
  1000 - 1 - Read Write - Average Latency
  1000 - 50 - Read Only
  1000 - 50 - Read Only - Average Latency
  100 - 100 - Read Write
  100 - 100 - Read Write - Average Latency
  100 - 250 - Read Write
  100 - 250 - Read Write - Average Latency
  100 - 500 - Read Write
  100 - 500 - Read Write - Average Latency
  1000 - 100 - Read Only
  1000 - 100 - Read Only - Average Latency
  1000 - 250 - Read Only
  1000 - 250 - Read Only - Average Latency
  1000 - 50 - Read Write
  1000 - 50 - Read Write - Average Latency
  1000 - 500 - Read Only
  1000 - 500 - Read Only - Average Latency
  1000 - 100 - Read Write
  1000 - 100 - Read Write - Average Latency
  1000 - 250 - Read Write
  1000 - 250 - Read Write - Average Latency
  1000 - 500 - Read Write
  1000 - 500 - Read Write - Average Latency
SQLite Speedtest
Memtier_benchmark
Redis:
  LPOP
  SADD
  LPUSH
  GET
  SET
Apache Cassandra
Facebook RocksDB:
  Rand Fill
  Rand Read
  Update Rand
  Seq Fill
  Rand Fill Sync
  Read While Writing
  Read Rand Write Rand
Apache HBase:
  Increment - 1:
    Rows Per Second
    Microseconds - Average Latency
  Increment - 4:
    Rows Per Second
    Microseconds - Average Latency
  Rand Read - 1:
    Rows Per Second
    Microseconds - Average Latency
  Rand Read - 4:
    Rows Per Second
    Microseconds - Average Latency
  Rand Write - 1:
    Rows Per Second
    Microseconds - Average Latency
  Rand Write - 4:
    Rows Per Second
    Microseconds - Average Latency
  Seq Read - 1:
    Rows Per Second
    Microseconds - Average Latency
  Seq Read - 4:
    Rows Per Second
    Microseconds - Average Latency
  Seq Write - 1:
    Rows Per Second
    Microseconds - Average Latency
  Seq Write - 4:
    Rows Per Second
    Microseconds - Average Latency
  Async Rand Read - 1:
    Rows Per Second
    Microseconds - Average Latency
  Async Rand Read - 4:
    Rows Per Second
    Microseconds - Average Latency
  Async Rand Write - 4:
    Rows Per Second
    Microseconds - Average Latency
InfluxDB:
  4 - 10000 - 2,5000,1 - 10000
  64 - 10000 - 2,5000,1 - 10000
  1024 - 10000 - 2,5000,1 - 10000