article thumbnail

HammerDB v4.2 New Features Pt1: MariaDB Build and Test Example with the CLI

HammerDB

Also, the additional installation of the MySQL client libraries was needed when testing MariaDB. adds full support for MariaDB in both the GUI as shown: And in the CLI as a separate database from MySQL, this post describes a setup and test for MariaDB using the CLI on Linux as an example running the TPROC-C workload. HammerDB v4.2

Testing 57
article thumbnail

Testing MySQL 8.0.16 on Skylake with innodb_spin_wait_pause_multiplier

HammerDB

Fortunately the HammerDB TPC-C/OLTP workload intentionally has a great deal of contention between threads and is therefore ideal for testing spin-locks. So to test I took a system with Skylake CPUs and all storage on a P4800X SSD. In the recent MySQL 8.0.16 model name : Intel(R) Xeon(R) Platinum 8180 CPU @ 2.50GHz. 23-generic x86_64).

Testing 48
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

Web Performance Bookshelf

Rigor

These are the bestsellers in the web performance field, including the good old Speed Up Your Site (2003) by Andy King; Steve Souders’ Even Faster Web Sites (2009) ; Ilya Grigorik’s High Performance Browser Networking (2013) ; Tammy Everts’ Time is Money (2016) ; and a handful of more recent publications. Mobile First.

article thumbnail

What Adrian Did Next?—?Part 2?—?Sun Microsystems

Adrian Cockcroft

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. Rich became co-author of the second edition of the Sun Performance Tuning book, to describe how it worked. He had it up and running on Wednesday.

Tuning 52
article thumbnail

HammerDB MySQL and MariaDB Best Practice for Performance and Scalability

HammerDB

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.

article thumbnail

SQL Server I/O Basics Chapter #2

SQL Server According to Bob

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