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. We had specializations in hardware, operating systems, databases, graphics, etc.

Tuning 52

Tuning Benchmarking Engineering C++ 52

HammerDB

JULY 5, 2022

Python is a popular programming language, especially for beginners, and consequently we see it occurring in places where it just shouldn’t be used, such as database benchmarking. We use stored procedures because, as the introductory post shows, using single SQL statements turns our database benchmark into a network test).

Benchmarking 98

Benchmarking Database C++ Virtualization 98

HammerDB

OCTOBER 12, 2018

Similarly for this guide MySQL can be swapped for a mySQL based databases such as MariaDB. As is also the case this limitation is at the database level (especially the storage engine) rather than the hardware level. As is exactly the same with PostgreSQL for system choice a 2 socket system is optimal for MySQL OLTP performance.

Best Practices 40

Best Practices Scalability Performance C++ 40

Percona

AUGUST 25, 2023

3308", "memberRole": "SECONDARY", "memberState": "(MISSING)", "mode": "n/a", "readReplicas": {}, "role": "HA", "shellConnectError": "MySQL Error 2003: Could not open connection to '127.0.0.1:3308': MySQL localhost:3309 ssl JS > cluster1.status() 3309' and cannot process write transactions. 3308": { "address": "127.0.0.1:3308",

Traffic 75

Traffic Database C++ Servers 75

HammerDB

OCTOBER 8, 2018

This limitation is at the database level rather than the hardware level, nevertheless with up to date hardware (from mid-2018) PostgreSQL on a 2 socket system can be expected to deliver more than 2M PostgreSQL TPM and 1M NOPM with the HammerDB TPC-C test. . Start the PostgreSQL Database. cat /proc/meminfo. HugePages_Total: 35000.

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. Plotting these data points enables us to understand the scalability of the database software being tested on that system. In this example, we will compare MySQL 5.7.33 and MySQL 8.0.25 and MySQL 8.0.25

Virtualization 57

Virtualization Performance C++ Database 57

HammerDB

NOVEMBER 30, 2018

However if you have downloaded the source code and are looking to add features or make modifications such as adding new databases you may be wondering once you have the source code where to start. However HammerDB will not be able to connect to a database yet and the librarycheck command included with the CLI gives an indication why.

Architecture 40

Architecture Virtualization Open Source C++ 40