Remove c
article thumbnail

Using Huge Pages with PostgreSQL Running Inside Kubernetes

Percona

During the deployment procedure on the custom resource apply stage , Percona Operator for PostgreSQL 2.2.0 PG pods are not able to start without proper limits on the node with huge pages enabled. It’s easy with anydbver and k3d.

C++ 105
article thumbnail

Poor Disk Performance

Brendan Gregg

Hit Ctrl-C to end. Hit Ctrl-C to end. The read size is large (128 Kbyte average as seen in iostat(1)), but that's not excessive. biolatency (this is my BPF tool from [bcc]), printing 60-second histograms, per disk (-D): # biolatency -D 60 1. Tracing block device I/O.

Insiders

Sign Up for our Newsletter

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

article thumbnail

Data Redundancy With the PostgreSQL Citus Extension

Percona

Step three: Check packages Inspecting the nodes confirms Citus has been correctly installed: for u in citus1 citus2 citus3 citus4 citus-coord-01 do echo " = NODE: $u =" lxc exec $u -- su - postgres -c 'psql db01'<<_eof_ select extname, extversion from pg_extension; _eof_ done | less -S = NODE: citus1 = extname | extversion -+ plpgsql | 1.0

C++ 84
article thumbnail

Configuring PostgreSQL and LDAP Using StartTLS

Percona

Even though there is an encrypted session between psql and the Postgres server, there is no encrypted session between Postgres and LDAP as authentication is performed: SSL connection (protocol: TLSv1.3,

C++ 74
article thumbnail

HammerDB v4.3 New Features Pt1: Graphical Metrics for PostgreSQL

HammerDB

usr/bin/install -c -m 644./pg_stat_statements--1.4.sql./pg_stat_statements--1.8--1.9.sql./pg_stat_statements--1.7--1.8.sql./pg_stat_statements--1.6--1.7.sql./pg_stat_statements--1.5--1.6.sql./pg_stat_statements--1.4--1.5.sql. include/internal -D_GNU_SOURCE -c -o pgsentinel.o /src/port -L././src/common lib',--enable-new-dtags -lm./postgresql-14.1/contrib/pg_stat_statements$

Metrics 63
article thumbnail

Percona Toolkit – A Quick Introduction to Summary

Percona

autovacuum_analyze_threshold : 50 autovacuum_freeze_max_age : 200000000 autovacuum_max_workers : 3 autovacuum_multixact_freeze_max_age : 400000000 autovacuum_naptime : 60 autovacuum_vacuum_cost_delay : 2 autovacuum_vacuum_cost_limit : -1 autovacuum_vacuum_insert_scale_factor : 0.2 createrole_self_grant : cursor_tuple_fraction : 0.1

Cache 106
article thumbnail

High Memory Usage on ProxySQL Server

Percona

Your MySQL connection id is 1 Server version: 5.5.30 (ProxySQL Admin Module) Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others. Type 'c' to clear the current input statement. 2) mysql-query_digests_max_digest_length – This is by default set to 2048. Commands end with ; or g. Type 'help;' or 'h' for help.

Servers 60