sqlite+aio stress

Intel Core i7-3770 testing with a Dell 0YJPT1 and Zotac NVIDIA GeForce GT 610 1024MB on Ubuntu 16.04 via the Phoronix Test Suite.

HTML result view exported from: https://openbenchmarking.org/result/1610124-LO-SQLITEAIO85.

sqlite+aio stressProcessorMotherboardChipsetMemoryDiskGraphicsAudioNetworkOSKernelDesktopDisplay ServerDisplay DriverOpenGLCompilerFile-SystemScreen ResolutionOld SSDNew SSDIntel Core i7-3770 @ 3.90GHz (8 Cores)Dell 0YJPT1Intel Xeon E3-1200 v2/3rd8192MB60GB ADATA SSD S510 6 + 500GB Seagate ST500DM002-1BD14Zotac NVIDIA GeForce GT 610 1024MB (810/666MHz)Realtek ALC887-VDRealtek RTL8111/8168/8411 + Qualcomm Atheros AR9485 WirelessUbuntu 16.044.4.0-42-generic (x86_64)Unity 7.4.0X Server 1.18.4NVIDIA 361.424.5.0GCC 5.4.0 20160609ext43360x105016384MB128GB KINGSTON SKC400S + 500GB Seagate ST500DM002-1BD14OpenBenchmarking.orgCompiler Details- --build=x86_64-linux-gnu --disable-browser-plugin --disable-vtable-verify --disable-werror --enable-checking=release --enable-clocale=gnu --enable-gnu-unique-object --enable-gtk-cairo --enable-java-awt=gtk --enable-java-home --enable-languages=c,ada,c++,java,go,d,fortran,objc,obj-c++ --enable-libmpx --enable-libstdcxx-debug --enable-libstdcxx-time=yes --enable-multiarch --enable-multilib --enable-nls --enable-objc-gc --enable-plugin --enable-shared --enable-threads=posix --host=x86_64-linux-gnu --target=x86_64-linux-gnu --with-abi=m64 --with-arch-32=i686 --with-arch-directory=amd64 --with-default-libstdcxx-abi=new --with-multilib-list=m32,m64,mx32 --with-tune=generic -v Disk Details- DEADLINE / relatime,rwProcessor Details- Scaling Governor: intel_pstate powersave

sqlite+aio stressaio-stress: Rand Writesqlite: Default Test DirectoryOld SSDNew SSD745.7414.183086.8157.69OpenBenchmarking.org

AIO-Stress

Test: Random Write

OpenBenchmarking.orgMB/s, More Is BetterAIO-Stress 0.21Test: Random WriteOld SSDNew SSD7001400210028003500SE +/- 7.74, N = 3SE +/- 46.11, N = 5745.743086.811. (CC) gcc options: -pthread -laio

SQLite

Test Target: Default Test Directory

OpenBenchmarking.orgSeconds, Fewer Is BetterSQLite 3.8.10.2Test Target: Default Test DirectoryOld SSDNew SSD1326395265SE +/- 0.04, N = 3SE +/- 0.21, N = 314.1857.691. (CC) gcc options: -O2 -ldl -lpthread

Phoronix Test Suite v10.8.4