Remove Availability Remove Benchmarking Remove Cache Remove Virtualization
article thumbnail

A MyRocks Use Case

Percona

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 56
article thumbnail

Percona Monitoring and Management 2 Scaling and Capacity Planning

Percona

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.

Insiders

Sign Up for our Newsletter

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Trending Sources

article thumbnail

The Importance of Selecting the Proper Azure VM Size

SQL Performance

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. Memory optimized – High memory-to-CPU ratio, relational database servers, medium to large caches, and in-memory analytics.

Azure 76
article thumbnail

Why Tcl is 700% faster than Python for database benchmarking

HammerDB

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).

article thumbnail

The Return of the Frame Pointers

Brendan Gregg

This technique saves two instructions in the prologue and epilogue and makes one additional general-purpose register (%rbp) available." Only in extreme circumstances does the cost (in processor time and I-cache footprint) translate to a tangible benefit - circumstances which usually resort to hand-coded assembly anyway.

Java 145
article thumbnail

HammerDB for Managers

HammerDB

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.

article thumbnail

The Ultimate Guide to Database High Availability

Percona

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?