Intel Core i5-4460 testing with a Mouse Z97-S01 v1.0 (V2.0B5 BIOS) and MSI Intel Xeon E3-1200 v3/4th Gen Core IGP on Ubuntu 20.04 via the Phoronix Test Suite.
Compare your own system(s) to this result file with the
Phoronix Test Suite by running the command:
phoronix-test-suite benchmark 2403188-NE-SQLITE10220
{
"title": "sqlite1",
"last_modified": "2024-03-18 19:30:15",
"description": "Intel Core i5-4460 testing with a Mouse Z97-S01 v1.0 (V2.0B5 BIOS) and MSI Intel Xeon E3-1200 v3\/4th Gen Core IGP on Ubuntu 20.04 via the Phoronix Test Suite.",
"systems": {
"bcachefs replica=3": {
"identifier": "bcachefs replica=3",
"hardware": {
"Processor": "Intel Core i5-4460 @ 3.40GHz (4 Cores)",
"Motherboard": "Mouse Z97-S01 v1.0 (V2.0B5 BIOS)",
"Chipset": "Intel 4th Gen Core DRAM",
"Memory": "2 x 8192 MB DDR3-1600MT\/s",
"Disk": "2 x 1000GB TOSHIBA DT01ACA1 + 500GB SAMSUNG HD501LJ + 120GB Western Digital WDS120G1G0A-",
"Graphics": "MSI Intel Xeon E3-1200 v3\/4th Gen Core IGP (1100MHz)",
"Audio": "Intel Xeon E3-1200 v3\/4th",
"Network": "4 x Intel 10-Gigabit X540-AT2 + Realtek RTL8111\/8168\/8411"
},
"software": {
"OS": "Ubuntu 20.04",
"Kernel": "6.7.3 (x86_64)",
"Desktop": "GNOME Shell 3.36.9",
"Display Server": "X Server 1.20.13",
"Vulkan": "1.2.182",
"Compiler": "GCC 9.4.0",
"File-System": "BcacheFS"
},
"user": "root",
"timestamp": "2024-03-18 16:16:41",
"client_version": "10.8.3",
"data": {
"compiler-configuration": "--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++,gm2 --enable-libstdcxx-debug --enable-libstdcxx-time=yes --enable-multiarch --enable-multilib --enable-nls --enable-objc-gc=auto --enable-offload-targets=nvptx-none=\/build\/gcc-9-9QDOt0\/gcc-9-9.4.0\/debian\/tmp-nvptx\/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-scheduler": "MQ-DEADLINE",
"disk-mount-options": "relatime,rw",
"disk-details": "Block Size: 512",
"cpu-scaling-governor": "intel_cpufreq performance",
"cpu-microcode": "0x28",
"cpu-thermald": "1.9.1",
"kernel-extra-details": "Transparent Huge Pages: madvise",
"security": "gather_data_sampling: Not affected + itlb_multihit: KVM: Mitigation of VMX disabled + l1tf: Mitigation of PTE Inversion; VMX: conditional cache flushes SMT disabled + mds: Mitigation of Clear buffers; SMT disabled + meltdown: Mitigation of PTI + mmio_stale_data: Unknown: No mitigations + retbleed: Not affected + spec_rstack_overflow: Not affected + spec_store_bypass: Mitigation of SSB disabled via prctl + spectre_v1: Mitigation of usercopy\/swapgs barriers and __user pointer sanitization + spectre_v2: Mitigation of Retpolines IBPB: conditional IBRS_FW STIBP: disabled RSB filling PBRSB-eIBRS: Not affected + srbds: Mitigation of Microcode + tsx_async_abort: Not affected"
}
},
"bcachefs replica=2": {
"identifier": "bcachefs replica=2",
"hardware": {
"Processor": "Intel Core i5-4460 @ 3.40GHz (4 Cores)",
"Motherboard": "Mouse Z97-S01 v1.0 (V2.0B5 BIOS)",
"Chipset": "Intel 4th Gen Core DRAM",
"Memory": "2 x 8192 MB DDR3-1600MT\/s",
"Disk": "2 x 1000GB TOSHIBA DT01ACA1 + 500GB SAMSUNG HD501LJ + 120GB Western Digital WDS120G1G0A-",
"Graphics": "MSI Intel Xeon E3-1200 v3\/4th Gen Core IGP (1100MHz)",
"Audio": "Intel Xeon E3-1200 v3\/4th",
"Network": "4 x Intel 10-Gigabit X540-AT2 + Realtek RTL8111\/8168\/8411"
},
"software": {
"OS": "Ubuntu 20.04",
"Kernel": "6.7.3 (x86_64)",
"Desktop": "GNOME Shell 3.36.9",
"Display Server": "X Server 1.20.13",
"Vulkan": "1.2.182",
"Compiler": "GCC 9.4.0",
"File-System": "BcacheFS"
},
"user": "root",
"timestamp": "2024-03-18 18:21:00",
"client_version": "10.8.3",
"data": {
"compiler-configuration": "--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++,gm2 --enable-libstdcxx-debug --enable-libstdcxx-time=yes --enable-multiarch --enable-multilib --enable-nls --enable-objc-gc=auto --enable-offload-targets=nvptx-none=\/build\/gcc-9-9QDOt0\/gcc-9-9.4.0\/debian\/tmp-nvptx\/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-scheduler": "MQ-DEADLINE",
"disk-mount-options": "relatime,rw",
"disk-details": "Block Size: 512",
"cpu-scaling-governor": "intel_cpufreq performance",
"cpu-microcode": "0x28",
"cpu-thermald": "1.9.1",
"kernel-extra-details": "Transparent Huge Pages: madvise",
"security": "gather_data_sampling: Not affected + itlb_multihit: KVM: Mitigation of VMX disabled + l1tf: Mitigation of PTE Inversion; VMX: conditional cache flushes SMT disabled + mds: Mitigation of Clear buffers; SMT disabled + meltdown: Mitigation of PTI + mmio_stale_data: Unknown: No mitigations + retbleed: Not affected + spec_rstack_overflow: Not affected + spec_store_bypass: Mitigation of SSB disabled via prctl + spectre_v1: Mitigation of usercopy\/swapgs barriers and __user pointer sanitization + spectre_v2: Mitigation of Retpolines IBPB: conditional IBRS_FW STIBP: disabled RSB filling PBRSB-eIBRS: Not affected + srbds: Mitigation of Microcode + tsx_async_abort: Not affected"
}
},
"bcachefs replica=1": {
"identifier": "bcachefs replica=1",
"hardware": {
"Processor": "Intel Core i5-4460 @ 3.40GHz (4 Cores)",
"Motherboard": "Mouse Z97-S01 v1.0 (V2.0B5 BIOS)",
"Chipset": "Intel 4th Gen Core DRAM",
"Memory": "2 x 8192 MB DDR3-1600MT\/s",
"Disk": "2 x 1000GB TOSHIBA DT01ACA1 + 500GB SAMSUNG HD501LJ + 120GB Western Digital WDS120G1G0A-",
"Graphics": "MSI Intel Xeon E3-1200 v3\/4th Gen Core IGP (1100MHz)",
"Audio": "Intel Xeon E3-1200 v3\/4th",
"Network": "4 x Intel 10-Gigabit X540-AT2 + Realtek RTL8111\/8168\/8411"
},
"software": {
"OS": "Ubuntu 20.04",
"Kernel": "6.7.3 (x86_64)",
"Desktop": "GNOME Shell 3.36.9",
"Display Server": "X Server 1.20.13",
"Vulkan": "1.2.182",
"Compiler": "GCC 9.4.0",
"File-System": "BcacheFS"
},
"user": "root",
"timestamp": "2024-03-18 19:09:42",
"client_version": "10.8.3",
"data": {
"compiler-configuration": "--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++,gm2 --enable-libstdcxx-debug --enable-libstdcxx-time=yes --enable-multiarch --enable-multilib --enable-nls --enable-objc-gc=auto --enable-offload-targets=nvptx-none=\/build\/gcc-9-9QDOt0\/gcc-9-9.4.0\/debian\/tmp-nvptx\/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-scheduler": "MQ-DEADLINE",
"disk-mount-options": "relatime,rw",
"disk-details": "Block Size: 512",
"cpu-scaling-governor": "intel_cpufreq performance",
"cpu-microcode": "0x28",
"cpu-thermald": "1.9.1",
"kernel-extra-details": "Transparent Huge Pages: madvise",
"security": "gather_data_sampling: Not affected + itlb_multihit: KVM: Mitigation of VMX disabled + l1tf: Mitigation of PTE Inversion; VMX: conditional cache flushes SMT disabled + mds: Mitigation of Clear buffers; SMT disabled + meltdown: Mitigation of PTI + mmio_stale_data: Unknown: No mitigations + retbleed: Not affected + spec_rstack_overflow: Not affected + spec_store_bypass: Mitigation of SSB disabled via prctl + spectre_v1: Mitigation of usercopy\/swapgs barriers and __user pointer sanitization + spectre_v2: Mitigation of Retpolines IBPB: conditional IBRS_FW STIBP: disabled RSB filling PBRSB-eIBRS: Not affected + srbds: Mitigation of Microcode + tsx_async_abort: Not affected"
}
}
},
"results": {
"92c7c0236692f69ef464fe7d329814a0592a94f3": {
"identifier": "pts\/sqlite-2.2.0",
"title": "SQLite",
"app_version": "3.41.2",
"arguments": "4",
"description": "Threads \/ Copies: 4",
"scale": "Seconds",
"proportion": "LIB",
"display_format": "BAR_GRAPH",
"results": {
"bcachefs replica=3": {
"value": 110.412000000000006139089236967265605926513671875,
"raw_values": [
105.3700000000000045474735088646411895751953125,
107.4680000000000035242919693700969219207763671875,
112.701999999999998181010596454143524169921875,
106.953000000000002955857780762016773223876953125,
113.55500000000000682121026329696178436279296875,
108.736999999999994770405464805662631988525390625,
112.299000000000006593836587853729724884033203125,
107.75700000000000500222085975110530853271484375,
112.5930000000000035242919693700969219207763671875,
112.8349999999999937472239253111183643341064453125,
111.501000000000004774847184307873249053955078125,
111.8780000000000001136868377216160297393798828125,
111.71399999999999863575794734060764312744140625
],
"test_run_times": [
105.3700000000000045474735088646411895751953125,
107.469999999999998863131622783839702606201171875,
112.7000000000000028421709430404007434844970703125,
106.9500000000000028421709430404007434844970703125,
113.5499999999999971578290569595992565155029296875,
108.7399999999999948840923025272786617279052734375,
112.2999999999999971578290569595992565155029296875,
107.7600000000000051159076974727213382720947265625,
112.590000000000003410605131648480892181396484375,
112.840000000000003410605131648480892181396484375,
111.5,
111.8799999999999954525264911353588104248046875,
111.7099999999999937472239253111183643341064453125
],
"details": {
"compiler-options": {
"compiler-type": "CC",
"compiler": "gcc",
"compiler-options": "-O2 -lz -lm -ldl -lpthread"
}
}
},
"bcachefs replica=2": {
"value": 76.7699999999999960209606797434389591217041015625,
"raw_values": [
75.4920000000000044337866711430251598358154296875,
76.0729999999999932924765744246542453765869140625,
78.7450000000000045474735088646411895751953125
],
"test_run_times": [
75.4899999999999948840923025272786617279052734375,
76.06999999999999317878973670303821563720703125,
78.7399999999999948840923025272786617279052734375
],
"details": {
"compiler-options": {
"compiler-type": "CC",
"compiler": "gcc",
"compiler-options": "-O2 -lz -lm -ldl -lpthread"
}
}
},
"bcachefs replica=1": {
"value": 58.14699999999999846522769075818359851837158203125,
"raw_values": [
58.042000000000001591615728102624416351318359375,
62.4140000000000014779288903810083866119384765625,
63.75999999999999801048033987171947956085205078125,
56.3250000000000028421709430404007434844970703125,
54.68299999999999982946974341757595539093017578125,
57.88900000000000289901436190120875835418701171875,
61.0439999999999969304553815163671970367431640625,
58.9320000000000021600499167107045650482177734375,
56.00500000000000255795384873636066913604736328125,
56.0240000000000009094947017729282379150390625,
57.37899999999999778310666442848742008209228515625,
58.81099999999999994315658113919198513031005859375,
55.9279999999999972715158946812152862548828125,
59.42399999999999948840923025272786617279052734375,
55.5499999999999971578290569595992565155029296875
],
"test_run_times": [
58.03999999999999914734871708787977695465087890625,
62.409999999999996589394868351519107818603515625,
63.75999999999999801048033987171947956085205078125,
56.32000000000000028421709430404007434844970703125,
54.67999999999999971578290569595992565155029296875,
57.8900000000000005684341886080801486968994140625,
61.03999999999999914734871708787977695465087890625,
58.92999999999999971578290569595992565155029296875,
56.00999999999999801048033987171947956085205078125,
56.02000000000000312638803734444081783294677734375,
57.38000000000000255795384873636066913604736328125,
58.81000000000000227373675443232059478759765625,
55.92999999999999971578290569595992565155029296875,
59.4200000000000017053025658242404460906982421875,
55.5499999999999971578290569595992565155029296875
],
"details": {
"compiler-options": {
"compiler-type": "CC",
"compiler": "gcc",
"compiler-options": "-O2 -lz -lm -ldl -lpthread"
}
}
}
}
},
"bdab74310add53b64a328f392b77f774eda100a7": {
"identifier": "pts\/sqlite-2.2.0",
"title": "SQLite",
"app_version": "3.41.2",
"arguments": "1",
"description": "Threads \/ Copies: 1",
"scale": "Seconds",
"proportion": "LIB",
"display_format": "BAR_GRAPH",
"results": {
"bcachefs replica=3": {
"value": 49.27799999999999869260136620141565799713134765625,
"raw_values": [
49.22399999999999664623828721232712268829345703125,
57.78699999999999903366187936626374721527099609375,
48.7830000000000012505552149377763271331787109375,
48.441000000000002501110429875552654266357421875,
48.74900000000000233058017329312860965728759765625,
49.9320000000000021600499167107045650482177734375,
49.38600000000000278532752417959272861480712890625,
48.78999999999999914734871708787977695465087890625,
47.296999999999997044142219237983226776123046875,
47.98400000000000176214598468504846096038818359375,
50.2740000000000009094947017729282379150390625,
47.9470000000000027284841053187847137451171875,
51.41100000000000136424205265939235687255859375,
47.03999999999999914734871708787977695465087890625,
46.12899999999999778310666442848742008209228515625
],
"test_run_times": [
49.219999999999998863131622783839702606201171875,
57.78999999999999914734871708787977695465087890625,
48.780000000000001136868377216160297393798828125,
48.43999999999999772626324556767940521240234375,
48.75,
49.92999999999999971578290569595992565155029296875,
49.3900000000000005684341886080801486968994140625,
48.78999999999999914734871708787977695465087890625,
47.2999999999999971578290569595992565155029296875,
47.97999999999999687361196265555918216705322265625,
50.27000000000000312638803734444081783294677734375,
47.9500000000000028421709430404007434844970703125,
51.409999999999996589394868351519107818603515625,
47.03999999999999914734871708787977695465087890625,
46.13000000000000255795384873636066913604736328125
],
"details": {
"compiler-options": {
"compiler-type": "CC",
"compiler": "gcc",
"compiler-options": "-O2 -lz -lm -ldl -lpthread"
}
}
},
"bcachefs replica=2": {
"value": 41.8010000000000019326762412674725055694580078125,
"raw_values": [
52.75200000000000244426701101474463939666748046875,
42.89999999999999857891452847979962825775146484375,
42.47099999999999653255144949071109294891357421875,
41.98299999999999698729880037717521190643310546875,
42.195999999999997953636921010911464691162109375,
42.179000000000002046363078989088535308837890625,
40.33200000000000073896444519050419330596923828125,
43.12899999999999778310666442848742008209228515625,
38.9309999999999973852027324028313159942626953125,
38.78099999999999880628820392303168773651123046875,
42.01299999999999812416717759333550930023193359375,
39.542000000000001591615728102624416351318359375,
39.98700000000000187583282240666449069976806640625,
40.62599999999999766941982670687139034271240234375,
39.1869999999999976125764078460633754730224609375
],
"test_run_times": [
52.75,
42.89999999999999857891452847979962825775146484375,
42.469999999999998863131622783839702606201171875,
41.97999999999999687361196265555918216705322265625,
42.2000000000000028421709430404007434844970703125,
42.17999999999999971578290569595992565155029296875,
40.3299999999999982946974341757595539093017578125,
43.13000000000000255795384873636066913604736328125,
38.92999999999999971578290569595992565155029296875,
38.780000000000001136868377216160297393798828125,
42.00999999999999801048033987171947956085205078125,
39.53999999999999914734871708787977695465087890625,
39.99000000000000198951966012828052043914794921875,
40.63000000000000255795384873636066913604736328125,
39.18999999999999772626324556767940521240234375
],
"details": {
"compiler-options": {
"compiler-type": "CC",
"compiler": "gcc",
"compiler-options": "-O2 -lz -lm -ldl -lpthread"
}
}
},
"bcachefs replica=1": {
"value": 35.09599999999999653255144949071109294891357421875,
"raw_values": [
35.04099999999999681676854379475116729736328125,
35.07300000000000039790393202565610408782958984375,
35.17399999999999948840923025272786617279052734375
],
"test_run_times": [
35.03999999999999914734871708787977695465087890625,
35.07000000000000028421709430404007434844970703125,
35.1700000000000017053025658242404460906982421875
],
"details": {
"compiler-options": {
"compiler-type": "CC",
"compiler": "gcc",
"compiler-options": "-O2 -lz -lm -ldl -lpthread"
}
}
}
}
},
"b9ea62081cf18bccb1a640d379b979206e7994d0": {
"identifier": "pts\/sqlite-2.2.0",
"title": "SQLite",
"app_version": "3.41.2",
"arguments": "2",
"description": "Threads \/ Copies: 2",
"scale": "Seconds",
"proportion": "LIB",
"display_format": "BAR_GRAPH",
"results": {
"bcachefs replica=3": {
"value": 73.6880000000000023874235921539366245269775390625,
"raw_values": [
72.308999999999997498889570124447345733642578125,
78.1820000000000021600499167107045650482177734375,
70.2000000000000028421709430404007434844970703125,
73.5319999999999964757080306299030780792236328125,
72.7480000000000046611603465862572193145751953125,
74.751000000000004774847184307873249053955078125,
71.9909999999999996589394868351519107818603515625,
74.4369999999999976125764078460633754730224609375,
74.5040000000000048885340220294892787933349609375,
73.7279999999999944293449516408145427703857421875,
73.8239999999999980673237587325274944305419921875,
74.054000000000002046363078989088535308837890625
],
"test_run_times": [
72.31000000000000227373675443232059478759765625,
78.18000000000000682121026329696178436279296875,
70.2000000000000028421709430404007434844970703125,
73.530000000000001136868377216160297393798828125,
72.75,
74.75,
71.9899999999999948840923025272786617279052734375,
74.43999999999999772626324556767940521240234375,
74.5,
73.7300000000000039790393202565610408782958984375,
73.81999999999999317878973670303821563720703125,
74.0499999999999971578290569595992565155029296875
],
"details": {
"compiler-options": {
"compiler-type": "CC",
"compiler": "gcc",
"compiler-options": "-O2 -lz -lm -ldl -lpthread"
}
}
},
"bcachefs replica=2": {
"value": 60.195999999999997953636921010911464691162109375,
"raw_values": [
60.37700000000000244426701101474463939666748046875,
60.76299999999999812416717759333550930023193359375,
59.4470000000000027284841053187847137451171875
],
"test_run_times": [
60.38000000000000255795384873636066913604736328125,
60.75999999999999801048033987171947956085205078125,
59.4500000000000028421709430404007434844970703125
],
"details": {
"compiler-options": {
"compiler-type": "CC",
"compiler": "gcc",
"compiler-options": "-O2 -lz -lm -ldl -lpthread"
}
}
},
"bcachefs replica=1": {
"value": 50.6159999999999996589394868351519107818603515625,
"raw_values": [
49.84899999999999664623828721232712268829345703125,
50.31099999999999994315658113919198513031005859375,
51.6869999999999976125764078460633754730224609375
],
"test_run_times": [
49.85000000000000142108547152020037174224853515625,
50.31000000000000227373675443232059478759765625,
51.68999999999999772626324556767940521240234375
],
"details": {
"compiler-options": {
"compiler-type": "CC",
"compiler": "gcc",
"compiler-options": "-O2 -lz -lm -ldl -lpthread"
}
}
}
}
}
}
}