article thumbnail

A thorough introduction to bpftrace

Brendan Gregg

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 68
article thumbnail

Transparent Data Encryption (TDE)

Percona

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.

Insiders

Sign Up for our Newsletter

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Trending Sources

article thumbnail

Tune Linux Kernel Parameters For PostgreSQL Optimization

Percona

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 54
article thumbnail

Data Redundancy With the PostgreSQL Citus Extension

Percona

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++ 77
article thumbnail

SQL Server I/O Basics Chapter #2

SQL Server According to Bob

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

Servers 40