Remove Benchmarking Remove Comparison 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

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

Scalegrid

In our final post, we will put them head-to-head in a detailed feature comparison and compare the results of PgBouncer vs. Pgpool-II performance for your PostgreSQL hosting ! PgBouncer provides a virtual database that reports various useful statistics. Throughput Benchmark. PostgreSQL Connection Pooling Series. Administration.

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

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. Note that Ubuntu also has a frame to show entry into vDSO (virtual dynamic shared object). How long is each time call? us on Centos and 0.68 us on Ubuntu.

Speed 126
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. Note that Ubuntu also has a frame to show entry into vDSO (virtual dynamic shared object). us on Centos and 0.68 us on Ubuntu. Ubuntu is 5x slower.

Speed 52
article thumbnail

The Most Important MySQL Setting

Percona

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 We have long been surfing the virtualization wave (to keep it broad). MySQL (B) 2517529 2610323 389048 5516900 194140 11523.48

Tuning 137
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. Note that Ubuntu also has a frame to show entry into vDSO (virtual dynamic shared object). us on Centos and 0.68 us on Ubuntu. Ubuntu is 5x slower.

Speed 40
article thumbnail

A Management Maturity Model for Performance

Alex Russell

This is a complex topic, but to borrow from a recent post , web performance expands access to information and services by reducing latency and variance across interactions in a session, with a particular focus on the tail of the distribution (P75+). Consistent performance matters just as much as low average latency.