Highly Scalable

MARCH 10, 2015

Most of this article represents an overview of the results published by retailers and researchers who built practical decision making and optimization systems combining abstract economic models with data mining methods. The most typical use cases for this problem are recommender systems, personalized search results ranking, and targeted ads.

Retail 152

Retail C++ Analytics Metrics 152

HammerDB

MAY 10, 2021

dbset db ora dbset bm TPC-C diset connection system_user system diset connection system_password oracle diset connection instance RAZPDB1 diset tpcc tpcc_user tpcc diset tpcc tpcc_pass tpcc diset tpcc total_iterations 10000000 diset tpcc ora_driver timed diset tpcc rampup 2 diset tpcc duration 10 vuset logtotemp 1 vuset vu 2 steprun.

Virtualization 52

Virtualization C++ Database Monitoring 52

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

NOVEMBER 23, 2021

dbset db pg dbset bm TPC-C diset tpcc pg_count_ware 20 diset tpcc pg_num_vu 4 diset tpcc pg_superuser postgres diset tpcc pg_superuserpass postgres buildschema. 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 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 58

Testing C++ Virtualization Tuning 58

HammerDB

MARCH 27, 2023

In this example, we will use the PostgreSQL Docker image and have PostgreSQL running on our Linux system. Copyright (C) 2003-2023 Steve Shaw Type "help" for a list of commands Initialized SQLite on-disk database /home/hammerdb/HammerDB-4.7/TMP/hammer.DB How to deploy HammerDB CLI fast with Docker HammerDB v4.7 TMP/hammer.DB

Benchmarking 52

Benchmarking Testing Database 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. As is exactly the same with PostgreSQL for system choice a 2 socket system is optimal for MySQL OLTP performance. order by c.

Best Practices 40

Best Practices Scalability Performance C++ 40

HammerDB

MAY 5, 2019

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. Copyright (C) 2003-2018 Steve Shaw. The OS was: Ubuntu 18.04.1 LTS (GNU/Linux 4.15.0-23-generic

Testing 49

Testing Tuning Latency Storage 49

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). These bin and lib directories are not included with the source code. HammerDB CLI v3.1

Architecture 40

Architecture Virtualization Open Source 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. Many people use postgres. CPU Configuration. Although 9.6.5

Best Practices 40

Best Practices Scalability Performance Hardware 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

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.

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