HammerDB

OCTOBER 17, 2018

The official TPC-C test has a fixed number of users per warehouse and uses keying and thinking time so that the workload generated by each user is not intensive. By default each virtual user has the concept of a home warehouses where approximately 75% of its workload will take place.

C++ 40

C++ Testing Virtualization Cache 40

HammerDB

JUNE 22, 2023

Copyright (C) 2003-2023 Steve Shaw Type "help" for a list of commands Initialized new Jobs on-disk database /opt/HammerDB-4.8/DATA/hammer.db On Windows it will look for TEMP, TMP, TMPDIR or finally C: for example, on Linux. In this example, we will run a PostgreSQL TPROC-C autopilot workload to generate some jobs to analyse.

Benchmarking 57

Benchmarking C++ Virtualization Database 57

HammerDB

JULY 14, 2021

adds full support for MariaDB in both the GUI as shown: And in the CLI as a separate database from MySQL, this post describes a setup and test for MariaDB using the CLI on Linux as an example running the TPROC-C workload. dbset db maria dbset bm TPC-C diset connection maria_socket /tmp/mariadb10234.sock HammerDB v4.2 linux-x86_64.tar.gz

Testing 57

Testing C++ Virtualization Tuning 57

Percona

OCTOBER 2, 2023

virtual = 2.2G virtual = 2.2G 2004l# Percona Toolkit System Summary Report ###################### Date | 2023-09-25 14:43:34 UTC (local TZ: CDT -0500) Hostname | testbox Uptime | 44 min, 1 user, load average: 0.47, 0.67, 0.57 Platform | Linux Release | Ubuntu 22.04.3 LTS (jammy) Kernel | 6.2.0-33-generic Shared | 475.0M Buffers | 3.8G

Cache 98

Cache Database Virtualization Servers 98

Brendan Gregg

OCTOBER 8, 2018

more capable, and built from the ground up for the modern era of the eBPF virtual machine. eBPF was created by Alexei Starovoitov while at PLUMgrid (he's now at Facebook) as a generic in-kernel virtual machine, with software defined networks as the primary use case. It's shaping up to be a DTrace version 2.0: Attaching 2 probes. ^C

C++ 110

C++ Virtualization Programming Latency 110

SQL Performance

AUGUST 2, 2019

I have been making the same recommendations about tempdb since I started working with SQL Server over 15 years ago, when I was working with customers running version 2000. installed on my virtual machine, which has 8GB of memory (max server memory set to 6 GB) and 4 vCPUs. OrderID , c. Customers c ON o. CustomerID = c.

Servers 95

Servers C++ Testing Systems 95

Brendan Gregg

AUGUST 18, 2019

C @ns: [256, 512) 10900 |@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@ | [512, 1k) 18291 |@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@| [1k, 2k) 4998 |@@@@@@@@@@@@@@ | [2k, 4k) 57 | | [4k, 8k) 117 | | [8k, 16k) 48 | | [16k, 32k) 109 | | [32k, 64k) 3 | |. Hit Ctrl-C to end. ^C Attaching 2 probes. ^C 1 /* 2 * biolatency.bt Attaching 3 probes.

Latency 68

Latency C++ Cache Programming 68