Remove 2003 Remove Architecture Remove Latency Remove Tuning
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

HammerDB MySQL and MariaDB Best Practice for Performance and Scalability

HammerDB

maximum transition latency: Cannot determine or is not supported. . 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. innodb_file_per_table.