John McCalpin

APRIL 25, 2023

Looking at sustained single-core bandwidth for a kernel composed of 100% reads, the trends for a large set of high-end AMD and Intel processors are shown in the figure below: So from 2010 to 2023, the sustainable single-core bandwidth increased by about 2x on Intel processors and about 5x on AMD processors. Details in the next blog entry.)

Benchmarking 97

Benchmarking Cache Latency Tuning 97

Brendan Gregg

MARCH 16, 2024

2005-2023: The winter of broken profilers However, the change was then applied to x86-64 (64-bit) as well, which had sixteen registers and didn't benefit so much from a seventeenth. 2023, 2024: Frame Pointers in Fedora and Ubuntu! The actual overhead depends on your workload. Others have reported around 1% and around 2%.

Java 145

Java Cache Google Hardware 145

Percona

MAY 1, 2023

This blog was originally published in August 2018 and was updated in May 2023. Key areas include: Configuration parameter tuning : This tuning involves altering variables such as memory allocation, disk I/O settings, and concurrent connections based on specific hardware and requirements. Why is PostgreSQL performance tuning important?

Tuning 52

Tuning Efficiency Database Performance 52

Percona

SEPTEMBER 1, 2023

This post was originally published in June 2020 and was updated in September 2023. This results in expedited query execution, reduced resource utilization, and more efficient exploitation of the available hardware resources. MySQL relies heavily on the availability of hardware resources to perform at its best.

Tuning 52

Tuning Database Performance Hardware 52

Alex Russell

JANUARY 30, 2024

HTML, CSS, images, and fonts can all be parsed and run at near wire speeds on low-end hardware, but JavaScript is at least three times more expensive, byte-for-byte. The multi-core performance gap between i-devices and budget Androids grew considerably, with the score delta rising from 4,318 points last year to 4,936 points in 2023.

Performance 90

Performance Network Mobile Speed 90

Percona

AUGUST 5, 2023

This blog was originally published in July 2017 and was updated in August 2023. This means that multiple partitions can be processed simultaneously, making better use of available hardware resources and further enhancing query performance. It’s a pretty common question around here, so let’s see what we can do about that.

Strategy 40

Strategy Storage Database Best Practices 40

Percona

JULY 1, 2023

This post was originally published in July 2018 and was updated in July 2023. Understanding DBaaS DBaaS cloud services allow users to use databases without configuring physical hardware and infrastructure or installing software. Doing extensive benchmarks will be the subject of a future blog post. Learn more here!

AWS 52

AWS Database Serverless Storage 52