HammerDB

JANUARY 5, 2019

Some opinions claim that “Benchmarks are meaningless”, “benchmarks are irrelevant” or “benchmarks are nothing like your real applications” However for others “Benchmarks matter,” as they “account for the processing architecture and speed, memory, storage subsystems and the database engine.”

Benchmarking 40

Benchmarking Database Social Media Scalability 40

HammerDB

OCTOBER 18, 2019

HammerDB doesn’t publish competitive database benchmarks, instead we always encourage people to be better informed by running their own. So over at Phoronix some database benchmarks were published showing PostgreSQL 12 Performance With AMD EPYC 7742 vs. Intel Xeon Platinum 8280 Benchmarks . bin/createdb pgbench./bin/pgbench

Benchmarking 63

Benchmarking Performance Hardware C++ 63

HammerDB

MAY 26, 2022

If you are not already familiar with the programming languages that HammerDB uses, then this earlier post serves as an ideal introduction to what makes up the highest performing GIL free database benchmarking application. set MARIADB_CONFIG=C:Program FilesMariaDBMariaDB Connector C 64-bit set MYSQL_CONFIG=C:Program FilesMySQLMySQL Server 8.0

C++ 113

C++ Database Open Source Servers 113

Brendan Gregg

SEPTEMBER 25, 2021

As (C) looked like a kernel rebuild, I started with (D) and (E). ## 5. I also rewrote this in C and called gettimeofday(2) directly: $ cat gettimeofdaybench.c. Here's some experimental approaches I could also explore: Disable tracesys/syscall_trace. Microbenchmark os::javaTimeMillis() on both systems. include <sys/time.h>

Speed 126

Speed Java AWS Virtualization 126

The Morning Paper

MAY 12, 2019

An open-source benchmark suite for microservices and their hardware-software implications for cloud & edge systems Gan et al., A typical architecture diagram for one of these services looks like this: Suitably armed with a set of benchmark microservices applications, the investigation can begin! ASPLOS’19.

Open Source 61

Open Source Hardware Benchmarking Systems 61

SQL Performance

DECEMBER 8, 2021

This month, I'll present the challenge and the classic cursor-based solution. In subsequent articles, I'll present set-based solutions—including the ones Peter and I worked on. L0 AS ( SELECT 1 AS c. It will be used as a benchmark. The Challenge. Cursor-Based Solution. Peter provided the cursor-based solution.

C++ 133

C++ Code Benchmarking Performance 133

HammerDB

JULY 6, 2023

In this example, we will use the CLI to run TPROC-C on a MariaDB database to illustrate the concepts. In the TPC-C specification, each warehouse has 10 connections and therefore with HammerDB derived workload this enables us to use 1.28 tpmC per warehouse. NOPM per virtual user as a guide to our fixed throughput.

Virtualization 57

Virtualization C++ Database Code 57

Brendan Gregg

SEPTEMBER 25, 2021

As (C) looked like a kernel rebuild, I started with (D) and (E). I also rewrote this in C and called gettimeofday(2) directly: $ cat gettimeofdaybench.c Here's some experimental approaches I could also explore: Disable tracesys/syscall_trace. Microbenchmark os::javaTimeMillis() on both systems. Try changing the kernel clocksource.

Speed 52

Speed Java AWS Virtualization 52

Brendan Gregg

SEPTEMBER 25, 2021

As (C) looked like a kernel rebuild, I started with (D) and (E). ## 6. I also rewrote this in C and called gettimeofday(2) directly: $ cat gettimeofdaybench.c Here's some experimental approaches I could also explore: Disable tracesys/syscall_trace. Microbenchmark os::javaTimeMillis() on both systems. include <sys/time.h>

Speed 40

Speed Java AWS Virtualization 40

HammerDB

OCTOBER 12, 2018

This post complements the previous best practice guides this time with the focus on MySQL and MariaDB and achieving top levels of performance with the HammerDB MySQL TPC-C test. For this reason sysbench presents a vastly more simplified workload than HammerDB. . SELECT DISTINCT c from sbtest where id between ? order by c.

Best Practices 40

Best Practices Scalability Performance C++ 40

Percona

NOVEMBER 3, 2023

Leveraging pgbench , which is a benchmarking utility that comes bundled with PostgreSQL, I will put the cluster through its paces by executing a series of DML operations. And now, execute the benchmark: -- execute the following on the coordinator node pgbench -c 20 -j 3 -T 60 -P 3 pgbench The results are not pretty.

Database 107

Database Benchmarking Latency C++ 107

Highly Scalable

MARCH 10, 2015

Recommender systems have been a subject of extremely intensive research during the last two decades, and books [JZ10, RR10] were written to provide a systematic view on dozens of recommendation algorithms and techniques suggested in numerous articles, presentations and whitepapers. For instance, this vector can contain product gross margins.

Retail 152

Retail C++ Analytics Metrics 152

Alex Russell

MAY 9, 2022

This blindspot usually extends up to the C-suite. They routinely benchmark against their competition on important flows and can understand when a competitor has taken the initiative to catch up (it rarely happens through a single commit or launch). miAi3020A9G #perfmatters 1 10:04 AM · Jul 7, 2016.

Performance 86

Performance Latency Metrics Engineering 86

John McCalpin

JANUARY 22, 2018

Dr. Damon McDougall gave a short presentation on this study at the IXPUG 2018 Fall Conference ( pdf ) — I originally wrote these notes to help organize my thoughts as we were preparing the IXPUG presentation, and later decided that the extra details contained here are interesting enough for me to post it.

Latency 40

Latency Hardware Code Testing 40

SQL Server According to Bob

JANUARY 11, 2020

​​ Because Microsoft must respond to changing market conditions, it should not be interpreted to be a commitment on the part of Microsoft, and Microsoft cannot guarantee the accuracy of any information presented after the date of publication. This White Paper is for informational purposes only.

Servers 40

Servers Cache Database Media 40

Smashing Magazine

JANUARY 6, 2020

Geekbench CPU performance benchmarks for the highest selling smartphones globally in 2019. We could offload computationally heavy tasks off to WebAssembly ( WASM ), a binary instruction format, designed as a portable target for compilation of high-level languages like C/C++/Rust. Plus, it’s even supported on Fastly’s edge cloud.

Performance 145

Performance Cache Network Metrics 145

Smashing Magazine

JANUARY 11, 2021

Geekbench CPU performance benchmarks for the highest selling smartphones globally in 2019. We could offload computationally heavy tasks off to WebAssembly ( WASM ), a binary instruction format, designed as a portable target for compilation of high-level languages like C/C++/Rust. compared to early 2015.

Performance 145

Performance Cache Media Metrics 145