HammerDB

DECEMBER 1, 2022

Copyright (C) 2003-2022 Steve Shaw Type "help" for a list of commands Initialized new SQLite on-disk database C:/Users/Hdb/AppData/Local/Temp/hammer.DB Copyright (C) 2003-2022 Steve Shaw Type "help" for a list of commands Initialized new SQLite on-disk database C:/Users/Hdb/AppData/Local/Temp/hammer.DB Use a different Browser.

Virtualization 58

Virtualization C++ Storage Database 58

HammerDB

NOVEMBER 30, 2022

HammerDB will rely on the system installed Python interpreter and at a specific version as described in the following table. Copyright (C) 2003-2022 Steve Shaw. Copyright (C) 2003-2022 Steve Shaw. From version v4.6 Python Version Dependency. hammerdbcli py HammerDB CLI v4.6. Type "help()" for a list of commands.

Virtualization 45

Virtualization C++ Lambda Monitoring 45

HammerDB

NOVEMBER 23, 2021

Copyright (C) 2003-2021 Steve Shaw Type "help" for a list of commands The xml is well-formed, applying configuration Initialized new SQLite on-disk database /tmp/hammer.DB Copyright (C) 2003-2021 Steve Shaw Type "help" for a list of commands The xml is well-formed, applying configuration Initialized new SQLite on-disk database /tmp/hammer.DB

Virtualization 71

Virtualization Benchmarking C++ Database 71

HammerDB

JULY 16, 2021

When a system ‘scales’ it is able to deliver higher levels of performance proportional to the system resources available to it. In particular, this means as we add CPU cores and increase the system load, we see higher performance. In this example, we will compare MySQL 5.7.33 and MySQL 8.0.25 and MySQL 5.7.33.

Virtualization 58

Virtualization Performance C++ Database 58

HammerDB

JULY 14, 2021

Copyright (C) 2003-2021 Steve Shaw Type "help" for a list of commands The xml is well-formed, applying configuration hammerdb>librarycheck. Vuser 1:64 Active Virtual Users configured Vuser 1:TEST RESULT : System achieved 669086 NOPM from 2026420 MariaDB TPM. ~/HammerDB-4.2/lib/mariatcl0.1$ lib/mariatcl0.1$ ldd libmariatcl0.1.so

Testing 58

Testing C++ Virtualization Tuning 58

HammerDB

MAY 5, 2019

So to test I took a system with Skylake CPUs and all storage on a P4800X SSD. Copyright (C) 2003-2018 Steve Shaw. Vuser 1:TEST RESULT : System achieved 2159378 MySQL TPM at 713488 NOPM. model name : Intel(R) Xeon(R) Platinum 8180 CPU @ 2.50GHz. The OS was: Ubuntu 18.04.1 LTS (GNU/Linux 4.15.0-23-generic 23-generic x86_64).

Testing 49

Testing Tuning Latency Storage 49

HammerDB

JULY 5, 2022

Vuser 1:1 Active Virtual Users configured Vuser 1:TEST RESULT : System achieved 1844256 NOPM from 4232155 PostgreSQL TPM Vuser 1:FINISHED SUCCESS ALL VIRTUAL USERS COMPLETE. hammerdbcli auto pgtime.tcl HammerDB CLI v4.4 hammerdbcli auto pgtime.tcl HammerDB CLI v4.4 Vuser 1:Test complete, Taking end Transaction Count.

Benchmarking 98

Benchmarking Database C++ Virtualization 98

HammerDB

OCTOBER 12, 2018

As with the previous guides as an Intel employee (#IAMINTEL) the examples are taken from a MySQL 8 on Linux on Intel system and the approach is the same for whatever system you are testing although some of the settings you see may be different. System Setup: CPU, Memory and I/O Configuration. monitoring. perf special.

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. Firstly for system choice a 2 socket system is optimal for PostgreSQL OLTP performance at the time of writing. dev/nvme0n1p1 /mnt/ssd xfs noatime.

Best Practices 40

Best Practices Scalability Performance Hardware 40

HammerDB

NOVEMBER 30, 2018

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. HammerDB CLI v3.1

Architecture 40

Architecture Virtualization Open Source C++ 40

HammerDB

JULY 8, 2019

Copyright (C) 2003-2019 Steve Shaw Type "help" for a list of commands The xml is well-formed, applying configuration Initialized new SQLite in-memory database Starting HammerDB Web Service on port 8080 Listening for HTTP requests on TCP port 8080. see the documentation for setting the port). . $./hammerdbws hammerdbws HammerDB Web Service v3.2

Virtualization 40

Virtualization Benchmarking C++ Database 40

Adrian Cockcroft

JUNE 21, 2022

Photo by Adrian I spent six years at Cambridge Consultants, building some interesting systems, managing our Sun workstations and learning a lot, but by then Sun had opened a sales office across the street, and I wanted to find out what they were going to release next, before everyone else. as a result there were product and messaging changes.

Tuning 52

Tuning Benchmarking Engineering C++ 52

SQL Server According to Bob

JANUARY 11, 2020

​​ Without limiting the rights under copyright, no part of this document may be reproduced, stored in or introduced into a retrieval system, or transmitted in any form or by any means (electronic, mechanical, photocopying, recording, or otherwise), or for any purpose, without the express written permission of Microsoft Corporation.

Servers 40

Servers Cache Database Media 40