Hardware, Speed and Tuning - Technology Performance Pulse

Trip report: Autumn ISO C++ standards meeting (Kona, HI, USA)

Sutter's Mill

NOVEMBER 11, 2023

Today, the ISO C++ committee completed its second meeting of C++26, held in Kona, HI, USA. Our hosts, Standard C++ Foundation and WorldQuant, arranged for high-quality facilities for our six-day meeting from Monday through Saturday. This time, the committee adopted the next set of features for C++26. This is that library.

C++

C++ Lambda Network Programming

PostgreSQL Performance Tuning: Optimizing Database Parameters for Maximum Efficiency

Percona

MAY 1, 2023

Out of the box, the default PostgreSQL configuration is not tuned for any particular workload. It is primarily the responsibility of the database administrator or developer to tune PostgreSQL according to their system’s workload. What is PostgreSQL performance tuning? Why is PostgreSQL performance tuning important?

Tuning

Tuning Efficiency Database Performance

The Speed of Time

Brendan Gregg

SEPTEMBER 25, 2021

As a Xen guest, this profile was gathered using perf(1) and the kernel's software cpu-clock soft interrupts, not the hardware NMI. As (C) looked like a kernel rebuild, I started with (D) and (E). ## 5. Measuring the speed of time Is there already a microbenchmark for os::javaTimeMillis()? But I'm not completely sure.

Speed

Speed Java AWS Virtualization

How To Scale a Single-Host PostgreSQL Database With Citus

Percona

NOVEMBER 3, 2023

PostgreSQL Cluster One coordinator node citus-coord-01 Three worker nodes citus1 citus2 citus3 Hardware AWS Instance Ubuntu Server 20.04, SSD volume type 64-bit (x86) c5.xlarge And now, execute the benchmark: -- execute the following on the coordinator node pgbench -c 20 -j 3 -T 60 -P 3 pgbench The results are not pretty.

Database

Database Benchmarking Latency C++

The Speed of Time

Brendan Gregg

SEPTEMBER 25, 2021

As a Xen guest, this profile was gathered using perf(1) and the kernel's software cpu-clock soft interrupts, not the hardware NMI. As (C) looked like a kernel rebuild, I started with (D) and (E). ## 6. Measuring the speed of time Is there already a microbenchmark for os::javaTimeMillis()? But I'm not completely sure.

Speed

Speed Java AWS Virtualization

Data Redundancy With the PostgreSQL Citus Extension

Percona

AUGUST 29, 2023

Columnar storage of tables can compress data, speeding up scans and supporting fast projections, both on regular and distributed tables. Depending on the configuration, one can tune a hardware RAID for either performance or redundancy. The same can be said for Citus data sharding. citus_columnar | 11.1-1 1 citus | 11.1-1

C++

C++ Database Storage Testing

How to Assess MySQL Performance

HammerDB

APRIL 19, 2023

GHz 4th Generation Intel Xeon Scalable processors (code-named Sapphire Rapids) Up to 20% higher compute performance than z1d instances Up to 50 Gbps of networking speed Up to 40 Gbps of bandwidth to the Amazon Elastic Block Store (EBS) We can also verify these capabilities by running some simple benchmarks on the different subsystems.

Performance

Performance Benchmarking Cache Storage

How to maximize CPU performance for PostgreSQL 12.0 benchmarks on Linux

HammerDB

OCTOBER 18, 2019

cpupower frequency-info analyzing CPU 0: driver: intel_pstate CPUs which run at the same hardware frequency: 0 CPUs which need to have their frequency coordinated by software: 0 maximum transition latency: Cannot determine or is not supported. hardware limits: 1000 MHz - 4.00 hardware limits: 1000 MHz - 4.00

Benchmarking

Benchmarking Performance Hardware C++

The top 5 reasons to run your own database benchmarks

HammerDB

JANUARY 5, 2019

Some opinions claim that “Benchmarks are meaningless”, “benchmarks are irrelevant” or “benchmarks are nothing like your real applications” However for others “Benchmarks matter,” as they “account for the processing architecture and speed, memory, storage subsystems and the database engine.”

Benchmarking

Benchmarking Database Social Media Scalability

HammerDB MySQL and MariaDB Best Practice for Performance and Scalability

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 also the case this limitation is at the database level (especially the storage engine) rather than the hardware level. order by c.

Best Practices

Best Practices Scalability Performance C++

Solaris to Linux Migration 2017

Brendan Gregg

SEPTEMBER 5, 2017

Hit Ctrl-C to end. ^C C operation = 'read' usecs : count distribution 0 -> 1 : 0 | | 2 -> 3 : 0 | | 4 -> 7 : 4479 | *| 8 -> 15 : 1028 | | 16 -> 31 : 14 | | 32 -> 63 : 1 | | [.]. If that seems wildly unacceptable, note that you can tune overcommit on Linux to not do this, and behave more like Solaris (see sysctl vm.overcommit_memory).

Virtualization

Virtualization AWS Engineering Hardware

Egnyte Architecture: Lessons learned in building and scaling a multi petabyte content platform

High Scalability

NOVEMBER 25, 2019

To add elasticity, reliability and durability, these data centers are connected to Google Cloud platform using high speed, secure Google Interconnect network. Java/Python mostly and some small services in Go/C. Egnyte Connect platform employs 3 data centers to fulfill requests from millions of users across the world. Cloud Platform.

Architecture

Architecture Cache Azure Storage

SQL Server I/O Basics Chapter #2

SQL Server According to Bob

JANUARY 11, 2020

Character POS ASCII Value Formula Value A 1 65 67 C 2 67 69 Checksum 136 Comparing the checksum values indicates that the values do not match and damage has occurred to the data. Contact your hardware manufacture for assistance.

Servers

Servers Cache Database Media

HTTP/3: Performance Improvements (Part 2)

Smashing Magazine

AUGUST 22, 2021

A Primer on Speed. Discussing performance and “speed” can quickly get complex, because many underlying aspects contribute to a web-page loading “slowly”. It is physically limited by the speed of light or, practically, how fast signals can travel in wires or in the open air. also “only” take two round trips ((b) is rarely shown).

Performance

Performance Network Latency Servers

Technology Performance Pulse

Trip report: Autumn ISO C++ standards meeting (Kona, HI, USA)

PostgreSQL Performance Tuning: Optimizing Database Parameters for Maximum Efficiency

Trending Sources

The Speed of Time

How To Scale a Single-Host PostgreSQL Database With Citus

The Speed of Time

Data Redundancy With the PostgreSQL Citus Extension

How to Assess MySQL Performance

How to maximize CPU performance for PostgreSQL 12.0 benchmarks on Linux

The top 5 reasons to run your own database benchmarks

HammerDB MySQL and MariaDB Best Practice for Performance and Scalability

Solaris to Linux Migration 2017

Egnyte Architecture: Lessons learned in building and scaling a multi petabyte content platform

SQL Server I/O Basics Chapter #2

HTTP/3: Performance Improvements (Part 2)

Stay Connected