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 83

Benchmarking Servers Tuning C++ 83

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 103

Database Benchmarking Latency C++ 103

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

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 123

Performance Hardware Tuning Storage 123

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

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 54

Performance Benchmarking Cache Storage 54

Dynatrace

OCTOBER 2, 2023

Because monolithic applications combine database, client-side interfaces, and server-side application elements in a single executable, they’re difficult to understand, even for their own administrators. Use SLAs, SLOs, and SLIs as performance benchmarks for newly migrated microservices.

Architecture 231

Architecture Artificial Intelligence Cloud Open Source 231

Dynatrace

APRIL 8, 2021

This means that there is no need to provision or manage servers (or even containers). These served as our benchmark when creating our Lambda monitoring extension. This means that, compared to running a regular web server, there are virtually no costs while users are not interacting with your site. Auto scaling. Failure retries.

Lambda 221

Lambda AWS Serverless Monitoring 221

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 99

Cache Hardware Servers Benchmarking 99

Adrian Cockcroft

JUNE 21, 2022

I became the Sun UK local specialist in performance and hardware, and as Sun transitioned from a desktop workstation company to sell high end multiprocessor servers I was helping customers find and fix scalability problems. This was followed by a greatly expanded second edition with some additional chapters by Rich Pettit.

Tuning 52

Tuning Benchmarking Engineering C++ 52

Dynatrace

APRIL 8, 2021

This means that there is no need to provision or manage servers (or even containers). These served as our benchmark when creating our Lambda monitoring extension. This means that, compared to running a regular web server, there are virtually no costs while users are not interacting with your site. Auto scaling. Failure retries.

Lambda 182

Lambda AWS Serverless Monitoring 182

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 171

Benchmarking Efficiency DevOps Tuning 171

Scalegrid

JULY 13, 2020

Compare ease of use across compatibility, extensions, tuning, operating systems, languages and support providers. The $47,500 licensing costs for Oracle Enterprise Edition is only for one CPU core, that ultimately has to be multiplied with the actual number of cores on the physical server. Compare Ease of Use.

Open Source 244

Open Source Tuning C++ Database 244

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 67

Programming Benchmarking Virtualization C++ 67

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 40

Database Tuning Performance AWS 40

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 79

Open Source Programming Database Servers 79

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

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 218

Lambda AWS Monitoring Serverless 218

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 126

Speed Java AWS Virtualization 126

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 86

Open Source Storage Database Big Data 86

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

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

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

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 75

Performance Benchmarking Cache Tuning 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 46

Benchmarking Database Operating System Architecture 46

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

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

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

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

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

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

Rigor

SEPTEMBER 11, 2019

Patrick is a London-based software developer who specializes in web performance and who describes himself as enjoying “working the entire stack, back-end to front-end, CDN to server.” The future of HTTP/2 server push. You can find him on Twitter @ patrickhamann or catch him on the speaker circuit. Billy Hoffman.

Performance 89

Performance Education Google Website 89

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