Remove Benchmarking Remove Database Remove Latency Remove Virtualization
article thumbnail

Why you should benchmark your database using stored procedures

HammerDB

HammerDB uses stored procedures to achieve maximum throughput when benchmarking your database. HammerDB has always used stored procedures as a design decision because the original benchmark was implemented as close as possible to the example workload in the TPC-C specification that uses stored procedures. On MySQL, we saw a 1.5X

article thumbnail

Virtual consensus in Delos

The Morning Paper

Virtual consensus in Delos , Balakrishnan et al. If you think of this a bit like mapping memory addresses to data in memory, then another parallel comes to mind: the virtual address space. We propose the novel abstraction of a virtual shared log (or VirtualLog). Facebook, Inc. ), OSDI’2020. What does the VirtualLog give us?

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

PostgreSQL Connection Pooling: Part 4 – PgBouncer vs. Pgpool-II

Scalegrid

PgBouncer defines one pool per user+database combination. A client benefits from a pooled connection only if it connects to a child which has previously served a connection for this database+user combination. PgBouncer allows limiting connections per-pool, per-database, per-user or per-client. Throughput Benchmark.

article thumbnail

What Is a Workload in Cloud Computing

Scalegrid

Simply put, it’s the set of computational tasks that cloud systems perform, such as hosting databases, enabling collaboration tools, or running compute-intensive algorithms. This applies to both virtual machines and container-based deployments. What is workload in cloud computing?

Cloud 130
article thumbnail

How to maximize CPU performance for PostgreSQL 12.0 benchmarks on Linux

HammerDB

HammerDB doesn’t publish competitive database benchmarks, instead we always encourage people to be better informed by running their own. So what jumps out immediately here is the comment “The single-threaded PostgreSQL 12 performance was most surprising.” hardware limits: 1000 MHz - 4.00

article thumbnail

AMD EPYC Processors in Azure Virtual Machines

SQL Performance

Back on December 5, 2017, Microsoft announced that they were using AMD EPYC 7551 processors in their storage-optimized Lv2-Series virtual machines. Both of these Intel processors are special bespoke models that are not in the Intel ARK database. Figure 1: CPU-Z Benchmark Results for LS16v2. Figure 2: Microsoft Project Olympus.

Azure 42
article thumbnail

The Speed of Time

Brendan Gregg

A Cassandra database cluster had switched to Ubuntu and noticed write latency increased by over 30%. CLI tools The Cassandra systems were EC2 virtual machine (Xen) instances. top(1) showed that only the Cassandra database was consuming CPU. What on Earth is Ubuntu doing that results in 30% higher CPU time!? ## 1.

Speed 126