Percona

AUGUST 29, 2018

cat /proc/meminfo | grep -i huge AnonHugePages: 0 kB ShmemHugePages: 0 kB HugePages_Total: 88 HugePages_Free: 88 HugePages_Rsvd: 0 HugePages_Surp: 0 Hugepagesize: 2048 kB Now set the parameter huge_pages “on” in $PGDATA/postgresql.conf and restart the server. $ Allow overcommit anyway.

Tuning 79

Tuning Database Servers Processing 79

Percona

DECEMBER 27, 2022

Several tools are available for implementing disk-level encryption, including BitLocker for Windows, dm-crypt for Linux, and FileVault for MacOS. Encryption available in databases. Here is a comparison chart of the different levels of encryption available in various relational database management systems: Encryption Level.

Database 94

Database Storage Servers Strategy 94

Percona

AUGUST 29, 2023

Data redundancy, a database version of a RAID Pondering the case of high availability and redundancy, one replicates data by creating a replica via streaming replication. Now let’s stretch our imagination and consider a second method of high availability, ala Citus. The same can be said for Citus data sharding. 1 citus | 11.1-1

C++ 98

C++ Database Storage Testing 98

Brendan Gregg

AUGUST 18, 2019

This example instrumented one of many thousands of available events. hardware Hardware counter-based instrumentation. If you have some weird performance problem, there's probably some bpftrace one-liner that can shed light on it. For large environments, this ability can help you save millions. BEGIN Start of bpftrace. ^C

Latency 57

Latency C++ Cache Programming 57

SQL Server According to Bob

JANUARY 11, 2020

​​ Various defragmentation ​​ utilities ​​ are ​​ available ​​ on the market today. ​​ Extended Data: ​​ “incorrect checksum (expected:​​ ## ; actual:​​ ## )” Contact your hardware manufacture for assistance.

Servers 40

Servers Cache Database Media 40