HammerDB

APRIL 19, 2023

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. Benchmarking the target Two of the more popular database benchmarks for MySQL are HammerDB and sysbench.

Performance 54

Performance Benchmarking Cache Storage 54

Percona

MARCH 27, 2023

Disclaimer : This blog post is meant to show a less-known problem but is not meant to be a serious benchmark. The percentage in degradation will vary depending on many factors {hardware, workload, number of tables, configuration, etc.}. Setup The setup consists of creating 10K tables with sysbench and adding 20 FKs to 20 tables.

Cache 105

Cache Hardware Servers Benchmarking 105

Percona

JUNE 22, 2023

A monitoring tool like Percona Monitoring and Management (PMM) is a popular choice among open source options for effectively monitoring MySQL performance. In this blog, we will explore various MySQL KPIs that are basic and essential to track using monitoring tools like PMM.

Performance 107

Performance Monitoring Traffic Database 107

Percona

MAY 1, 2023

This blog was originally published in August 2018 and was updated in May 2023. In this blog post, we will delve into the world of PostgreSQL performance tuning and establish some basic guidelines for setting database parameters to enhance the performance of your PostgreSQL database, based on the workload.

Tuning 52

Tuning Efficiency Database Performance 52

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 91

Open Source Storage Database Big Data 91

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 127

Performance Hardware Tuning Storage 127

Percona

AUGUST 22, 2023

This blog article will examine shared attributes of high availability (HA) and fault tolerance (FT). We’ll wrap it up by suggesting high availability open source solutions, and we’ll introduce you to support options for ensuring continuous high performance from your systems. What does high availability mean?

Availability 80

Availability Hardware Open Source Database 80