Remove c
article thumbnail

Using Huge Pages with PostgreSQL Running Inside Kubernetes

Percona

Kubectl helps to check the amount of huge pages available. kubectl describe nodes NODENAME … hugepages-1Gi 0 (0%) 0 (0%) hugepages-2Mi 1Gi (25%) 1Gi (25%) … The tool reports only 2MB pages availability in the above output. PG pods are not able to start without proper limits on the node with huge pages enabled.

C++ 95
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. Much of what I will show you makes heavy use of them.

C++ 77
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

High Memory Usage on ProxySQL Server

Percona

ProxySQL is a very useful tool for gaining high availability, load balancing, query routing, query caching, query rewriting, multiplexing, and data masking. Your MySQL connection id is 1 Server version: 5.5.30 (ProxySQL Admin Module) Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others. Commands end with ; or g.

Servers 58
article thumbnail

A thorough introduction to bpftrace

Brendan Gregg

C @ns: [256, 512) 10900 |@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@ | [512, 1k) 18291 |@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@| [1k, 2k) 4998 |@@@@@@@@@@@@@@ | [2k, 4k) 57 | | [4k, 8k) 117 | | [8k, 16k) 48 | | [16k, 32k) 109 | | [32k, 64k) 3 | |. This example instrumented one of many thousands of available events. Hit Ctrl-C to end.

Latency 68
article thumbnail

SQL Server I/O Basics Chapter #2

SQL Server According to Bob

​​ Various defragmentation ​​ utilities ​​ are ​​ available ​​ on the market today. Therefore, the database can have pages in any one of the three available verification states.

Servers 40