sqlite zfs pool2 with zil and lz4

sqlite zfs pool2 with zil and lz4 no cache

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

Statistics

Remove Outliers Before Calculating Averages

Graph Settings

Prefer Vertical Bar Graphs

Table

Show Detailed System Result Table

Run Management

Result
Identifier
Performance Per
Dollar
Date
Run
  Test
  Duration
sqlite zfs pool2 with zil and lz4
September 02 2016
 

sqlite zfs pool2 with zil and lz4

Processor: AMD FX-8350 Eight-Core @ 4.00GHz (8 Cores), Motherboard: ASUS M5A97 LE R2.0, Chipset: AMD RD890 bridge, Memory: 4 x 8192 MB DDR3-1333MHz, Disk: 3 x 2000GB Western Digital WD20EFRX-68E + 2 x 500GB Seagate ST500DM002-1BD14 + 2000GB Western Digital WD20EFRX-68A + 120GB Patriot Pyro + 4001GB Western Digital WD40EFRX-68W, Graphics: Sapphire AMD Radeon X700 PRO 128MB, Audio: Realtek ALC887-VD, Monitor: HP f1905, Network: Intel 82574L Gigabit Connection

OS: Ubuntu 16.04, Kernel: 4.4.0-36-generic (x86_64), Display Server: X Server 1.18.3, Display Driver: modesetting 1.18.3, Compiler: GCC 5.4.0 20160609, File-System: zfs, Screen Resolution: 1920x1080

Compiler Notes: --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 Notes: NOOP / data=ordered,errors=remount-ro,noatime,rw
Processor Notes: Scaling Governor: acpi-cpufreq ondemand
System Notes: Disk Scheduler: NOOP.

sqlite zfs pool2 with zil and lz4OpenBenchmarking.orgPhoronix Test SuiteAMD FX-8350 Eight-Core @ 4.00GHz (8 Cores)ASUS M5A97 LE R2.0AMD RD890 bridge4 x 8192 MB DDR3-1333MHz3 x 2000GB Western Digital WD20EFRX-68E + 2 x 500GB Seagate ST500DM002-1BD14 + 2000GB Western Digital WD20EFRX-68A + 120GB Patriot Pyro + 4001GB Western Digital WD40EFRX-68WSapphire AMD Radeon X700 PRO 128MBRealtek ALC887-VDHP f1905Intel 82574L Gigabit ConnectionUbuntu 16.044.4.0-36-generic (x86_64)X Server 1.18.3modesetting 1.18.3GCC 5.4.0 20160609zfs1920x1080ProcessorMotherboardChipsetMemoryDiskGraphicsAudioMonitorNetworkOSKernelDisplay ServerDisplay DriverCompilerFile-SystemScreen ResolutionSqlite Zfs Pool2 With Zil And Lz4 BenchmarksSystem Logs- --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 - NOOP / data=ordered,errors=remount-ro,noatime,rw- Scaling Governor: acpi-cpufreq ondemand- Disk Scheduler: NOOP.

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.8.10.2Test Target: Default Test Directorysqlite zfs pool2 with zil and lz4246810SE +/- 0.04, N = 38.331. (CC) gcc options: -O2 -ldl -lpthread

sqlite zfs pool2 with zil and lz4

Processor: AMD FX-8350 Eight-Core @ 4.00GHz (8 Cores), Motherboard: ASUS M5A97 LE R2.0, Chipset: AMD RD890 bridge, Memory: 4 x 8192 MB DDR3-1333MHz, Disk: 3 x 2000GB Western Digital WD20EFRX-68E + 2 x 500GB Seagate ST500DM002-1BD14 + 2000GB Western Digital WD20EFRX-68A + 120GB Patriot Pyro + 4001GB Western Digital WD40EFRX-68W, Graphics: Sapphire AMD Radeon X700 PRO 128MB, Audio: Realtek ALC887-VD, Monitor: HP f1905, Network: Intel 82574L Gigabit Connection

OS: Ubuntu 16.04, Kernel: 4.4.0-36-generic (x86_64), Display Server: X Server 1.18.3, Display Driver: modesetting 1.18.3, Compiler: GCC 5.4.0 20160609, File-System: zfs, Screen Resolution: 1920x1080

Compiler Notes: --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 Notes: NOOP / data=ordered,errors=remount-ro,noatime,rw
Processor Notes: Scaling Governor: acpi-cpufreq ondemand
System Notes: Disk Scheduler: NOOP.

Testing initiated at 2 September 2016 10:22 by user root.