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

Percona Monitoring and Management 2 Scaling and Capacity Planning

Percona

Percona’s co-Founder Peter Zaitsev wrote a detailed post about migration from Prometheus to VictoriaMetrics , One of the most significant differences in terms of performance of PMM2 comes with the usage for VM, which can also be derived from performance comparison on node_exporter metrics between Prometheus and VictoriaMetrics.

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

Percona Database Performance Blog 2018 Year in Review: Top Blog Posts

Percona

I found the comparison of InnoDB vs. MyISAM quite interesting, and I’ll use it in this post. We’ll note how some of the Linux parameter settings used OS tuning may vary according to different system types: physical, virtual or cloud. It feels a bit like people are telling me “Why do you use InnoDB? A Look at MyRocks Performance.

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 ! This is shared between all clients, so a pooled connection is available to all clients. High availability. PostgreSQL Connection Pooling Series.

article thumbnail

HammerDB for Managers

HammerDB

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.

article thumbnail

The Speed of Time

Brendan Gregg

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). As I'm interested in the relative comparison I can just compare the total runtimes (the "real" time) for the same result. How long is each time call? us on Ubuntu.

Speed 126
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 MySQL comes pre-configured to be conservative instead of making the most of the resources available in the server. MySQL (B) 2517529 2610323 389048 5516900 194140 11523.48

Tuning 137