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. linux-glibc2.12-x86_64/data

Testing 48
article thumbnail

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

Adrian Cockcroft

I had to setup a week of talks by all the relevant product teams, with a hundred or so of the most experienced systems engineers from all over the world as an audience. We had specializations in hardware, operating systems, databases, graphics, etc.

Tuning 52
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

HammerDB Concepts and Architecture

HammerDB

It is of note that we have not discussed the operating system yet, that is because the source code and the code included with the pre-packaged versions is identical whether it is running on Linux or Windows on x86-64 architecture (or any other platform). Virtual Users within HammerDB are operating system threads.

article thumbnail

SQL Server I/O Basics Chapter #2

SQL Server According to Bob

Subsystem / Path The ​​ I/O subsystem or path ​​ includes ​​ those ​​ components ​​ that are ​​ used to support an I/O operation. The names of actual companies and products mentioned herein may be the trademarks of their respective owners.

Servers 40