Percona

AUGUST 29, 2018

For optimum performance, a PostgreSQL database depends on the operating system parameters being defined correctly. In this post, we will discuss some important kernel parameters that can affect database server performance and how these should be tuned. PostgreSQL uses System V (SysV) that requires SHMMAX setting.

Tuning 54

Tuning Database Servers Processing 54

The Morning Paper

MAY 21, 2019

We focus on a definition that draws from the following two principles: (1) the value of temporal locality, by classifying as cold a memory page that has not been accessed beyond a threshold of T seconds; (2) a proxy for the application effect of far memory, by measuring the rate of accesses to cold memory pages, called promotion rate.

Software 78

Software Software Google Hardware 78

HammerDB

FEBRUARY 25, 2021

For this reason we need to implement our database sessions in the form of operating system threads. This is possible because the Tcl interpreter is exceptionally compact and lightweight (Also for this reason Tcl is often used as an embedded language in hardware such as Cisco Routers). Tcl Multithreading in parallel.

Programming 67

Programming Benchmarking Virtualization C++ 67

O'Reilly Software

APRIL 4, 2018

Are there inherent time relationships in the messages that need to be preserved as they travel across the system? The data shape will dictate capacity planning, tuning of the backbone, and scalability analysis for individual components. They have a clear input and output definition, and often a schema as well. At least once?

Architecture 80

Architecture Scalability Google Operating System 80

SQL Server According to Bob

JANUARY 11, 2020

Most manufacturers' implementations immediately flush pending writes to physical disk during the restart operations. Example 1: ​​ Hardware failure (CPU board) Battery backup on the caching controller maintained the data. Important Always consult with your hardware manufacturer for proper stable media strategies.

Servers 40

Servers Cache Media Hardware 40

High Scalability

NOVEMBER 25, 2019

There are many unique things but the storage layer, event-based sync is definitely worth learning, here are more details on it Egnyte object store and Egnyte Canonical File System. What operating systems do you use? How are software and hardware upgrades rolled out? What lessons have you learned? Nginx, HAproxy.

Architecture 52

Architecture Cache Azure Storage 52