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. InnoDB is the storage engine that will deliver the best OLTP throughput and should be chosen for this test. . order by c.

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. It is your test so you can set the options as you see fit.

Best Practices 40

Best Practices Scalability Performance Hardware 40

HammerDB

JULY 16, 2021

One of the most important concepts in analysing database performance is that of understanding scalability. The way we measure this is through a ‘performance profile’ This simply means that we run a series of tests incrementally increasing the system load until we find the peak performance. and MySQL 8.0.25 and MySQL 5.7.33.

Virtualization 57

Virtualization Performance C++ Database 57

HammerDB

JULY 5, 2022

To do this, we are going to rewrite HammerDB in Python and run a series of tests on a 2 socket Intel(R) Xeon(R) Platinum 8280L server to see how and why Tcl is 700% faster than Python for database benchmarking*. Building the Test Schema and Timing Script. Background and Concepts. usr/local/bin/tclsh8.6

Benchmarking 98

Benchmarking Database C++ Virtualization 98

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

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() Please note that sandbox instances are only suitable for deploying test clusters for use within the same host. MySQL 127.0.0.1:3308 3308": { "address": "127.0.0.1:3308", MySQL 127.0.0.1:3308

Traffic 76

Traffic Database Servers C++ 76