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

APRIL 19, 2023

Therefore, before we attempt to measure our database performance, we should know the system or cloud instance to be tested in detail. Benchmarking the target Two of the more popular database benchmarks for MySQL are HammerDB and sysbench. For the experiments in this blog, we did not tune the system. 4.22 %usr 38.40

Performance 54

Performance Benchmarking Cache Storage 54

Scalegrid

OCTOBER 24, 2019

MySQL on AWS Performance Test. Reads and writes to your Primary, and even reads from Slave-1 will work at SSD speed. MySQL Performance Benchmark Configuration. MySQL Performance Test Scenarios and Results. Amazon RDS. Instance Type. AWS High Performance XLarge (see system details below). DB Instance r4.xlarge

AWS 183

AWS Latency Performance Benchmarking 183

The Morning Paper

NOVEMBER 3, 2019

Perhaps the most interesting lesson/reminder is this: it takes a lot of effort to tune a Linux kernel. Google’s data center kernel is carefully performance tuned for their workloads. A micro-benchmark suite, LEBench was then built around tee system calls responsible for most of the time spent in the kernel. Headline results.

Performance 108

Performance Benchmarking Tuning Hardware 108

Brendan Gregg

SEPTEMBER 25, 2021

Measuring the speed of time Is there already a microbenchmark for os::javaTimeMillis()? There's also a test and println() in the loop to, hopefully, convince the compiler not to optimize-out an otherwise empty loop. This will slow this test a little.) Microbenchmark os::javaTimeMillis() on both systems. include <sys/time.h>

Speed 40

Speed Java AWS Virtualization 40

Percona

MARCH 23, 2023

Nowadays, solid-state drives (SSDs) or non-volatile memory express (NVMe) drives are preferred over traditional hard disk drives (HDDs) for database servers due to their faster read and write speeds, lower latency, and improved reliability. Benchmark before you decide. If you see concurrency issues, you can tune this variable.

Performance 127

Performance Hardware Tuning Storage 127

KeyCDN

AUGUST 15, 2019

Web performance is a broad subject, and you’ll find no shortage of performance testing tips and tutorials all over the web. Before you begin tuning your website or application, you must first figure out which metrics matter most to your users and establish some achievable benchmarks. What is Performance Testing?

Testing Tools 55

Testing Tools Best Practices Performance Testing Testing 55

Percona

DECEMBER 20, 2018

Linux OS Tuning for MySQL Database Performance. In this post we will review the most important Linux settings to adjust for performance tuning and optimization of a MySQL database server. We’ll note how some of the Linux parameter settings used OS tuning may vary according to different system types: physical, virtual or cloud.

Database 40

Database Tuning Performance AWS 40

Rigor

JANUARY 13, 2020

Yet, we wanted to put together our list of the top web performance books for anyone who cares about speed of the web and would like to explore the timeline of web performance engineering milestones over nearly two decades through the lens of published books. Site speed & SEO go hand in hand. Information Architecture. Mobile First.

Performance 75

Performance Social Media Website Website Performance 75

Percona

AUGUST 5, 2023

Each partition holds data that falls within a specific range, optimizing data handling and query speed. This version also notably integrates native backing for range and list partitioning of spatial indexes, amplifying geospatial query speed for substantial datasets. Additionally, MySQL 8.0 Documentation : Always be documenting!

Strategy 40

Strategy Storage Database Best Practices 40

Smashing Magazine

JUNE 3, 2022

How would we test to see if there is any difference between a good sans serif and a serif typeface with users? This diversity adds to the difficulty and complexity of defining and testing typefaces. For a proper test setup you would need to modify one parameter while keeping every other parameter unchanged.

Performance 110

Performance Design Best Practices Testing 110

Rigor

SEPTEMBER 11, 2019

list of those who are making a significant impact on speeding up the web today. Developers representing hundreds of companies work together at these meetups to become masters in performance metrics and the latest trends in measuring site speed.) We at Rigor respect many web performance leaders around the world. Rachel Andrew.

Performance 89

Performance Education Google Website 89

Randon ASCII

APRIL 17, 2018

This weeks’ blog post covers a technique you can use to make all file operations on Windows run at one tenth their normal speed (or slower), in a way that will be untraceable for most users! When you own all of the code then this may involve some back of the envelope estimates, competitive benchmarking, or intuition tuned by experience.

Monitoring 43

Monitoring C++ Code Processing 43

HammerDB

OCTOBER 12, 2018

This post complements the previous best practice guides this time with the focus on MySQL and MariaDB and achieving top levels of performance with the HammerDB MySQL TPC-C test. InnoDB is the storage engine that will deliver the best OLTP throughput and should be chosen for this test. . HammerDB difference from Sysbench.

Best Practices 40

Best Practices Scalability Performance C++ 40

Smashing Magazine

JANUARY 7, 2022

Worse yet, once the work is batched they insert user research that should have been done to inform the original work effort to what the real benchmark (MVP) should be. If you speed up, you’ll likely through off your car’s alignment and loosen up some other critical parts. They may identify a detail you overlooked in your solution.

Design 92

Design Logistics Strategy Benchmarking 92

SQL Server According to Bob

JANUARY 11, 2020

Many high-end disk subsystems provide high-speed cache facilities to reduce the latency of read and write operations. For specific information on I/O tuning and balancing, you will find more details in the following document. SQL Server defines stable media as storage that can survive system restart or common failure.

Servers 40

Servers Cache Media Hardware 40

SQL Server According to Bob

JANUARY 11, 2020

Pull-the-plug ​​ power ​​ outage testing ​​ Power outage testing ​​ is ​​ a fundamental and critical part of the administrator’s data safety and integrity requirements. ​​ Incorrect configurations lead to data loss.

Servers 40

Servers Cache Database Media 40

High Scalability

NOVEMBER 25, 2019

To add elasticity, reliability and durability, these data centers are connected to Google Cloud platform using high speed, secure Google Interconnect network. If you develop something then you own the lifecycle of that product, which means you would work with QA, DevOps to ensure it’s tested/deployed.

Architecture 52

Architecture Cache Azure Storage 52