db xeon e

Tests for a future article. Intel Xeon E-2336 testing with a ASRockRack E3C252D4U (1.22 BIOS) and ASPEED on Ubuntu 22.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 2309091-NE-DBXEONE4100
Jump To Table - Results

View

Do Not Show Noisy Results
Do Not Show Results With Incomplete Data
Do Not Show Results With Little Change/Spread
List Notable Results
Show Result Confidence Charts
Allow Limiting Results To Certain Suite(s)

Statistics

Show Overall Harmonic Mean(s)
Show Overall Geometric Mean
Show Wins / Losses Counts (Pie Chart)
Normalize Results
Remove Outliers Before Calculating Averages

Graph Settings

Force Line Graphs Where Applicable
Convert To Scalar Where Applicable
Prefer Vertical Bar Graphs

Multi-Way Comparison

Condense Multi-Option Tests Into Single Result Graphs

Table

Show Detailed System Result Table

Run Management

Highlight
Result
Toggle/Hide
Result
Result
Identifier
View Logs
Performance Per
Dollar
Date
Run
  Test
  Duration
a
September 09 2023
  2 Hours, 59 Minutes
b
September 09 2023
  3 Hours, 9 Minutes
Invert Behavior (Only Show Selected Data)
  3 Hours, 4 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):

a

Kernel Notes: Transparent Huge Pages: madvise
Processor Notes: Scaling Governor: acpi-cpufreq performance (Boost: Enabled) - CPU Microcode: 0x59 - Thermald 2.4.9
Java Notes: OpenJDK Runtime Environment (build 11.0.20+8-post-Ubuntu-1ubuntu122.04)
Security Notes: gather_data_sampling: Vulnerable + itlb_multihit: Not affected + l1tf: Not affected + mds: Not affected + meltdown: Not affected + mmio_stale_data: Vulnerable + retbleed: Vulnerable + spec_rstack_overflow: Not affected + spec_store_bypass: Vulnerable + spectre_v1: Vulnerable: __user pointer sanitization and usercopy barriers only; no swapgs barriers + spectre_v2: Vulnerable IBPB: disabled STIBP: disabled PBRSB-eIBRS: Vulnerable + srbds: Not affected + tsx_async_abort: Not affected

b

Processor: Intel Xeon E-2336 @ 2.90GHz (6 Cores / 12 Threads), Motherboard: ASRockRack E3C252D4U (1.22 BIOS), Chipset: Intel Tiger Lake-H, Memory: 64GB, Disk: 3201GB Micron_7450_MTFDKCC3T2TFS, Graphics: ASPEED, Network: 2 x Intel I210

OS: Ubuntu 22.04, Kernel: 6.5.1-060501-generic (x86_64), Desktop: GNOME Shell 42.9, Display Server: X Server 1.21.1.4, Vulkan: 1.3.238, Compiler: GCC 11.4.0, File-System: ext4, Screen Resolution: 1024x768

db xeon eOpenBenchmarking.orgPhoronix Test SuiteIntel Xeon E-2336 @ 2.90GHz (6 Cores / 12 Threads)ASRockRack E3C252D4U (1.22 BIOS)Intel Tiger Lake-H64GB3201GB Micron_7450_MTFDKCC3T2TFSASPEED2 x Intel I210Ubuntu 22.046.5.1-060501-generic (x86_64)GNOME Shell 42.9X Server 1.21.1.41.3.238GCC 11.4.0ext41024x768ProcessorMotherboardChipsetMemoryDiskGraphicsNetworkOSKernelDesktopDisplay ServerVulkanCompilerFile-SystemScreen ResolutionDb Xeon E BenchmarksSystem Logs- Transparent Huge Pages: madvise- Scaling Governor: acpi-cpufreq performance (Boost: Enabled) - CPU Microcode: 0x59 - Thermald 2.4.9 - OpenJDK Runtime Environment (build 11.0.20+8-post-Ubuntu-1ubuntu122.04) - gather_data_sampling: Vulnerable + itlb_multihit: Not affected + l1tf: Not affected + mds: Not affected + meltdown: Not affected + mmio_stale_data: Vulnerable + retbleed: Vulnerable + spec_rstack_overflow: Not affected + spec_store_bypass: Vulnerable + spectre_v1: Vulnerable: __user pointer sanitization and usercopy barriers only; no swapgs barriers + spectre_v2: Vulnerable IBPB: disabled STIBP: disabled PBRSB-eIBRS: Vulnerable + srbds: Not affected + tsx_async_abort: Not affected

a vs. b ComparisonPhoronix Test SuiteBaseline+42.1%+42.1%+84.2%+84.2%+126.3%+126.3%33%16.8%8.1%6.8%4.6%4.3%2.6%2.5%Open - 20 - 1000000168.3%File Status - 20 - 100000033.9%Open - 100 - 100000File Status - 50 - 100000Open - 50 - 10000015.1%File Status - 20 - 10000011%File Status - 100 - 100000Delete - 20 - 1000007.2%Rename - 100 - 100000Delete - 100 - 10000006.1%Open - 100 - 1000000Create - 50 - 1000004.4%Create - 50 - 1000000File Status - 100 - 10000003.9%Rename - 20 - 10000003.5%Delete - 50 - 10000003.4%File Status - 50 - 10000002.9%Open - 20 - 100000Open - 50 - 1000000Rename - 50 - 1000002.2%Delete - 100 - 1000002%Apache HadoopApache HadoopApache HadoopApache HadoopApache HadoopApache HadoopApache HadoopApache HadoopApache HadoopApache HadoopApache HadoopApache HadoopApache HadoopApache HadoopApache HadoopApache HadoopApache HadoopApache HadoopApache HadoopApache HadoopApache Hadoopab

db xeon ehadoop: Open - 20 - 100000hadoop: Open - 50 - 100000hadoop: Open - 100 - 100000hadoop: Open - 20 - 1000000hadoop: Open - 50 - 1000000hadoop: Create - 20 - 100000hadoop: Create - 50 - 100000hadoop: Delete - 20 - 100000hadoop: Delete - 50 - 100000hadoop: Open - 100 - 1000000hadoop: Rename - 20 - 100000hadoop: Rename - 50 - 100000hadoop: Create - 100 - 100000hadoop: Create - 20 - 1000000hadoop: Create - 50 - 1000000hadoop: Delete - 100 - 100000hadoop: Delete - 20 - 1000000hadoop: Delete - 50 - 1000000hadoop: Rename - 100 - 100000hadoop: Rename - 20 - 1000000hadoop: Rename - 50 - 1000000hadoop: Create - 100 - 1000000hadoop: Delete - 100 - 1000000hadoop: Rename - 100 - 1000000hadoop: File Status - 20 - 100000hadoop: File Status - 50 - 100000hadoop: File Status - 100 - 100000hadoop: File Status - 20 - 1000000hadoop: File Status - 50 - 1000000hadoop: File Status - 100 - 1000000tidb: oltp_read_write - 1tidb: oltp_read_write - 16tidb: oltp_read_write - 32tidb: oltp_read_write - 64tidb: oltp_point_select - 1tidb: oltp_update_index - 1tidb: oltp_point_select - 16tidb: oltp_point_select - 32tidb: oltp_point_select - 64tidb: oltp_update_index - 16tidb: oltp_update_index - 32tidb: oltp_update_index - 64tidb: oltp_update_non_index - 1tidb: oltp_update_non_index - 16tidb: oltp_update_non_index - 32tidb: oltp_update_non_index - 64ab854701943396709220937207141643156402560851196171173711285347904168710850684786477367010449312750212794381833873368195475540124177837319174318000009345795081301340483135135132701617217806676014443745142357451967023810989051881114411389015501877193819672943396349284145137955648537351116071158751344086914918525151230775807685810245912938312377887413843538307774968117055827758264469345791010101379507130208313003903287160711728317763670914553738541995447596967799589011874115241384115559OpenBenchmarking.org

Apache Hadoop

This is a benchmark of the Apache Hadoop making use of its built-in name-node throughput benchmark (NNThroughputBenchmark). Learn more via the OpenBenchmarking.org test page.

OpenBenchmarking.orgOps per sec, More Is BetterApache Hadoop 3.3.6Operation: Open - Threads: 20 - Files: 100000ab200K400K600K800K1000K854701877193

OpenBenchmarking.orgOps per sec, More Is BetterApache Hadoop 3.3.6Operation: Open - Threads: 50 - Files: 100000ab200K400K600K800K1000K943396819672

OpenBenchmarking.orgOps per sec, More Is BetterApache Hadoop 3.3.6Operation: Open - Threads: 100 - Files: 100000ab200K400K600K800K1000K709220943396

OpenBenchmarking.orgOps per sec, More Is BetterApache Hadoop 3.3.6Operation: Open - Threads: 20 - Files: 1000000ab200K400K600K800K1000K937207349284

OpenBenchmarking.orgOps per sec, More Is BetterApache Hadoop 3.3.6Operation: Open - Threads: 50 - Files: 1000000ab300K600K900K1200K1500K14164311451379

OpenBenchmarking.orgOps per sec, More Is BetterApache Hadoop 3.3.6Operation: Create - Threads: 20 - Files: 100000ab12K24K36K48K60K5640255648

OpenBenchmarking.orgOps per sec, More Is BetterApache Hadoop 3.3.6Operation: Create - Threads: 50 - Files: 100000ab12K24K36K48K60K5608553735

OpenBenchmarking.orgOps per sec, More Is BetterApache Hadoop 3.3.6Operation: Delete - Threads: 20 - Files: 100000ab30K60K90K120K150K119617111607

OpenBenchmarking.orgOps per sec, More Is BetterApache Hadoop 3.3.6Operation: Delete - Threads: 50 - Files: 100000ab30K60K90K120K150K117371115875

OpenBenchmarking.orgOps per sec, More Is BetterApache Hadoop 3.3.6Operation: Open - Threads: 100 - Files: 1000000ab300K600K900K1200K1500K12853471344086

OpenBenchmarking.orgOps per sec, More Is BetterApache Hadoop 3.3.6Operation: Rename - Threads: 20 - Files: 100000ab20K40K60K80K100K9041691491

OpenBenchmarking.orgOps per sec, More Is BetterApache Hadoop 3.3.6Operation: Rename - Threads: 50 - Files: 100000ab20K40K60K80K100K8710885251

OpenBenchmarking.orgOps per sec, More Is BetterApache Hadoop 3.3.6Operation: Create - Threads: 100 - Files: 100000ab11K22K33K44K55K5068451230

OpenBenchmarking.orgOps per sec, More Is BetterApache Hadoop 3.3.6Operation: Create - Threads: 20 - Files: 1000000ab20K40K60K80K100K7864777580

OpenBenchmarking.orgOps per sec, More Is BetterApache Hadoop 3.3.6Operation: Create - Threads: 50 - Files: 1000000ab16K32K48K64K80K7367076858

OpenBenchmarking.orgOps per sec, More Is BetterApache Hadoop 3.3.6Operation: Delete - Threads: 100 - Files: 100000ab20K40K60K80K100K104493102459

OpenBenchmarking.orgOps per sec, More Is BetterApache Hadoop 3.3.6Operation: Delete - Threads: 20 - Files: 1000000ab30K60K90K120K150K127502129383

OpenBenchmarking.orgOps per sec, More Is BetterApache Hadoop 3.3.6Operation: Delete - Threads: 50 - Files: 1000000ab30K60K90K120K150K127943123778

OpenBenchmarking.orgOps per sec, More Is BetterApache Hadoop 3.3.6Operation: Rename - Threads: 100 - Files: 100000ab20K40K60K80K100K8183387413

OpenBenchmarking.orgOps per sec, More Is BetterApache Hadoop 3.3.6Operation: Rename - Threads: 20 - Files: 1000000ab20K40K60K80K100K8733684353

OpenBenchmarking.orgOps per sec, More Is BetterApache Hadoop 3.3.6Operation: Rename - Threads: 50 - Files: 1000000ab20K40K60K80K100K8195483077

OpenBenchmarking.orgOps per sec, More Is BetterApache Hadoop 3.3.6Operation: Create - Threads: 100 - Files: 1000000ab16K32K48K64K80K7554074968

OpenBenchmarking.orgOps per sec, More Is BetterApache Hadoop 3.3.6Operation: Delete - Threads: 100 - Files: 1000000ab30K60K90K120K150K124177117055

OpenBenchmarking.orgOps per sec, More Is BetterApache Hadoop 3.3.6Operation: Rename - Threads: 100 - Files: 1000000ab20K40K60K80K100K8373182775

OpenBenchmarking.orgOps per sec, More Is BetterApache Hadoop 3.3.6Operation: File Status - Threads: 20 - Files: 100000ab200K400K600K800K1000K917431826446

OpenBenchmarking.orgOps per sec, More Is BetterApache Hadoop 3.3.6Operation: File Status - Threads: 50 - Files: 100000ab200K400K600K800K1000K800000934579

OpenBenchmarking.orgOps per sec, More Is BetterApache Hadoop 3.3.6Operation: File Status - Threads: 100 - Files: 100000ab200K400K600K800K1000K9345791010101

OpenBenchmarking.orgOps per sec, More Is BetterApache Hadoop 3.3.6Operation: File Status - Threads: 20 - Files: 1000000ab110K220K330K440K550K508130379507

OpenBenchmarking.orgOps per sec, More Is BetterApache Hadoop 3.3.6Operation: File Status - Threads: 50 - Files: 1000000ab300K600K900K1200K1500K13404831302083

OpenBenchmarking.orgOps per sec, More Is BetterApache Hadoop 3.3.6Operation: File Status - Threads: 100 - Files: 1000000ab300K600K900K1200K1500K13513511300390

TiDB Community Server

This is a PingCAP TiDB Community Server benchmark facilitated using the sysbench OLTP database benchmarks. Learn more via the OpenBenchmarking.org test page.

OpenBenchmarking.orgQueries Per Second, More Is BetterTiDB Community Server 7.3Test: oltp_read_write - Threads: 1ab700140021002800350032703287

OpenBenchmarking.orgQueries Per Second, More Is BetterTiDB Community Server 7.3Test: oltp_read_write - Threads: 16ab3K6K9K12K15K1617216071

OpenBenchmarking.orgQueries Per Second, More Is BetterTiDB Community Server 7.3Test: oltp_read_write - Threads: 32b4K8K12K16K20K17283

Test: oltp_read_write - Threads: 32

a: The test quit with a non-zero exit status. E: FATAL: Thread initialization failed!

OpenBenchmarking.orgQueries Per Second, More Is BetterTiDB Community Server 7.3Test: oltp_read_write - Threads: 64ab4K8K12K16K20K1780617763

OpenBenchmarking.orgQueries Per Second, More Is BetterTiDB Community Server 7.3Test: oltp_point_select - Threads: 1ab1400280042005600700067606709

OpenBenchmarking.orgQueries Per Second, More Is BetterTiDB Community Server 7.3Test: oltp_update_index - Threads: 1ab3006009001200150014441455

OpenBenchmarking.orgQueries Per Second, More Is BetterTiDB Community Server 7.3Test: oltp_point_select - Threads: 16ab8K16K24K32K40K3745137385

OpenBenchmarking.orgQueries Per Second, More Is BetterTiDB Community Server 7.3Test: oltp_point_select - Threads: 32ab9K18K27K36K45K4235741995

OpenBenchmarking.orgQueries Per Second, More Is BetterTiDB Community Server 7.3Test: oltp_point_select - Threads: 64ab10K20K30K40K50K4519644759

OpenBenchmarking.orgQueries Per Second, More Is BetterTiDB Community Server 7.3Test: oltp_update_index - Threads: 16ab1500300045006000750070236967

OpenBenchmarking.orgQueries Per Second, More Is BetterTiDB Community Server 7.3Test: oltp_update_index - Threads: 32ab2K4K6K8K10K81097995

OpenBenchmarking.orgQueries Per Second, More Is BetterTiDB Community Server 7.3Test: oltp_update_index - Threads: 64ab2K4K6K8K10K89058901

OpenBenchmarking.orgQueries Per Second, More Is BetterTiDB Community Server 7.3Test: oltp_update_non_index - Threads: 1ab40080012001600200018811874

OpenBenchmarking.orgQueries Per Second, More Is BetterTiDB Community Server 7.3Test: oltp_update_non_index - Threads: 16ab2K4K6K8K10K1144111524

OpenBenchmarking.orgQueries Per Second, More Is BetterTiDB Community Server 7.3Test: oltp_update_non_index - Threads: 32ab3K6K9K12K15K1389013841

OpenBenchmarking.orgQueries Per Second, More Is BetterTiDB Community Server 7.3Test: oltp_update_non_index - Threads: 64ab3K6K9K12K15K1550115559

a

Kernel Notes: Transparent Huge Pages: madvise
Processor Notes: Scaling Governor: acpi-cpufreq performance (Boost: Enabled) - CPU Microcode: 0x59 - Thermald 2.4.9
Java Notes: OpenJDK Runtime Environment (build 11.0.20+8-post-Ubuntu-1ubuntu122.04)
Security Notes: gather_data_sampling: Vulnerable + itlb_multihit: Not affected + l1tf: Not affected + mds: Not affected + meltdown: Not affected + mmio_stale_data: Vulnerable + retbleed: Vulnerable + spec_rstack_overflow: Not affected + spec_store_bypass: Vulnerable + spectre_v1: Vulnerable: __user pointer sanitization and usercopy barriers only; no swapgs barriers + spectre_v2: Vulnerable IBPB: disabled STIBP: disabled PBRSB-eIBRS: Vulnerable + srbds: Not affected + tsx_async_abort: Not affected

Testing initiated at 9 September 2023 11:24 by user phoronix.

b

Processor: Intel Xeon E-2336 @ 2.90GHz (6 Cores / 12 Threads), Motherboard: ASRockRack E3C252D4U (1.22 BIOS), Chipset: Intel Tiger Lake-H, Memory: 64GB, Disk: 3201GB Micron_7450_MTFDKCC3T2TFS, Graphics: ASPEED, Network: 2 x Intel I210

OS: Ubuntu 22.04, Kernel: 6.5.1-060501-generic (x86_64), Desktop: GNOME Shell 42.9, Display Server: X Server 1.21.1.4, Vulkan: 1.3.238, Compiler: GCC 11.4.0, File-System: ext4, Screen Resolution: 1024x768

Kernel Notes: Transparent Huge Pages: madvise
Processor Notes: Scaling Governor: acpi-cpufreq performance (Boost: Enabled) - CPU Microcode: 0x59 - Thermald 2.4.9
Java Notes: OpenJDK Runtime Environment (build 11.0.20+8-post-Ubuntu-1ubuntu122.04)
Security Notes: gather_data_sampling: Vulnerable + itlb_multihit: Not affected + l1tf: Not affected + mds: Not affected + meltdown: Not affected + mmio_stale_data: Vulnerable + retbleed: Vulnerable + spec_rstack_overflow: Not affected + spec_store_bypass: Vulnerable + spectre_v1: Vulnerable: __user pointer sanitization and usercopy barriers only; no swapgs barriers + spectre_v2: Vulnerable IBPB: disabled STIBP: disabled PBRSB-eIBRS: Vulnerable + srbds: Not affected + tsx_async_abort: Not affected

Testing initiated at 9 September 2023 14:31 by user phoronix.