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

SQL Performance

NOVEMBER 18, 2019

Migrating an on-premises SQL Server instance to an Azure Virtual Machine (VM) is a common method to migrate to Azure. IT professionals are familiar with scoping the size of VMs with regards to vCPU, memory, and storage capacity. Microsoft has helped simplify things by creating multiple types of virtual machines. Generation.

Azure 76

Azure Benchmarking Storage Virtualization 76

Percona

DECEMBER 23, 2022

I wrote this post on MyRocks because I believe it is the most interesting new MySQL storage engine to have appeared over the last few years. 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. Conclusion.

Storage 55

Storage Cache C++ Virtualization 55

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

Percona

MARCH 17, 2023

PMM2 uses VictoriaMetrics (VM) as its metrics storage engine. 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.

Monitoring 101

Monitoring Scalability Cache Database 101

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 138

Tuning Cache Servers Benchmarking 138

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

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

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 work includes changes to the CHERI ISA, the C compiler, the C language runtime, the virtual memory APIs, and the CheriBSD kernel. ASPLOS’19. slower to 9.8% PostgreSQL runs 6.8%

C++ 61

C++ Hardware Virtualization Benchmarking 61

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. faster access to external storage and data locality (I/O, bandwidth). Kubernetes has all necessary primitives available to make it happen. Performance.

Big Data 63

Big Data Storage Benchmarking Hardware 63

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

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

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. Fsync Performance on Storage Devices. Interested?

Database 40

Database Tuning Performance AWS 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. Higher is better.

Media 145

Media Games Education Engineering 145

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. InnoDB is the storage engine that will deliver the best OLTP throughput and should be chosen for this test. . GHz available cpufreq governors: performance powersave . HammerDB difference from Sysbench.

Best Practices 40

Best Practices Scalability Performance C++ 40

ScaleOut Software

MAY 15, 2014

For example, the IMDG must be able to efficiently create millions of objects in each server to make use of its huge storage capacity. These are areas in which we have invested heavily to take advantage of 10 Gbps (and faster) networks and to handle intermittent network delays inherent in virtual server infrastructures.

Cache 40

Cache Servers Network Design 40

SQL Server According to Bob

JANUARY 11, 2020

Stable Media Stable media is often confused with physical storage. SQL Server defines stable media as storage that can survive system restart or common failure. Stable media is commonly physical disk storage, but other devices and certain caching facilities qualify as well. These systems must maintain support for I/O ordering.

Servers 40

Servers Cache Media Hardware 40

SQL Server According to Bob

JANUARY 11, 2020

​​ The storage ​​ space that is required ​​ for the sparse file is only that of the actual bytes written to the file and not the ​​ maximum ​​ file ​​ size.

Servers 40

Servers Cache Database Media 40

Smashing Magazine

JANUARY 11, 2021

Usually, the most specific and relevant ones are: Time to Interactive (TTI) The point at which layout has stabilized , key webfonts are visible, and the main thread is available enough to handle user input — basically the time mark when a user can interact with the UI. Large preview ). compared to early 2015. How often is it the case?

Performance 145

Performance Cache Media Metrics 145