Benchmarking, Blog, Database and Hardware - Technology Performance Pulse

Why you should benchmark your database using stored procedures

HammerDB

OCTOBER 23, 2023

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.

Benchmarking

Benchmarking Database Network C++

How To Scale a Single-Host PostgreSQL Database With Citus

Percona

NOVEMBER 3, 2023

Rather than listing the concepts, function calls, etc, available in Citus, which frankly is a bit boring, I’m going to explore scaling out a database system starting with a single host. I won’t cover all the features but show just enough that you’ll want to see more of what you can learn to accomplish for yourself.

Database

Database Benchmarking Latency C++

The Ultimate Guide to Database High Availability

Percona

JUNE 22, 2023

To make data count and to ensure cloud computing is unabated, companies and organizations must have highly available databases. A basic high availability database system provides failover (preferably automatic) from a primary database node to redundant nodes within a cluster. HA is sometimes confused with “fault tolerance.”

Availability

Availability Database Open Source Hardware

PostgreSQL Performance Tuning: Optimizing Database Parameters for Maximum Efficiency

Percona

MAY 1, 2023

This blog was originally published in August 2018 and was updated in May 2023. It has default settings for all of the database parameters. It has default settings for all of the database parameters. Out of the box, the default PostgreSQL configuration is not tuned for any particular workload.

Tuning

Tuning Efficiency Database Performance

How to maximize CPU performance for PostgreSQL 12.0 benchmarks on Linux

HammerDB

OCTOBER 18, 2019

HammerDB doesn’t publish competitive database benchmarks, instead we always encourage people to be better informed by running their own. hardware limits: 1000 MHz - 4.00 hardware limits: 1000 MHz - 4.00 current CPU frequency: Unable to call hardware current CPU frequency: 1.00

Benchmarking

Benchmarking Performance Hardware C++

Crucial Redis Monitoring Metrics You Must Watch

Scalegrid

JANUARY 25, 2024

Redis® is an in-memory database that provides blazingly fast performance. This makes it a compelling alternative to disk-based databases when performance is a concern. Redis returns a big list of database metrics when you run the info command on the Redis shell. This blog post lists the important database metrics to monitor.

Metrics

Metrics Monitoring Latency Cache

InnoDB Performance Optimization Basics

Percona

MARCH 23, 2023

This blog is in reference to our previous ones for ‘Innodb Performance Optimizations Basics’ 2007 and 2013. Although there have been many blogs about adjusting MySQL variables for better performance since then, I think this topic deserves a blog update since the last update was a decade ago, and MySQL 5.7

Performance

Performance Hardware Tuning Storage

Aurora vs RDS: How to Choose the Right AWS Database Solution

Percona

JULY 1, 2023

Now that Database-as-a-service (DBaaS) is in high demand, there are multiple questions regarding AWS services that cannot always be answered easily: When should I use Aurora and when should I use RDS MySQL ? What we should really compare is the MySQL and Aurora database engines provided by Amazon RDS. How do I choose which one to use?

AWS

AWS Database Serverless Storage

High Availability vs. Fault Tolerance: Is FT’s 00.001% Edge in Uptime Worth the Headache?

Percona

AUGUST 22, 2023

Estimates vary, but most reports put the average cost of unplanned database downtime at approximately $300,000 to $500,000 per hour, or $5,000 to $8,000 per minute. With so much at stake, database high availability and fault tolerance have become must-have items, but many companies just aren’t certain which one they must have.

Availability

Availability Hardware Open Source Database

Impact of Querying Table Information From information_schema

Percona

MARCH 27, 2023

On MySQL and Percona Server for MySQL , there is a schema called information_schema (I_S) which provides information about database tables, views, indexes, and more. Disclaimer : This blog post is meant to show a less-known problem but is not meant to be a serious benchmark. Results for Percona Server for MySQL 8.0

Cache

Cache Hardware Servers Benchmarking

How to Assess MySQL Performance

HammerDB

APRIL 19, 2023

Among the different components of modern software solutions, the database is one of the most critical. In this blog, we aim to call out some key considerations when trying to assess MySQL performance for your application. Benchmarking the target Two of the more popular database benchmarks for MySQL are HammerDB and sysbench.

Performance

Performance Benchmarking Cache Storage

MySQL Key Performance Indicators (KPI) With PMM

Percona

JUNE 22, 2023

As a MySQL database administrator, keeping a close eye on the performance of your MySQL server is crucial to ensure optimal database operations. In this blog, we will explore various MySQL KPIs that are basic and essential to track using monitoring tools like PMM.

Performance

Performance Monitoring Traffic Database

Why MySQL Could Be Slow With Large Tables

Percona

JANUARY 19, 2023

16 years ago, our founder Peter Zaitsev covered this topic and some of the points described there are still valid, and we will cover more on this blog. In this blog post, we will review key topics to consider for managing large datasets more efficiently in MySQL. 1 mysql mysql 704M Dec 30 02:28 employees.ibd -rw-r --.

Open Source

Open Source Storage Database Big Data

The Speed of Time

Brendan Gregg

SEPTEMBER 25, 2021

A Cassandra database cluster had switched to Ubuntu and noticed write latency increased by over 30%. top(1) showed that only the Cassandra database was consuming CPU. As a Xen guest, this profile was gathered using perf(1) and the kernel's software cpu-clock soft interrupts, not the hardware NMI. But I'm not completely sure.

Speed

Speed Java AWS Virtualization

The Ultimate Guide to MySQL Partitions

Percona

AUGUST 5, 2023

This blog was originally published in July 2017 and was updated in August 2023. Partitioning is a way in which a database (MySQL in this case) splits its actual data down into separate tables but still gets treated as a single table by the SQL layer. Check out this blog to learn how to avoid disaster! Additionally, MySQL 8.0

Strategy

Strategy Storage Database Best Practices

Is Intel Doomed in the Server CPU Space?

SQL Performance

JULY 16, 2019

A close monitoring of the hardware enthusiast community, including many of the most respected hardware analysts and reviewers paints an even more dire picture about Intel in the server processor space. This made it easier for database professionals to make the case for a hardware upgrade, and made the typical upgrade more worthwhile.

Servers

Servers Hardware Architecture Retail

SQL Server 2016 – It Just Runs Faster: Always On Availability Groups Turbocharged

SQL Server According to Bob

SEPTEMBER 26, 2016

When we released Always On Availability Groups in SQL Server 2012 as a new and powerful way to achieve high availability, hardware environments included NUMA machines with low-end multi-core processors and SATA and SAN drives for storage (some SSDs). As we moved towards SQL Server 2014, the pace of hardware accelerated.

Availability

Availability Servers Hardware Benchmarking

Progress Delayed Is Progress Denied

Alex Russell

APRIL 29, 2021

As an engineer on a browser team, I'm privy to the blow-by-blow of various performance projects, benchmark fire drills, and the ways performance marketing (deeply) impacts engineering priorities. With each team, benchmarks lost are understood as bugs. is access to hardware devices. This is as it should be. Shape Detection.

Media

Media Games Education Engineering

The Speed of Time

Brendan Gregg

SEPTEMBER 25, 2021

A Cassandra database cluster had switched to Ubuntu and noticed write latency increased by over 30%. top(1) showed that only the Cassandra database was consuming CPU. As a Xen guest, this profile was gathered using perf(1) and the kernel's software cpu-clock soft interrupts, not the hardware NMI. But I'm not completely sure.

Speed

Speed Java AWS Virtualization

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

High Scalability

NOVEMBER 25, 2019

You can find more about these in the For The Techies section at our blog. Chokepoint : Even sharded Berkeley DB was choking under the stress and there was a database crash with recovery taking hours, it had to be replaced. Automate schema management for some remaining databases. Which database do you use? Cloud Platform.

Architecture

Architecture Cache Azure Storage

Technology Performance Pulse

Why you should benchmark your database using stored procedures

How To Scale a Single-Host PostgreSQL Database With Citus

Trending Sources

The Ultimate Guide to Database High Availability

PostgreSQL Performance Tuning: Optimizing Database Parameters for Maximum Efficiency

How to maximize CPU performance for PostgreSQL 12.0 benchmarks on Linux

Crucial Redis Monitoring Metrics You Must Watch

InnoDB Performance Optimization Basics

Aurora vs RDS: How to Choose the Right AWS Database Solution

High Availability vs. Fault Tolerance: Is FT’s 00.001% Edge in Uptime Worth the Headache?

Impact of Querying Table Information From information_schema

How to Assess MySQL Performance

MySQL Key Performance Indicators (KPI) With PMM

Why MySQL Could Be Slow With Large Tables

The Speed of Time

The Ultimate Guide to MySQL Partitions

Is Intel Doomed in the Server CPU Space?

SQL Server 2016 – It Just Runs Faster: Always On Availability Groups Turbocharged

Progress Delayed Is Progress Denied

The Speed of Time

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

Stay Connected