Percona

DECEMBER 20, 2023

Modern servers operate with terabytes of RAM, and by default, processors work with virtual memory address translation for each 4KB page. OS maintains a huge list of allocated and free pages to make slow but reliable address translation from virtual to physical. Huge pages make PostgreSQL faster; can we implement it in Kubernetes?

C++ 96

C++ Virtualization Benchmarking Database 96

HammerDB

OCTOBER 24, 2023

by @krithikasatish and @JoshInnis to provide accelerated load performance for both SQL Server TPROC-C and TPROC-H schemas. Summary The new Use BCP Option for SQL Server accelerates both TPROC-C and TPROC-H schema loads, so you can get to running your benchmarks faster. With the default for v4.9 to have this feature enabled.

Servers 62

Servers C++ Benchmarking Virtualization 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. Microsoft has helped simplify things by creating multiple types of virtual machines. High performance compute – Fastest and most powerful CPU virtual machines. Benchmark Test. VM Types and Sizes.

Azure 76

Azure Benchmarking Storage Virtualization 76

HammerDB

APRIL 27, 2021

This will show the benchmark options dialog. Benchmark Options. and benchmark set with the bm argument. In the example below we have modified the SQL Server, number of warehouses to build and the virtual users to build them. A key aspect is being able to visualise the multithreaded nature of the Virtual Users.

Virtualization 73

Virtualization Benchmarking Database Operating System 73

Smashing Magazine

JUNE 3, 2022

Measuring The Performance Of Typefaces For Users (Part 1). Measuring The Performance Of Typefaces For Users (Part 1). How well does a typeface work and perform against another similar typeface? Reasons To Measure The Performance Of Typefaces? Measuring Typefaces And The Resulting Performance Data. Thomas Bohm.

Performance 110

Performance Design Best Practices Testing 110

HammerDB

NOVEMBER 22, 2021

Introducing the PostgreSQL performance metrics viewer. HammerDB included a graphical performance metrics view for the Oracle database only. This enables the user to compare and contrast performance across different benchmark scenarios. The example shows a TPROC-C workload running with 4 Active Virtual Users.

Metrics 62

Metrics Benchmarking C++ Database 62

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. MyRocks Vs InnoDB.

Storage 55

Storage Cache C++ Virtualization 55

Percona

MARCH 17, 2023

These updates are designed to keep databases running at peak performance and simplify database operations. But as companies grow and see more demand for their databases, we need to ensure that PMM also remains scalable so you don’t need to worry about its performance while tending to the rest of your environment.

Monitoring 97

Monitoring Scalability Cache Database 97

n0derunner

MARCH 7, 2019

I use the “built in” benchmark pgbench to run a simple set of queries. Since I am interested in only the gains from hugepages I chose to use the “-S” parameter to pgbench which means perform only the “select” statements. The goal was to see what gains can be made from using hugepages.

Performance 40

Performance Benchmarking C++ Virtualization 40

Apica

MAY 10, 2019

The spread of where consumers want to consume content, at home, at the office, at the gym, on a plane, at any time where there is connectivity, puts significant pressure on the network and performance monitoring teams for streaming brands. Consumers will leave you for slow or intermittent performance because there are other content options.

Testing 40

Testing Performance Social Media Wireless 40

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. Fully audited configurations would require multiple racks of I/O capacity to reach maximum CPU performance.

C++ 40

C++ Benchmarking Virtualization Open Source 40

HammerDB

NOVEMBER 30, 2022

Vuser 1:1 Active Virtual Users configured Vuser 1:TEST RESULT : System achieved 39945 NOPM from 92893 SQL Server TPM Vuser 1:Gathering timing data from Active Virtual Users. Running this script returns output as follows using the Python loop to drive HammerDB. Vuser 2:FINISHED SUCCESS Vuser 1:Calculating timings.

Virtualization 44

Virtualization C++ Lambda Monitoring 44

Percona

DECEMBER 20, 2018

Let’s look at some of the most popular Percona Database Performance Blog posts in 2018. With the Percona Database Performance Blog, Percona staff and leadership work hard to provide the open source community with insights, technical support, predictions and metrics around multiple open source database software technologies.

Database 40

Database Tuning Performance AWS 40

The Morning Paper

MAY 27, 2019

The basic question here is whether it is practical to support a large-scale C-language software stack with strong pointer-based protection… with only modest changes to existing C code-bases and with reasonable performance cost. That ‘reasonable’ performance cost is a 6.8% For a macro-benchmark PostgreSQL’s initdb tool was used.

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. Rich became co-author of the second edition of the Sun Performance Tuning book, to describe how it worked.

Tuning 52

Tuning Benchmarking Engineering C++ 52

Testsigma

JANUARY 12, 2021

Even though most of the web browsers adhere to the Open Web Standards and render HTML, CSS, and JavaScript, it does not guarantee constant performance throughout browsers. If an app ill-performs due to browser or viewport – the user experience is severely hampered. What Is Covered Under Cross Browser Compatibility Testing?

Website 65

Website Benchmarking Operating System Testing Tools 65

The Morning Paper

NOVEMBER 8, 2020

Virtual consensus in Delos , Balakrishnan et al. While ultimately this new system should be able to take advantage of the latest advances in consensus for improved performance, that’s not realistic given a 6-9 month in-production target. We propose the novel abstraction of a virtual shared log (or VirtualLog).

Virtualization 126

Virtualization Latency Storage Systems 126

Percona

APRIL 12, 2023

Though still not “profitable” by many benchmarks, it’s a lot closer to being so, perhaps in a big way.) We are really pleased with our Q1 performance and see it as continued validation of the massive market we are pursuing, our strong product market fit, and our ability to execute.”

Open Source 79

Open Source Programming Database Servers 79

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

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. overall performance comparable to bare metal. Performance. better cluster resource utilization. portability between cloud and on-premises. Native frameworks.

Big Data 63

Big Data Storage Benchmarking Hardware 63

VoltDB

JUNE 1, 2017

It was – like the hypothetical movie I describe above – more than a little bit odd, as you could leave a session discussing ever more abstract layers of virtualization and walk into one where they emphasized the critical importance of pinning a network interface to a specific VM for optimal performance.

Hardware 56

Hardware Latency Virtualization Cloud 56

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. Hopefully, they will do that in the future. Conclusion.

Azure 72

Azure Virtualization Servers Storage 72

VoltDB

JUNE 1, 2017

It was – like the hypothetical movie I describe above – more than a little bit odd, as you could leave a session discussing ever more abstract layers of virtualization and walk into one where they emphasized the critical importance of pinning a network interface to a specific VM for optimal performance.

Hardware 40

Hardware Latency Virtualization Cloud 40

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 . 3834 2696 .

Benchmarking 63

Benchmarking Performance Hardware C++ 63

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

Scalegrid

JULY 29, 2020

In our final post, we will put them head-to-head in a detailed feature comparison and compare the results of PgBouncer vs. Pgpool-II performance for your PostgreSQL hosting ! PgBouncer provides a virtual database that reports various useful statistics. Performance Testing. Throughput Benchmark. Part 2 – PgBouncer.

Benchmarking 246

Benchmarking Database Performance Testing Availability 246

Scalegrid

JANUARY 12, 2024

Simply put, it’s the set of computational tasks that cloud systems perform, such as hosting databases, enabling collaboration tools, or running compute-intensive algorithms. This applies to both virtual machines and container-based deployments. What is workload in cloud computing?

Cloud 130

Cloud Virtualization Storage Efficiency 130

Brendan Gregg

MARCH 16, 2024

I'm sure this delivered large performance improvements and I wouldn't try arguing against it. While that Java change led to discovering countless performance wins in application code, libc was still breaking some portion of the samples (as pictured in the example at the top of this post) and preventing off-CPU flame graphs.

Java 145

Java Cache Google Hardware 145

HammerDB

FEBRUARY 25, 2021

HammerDB is a load testing and benchmarking application for relational databases. On high-performance multi-core systems all the supported databases can return performance in the many millions of transactions per minute. Basic Benchmarking Concepts. To benchmark a database we introduce the concept of a Virtual User.

Programming 67

Programming Benchmarking Virtualization C++ 67

Brendan Gregg

SEPTEMBER 25, 2021

These strange questions came to the fore back in 2014 when Netflix was switching services from CentOS Linux to Ubuntu, and I helped debug several weird performance issues including one I'll describe here. A quick check of basic performance statistics showed over 30% higher CPU consumption. How would you _time_ time?

Speed 126

Speed Java AWS Virtualization 126

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

Brendan Gregg

FEBRUARY 9, 2018

The recently revealed [Meltdown and Spectre] bugs are not just extraordinary issues of security, but also performance. The patches that workaround Meltdown introduce the largest kernel performance regressions I've ever seen. Some older kernels have the KAISER patches for Meltdown, and so far the performance overheads look similar.

Performance 75

Performance Benchmarking Cache Tuning 75

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

JULY 6, 2023

This way is typically the fastest way to determine the maximum throughput of a database with minimal configuration, and over time has been proven to show the same performance ratios between systems as a well configured fixed throughput setup. Again, each virtual user we add is running at approximately 1 NOPM.

Virtualization 57

Virtualization C++ Database Code 57

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. The AMD EPYC 7551 processor has slightly lower single-threaded CPU performance when compared to the older 2.3 Figure 1: CPU-Z Benchmark Results for LS16v2.

Azure 42

Azure Virtualization Storage Benchmarking 42

HammerDB

NOVEMBER 5, 2018

If you are new to running Oracle, SQL Server, MySQL and PostgreSQL TPC-C workloads with HammerDB and have needed to investigate I/O performance the chances are that you have experienced waits on writing to the Redo, Transaction Log or WAL depending on the database you are testing. Logging Waits.

Benchmarking 40

Benchmarking Database C++ Virtualization 40

HammerDB

DECEMBER 14, 2022

database with Docker installed, so we are going to use Docker to pull the HammerDB image and run the test scripts to measure the database performance. and the test will run with the number of Virtual Users equivalent to the number of CPUs. Benchmark set to TPC-C for MariaDB. ALL VIRTUAL USERS COMPLETE. Docker Hub.

C++ 62

C++ Virtualization Database Benchmarking 62