Percona

JUNE 22, 2023

Defining high availability In general terms, high availability refers to the continuous operation of a system with little to no interruption to end users in the event of hardware or software failures, power outages, or other disruptions. If a primary server fails, a backup server can take over and continue to serve requests.

Availability 108

Availability Database Open Source Hardware 108

Percona

AUGUST 22, 2023

Streaming services, for example, run mission-critical systems in which excessive downtime could result in significant financial and reputational losses for the business. Topology management — This is the software management related specifically to the database and managing its ability to stay consistent in the event of a failure.

Availability 79

Availability Hardware Open Source Database 79

Scalegrid

JANUARY 25, 2024

Key metrics like throughput, request latency, and memory utilization are essential for assessing Redis health, with tools like the MONITOR command and Redis-benchmark for latency and throughput analysis and MEMORY USAGE/STATS commands for evaluating memory. offers the Software Watchdog specifically designed for this purpose.

Metrics 130

Metrics Monitoring Latency Cache 130

ACM Sigarch

OCTOBER 12, 2020

Programmers continue to write applications in them, and they continue to evolve: the just approved C++20 standard is the latest example. I suggest it’s long past time to move beyond C and SPEC benchmarks and our exclusive focus on “metal” languages. Despite their age, these languages are far from dead!

C++ 108

C++ Benchmarking Hardware Architecture 108

Percona

MARCH 27, 2023

A lot of useful information can be retrieved from this schema, for example, table metadata and foreign key relations, but trying to query I_S can induce performance degradation if your server is under heavy load, as shown in the following example test. You can read some optimization examples in the official doc: [link].

Cache 102

Cache Hardware Servers Benchmarking 102

HammerDB

NOVEMBER 22, 2021

This enables the user to compare and contrast performance across different benchmark scenarios. This example uses a PostgreSQL source based build with the pg_stat_statements extension found in the contrib directory. ./ -I/opt/postgresql-14.1/include/server Add the following example entries to the postgresql.conf.

Metrics 62

Metrics Benchmarking C++ Database 62

HammerDB

APRIL 19, 2023

Among the different components of modern software solutions, the database is one of the most critical. For example, if you are buying the latest Amazon memory-optimized EC2 instance (R7iz), the AWS page ( [link] ) tells us the following: Up to 3.9 For storage, FIO is generally used. Operating System: Ubuntu 22.04 4.22 %usr 38.40

Performance 54

Performance Benchmarking Cache Storage 54

The Morning Paper

MAY 23, 2019

So while you probably won’t be using Zippads in practice anytime soon, it’s a wonderful example of what’s possible when you’re prepared to take a fresh look at “the way we’ve always done things.” Consider a B-Tree node from the B-tree Java benchmark: Uncompressed, it’s memory layout looks like (a) below. Implications.

Cache 61

Cache Benchmarking Hardware Java 61

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. Basic Benchmarking Concepts.

Programming 67

Programming Benchmarking Virtualization C++ 67

Percona

JUNE 22, 2023

Let’s dive in and learn how (and what) to effectively monitor MySQL performance, along with examples from PMM, by understanding the critical KPIs to watch for. This is not an exhaustive list but an example of what we can watch for. This KPI is also directly related to Query Performance and helps improve it.

Performance 104

Performance Monitoring Traffic Database 104

Percona

SEPTEMBER 1, 2023

This results in expedited query execution, reduced resource utilization, and more efficient exploitation of the available hardware resources. This not only enhances performance but also enables you to make more efficient use of your hardware resources, potentially resulting in cost savings on infrastructure.

Tuning 52

Tuning Database Performance Hardware 52

HammerDB

DECEMBER 5, 2020

For example HammerDB has not used tpmC terminology to report TPC-C based metrics instead using TPM and NOPM nomenclature. A full understanding of why this is important requires some knowledge of the evolution of database hardware and software. This was both expensive and time consuming to configure. I.e. if system A generated 1.5X

C++ 40

C++ Benchmarking Virtualization Open Source 40

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. Background Sync.

Media 145

Media Games Education Engineering 145

Percona

AUGUST 30, 2018

Because recognizing if the workload is read intensive or write intensive will impact your hardware choices, database configuration as well as what techniques you can apply for performance optimization and scalability. Let’s examine the TPC-C Benchmark from this point of view, or more specifically its implementation in Sysbench.

Benchmarking 47

Benchmarking Database Operating System Architecture 47

Percona

JANUARY 19, 2023

Example (using the employee sample DB ): Suppose we have the following schema: db1 employees> show create table employeesG 1. Example: Creating four simple tables to store strings but using different data types: db1 test> CREATE TABLE tb1 (id int auto_increment primary key, test_text char(200)); Query OK, 0 rows affected (0.11

Open Source 88

Open Source Storage Database Big Data 88

Percona

JULY 1, 2023

Understanding DBaaS DBaaS cloud services allow users to use databases without configuring physical hardware and infrastructure or installing software. Doing extensive benchmarks will be the subject of a future blog post. In any case, you should benchmark both RDS MySQL and Aurora before taking the decision to migrate.

AWS 52

AWS Database Serverless Storage 52

Abhishek Tiwari

DECEMBER 27, 2017

Over last few years, we have seen several attempts to run data workload in the containers especially distributed big data frameworks like Apache Hadoop, Apache Storm [3] , and Apache Spark [4] [5] without any software modifications. Twitter Heron is another good example of this approach. optimised container networking and security.

Big Data 63

Big Data Storage Benchmarking Hardware 63

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. In the context of web development, performance testing entails using software tools to simulate how an application runs under specific circumstances.

Testing Tools 55

Testing Tools Best Practices Performance Testing Testing 55

The Morning Paper

MAY 14, 2019

Last time around we looked at the DeathStarBench suite of microservices-based benchmark applications and learned that microservices systems can be especially latency sensitive, and that hotspots can propagate through a microservices architecture in interesting ways. When available, it can use hardware level performance counters.

Big Data 45

Big Data Cloud Performance Hardware 45

SQL Server According to Bob

JANUARY 11, 2020

The following are examples of successful recovery situations actually encountered by Microsoft SQL Server Product Support Services personnel. Example 1: ​​ Hardware failure (CPU board) Battery backup on the caching controller maintained the data.

Servers 40

Servers Cache Media Hardware 40

HammerDB

OCTOBER 12, 2018

As with the previous guides as an Intel employee (#IAMINTEL) the examples are taken from a MySQL 8 on Linux on Intel system and the approach is the same for whatever system you are testing although some of the settings you see may be different. an example is shown of the shortest of these: . hardware limits: 1000 MHz - 3.80

Best Practices 40

Best Practices Scalability Performance C++ 40

John McCalpin

JANUARY 22, 2018

Introduction: In December 2017, my colleague Damon McDougall (now at AMD) asked for help in porting the fused multiply-add example code from a Colfax report ( [link] ) to the Xeon Phi x200 (Knights Landing) processors here at TACC. A peculiar throughput limitation on Intel’s Xeon Phi x200 (Knights Landing). cmpl $1000000000, %eax.

Latency 40

Latency Hardware Code Testing 40

Alex Russell

JANUARY 30, 2024

HTML, CSS, images, and fonts can all be parsed and run at near wire speeds on low-end hardware, but JavaScript is at least three times more expensive, byte-for-byte. Representative examples from that time period include the Samsung Galaxy A51 and the Pixel 4a. But that's not the whole story! 2:1] The A51 featured eight slow cores (4x2.3

Performance 90

Performance Network Mobile Speed 90

All Things Distributed

NOVEMBER 21, 2018

People often ask me if developing for the cloud is any different from developing on-premises software. In this post, I show some of the reasons why that's true, using the Amazon Redshift team and the approach they have taken to improve the performance of their data warehousing service as an example. Verifying benchmark claims.

Cloud 135

Cloud Benchmarking Performance AWS 135

SQL Server According to Bob

JANUARY 11, 2020

As ​​ a ​​ simple ​​ example, ​​ take the following ​​ 2-byte string value of “AB” and apply a formula to it (Value = Position + ASCII value). ​​ Checksum ​​ is ​​ the sum of the values.

Servers 40

Servers Cache Database Media 40

Smashing Magazine

JANUARY 6, 2020

Run performance experiments and measure outcomes — both on mobile and on desktop (for example, with Google Analytics ). Rather than focusing on full page loading time (via onLoad and DOMContentLoaded timings, for example), prioritize page loading as perceived by your customers. What does it mean? Large preview ).

Performance 145

Performance Cache Network Metrics 145

Smashing Magazine

JANUARY 11, 2021

For example, to make performance more tangible, you could expose the revenue performance impact by showing the correlation between the conversion rate and time to application load, as well as rendering performance. Run performance experiments and measure outcomes — both on mobile and on desktop (for example, with Google Analytics ).

Performance 145

Performance Cache Media Metrics 145

High Scalability

NOVEMBER 25, 2019

The dedicated Security team runs automated security benchmark tests before every release. How are software and hardware upgrades rolled out? More details on this are in this blog post Debugging Performance Issues in Distributed Systems. How do you handle security? Continuous automation pen tests are running in production.

Architecture 52

Architecture Cache Azure Storage 52