Remove Benchmarking Remove Cache Remove Performance Testing Remove Tuning
article thumbnail

Impact of Data locality on DB workloads.

n0derunner

In this video I migrate a Postgres DB running PGbench benchmark. The variation in the transaction rate is due to the benchmark itself, the transaction rate is not expected to be uniform. Many different queries are executing in parallel, some hitting RAM cache, some hitting storage.

article thumbnail

KPTI/KAISER Meltdown Initial Performance Regressions

Brendan Gregg

In this post I'll look at the Linux kernel page table isolation (KPTI) patches that workaround Meltdown: what overheads to expect, and ways to tune them. Much of my testing was on Linux 4.14.11 Some older kernels have the KAISER patches for Meltdown, and so far the performance overheads look similar. and 4.14.12

Insiders

Sign Up for our Newsletter

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Trending Sources

article thumbnail

KPTI/KAISER Meltdown Initial Performance Regressions

Brendan Gregg

In this post I'll look at the Linux kernel page table isolation (KPTI) patches that workaround Meltdown: what overheads to expect, and ways to tune them. Much of my testing was on Linux 4.14.11 Some older kernels have the KAISER patches for Meltdown, and so far the performance overheads look similar. and 4.14.12

article thumbnail

SQL Server I/O Basics Chapter #1

SQL Server According to Bob

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 40
article thumbnail

Egnyte Architecture: Lessons learned in building and scaling a multi petabyte content platform

High Scalability

Edge caching. In general, Egnyte connect architecture shards and caches data at different levels based on: Amount of data. Nginx for disk based caching. We use different types of caching techniques depending on the problem statements. Disk based caching. Hybrid Sync. On prem data processing. Offline access.