The Morning Paper

SEPTEMBER 27, 2020

It’s common knowledge that the IEEE standard floating point number representations used in modern computers have their quirks, for example not being able to accurately represent numbers such as 1/3, or 0.1. PARSEC is a set of benchmarks for multi-threaded programs. is a set of benchmarks for parallel computing developed by NASA.

Benchmarking 101

Benchmarking Hardware Programming Code 101

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 98

Cache Hardware Servers Benchmarking 98

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

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. Verifying benchmark claims. Optimizing performance for bursts of user activity.

Cloud 135

Cloud Benchmarking Performance AWS 135

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. Derived Workloads.

Benchmarking 62

Benchmarking Open Source C++ Cache 62

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. have been released since then with some major changes. I hope this helps!

Performance 123

Performance Hardware Tuning Storage 123

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. Fault tolerance refers to the ability of a database system to continue functioning in full, with no downtime, amid hardware or software failures.

Availability 77

Availability Hardware Open Source Database 77

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 104

Availability Database Open Source Hardware 104

The Morning Paper

NOVEMBER 3, 2019

For example: “Red Hat and Suse normally required 6-18 months to optimise the performance an an upstream Linux kernel before it can be released as an enterprise distribution”, and. A micro-benchmark suite, LEBench was then built around tee system calls responsible for most of the time spent in the kernel. Measuring the kernel.

Performance 108

Performance Benchmarking Tuning Hardware 108

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

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 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. and 8.0.32

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

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 102

Performance Monitoring Traffic Database 102

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

SQL Performance

DECEMBER 17, 2019

This removes the burden of purchasing and maintaining your hardware, storage and networking infrastructure, while still giving you a very familiar experience with Windows and SQL Server itself. BTW, the "i" in the Standard_E64is_v3 naming means that the instance is isolated to hardware dedicated to a single customer.

Azure 72

Azure Virtualization Servers Storage 72

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

Speed Curve

MARCH 7, 2022

These numbers should not be taken as a benchmark for your own site. You can see this by looking at the synthetic test result for Sears.com (again, available via our Industry Benchmarks ). Amazon is a good example of a site that serves large, fast pages. Don't assume hardware and networks will mitigate page bloat.

Mobile 145

Mobile Benchmarking Google Metrics 145

The Morning Paper

JUNE 11, 2019

FlexFlow is also given a device topology graph describing all the available hardware devices and their interconnections. For example: An overall parallelization strategy defines a parallelization configuration for each operator in the graph. For example, suppose we reduce the parallelism of operator o3 down to 1.

Network 81

Network Strategy Hardware Benchmarking 81

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

SQL Performance

AUGUST 27, 2019

It will also use less power than a two-socket Intel server, with a lower hardware cost, and potentially lower licensing costs (for things like VMware). Figure 1 shows an example from AMD comparing a two-socket server with two Intel Xeon Gold 6262V processors to a one-socket server with one AMD EPYC 7702P processor.

Servers 52

Servers Benchmarking Virtualization Architecture 52

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 85

Open Source Storage Database Big Data 85

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 46

Benchmarking Database Operating System Architecture 46

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. Take a simple example: it would be really nice if we could have named dimensions instead of always having to work with indices. a research paper.

Systems 87

Systems Tuning Programming Innovation 87

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 5, 2023

This means that multiple partitions can be processed simultaneously, making better use of available hardware resources and further enhancing query performance. For example, when querying a large table for specific date ranges, partitioning allows the engine to scan only relevant partitions containing data within those ranges.

Strategy 40

Strategy Storage Database Best Practices 40

Abhishek Tiwari

DECEMBER 27, 2017

A recent performance benchmark completed by Intel and BlueData using the BigBench benchmarking kit has shown that the performance ratios for container-based Hadoop workloads on BlueData EPIC are equal to and in some cases, better than bare-metal Hadoop [7]. Twitter Heron is another good example of this approach. Performance.

Big Data 63

Big Data Storage Benchmarking Hardware 63

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

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

Alex Russell

MARCH 6, 2021

The Moto G4 , for example. Hardware Past As Performance Prologue. Using a global ASP as a benchmark can further mislead thanks to the distorting effect of ultra-high-end prices rising while shipment volumes stagnate. But the hardware future is not evenly distributed, and web workloads aren't heavily parallel.

Performance 124

Performance Network Cache Metrics 124

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

Speed Curve

JULY 3, 2023

These numbers should not be taken as a benchmark for your own site. Amazon is a good example of a site that serves large, fast pages, as you can see in this recent look at our Retail Page Speed Benchmarks : In the waterfall chart for this test run , you can see why the Amazon home page ranks fastest for Start Render.

Mobile 52

Mobile Google Metrics Retail 52

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

SQL Server According to Bob

AUGUST 23, 2021

For example: A memory node with 64 CPUs is a complete, O perating System, ​​ scheduler group. The decision is performance driven. ​​ A memory node represents the memory associated with a group of CPUs from the physical hardware. For this example, assume the host machine is single node, 8 CPU system.

Servers 40

Servers Azure Operating System Database 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

Alex Russell

OCTOBER 22, 2017

Budgets are scaled to a benchmark network & device. If our example document wasn’t reliant on JavaScript to construct the <my-app> custom element, the contents of the document would likely be interactive as soon as enough CSS and content was available to render meaningfully. Construction of DOM. Global Ground-Truth.

Performance 68

Performance Benchmarking Network Mobile 68

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