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. I wrote about using CPU-Z to benchmark the Intel Xeon E5-2673 v3 processor in an Azure VM in this article. Figure 1: CPU-Z Benchmark Results for LS16v2. SQL Server Impact.

Azure 42

Azure Virtualization Storage Benchmarking 42

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 56

Storage Cache C++ Virtualization 56

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

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

HammerDB

DECEMBER 1, 2022

Jobs Configuration and Storage. The base configuration for the jobs storage can be found in the generic.xml file in the commandline section. <commandline> If the storage of job related data is not desired, then it is possible to disable/enable this feature with the jobs disable command. Use a different Browser.

Virtualization 57

Virtualization C++ Storage Database 57

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

HammerDB

DECEMBER 14, 2022

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). in host REDPOLL:3306 under user ROOT in database TPCC with storage engine INNODB?

C++ 62

C++ Virtualization Database Benchmarking 62

HammerDB

NOVEMBER 5, 2018

This post at an entry-level discusses the options you have to improve log throughput in your benchmark environment. . The first example shows a data load, the second a TPC-C based workload with 5 virtual users and the 2nd example with 10 virtual users. innodb_flush_log_at_trx_commit=0. PostgreSQL.

Benchmarking 40

Benchmarking Database C++ Virtualization 40

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 In MySQL, considering the standard storage engine, InnoDB , the data cache is called Buffer Pool. We have long been surfing the virtualization wave (to keep it broad).

Tuning 136

Tuning Cache Servers Benchmarking 136

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. more transactions than system B in the fully audited benchmark then the HammerDB result was also 1.5X I.e. if system A generated 1.5X

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

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. More total PCIe lanes and bandwidth.

Servers 52

Servers Benchmarking Virtualization Architecture 52

Percona

JUNE 22, 2023

High availability works through a combination of the following: No single point of failure (SPOF) : You must eliminate any single point of failure in the database environment, including physical or virtual hardware the database system relies on that would cause it to fail. there cannot be high availability.

Availability 109

Availability Database Open Source Hardware 109

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). Storage provisioning. But Kubernetes storage is evolving quite quickly.

Big Data 63

Big Data Storage Benchmarking Hardware 63

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

Percona

AUGUST 22, 2023

Some of the most important elements include: No single point of failure (SPOF): You must eliminate any SPOF in the database environment, including any potential for an SPOF in physical or virtual hardware. Without enough infrastructure (physical or virtualized servers, networking, etc.), there cannot be high availability.

Availability 80

Availability Hardware Open Source Database 80

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. . Error in Virtual User 1: mysqlexec/db server: Table 'mysql.proc' doesn't exist.

Best Practices 40

Best Practices Scalability Performance C++ 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. Chrome has missed several APIs for 3+ years: Storage Access API.

Media 145

Media Games Education Engineering 145

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

​​ 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

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. See the article for more details. SQL Server 7.0

Servers 40

Servers Cache Media Hardware 40

Smashing Magazine

JANUARY 11, 2021

Geekbench CPU performance benchmarks for the highest selling smartphones globally in 2019. To optimize storage interally, you could use Dropbox’s new Lepton format for losslessly compressing JPEGs by an average of 22%. Faster devices on faster networks have virtually no stalls. compared to early 2015. Large preview ).

Performance 145

Performance Cache Media Metrics 145