sqlite_8

lxc testing on Ubuntu 20.10 via the Phoronix Test Suite.

HTML result view exported from: https://openbenchmarking.org/result/2102213-HA-2102201HA10&sor.

sqlite_8ProcessorMotherboardMemoryDiskChipsetAudioOSKernelCompilerFile-SystemSystem LayerDisplay Serverhermioneginnyspeedypixel-slateARMv8 Cortex-A72 @ 1.80GHz (4 Cores)BCM2835 Raspberry Pi 4 Model B Rev 1.48GB500GB Portable SSD T5Ubuntu 20.105.8.0-1015-raspi (aarch64)GCC 10.2.0btrfslxcext4ARMv7 Cortex-A72 @ 1.80GHz (4 Cores)BCM2711 Raspberry Pi 4 Model B Rev 1.24096MB16GB SL16GRaspbian 105.10.11-v7l+ (armv7l)X Server 1.20.4GCC 8.3.006/8e (4 Cores)ChromiumOS crosvmIntel 440FX 82441FX PMC8GB29GBIntel 82801AA AC 97 AudioUbuntu 20.105.4.87-12019-gb0caca41e2f4 (x86_64)GCC 10.2.0btrfslxcOpenBenchmarking.orgKernel Details- hermione: snd_bcm2835.enable_compat_alsa=0 snd_bcm2835.enable_hdmi=1 snd_bcm2835.enable_headphones=1- ginny: snd_bcm2835.enable_compat_alsa=0 snd_bcm2835.enable_hdmi=1 snd_bcm2835.enable_headphones=1- speedy: snd_bcm2835.enable_compat_alsa=0 snd_bcm2835.enable_hdmi=1- pixel-slate: Transparent Huge Pages: madviseCompiler Details- hermione: --build=aarch64-linux-gnu --disable-libquadmath --disable-libquadmath-support --disable-werror --enable-checking=release --enable-clocale=gnu --enable-default-pie --enable-fix-cortex-a53-843419 --enable-gnu-unique-object --enable-languages=c,ada,c++,go,d,fortran,objc,obj-c++,m2 --enable-libphobos-checking=release --enable-libstdcxx-debug --enable-libstdcxx-time=yes --enable-multiarch --enable-nls --enable-objc-gc=auto --enable-plugin --enable-shared --enable-threads=posix --host=aarch64-linux-gnu --program-prefix=aarch64-linux-gnu- --target=aarch64-linux-gnu --with-default-libstdcxx-abi=new --with-gcc-major-version-only --with-target-system-zlib=auto -v - ginny: --build=aarch64-linux-gnu --disable-libquadmath --disable-libquadmath-support --disable-werror --enable-checking=release --enable-clocale=gnu --enable-default-pie --enable-fix-cortex-a53-843419 --enable-gnu-unique-object --enable-languages=c,ada,c++,go,d,fortran,objc,obj-c++,m2 --enable-libphobos-checking=release --enable-libstdcxx-debug --enable-libstdcxx-time=yes --enable-multiarch --enable-nls --enable-objc-gc=auto --enable-plugin --enable-shared --enable-threads=posix --host=aarch64-linux-gnu --program-prefix=aarch64-linux-gnu- --target=aarch64-linux-gnu --with-default-libstdcxx-abi=new --with-gcc-major-version-only --with-target-system-zlib=auto -v - speedy: --build=arm-linux-gnueabihf --disable-libitm --disable-libquadmath --disable-libquadmath-support --disable-sjlj-exceptions --disable-werror --enable-bootstrap --enable-checking=release --enable-clocale=gnu --enable-gnu-unique-object --enable-languages=c,ada,c++,go,d,fortran,objc,obj-c++ --enable-libstdcxx-debug --enable-libstdcxx-time=yes --enable-multiarch --enable-nls --enable-objc-gc=auto --enable-plugin --enable-shared --enable-threads=posix --host=arm-linux-gnueabihf --program-prefix=arm-linux-gnueabihf- --target=arm-linux-gnueabihf --with-arch=armv6 --with-default-libstdcxx-abi=new --with-float=hard --with-fpu=vfp --with-gcc-major-version-only --with-target-system-zlib -v - pixel-slate: --build=x86_64-linux-gnu --disable-vtable-verify --disable-werror --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-multiarch --enable-multilib --enable-nls --enable-objc-gc=auto --enable-offload-targets=nvptx-none=/build/gcc-10-JvwpWM/gcc-10-10.2.0/debian/tmp-nvptx/usr,amdgcn-amdhsa=/build/gcc-10-JvwpWM/gcc-10-10.2.0/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-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 Disk Details- hermione: MQ-DEADLINE / relatime,rw,space_cache,ssd,subvol=/containers/hermione,subvolid=289,user_subvol_rm_allowed / Block Size: 4096- ginny: MQ-DEADLINE / discard,relatime,rw,stripe=16 / Block Size: 4096- pixel-slate: MQ-DEADLINE / discard,relatime,rw,space_cache,subvol=/lxd/storage-pools/default/containers/ubuntu,subvolid=275,user_subvol_rm_allowed / Block Size: 4096Processor Details- hermione: Scaling Governor: cpufreq-dt ondemand- ginny: Scaling Governor: cpufreq-dt ondemand- speedy: Scaling Governor: cpufreq-dt ondemand- pixel-slate: CPU Microcode: 0x1Security Details- hermione: itlb_multihit: Not affected + l1tf: Not affected + mds: Not affected + meltdown: Not affected + spec_store_bypass: Vulnerable + spectre_v1: Mitigation of __user pointer sanitization + spectre_v2: Vulnerable + srbds: Not affected + tsx_async_abort: Not affected - ginny: itlb_multihit: Not affected + l1tf: Not affected + mds: Not affected + meltdown: Not affected + spec_store_bypass: Vulnerable + spectre_v1: Mitigation of __user pointer sanitization + spectre_v2: Vulnerable + srbds: Not affected + tsx_async_abort: Not affected - pixel-slate: itlb_multihit: KVM: Vulnerable + l1tf: Mitigation of PTE Inversion + mds: Mitigation of Clear buffers; 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 Full generic retpoline IBPB: conditional IBRS_FW STIBP: disabled RSB filling + srbds: Unknown: Dependent on hypervisor status + tsx_async_abort: Not affected Disk Mount Options Details- speedy: noatime,rwDisk Details Details- speedy: Block Size: 4096

sqlite_8sqlite: 8DifferenceStandard ErrorStandard Deviationhermioneginnyspeedypixel-slate159.9301.84x0.310.33%126.6741.88x1.322.33%1031.0621.00x22.615.80%568.1451.45x3.311.01%OpenBenchmarking.org

SQLite

Threads / Copies: 8

OpenBenchmarking.orgSeconds, Fewer Is BetterSQLite 3.30.1Threads / Copies: 8ginnyhermionepixel-slatespeedy2004006008001000SE +/- 1.32, N = 5SE +/- 0.31, N = 3SE +/- 3.31, N = 3SE +/- 22.61, N = 7126.67159.93568.151031.06-lz1. (CC) gcc options: -O2 -lm -ldl -lpthread


Phoronix Test Suite v10.8.4