Brendan Gregg

JUNE 30, 2018

A co-worker introduced me to Craig Hanson and Pat Crain's performance mantras, which neatly summarize much of what we do in performance analysis and tuning. These have inspired me to summarize another performance activity: evaluating benchmark accuracy. If the benchmark reported 20k ops/sec, you should ask: why not 40k ops/sec?

Benchmarking 54

Benchmarking Latency Cache Network 54

Percona

APRIL 7, 2023

If we were to select the most important MySQL setting, if we were given a freshly installed MySQL or Percona Server for MySQL and could only tune a single MySQL variable, which one would it be? The throughput didn’t double but increased by 57%. MySQL (B) 2517529 2610323 389048 5516900 194140 11523.48

Tuning 137

Tuning Cache Servers Benchmarking 137

Brendan Gregg

JUNE 29, 2018

A co-worker introduced me to Craig Hanson and Pat Crain's performance mantras, which neatly summarize much of what we do in performance analysis and tuning. These have inspired me to summarize another performance activity: evaluating benchmark accuracy. If the benchmark reported 20k ops/sec, you should ask: why not 40k ops/sec?

Benchmarking 40

Benchmarking Latency Cache Network 40

Percona

MARCH 23, 2023

Nowadays, solid-state drives (SSDs) or non-volatile memory express (NVMe) drives are preferred over traditional hard disk drives (HDDs) for database servers due to their faster read and write speeds, lower latency, and improved reliability. Benchmark before you decide. If you see concurrency issues, you can tune this variable.

Performance 127

Performance Hardware Tuning Storage 127

Brendan Gregg

SEPTEMBER 25, 2021

A Cassandra database cluster had switched to Ubuntu and noticed write latency increased by over 30%. There's also a test and println() in the loop to, hopefully, convince the compiler not to optimize-out an otherwise empty loop. This will slow this test a little.) Trying it out: centos$ time java TimeBench.

Speed 126

Speed Java AWS Virtualization 126

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 . uname -a Linux ubuntu19 5.3.0-rc3-custom

Benchmarking 63

Benchmarking Performance Hardware C++ 63

HammerDB

NOVEMBER 5, 2018

If you are new to running Oracle, SQL Server, MySQL and PostgreSQL TPC-C workloads with HammerDB and have needed to investigate I/O performance the chances are that you have experienced waits on writing to the Redo, Transaction Log or WAL depending on the database you are testing. SQL> alter system flush buffer_cache; System altered.

Benchmarking 40

Benchmarking Database C++ Virtualization 40

Brendan Gregg

SEPTEMBER 25, 2021

A Cassandra database cluster had switched to Ubuntu and noticed write latency increased by over 30%. There's also a test and println() in the loop to, hopefully, convince the compiler not to optimize-out an otherwise empty loop. This will slow this test a little.) include <sys/time.h>

Speed 40

Speed Java AWS Virtualization 40

IO River

NOVEMBER 15, 2023

Let's break down this Security Flywheel into its core components: ‍Research, Close Breaches, and Test. But hold your horses—before switching them to "block" mode, it's crucial to test them extensively. After you've researched, closed breaches, and tested, you start all over again. It's an ongoing, iterative process.

Traffic 52

Traffic Network Logistics Architecture 52

IO River

NOVEMBER 2, 2023

Let's break down this Security Flywheel into its core components: ‍Research, Close Breaches, and Test. But hold your horses—before switching them to "block" mode, it's crucial to test them extensively. After you've researched, closed breaches, and tested, you start all over again. It's an ongoing, iterative process.

Traffic 40

Traffic Network Logistics Architecture 40

John McCalpin

JANUARY 22, 2018

After almost four weeks, we have a solid characterization of the behavior — no tested code exceeds an execution rate of 12 vector pipe instructions every 7 cycles (6/7 of the nominal peak) when executed on a single core — but we are unable to propose a testable quantitative model for the source of the throughput limitation.

Latency 40

Latency Hardware Code Testing 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. InnoDB is the storage engine that will deliver the best OLTP throughput and should be chosen for this test. . HammerDB difference from Sysbench.

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 108

Database Benchmarking Latency C++ 108

SQL Server According to Bob

JANUARY 11, 2020

Pull-the-plug ​​ power ​​ outage testing ​​ Power outage testing ​​ is ​​ a fundamental and critical part of the administrator’s data safety and integrity requirements. ​​ Incorrect configurations lead to data loss.

Servers 40

Servers Cache Database Media 40

SQL Server According to Bob

JANUARY 11, 2020

Many high-end disk subsystems provide high-speed cache facilities to reduce the latency of read and write operations. For specific information on I/O tuning and balancing, you will find more details in the following document. Dirty Page Latency ​​ – A page is considered dirty when data modifications have taken place.

Servers 40

Servers Cache Media Hardware 40

John McCalpin

APRIL 25, 2023

I have a lot of historical data using my ReadOnly benchmark (as described in some of the earliest entries in this blog [link] A read-only access pattern removes the need to understand and explain the many complexities associated with the “streaming stores” typically used in the STREAM benchmark (e.g., Stay tuned!

Benchmarking 97

Benchmarking Cache Latency Tuning 97