Benchmarking, Cache, Code and Virtualization - Technology Performance Pulse

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

The Return of the Frame Pointers

Brendan Gregg

MARCH 16, 2024

Apart from library code, maybe your application doesn't have frame pointers either, in which case everything is broken. 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.

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., Being static , it has the advantage that analysis results can be produced solely from source code without the need to execute the program. PLDI’20. Enterprise applications have (more than?) Introducing JackEE.

Java

Java Cache Benchmarking Programming

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

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

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. I decided to use a virtual machine with two CPU cores, four GB of memory, and storage limited to a maximum of 1000 IOPs of 16KB. . <iotune>

Storage

Storage Cache C++ Virtualization

Understanding MySQL Triggers: Exploring How Triggers Impact MySQL Memory Allocation

Percona

SEPTEMBER 1, 2023

Per-Row Execution : For each affected row, the trigger’s code is executed. This code can include SQL statements, procedures, or other actions defined within the trigger. Access to OLD and NEW Values : Within the trigger code, you can access the OLD and NEW values for each column of the current row.

Cache

Cache Database Games Healthcare

AppFabric Caching: Retry Later

ScaleOut Software

MAY 15, 2014

We have spent a great deal of time at ScaleOut Software re-architecting our in-memory data grid (IMDG)’s code base to make best use of many cores and large memory. During load-balancing, the client gets the following exception when accessing the cache: ErrorCode<ERRCA0017>:SubStatus<ES0006>:There is a temporary failure.

Cache

Cache Servers Network Design

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

KPTI/KAISER Meltdown Initial Performance Regressions

Brendan Gregg

FEBRUARY 9, 2018

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. virtual (bgregg-c5.9xl-i-xxx) 02/09/2018 _x86_64_ (36 CPU) 05:24:51 PM proc/s cswch/s.

Performance

Performance Benchmarking Cache Tuning

Front-End Performance Checklist 2021

Smashing Magazine

JANUARY 11, 2021

Have we optimized enough with tree-shaking, scope hoisting, code-splitting, and all the fancy loading patterns with intersection observer, progressive hydration, clients hints, HTTP/3, service workers and — oh my — edge workers? It’s much easier to reach performance goals when the code base is fresh or is just being refactored.

Performance

Performance Cache Media Metrics

Progress Delayed Is Progress Denied

Alex Russell

APRIL 29, 2021

As an engineer on a browser team, I'm privy to the blow-by-blow of various performance projects, benchmark fire drills, and the ways performance marketing (deeply) impacts engineering priorities. With each team, benchmarks lost are understood as bugs. All modern browsers are fast, Chromium and Safari/WebKit included. Keyboard Lock API.

Media

Media Games Education Engineering

KPTI/KAISER Meltdown Initial Performance Regressions

Brendan Gregg

FEBRUARY 8, 2018

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. virtual (bgregg-c5.9xl-i-xxx) 02/09/2018 _x86_64_ (36 CPU) 05:24:51 PM proc/s cswch/s.

Performance

Performance Benchmarking Cache Tuning

SQL Server I/O Basics Chapter #1

SQL Server According to Bob

JANUARY 11, 2020

Stable media is commonly physical disk storage, but other devices and certain caching facilities qualify as well. Many high-end disk subsystems provide high-speed cache facilities to reduce the latency of read and write operations. This cache is often supported by a battery-powered backup facility.

Servers

Servers Cache Media Hardware