Percona

DECEMBER 23, 2022

The use case is the TPC-C benchmark but executed not on a high-end server but on a lower-spec virtual machine that is I/O limited like for example, with AWS EBS volumes. I decided to use a virtual machine with two CPU cores, four GB of memory, and storage limited to a maximum of 1000 IOPs of 16KB.

Storage 55

Storage Cache C++ Virtualization 55

HammerDB

DECEMBER 5, 2020

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. For TPC-C this meant enough available spindles to reduce I/O latency and for TPC-H enough bandwidth for data throughput.

C++ 40

C++ Benchmarking Virtualization Open Source 40

Percona

MARCH 17, 2023

Please note that the focus of these tests was around standard metrics gathering and display, we’ll use a future blog post to benchmark some of the more intensive query analytics (QAN) performance numbers. Virtual Memory utilization was averaging 48 GB of RAM. Virtual Memory utilization was averaging 48 GB of RAM.

Monitoring 97

Monitoring Scalability Cache Database 97

Percona

APRIL 12, 2023

Let’s start with this: MongoDB is accurately referred to as source-available software. Though still not “profitable” by many benchmarks, it’s a lot closer to being so, perhaps in a big way.) MongoDB is commonly referred to as source-available software. 2017: MongoDB goes public, trading as MDB.

Open Source 79

Open Source Programming Database Servers 79

The Morning Paper

MAY 27, 2019

The work includes changes to the CHERI ISA, the C compiler, the C language runtime, the virtual memory APIs, and the CheriBSD kernel. On a context switch the kernel saves and restores user-thread register capability state, and updates virtual-physical mappings. For a macro-benchmark PostgreSQL’s initdb tool was used.

C++ 61

C++ Hardware Virtualization Benchmarking 61

Adrian Cockcroft

JUNE 21, 2022

Another big jump, but now it was my job to run benchmarks in the lab, and write white papers that explained the new products to the world, as they were launched. I was mostly coding in C, tuning FORTRAN, and when I needed to do a lot of data analysis of benchmark results used the S-PLUS statistics language, that is the predecessor to R.

Tuning 52

Tuning Benchmarking Engineering C++ 52

The Morning Paper

NOVEMBER 8, 2020

Virtual consensus in Delos , Balakrishnan et al. USENIX is a nonprofit organisation committed to making content and research freely available – both conference proceedings and the recorded presentations of their events. We propose the novel abstraction of a virtual shared log (or VirtualLog). Facebook, Inc. ), OSDI’2020.

Virtualization 126

Virtualization Latency Storage Systems 126

Apica

MAY 10, 2019

The Apica LoadTest solution uses innovative technologies like monitoring nodes and load clusters to reliably deliver and sustain a large-scale load of virtual users (VUs) to Hollywood for different, realistic user scenarios all at the same time. Load and stress-testing benchmark goals for the backend technological components.

Testing 40

Testing Performance Social Media Wireless 40

Abhishek Tiwari

DECEMBER 27, 2017

Containerized data workloads running on Kubernetes offer several advantages over traditional virtual machine/bare metal based data workloads including but not limited to. Kubernetes has all necessary primitives available to make it happen. better cluster resource utilization. portability between cloud and on-premises. Performance.

Big Data 63

Big Data Storage Benchmarking Hardware 63

HammerDB

JULY 5, 2022

Python is a popular programming language, especially for beginners, and consequently we see it occurring in places where it just shouldn’t be used, such as database benchmarking. We use stored procedures because, as the introductory post shows, using single SQL statements turns our database benchmark into a network test).

Benchmarking 98

Benchmarking Database C++ Virtualization 98

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. How does high availability work?

Availability 105

Availability Database Open Source Hardware 105

Percona

DECEMBER 20, 2018

We’ll note how some of the Linux parameter settings used OS tuning may vary according to different system types: physical, virtual or cloud. In this benchmark, I discovered some interesting discrepancies in performance between AMD and Intel CPUs when running under systemd. A Look at MyRocks Performance.

Database 40

Database Tuning Performance AWS 40

SQL Performance

DECEMBER 17, 2019

One important choice you will still have to make is what type and size of Azure virtual machine you want to use for your existing SQL Server workload. Microsoft currently has eight main types of virtual machines designed for different types of workloads. Azure VM Types and Series.

Azure 72

Azure Virtualization Servers Storage 72

Scalegrid

JULY 29, 2020

This is shared between all clients, so a pooled connection is available to all clients. High availability. PostgreSQL high availability is supported through Pgpool-II in-built watcher processes. Not supported – PgBouncer recommends use of HAProxy for high availability and load balancing. When are connections reused?

Benchmarking 246

Benchmarking Database Performance Testing Availability 246

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 77

Availability Hardware Open Source Database 77

HammerDB

JUNE 27, 2022

HammerDB is a software application for database benchmarking. Databases are highly sophisticated software, and to design and run a fair benchmark workload is a complex undertaking. The Transaction Processing Performance Council (TPC) was founded to bring standards to database benchmarking, and the history of the TPC can be found here.

Benchmarking 62

Benchmarking Open Source C++ Cache 62

Smashing Magazine

JUNE 3, 2022

And today, we still have type in a digital context, but it travels through cables, wirelessly on smartphones, and in virtual reality glasses in 3D. There are many typefaces, and many of them are very similar or are nearly identical to previous or contemporary versions available. There are many different classifications of typefaces.

Performance 110

Performance Design Best Practices Testing 110

Scalegrid

JANUARY 12, 2024

Various forms can take shape when discussing workloads within the realm of cloud computing environments – examples include order management databases, collaboration tools, videoconferencing systems, virtual desktops, and disaster recovery mechanisms. This applies to both virtual machines and container-based deployments.

Cloud 130

Cloud Virtualization Storage Efficiency 130

Dynatrace

SEPTEMBER 23, 2021

Unfortunately, container security is much more difficult to achieve than security for more traditional compute platforms, such as virtual machines or bare metal hosts. Many good security tools provide that function, and benchmarks from the Center for Internet Security (CIS) are clear and prescriptive. Why is container security tricky?

Open Source 250

Open Source Benchmarking Best Practices Network 250

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

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

Brendan Gregg

SEPTEMBER 25, 2021

CLI tools The Cassandra systems were EC2 virtual machine (Xen) instances. Note that Ubuntu also has a frame to show entry into vDSO (virtual dynamic shared object). Checking those available: $ cat /sys/devices/system/clocksource/clocksource0/available_clocksource. This was much worse many years ago on Xen virtual machine guests.

Speed 126

Speed Java AWS Virtualization 126

Brendan Gregg

MARCH 16, 2024

This technique saves two instructions in the prologue and epilogue and makes one additional general-purpose register (%rbp) available." It was also a virtual machine that lacked low-level hardware profiling capabilities, so I wasn't able to do cycle analysis to confirm that the 10% was entirely frame pointer-based.

Java 145

Java Cache Google Hardware 145

SQL Performance

APRIL 8, 2019

Back on December 5, 2017, Microsoft announced that they were using AMD EPYC 7551 processors in their storage-optimized Lv2-Series virtual machines. These VMs are not available in all regions, so you will want to check the availability in the Azure region that you are interested in using. Figure 2: Microsoft Project Olympus.

Azure 42

Azure Virtualization Storage Benchmarking 42

HammerDB

DECEMBER 14, 2022

The scripts are available in both Python and Tcl formats. and the test will run with the number of Virtual Users equivalent to the number of CPUs. Benchmark set to TPC-C for MariaDB. Building 20 Warehouses with 5 Virtual Users, 4 active + 1 Monitor VU(dict value maria_num_vu is set to 4). ALL VIRTUAL USERS COMPLETE.

C++ 62

C++ Virtualization Database Benchmarking 62

Percona

APRIL 7, 2023

To illustrate this, I ran the Sysbench-TPCC synthetic benchmark against two different GCP instances running a freshly installed Percona Server for MySQL version 8.0.31 MySQL comes pre-configured to be conservative instead of making the most of the resources available in the server. MySQL (B) 2517529 2610323 389048 5516900 194140 11523.48

Tuning 133

Tuning Cache Servers Benchmarking 133

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. Higher is better.

Media 145

Media Games Education Engineering 145

Brendan Gregg

SEPTEMBER 25, 2021

CLI tools The Cassandra systems were EC2 virtual machine (Xen) instances. Note that Ubuntu also has a frame to show entry into vDSO (virtual dynamic shared object). Over the years, more and more articles have been published about clocksource in virtual machines, and it's now a well-known issue.

Speed 52

Speed Java AWS Virtualization 52

Brendan Gregg

SEPTEMBER 25, 2021

CLI tools The Cassandra systems were EC2 virtual machine (Xen) instances. Note that Ubuntu also has a frame to show entry into vDSO (virtual dynamic shared object). Over the years, more and more articles have been published about clocksource in virtual machines, and it's now a well-known issue.

Speed 40

Speed Java AWS Virtualization 40

Dynatrace

FEBRUARY 25, 2021

To handle N parallel requests, N Lambda instances need to be available, and AWS will spin up up to 1000 such instances automatically to handle 1000 parallel requests. A cold start occurs when there’s no instance of the requested Lambda function available. The virtual CPU is turned off.

Lambda 218

Lambda AWS Monitoring Serverless 218

HammerDB

NOVEMBER 30, 2018

HammerDB is open source and all of the source code is available at the sourceforge Git development site here [link] or the github mirror here [link]. As virtual users are started the database specific packages and workload specific modules are loaded into the virtual user threads. Virtual Users. program in TCL. #!/usr/local/bin/tclsh8.6

Architecture 40

Architecture Virtualization Open Source C++ 40

HammerDB

DECEMBER 9, 2020

<benchmark> <first_result>TPM</first_result> </benchmark> So why not just print NOPM and report a single metric for TPROC-C as per the official TPC-C workloads? and earlier. <benchmark> The fix to this was to move to a newer ODBCv3 interface called tdbc::odbc.

C++ 52

C++ Benchmarking Metrics Database 52

n0derunner

JUNE 28, 2019

One of the nice things about using public cloud is the ability to use pre-canned application virtual appliances created by companies like Bitnami. We can use these same appliance images on Nutanix AHV to easily do a Postgres database benchmark. Importing OVAs direct into AHV should be available in the future. wget [link].

Benchmarking 40

Benchmarking C++ Virtualization Database 40

Rigor

FEBRUARY 19, 2020

Synthetic monitoring is one of the best ways to detect outages or availability issues since it actively tests your site from the outside. Is it a physical system or virtual? If virtualized, what is the technology used (VM, Docker, software package)? Competitive & Industry Benchmarking. And BOOM, you’re done!

Monitoring 59

Monitoring Benchmarking Mobile Traffic 59

Brendan Gregg

FEBRUARY 9, 2018

This overhead can be reduced by A) pcid, fully available in Linux 4.14, and B) Huge pages. - **Cache access pattern**: the overheads are exacerbated by certain access patterns that switch from caching well to caching a little less well. virtual (bgregg-c5.9xl-i-xxx) 02/09/2018 _x86_64_ (36 CPU) 05:24:51 PM proc/s cswch/s. Linux 4.14.12-virtual

Performance 75

Performance Benchmarking Cache Tuning 75

SQL Performance

AUGUST 27, 2019

The initial reviews and benchmarks for these processors have been very impressive: AMD EPYC 7002 Series Rome Delivers a Knockout. AMD Rome Second Generation EPYC Review: 2x 64-core Benchmarked. TPC-H Benchmark Results with SQL Server 2017. TPC-E Benchmark Results with SQL Server 2017. Preferred AMD EPYC Processors.

Servers 52

Servers Benchmarking Virtualization Architecture 52