Benchmarking, Cache, Engineering and Virtualization

Why Tcl is 700% faster than Python for database benchmarking

HammerDB

JULY 5, 2022

Python is a popular programming language, especially for beginners, and consequently we see it occurring in places where it just shouldn’t be used, such as database benchmarking. We use stored procedures because, as the introductory post shows, using single SQL statements turns our database benchmark into a network test).

Benchmarking

Benchmarking Database C++ Virtualization

HammerDB for Managers

HammerDB

JUNE 27, 2022

HammerDB is a software application for database benchmarking. Databases are highly sophisticated software, and to design and run a fair benchmark workload is a complex undertaking. The Transaction Processing Performance Council (TPC) was founded to bring standards to database benchmarking, and the history of the TPC can be found here.

Benchmarking

Benchmarking Open Source C++ Cache

The Most Important MySQL Setting

Percona

APRIL 7, 2023

To illustrate this, I ran the Sysbench-TPCC synthetic benchmark against two different GCP instances running a freshly installed Percona Server for MySQL version 8.0.31 In MySQL, considering the standard storage engine, InnoDB , the data cache is called Buffer Pool. In PostgreSQL, it is called shared buffers.

Tuning

Tuning Cache Servers Benchmarking

How to Assess MySQL Performance

HammerDB

APRIL 19, 2023

Regardless of whether the computing platform to be evaluated is on-prem, containerized, virtualized, or in the cloud, it is crucial to consider several essential factors. Benchmarking the target Two of the more popular database benchmarks for MySQL are HammerDB and sysbench. For storage, FIO is generally used. 4.22 %usr 38.40

Performance

Performance Benchmarking Cache Storage

A MyRocks Use Case

Percona

DECEMBER 23, 2022

I wrote this post on MyRocks because I believe it is the most interesting new MySQL storage engine to have appeared over the last few years. The use case is the TPC-C benchmark but executed not on a high-end server but on a lower-spec virtual machine that is I/O limited like for example, with AWS EBS volumes.

Storage

Storage Cache C++ Virtualization

The Return of the Frame Pointers

Brendan Gregg

MARCH 16, 2024

Only in extreme circumstances does the cost (in processor time and I-cache footprint) translate to a tangible benefit - circumstances which usually resort to hand-coded assembly anyway. It shouldn't be 10%, unless it's cache effects. And for leaf routines (which never establish a frame), this is a non-issue.

Java

Java Cache Google Hardware

Static Analysis of Java Enterprise Applications: Frameworks and Caches, the Elephants in the Room

The Morning Paper

SEPTEMBER 24, 2020

Static analysis of Java enterprise applications: frameworks and caches, the elephants in the room , Antoniadis et al., Instead, analyses expect their users to provide customization for web applications, which is a significant burden, virtually never overcome in practice. PLDI’20. Introducing JackEE. JackEE in action.

Java

Java Cache Benchmarking Programming

Percona Monitoring and Management 2 Scaling and Capacity Planning

Percona

MARCH 17, 2023

PMM2 uses VictoriaMetrics (VM) as its metrics storage engine. Please note that the focus of these tests was around standard metrics gathering and display, we’ll use a future blog post to benchmark some of the more intensive query analytics (QAN) performance numbers. Virtual Memory utilization was averaging 48 GB of RAM.

Monitoring

Monitoring Scalability Cache Database

How to improve Redo, Transaction Log and WAL throughput for HammerDB benchmarks

HammerDB

NOVEMBER 5, 2018

This post at an entry-level discusses the options you have to improve log throughput in your benchmark environment. . The first example shows a data load, the second a TPC-C based workload with 5 virtual users and the 2nd example with 10 virtual users. To illustrate the data reads on Oracle we can flush the buffer cache.

Benchmarking

Benchmarking Database C++ Virtualization

The Ultimate Guide to Database High Availability

Percona

JUNE 22, 2023

High availability works through a combination of the following: No single point of failure (SPOF) : You must eliminate any single point of failure in the database environment, including physical or virtual hardware the database system relies on that would cause it to fail. Each node has its own cache buffer.)

Availability

Availability Database Open Source Hardware

Progress Delayed Is Progress Denied

Alex Russell

APRIL 29, 2021

Apple forces developers of competing browsers to use their engine for all browsers on iOS , restricting their ability to deliver a better version of the web platform. They are, pound for pound, some of the best engine developers globally and genuinely want good things for the web. With each team, benchmarks lost are understood as bugs.

Media

Media Games Education Engineering

KPTI/KAISER Meltdown Initial Performance Regressions

Brendan Gregg

FEBRUARY 9, 2018

Many thanks to the engineers working hard to develop workarounds to these processor bugs. This overhead can be reduced by A) pcid, fully available in Linux 4.14, and B) Huge pages. - **Cache access pattern**: the overheads are exacerbated by certain access patterns that switch from caching well to caching a little less well.

Performance

Performance Benchmarking Cache Tuning

KPTI/KAISER Meltdown Initial Performance Regressions

Brendan Gregg

FEBRUARY 8, 2018

Many thanks to the engineers working hard to develop workarounds to these processor bugs. This overhead can be reduced by A) pcid, fully available in Linux 4.14, and B) Huge pages. - **Cache access pattern**: the overheads are exacerbated by certain access patterns that switch from caching well to caching a little less well.

Performance

Performance Benchmarking Cache Tuning

Front-End Performance Checklist 2021

Smashing Magazine

JANUARY 11, 2021

Performance isn’t just a technical concern: it affects everything from accessibility to usability to search engine optimization, and when baking it into the workflow, design decisions have to be informed by their performance implications. Geekbench CPU performance benchmarks for the highest selling smartphones globally in 2019.

Performance

Performance Cache Media Metrics