Percona

AUGUST 29, 2018

For optimum performance, a PostgreSQL database depends on the operating system parameters being defined correctly. PostgreSQL uses System V (SysV) that requires SHMMAX setting. So now it requires fewer bytes of System V shared memory. DETAIL: Failed system call was shmget(key=1, size=2072576, 03600). Until version 9.2,

Tuning 79

Tuning Database Servers Processing 79

Percona

DECEMBER 27, 2022

Encrypting data at rest in a database management system (DBMS) refers to securing data by encrypting it when it is not being used or accessed. Several database management systems support cluster-level encryption, including Oracle, MySQL, Microsoft SQL Server, MongoDB, and Cassandra. Database-level encryption. Table-level encryption.

Database 94

Database Storage Servers Strategy 94

Percona

AUGUST 29, 2023

Depending on the configuration, one can tune a hardware RAID for either performance or redundancy. Can you think of a better system that can stay up without losing time initiating failovers when a node fails? Now let’s stretch our imagination and consider a second method of high availability, ala Citus. citus_columnar | 11.1-1

C++ 98

C++ Database Storage Testing 98

Brendan Gregg

AUGUST 18, 2019

BPF has been extended (aka eBPF) in recent years for providing a safe way to extend kernel functionality, and has become a hot topic in systems engineering, with at least 24 talks on BPF at the last Linux Plumber's conference. hardware Hardware counter-based instrumentation. system(".") BEGIN Start of bpftrace.

Latency 57

Latency C++ Cache Programming 57

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