Adrian Cockcroft

JUNE 21, 2022

I became the Sun UK local specialist in performance and hardware, and as Sun transitioned from a desktop workstation company to sell high end multiprocessor servers I was helping customers find and fix scalability problems. I also applied Six Sigma to capacity planning and presented this at a conference in 2003.

Tuning 52

Tuning Benchmarking Engineering C++ 52

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. SELECT DISTINCT c from sbtest where id between ? order by c. SELECT c from sbtest where id=? Copyright (C) 2003-2018 Steve Shaw.

Best Practices 40

Best Practices Scalability Performance C++ 40

HammerDB

OCTOBER 8, 2018

This post gives a HOWTO guide on system configuration for achieving top levels of performance with the HammerDB PostgreSQL TPC-C test. D isabling all C-states or Idle states is likely to reduce overall performance by reducing the available turbo frequency. Copyright (C) 2003-2018 Steve Shaw. hammerdbcli.

Best Practices 40

Best Practices Scalability Performance Hardware 40

Percona

AUGUST 25, 2023

3308 ssl JS > c root@localhost:3308 MySQL localhost:3308 ssl JS > cluster1=dba.getCluster() MySQL localhost:3308 ssl JS > cluster1.status() 3308", "memberRole": "SECONDARY", "memberState": "(MISSING)", "mode": "n/a", "readReplicas": {}, "role": "HA", "shellConnectError": "MySQL Error 2003: Could not open connection to '127.0.0.1:3308':

Traffic 75

Traffic Database C++ Servers 75

HammerDB

JULY 16, 2021

One of the most important concepts in analysing database performance is that of understanding scalability. Plotting these data points enables us to understand the scalability of the database software being tested on that system. In particular, this means as we add CPU cores and increase the system load, we see higher performance.

Virtualization 57

Virtualization Performance C++ Database 57

HammerDB

NOVEMBER 30, 2018

This article Threads Done Right… With Tcl gives an excellent overview of these capabilities and it should be clear that to build a scalable benchmarking tool this thread performance and scalability is key. These bin and lib directories are not included with the source code. You can download and compile TCL/TK 8.6

Architecture 40

Architecture Virtualization Open Source C++ 40

HammerDB

JULY 5, 2022

So instead we are going to take a cut down version of the HammerDB TPROC-C driver script and do the same in Python and use the HammerDB infrastructure to measure performance. (We use stored procedures because, as the introductory post shows, using single SQL statements turns our database benchmark into a network test). usr/local/bin/tclsh8.6

Benchmarking 98

Benchmarking Database C++ Virtualization 98