article thumbnail

HammerDB: Using MySQL 5.7 vs 8.0 to understand performance profiles

HammerDB

Then we can run an interactive workload for a single Virtual User as follows for MySQL 8.0.25./hammerdbcli log 2 Virtual Users Created with Monitor VU hammerdb>vurun Vuser 1:RUNNING Vuser 1:Beginning rampup time of 2 minutes Vuser 2:RUNNING Vuser 2:Processing 10000000 transactions with output suppressed. and MySQL 5.7.33.

article thumbnail

Running hammerdbcli from a bash or batch script updated for v3.2

HammerDB

By default the HammerDB command line interface was designed to run interactively. Copyright (C) 2003-2019 Steve Shaw Type "help" for a list of commands The xml is well-formed, applying configuration SETTING CONFIGURATION Database set to Oracle. However many people wanted to run it from a script and an example to do this was shown here.

C++ 40
Insiders

Sign Up for our Newsletter

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Trending Sources

article thumbnail

The Back-to-Basics Readings of 2012 - All Things Distributed

All Things Distributed

May 28 - Virtual Time and Global States of Distributed Systems , Friedemann Mattern, Parallel and Distributed Algorithms, North-Holland (1989) , p. Jul 6 - End-To-End Arguments in System Design , by J. Jul - 13 Hints for Computer Systems Design Proceedings of the Ninth ACM Symposium on Operating Systems Principles, pp.

article thumbnail

HammerDB Concepts and Architecture

HammerDB

TCL was designed as a language to be closely tied with C/C++ and at this lower level there is the compiled TCL (tclsh) or TCL/TK (wish) interpreter and supporting libraries. As virtual users are started the database specific packages and workload specific modules are loaded into the virtual user threads. Virtual Users.

article thumbnail

Why Tcl is 700% faster than Python for database benchmarking

HammerDB

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. 700% Faster.

article thumbnail

Rethinking the 'production' of data

All Things Distributed

That was the provocative thesis of a much-talked-about article from 2003 in the Harvard Business Review by the US publicist Nicolas Carr. The founders had noticed that in many companies, product designers worked in a very detached manner from the rest of production. Strategically, IT doesn't matter. Value creation through data.

article thumbnail

What Adrian Did Next?—?Part 2?—?Sun Microsystems

Adrian Cockcroft

In the early 2000s, Sun was designing it’s next generation high end server, and to avoid reliability issues that had caused problems in previous systems, adopted Six Sigma to create quality best practices. I also applied Six Sigma to capacity planning and presented this at a conference in 2003.

Tuning 52