Percona

MAY 1, 2023

Key areas include: Configuration parameter tuning : This tuning involves altering variables such as memory allocation, disk I/O settings, and concurrent connections based on specific hardware and requirements. Slow queries and data retrieval can lead to frustrating delays that impact the user experience. Nobody has time for that!

Tuning 52

Tuning Efficiency Database Performance 52

The Morning Paper

MAY 14, 2019

Seer: leveraging big data to navigate the complexity of performance debugging in cloud microservices Gan et al., When a QoS violation is predicted to occur and a culprit microservice located, Seer uses a lower level tracing infrastructure with hardware monitoring primitives to identify the reason behind the QoS violation.

Big Data 45

Big Data Cloud Performance Hardware 45

The Morning Paper

MAY 27, 2019

Last week we saw the benefits of rethinking memory and pointer models at the hardware level when it came to object storage and compression ( Zippads ). The protections are hardware implemented and cannot be forged in software. At hardware reset the boot code is granted maximally permissive architectural capabilities.

C++ 61

C++ Hardware Virtualization Benchmarking 61

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. We had specializations in hardware, operating systems, databases, graphics, etc. that a lot of people used.

Tuning 52

Tuning Benchmarking Engineering C++ 52

HammerDB

DECEMBER 5, 2020

A full understanding of why this is important requires some knowledge of the evolution of database hardware and software. The HammerDB TPROC-C workload by design intended as CPU and memory intensive workload derived from TPC-C – so that we get to benchmark at maximum CPU performance at a much smaller database footprint.

C++ 40

C++ Benchmarking Virtualization Open Source 40

Percona

JANUARY 19, 2023

With disks being faster nowadays and CPU and memory resources being cheaper, we could easily say MySQL can handle TBs of data with good performance. For instance, in Percona Managed Services , we have many clients with TBs worth of data that are well performant. There are many compression tools and algorithms for data out there.

Open Source 93

Open Source Storage Database Big Data 93

Dynatrace

NOVEMBER 22, 2022

The nirvana state of system uptime at peak loads is known as “five-nines availability.” In its pursuit, IT teams hover over system performance dashboards hoping their preparations will deliver five nines—or even four nines—availability. But is five nines availability attainable? Downtime per year. 90% (one nine).

Infrastructure 178

Infrastructure Availability Systems Retail 178

Percona

JUNE 22, 2023

To make data count and to ensure cloud computing is unabated, companies and organizations must have highly available databases. This guide provides an overview of what high availability means, the components involved, how to measure high availability, and how to achieve it. More in the following sub-section.)

Availability 112

Availability Database Open Source Hardware 112

VoltDB

JULY 24, 2024

In this light, we are always seeking to prove Volt’s value against other data platforms for supporting applications that need to be fast without compromising on things like accuracy, consistency, or resiliency. As part of our new support for ARM processors , we recently ran benchmarks on both Intel C7 and ARM c7g on AWS.

AWS 52

AWS Benchmarking Hardware Latency 52

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. An interruption in data flow due to limited capacity is called a bottleneck. Test and collect data: Let your testing software do all the hard work, then assess the results.

Testing Tools 55

Testing Tools Best Practices Performance Testing Testing 55

Percona

AUGUST 22, 2023

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. This blog article will examine shared attributes of high availability (HA) and fault tolerance (FT). What does high availability mean?

Availability 84

Availability Hardware Open Source Database 84

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. Benchmark before you decide. Typically a good value is 70%-80% of available memory. have been released since then with some major changes.

Performance 130

Performance Hardware Tuning Storage 130

The Morning Paper

MAY 12, 2019

An open-source benchmark suite for microservices and their hardware-software implications for cloud & edge systems Gan et al., It’s a pretty impressive effort to pull together and make available in open source (not yet available as I write this) such a suite, and I’m sure explains much of the long list of 24 authors on this paper.

Open Source 61

Open Source Hardware Benchmarking Systems 61

Brendan Gregg

MARCH 16, 2024

It fails because of a compiler optimization where the frame pointer register is used to store data instead of the frame pointer, but it's just a number so the profiler is unaware this happened and tries to match that address to a function symbol and fails (it is therefore an unknown symbol). You usually get an extra junk frame.

Java 144

Java Cache Google Hardware 144

Scalegrid

DECEMBER 6, 2023

In the digital age, data management has transformed from locally hosted servers to cloud solutions. These databases require significant time commitment along with necessary technical skills plus hardware & software costs, all of which are without dedicated team assistance.

Database 130

Database Cloud Hardware Storage 130

HammerDB

JUNE 27, 2022

HammerDB is a software application for database benchmarking. It enables the user to measure database performance and make comparative judgements about database hardware and software. Databases are highly sophisticated software, and to design and run a fair benchmark workload is a complex undertaking. Supported Databases.

Benchmarking 62

Benchmarking Open Source C++ Cache 62

All Things Distributed

NOVEMBER 21, 2018

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. This yields hundreds of millions of data samples. Verifying benchmark claims.

Cloud 131

Cloud Benchmarking Performance AWS 131

HammerDB

OCTOBER 18, 2019

HammerDB doesn’t publish competitive database benchmarks, instead we always encourage people to be better informed by running their own. So over at Phoronix some database benchmarks were published showing PostgreSQL 12 Performance With AMD EPYC 7742 vs. Intel Xeon Platinum 8280 Benchmarks .

Benchmarking 63

Benchmarking Performance Hardware C++ 63

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

Alex Russell

APRIL 29, 2021

This post mines publicly available data on the pace of compatibility fixes and feature additions to assess the claim. 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.

Media 145

Media Games Education Engineering 145

Dynatrace

NOVEMBER 11, 2020

Dynatrace OneAgent deployment and life-cycle management are already widely considered to be industry benchmarks for reliability and efficiency. We’re now allowing for even easier OneAgent rollout by freeing up the /opt mount point from any runtime data that’s produced by OneAgents. Dynatrace news.

Best Practices 191

Best Practices Storage Java Benchmarking 191

ACM Sigarch

OCTOBER 12, 2020

An inte ger in Python consumes 24 bytes instead of 4 bytes (because every object carries around type information, reference counts, and more), while the overhead for data structures like lists or dictionaries can be 4x that of their C++ counterparts. There’s some work on hardware proposals for these systems, like Zhu et al.,

C++ 108

C++ Benchmarking Hardware Architecture 108

The Morning Paper

JUNE 11, 2019

Beyond data and model parallelism for deep neural networks Jia et al., Traditional approaches to training exploit either data parallelism (dividing up the training samples), model parallelism (dividing up the model parameters), or expert-designed hybrids for particular situations. SysML’2019. Expanding the search space.

Network 81

Network Strategy Hardware Benchmarking 81

HammerDB

FEBRUARY 25, 2021

HammerDB is a load testing and benchmarking application for relational databases. This helps to minimise locking allowing multiple sessions to access the same data at the same time. However, it is crucial that the benchmarking application does not have inherent bottlenecks that artificially limits the scalability of the database.

Programming 67

Programming Benchmarking Virtualization C++ 67

Speed Curve

MARCH 7, 2022

Size matters especially to mobile users who have limited and/or metered data. It's important to mention that there have been changes to how the Archive collects data over the years. Having said that, looking at data over the past ten years, it's safe to make the observation that pages are definitely trending bigger.

Mobile 145

Mobile Google Benchmarking Metrics 145

Percona

JULY 1, 2023

Understanding DBaaS DBaaS cloud services allow users to use databases without configuring physical hardware and infrastructure or installing software. These may be performance, high availability, operational cost, management, capacity planning, scalability, security, monitoring, etc.

AWS 52

AWS Database Serverless Storage 52

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 40

Availability Servers Hardware Benchmarking 40

Percona

AUGUST 5, 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. Each partition holds data that falls within a specific range, optimizing data handling and query speed. Each type caters to different data distribution needs.

Strategy 40

Strategy Storage Database Best Practices 40

The Morning Paper

JUNE 27, 2019

Systems researchers are doing an excellent job improving the performance of 5-year old benchmarks, but gradually making it harder to explore innovative machine learning research ideas. This comes at a cost though; copying, rearranging, and materialising to memory two orders of magnitude more data than is strictly necessary.

Systems 87

Systems Tuning Programming Innovation 87

Alex Russell

JANUARY 30, 2024

This split decision was available via last year's update , but was somewhat buried. Until and unless teams have better data about their performance, the global baseline budget should be enforced. Device Performance # Extending the SoC performance by price point series with another year's data, the picture remains ugly.

Performance 95

Performance Network Mobile Speed 95

Alex Russell

MARCH 6, 2021

Modern network performance and availability. Before Jio's disruptive pricing and aggressive rollout, data services in India were among the most expensive in the world relative to income and heavily reliant on 3G outside wealthier "tier 1" cities. Hardware Past As Performance Prologue. Here begins our 2021 adventure.

Performance 127

Performance Network Metrics Cache 127

SQL Server According to Bob

JANUARY 11, 2020

To ensure data integrity for our customers who are running SQL Server, it is important that I/O environments provide appropriate functionality. Atomicity A transaction must be an atomic unit of work; either all of its data modifications are performed or none of them are performed.

Servers 40

Servers Cache Media Hardware 40

Alex Russell

OCTOBER 22, 2017

This rework delays launch which, in turn, delays gathering data about the viability of a PWA strategy. Budgets are scaled to a benchmark network & device. Any DOM or UI created in JS is not available for use until the script runs. Deciding what benchmark to use for a performance budget is crucial. Global Ground-Truth.

Performance 72

Performance Benchmarking Network Mobile 72

HammerDB

OCTOBER 12, 2018

As is also the case this limitation is at the database level (especially the storage engine) rather than the hardware level. 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. large-pages.

Best Practices 40

Best Practices Scalability Performance C++ 40

ACM Sigarch

OCTOBER 25, 2018

While throughput performance is important, especially in data-centers, single threaded performance remains a pivotal metric for a large swath of application domains (HPC, Finance etc.). Studies have demonstrated that current generation OOO architectures extract significantly less ILP than is available in the programs.

Architecture 67

Architecture Technology Technology Innovation 67

John McCalpin

JANUARY 22, 2018

For 64-bit floating-point data, the 512-bit Fused Multiply-Add (FMA) instructions performs 16 floating-point operations (8 adds and 8 multiplies). Published DGEMM benchmark results for the Xeon Phi 7250 processor ( [link] ) show maximum values of about 2100 GFLOPS when using all 68 cores (a very approximate estimate from a bar chart).

Latency 40

Latency Hardware Code Testing 40

Percona

NOVEMBER 3, 2023

When it comes to Citus, successfully building out and scaling a PostgreSQL cluster across multiple nodes and even across data centers can feel, at times, to be an art form because there are so many ways of building it out. The following invocation generates almost 4GB of data.

Database 108

Database Benchmarking Latency C++ 108