Remove 2003 Remove Architecture Remove Tuning Remove Virtualization
article thumbnail

Testing MySQL 8.0.16 on Skylake with innodb_spin_wait_pause_multiplier

HammerDB

Note that the main developer of HammerDB is Intel employee (#IAMINTEL) however HammerDB is a personal open source project and HammerDB has no optimization whatsoever for a database running on any particular architecture. Copyright (C) 2003-2018 Steve Shaw. In the recent MySQL 8.0.16 mysqld] datadir=/home/mysql/mysql-8.0.16/mysql-8.0.16-linux-glibc2.12-x86_64/data

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

In particular on Intel Scalable Processors (Skylake architecture) the PAUSE instruction is much longer than previous architectures and therefore calling UT_RELAX_CPU can consume a lot more time resulting in reduced performance. Copyright (C) 2003-2018 Steve Shaw. Copyright (C) 2003-2018 Steve Shaw. innodb_file_per_table.