Percona

MARCH 23, 2023

Hardware Memory The amount of RAM to be provisioned for database servers can vary greatly depending on the size of the database and the specific requirements of the company. Some servers may need a few GBs of RAM, while others may need hundreds of GBs or even terabytes of RAM. Benchmark before you decide.

Performance 130

Performance Hardware Tuning Storage 130

Dynatrace

MARCH 25, 2022

“We were able to … fine-tune our systems in a very performant way,” notes Hood. “And now that we don’t need to babysit the servers, engineers can work on real-life problems they want to solve for our customers.” “Our brain, the source of that knowledge, was the information coming from Dynatrace.”

Benchmarking 182

Benchmarking Efficiency DevOps Tuning 182

The Morning Paper

MARCH 10, 2020

Characterizing, modeling, and benchmarking RocksDB key-value workloads at Facebook , Cao et al., Or in the case of key-value stores, what you benchmark. So if you want to design a system that will offer good real-world performance, it’s really useful to have benchmarks that accurately represent real-world workloads.

Benchmarking 59

Benchmarking Storage Cache Open Source 59

Dynatrace

FEBRUARY 25, 2021

When we set out to create the new Lambda extension, we benchmarked other dedicated Lambda monitoring solutions that were already on the market. Lambda functions are often used as back ends for static, single-page applications, and many customers asked for the same level of insights they get when running Dynatrace against a regular web server.

Lambda 231

Lambda AWS Monitoring Serverless 231

Percona

MAY 1, 2023

Out of the box, the default PostgreSQL configuration is not tuned for any particular workload. It is primarily the responsibility of the database administrator or developer to tune PostgreSQL according to their system’s workload. What is PostgreSQL performance tuning? Why is PostgreSQL performance tuning important?

Tuning 52

Tuning Database Efficiency Performance 52

Brendan Gregg

JUNE 30, 2018

A co-worker introduced me to Craig Hanson and Pat Crain's performance mantras, which neatly summarize much of what we do in performance analysis and tuning. These have inspired me to summarize another performance activity: evaluating benchmark accuracy. If the benchmark reported 20k ops/sec, you should ask: why not 40k ops/sec?

Benchmarking 47

Benchmarking Latency Cache Network 47

Percona

NOVEMBER 3, 2023

PostgreSQL Cluster One coordinator node citus-coord-01 Three worker nodes citus1 citus2 citus3 Hardware AWS Instance Ubuntu Server 20.04, SSD volume type 64-bit (x86) c5.xlarge And now, execute the benchmark: -- execute the following on the coordinator node pgbench -c 20 -j 3 -T 60 -P 3 pgbench The results are not pretty.

Database 110

Database Benchmarking Latency C++ 110

Percona

JANUARY 2, 2024

Two setups running in cluster mode: one in MariaDB+Galera and one with Percona XtraDB Cluster (Percona Server+Galera). We decided to run a few benchmarks to understand how the thread pool affects long-running transactions. For this reason, I’ve set up a server with the following specs: r6a.2xlarge

Benchmarking 91

Benchmarking Servers Tuning C++ 91

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 5.7

Cache 109

Cache Hardware Servers Benchmarking 109

Percona

SEPTEMBER 1, 2023

While there is no magic bullet for MySQL performance tuning, there are a few areas that can be focused on upfront that can dramatically improve the performance of your MySQL installation. What are the Benefits of MySQL Performance Tuning? A finely tuned database processes queries more efficiently, leading to swifter results.

Tuning 52

Tuning Database Performance Hardware 52

Brendan Gregg

JUNE 29, 2018

A co-worker introduced me to Craig Hanson and Pat Crain's performance mantras, which neatly summarize much of what we do in performance analysis and tuning. These have inspired me to summarize another performance activity: evaluating benchmark accuracy. If the benchmark reported 20k ops/sec, you should ask: why not 40k ops/sec?

Benchmarking 40

Benchmarking Latency Cache Network 40

HammerDB

JANUARY 5, 2019

Some opinions claim that “Benchmarks are meaningless”, “benchmarks are irrelevant” or “benchmarks are nothing like your real applications” However for others “Benchmarks matter,” as they “account for the processing architecture and speed, memory, storage subsystems and the database engine.”

Benchmarking 40

Benchmarking Database Social Media Scalability 40

HammerDB

DECEMBER 10, 2024

tpmC tpmC is the transactions per minute metric that is the measurement of the official TPC-C benchmark from the TPC-Council. Without exception, TPC-C and tpmC can only be used for official audited TPC-C benchmarks published here by the TPC-Council. Why this would be the case is straightforward.

C++ 58

C++ Benchmarking Hardware Performance 58

High Scalability

AUGUST 24, 2021

SysOps Enginee r: As Kinsta ’s SysOps Engineer, you’ll play a key role in caring for the health of our servers, preventing issues, and responding immediately to mitigate any problems in our infrastructure. No more hassles of benchmarking and tuning algorithms or building and maintaining infrastructure for vector search.

Education 100

Education DevOps Infrastructure Benchmarking 100

High Scalability

OCTOBER 27, 2021

SysOps Enginee r: As Kinsta ’s SysOps Engineer, you’ll play a key role in caring for the health of our servers, preventing issues, and responding immediately to mitigate any problems in our infrastructure. No more hassles of benchmarking and tuning algorithms or building and maintaining infrastructure for vector search.

Education 100

Education DevOps Infrastructure Benchmarking 100

High Scalability

SEPTEMBER 29, 2021

SysOps Enginee r: As Kinsta ’s SysOps Engineer, you’ll play a key role in caring for the health of our servers, preventing issues, and responding immediately to mitigate any problems in our infrastructure. No more hassles of benchmarking and tuning algorithms or building and maintaining infrastructure for vector search.

Education 100

Education DevOps Infrastructure Benchmarking 100

High Scalability

SEPTEMBER 15, 2021

SysOps Enginee r: As Kinsta ’s SysOps Engineer, you’ll play a key role in caring for the health of our servers, preventing issues, and responding immediately to mitigate any problems in our infrastructure. No more hassles of benchmarking and tuning algorithms or building and maintaining infrastructure for vector search.

Education 100

Education DevOps Infrastructure Benchmarking 100

HammerDB

FEBRUARY 25, 2021

HammerDB is a load testing and benchmarking application for relational databases. However, it is crucial that the benchmarking application does not have inherent bottlenecks that artificially limits the scalability of the database. Basic Benchmarking Concepts. To benchmark a database we introduce the concept of a Virtual User.

Programming 68

Programming Benchmarking Virtualization C++ 68

HammerDB

APRIL 19, 2023

GHz 4th Generation Intel Xeon Scalable processors (code-named Sapphire Rapids) Up to 20% higher compute performance than z1d instances Up to 50 Gbps of networking speed Up to 40 Gbps of bandwidth to the Amazon Elastic Block Store (EBS) We can also verify these capabilities by running some simple benchmarks on the different subsystems.

Performance 55

Performance Benchmarking Cache Storage 55

Brendan Gregg

SEPTEMBER 25, 2021

This server is spending about a third of its CPU cycles just checking the time! I love short benchmarks like this as I can disassemble the resulting binary and ensure that the compiled instructions match my expectations, and the compiler hasen't messed with it. ## 6. 30.14% in the middle of the flame graph. include <sys/time.h>

Speed 103

Speed Java AWS Virtualization 103

Percona

APRIL 12, 2023

Whereas many open source software offerings — like the community version of MySQL — use the GNU General Public License ( GPL ), MongoDB has been under the GNU Affero General Public License ( AGPL ) and more recently under the Server Side Public License ( SSPL ), introduced by MongoDB itself. Is MongoDB free to use?

Open Source 86

Open Source Programming Database Servers 86

Brendan Gregg

FEBRUARY 9, 2018

In this post I'll look at the Linux kernel page table isolation (KPTI) patches that workaround Meltdown: what overheads to expect, and ways to tune them. I then analyzed performance during the benchmark ([active benchmarking]), and used other benchmarks to confirm findings. Much of my testing was on Linux 4.14.11

Performance 72

Performance Benchmarking Cache Tuning 72

Percona

DECEMBER 20, 2018

Linux OS Tuning for MySQL Database Performance. In this post we will review the most important Linux settings to adjust for performance tuning and optimization of a MySQL database server. We’ll note how some of the Linux parameter settings used OS tuning may vary according to different system types: physical, virtual or cloud.

Database 41

Database Tuning Performance AWS 41

Percona

JANUARY 19, 2023

There are a couple of blog posts from Yves that describe and benchmark MySQL compression: Compression Options in MySQL (Part 1) Compression Options in MySQL (Part 2) Archive or purge old or non-used data: Some companies have to retain data for multiple years either for compliance or for business requirements.

Open Source 95

Open Source Storage Database Big Data 95

HammerDB

NOVEMBER 5, 2018

If you are new to running Oracle, SQL Server, MySQL and PostgreSQL TPC-C workloads with HammerDB and have needed to investigate I/O performance the chances are that you have experienced waits on writing to the Redo, Transaction Log or WAL depending on the database you are testing. A good example of how tuning is an iterative process.

Benchmarking 40

Benchmarking Database C++ Virtualization 40

Rigor

JANUARY 13, 2020

In her book, Lara Hogan helps you approach projects with page speed in mind, showing you how to test and benchmark which design choices are most critical. Podjarny presents a series of increasingly larger-scope solutions to each issue, including client-side techniques and RESS (Responsive + Server Side). Web Performance Tuning.

Performance 75

Performance Social Media Website Website Performance 75

Percona

AUGUST 30, 2018

Let’s examine the TPC-C Benchmark from this point of view, or more specifically its implementation in Sysbench. The illustrations below are taken from Percona Monitoring and Management (PMM) while running this benchmark. Analyzing read/write workload by counts. Analyzing Read/Write Workload by Response Time.

Benchmarking 49

Benchmarking Database Operating System Architecture 49

SQL Server According to Bob

JANUARY 11, 2020

Microsoft SQL Server I/O Basics Author: ​​ Bob Dorr, Microsoft SQL Server Escalation Published: ​​ December, 2004 SUMMARY: ​​ Learn the I/O requirements for Microsoft SQL Server database file operations. This will help you increase system performance and avoid I/O environment errors.

Servers 40

Servers Cache Media Hardware 40

KeyCDN

AUGUST 15, 2019

Before you begin tuning your website or application, you must first figure out which metrics matter most to your users and establish some achievable benchmarks. Bottlenecks can occur, for example, if you have a sudden surge in traffic that your servers are not equipped to handle. What is Performance Testing?

Testing Tools 55

Testing Tools Best Practices Performance Testing Testing 55

Brendan Gregg

FEBRUARY 8, 2018

In this post I'll look at the Linux kernel page table isolation (KPTI) patches that workaround Meltdown: what overheads to expect, and ways to tune them. I then analyzed performance during the benchmark ([active benchmarking]), and used other benchmarks to confirm findings. Much of my testing was on Linux 4.14.11

Performance 40

Performance Benchmarking Cache Tuning 40

O'Reilly

JULY 25, 2023

Similarly, it taught me that “Background scripts are ideal for handling long-term or ongoing tasks, managing state, maintaining databases, and communicating with remote servers. Perhaps future AI tool developers could use Swift Papers as a benchmark to assess how well their tool performs on an example real-real-world programming task.

Programming 98

Programming Code Design Benchmarking 98

IO River

NOVEMBER 15, 2023

Two of them are particularly gnarly: fine-tuning rules to perfection and managing a WAF over a multi-CDN architecture. A horde of compromised computers overwhelms a server, rendering it incapable of handling legitimate requests.In Let's dive deep into these challenges.‍1.

Traffic 52

Traffic Network Logistics Architecture 52

Brendan Gregg

SEPTEMBER 25, 2021

This server is spending about a third of its CPU cycles just checking the time! I love short benchmarks like this as I can disassemble the resulting binary and ensure that the compiled instructions match my expectations, and the compiler hasen't messed with it. ## 7. 30.14% in the middle of the flame graph. include <sys/time.h>

Speed 40

Speed Java AWS Virtualization 40

IO River

NOVEMBER 2, 2023

Two of them are particularly gnarly: fine-tuning rules to perfection and managing a WAF over a multi-CDN architecture. A horde of compromised computers overwhelms a server, rendering it incapable of handling legitimate requests.In Let's dive deep into these challenges.‍1.

Traffic 40

Traffic Network Logistics Architecture 40

HammerDB

OCTOBER 12, 2018

For anyone benchmarking MySQL with HammerDB it is important to understand the differences from sysbench workloads as HammerDB is targeted at a testing a different usage model from sysbench. Download and install HammerDB on a test client system, Like PostgreSQL another 2 socket server is ideal. HammerDB difference from Sysbench.

Best Practices 40

Best Practices Scalability Performance C++ 40

Percona

AUGUST 5, 2023

KEY partitioning KEY partitioning is similar to HASH partitioning, except that only one or more columns to be evaluated are specified, and the MySQL server provides its own hashing function. This helps identify potential issues and fine-tune the partitioning strategy. Documentation : Always be documenting!

Strategy 40

Strategy Storage Database Best Practices 40

SQL Server According to Bob

JANUARY 11, 2020

Microsoft, ​​ Windows, ​​ Windows NT, ​​ and Windows Server ​​ are registered trademarks of Microsoft Corporation in the United States and/or other countries. The names of actual companies and products mentioned herein may be the trademarks of their respective owners.

Servers 40

Servers Cache Database Media 40