Percona

DECEMBER 20, 2023

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

C++ Virtualization Benchmarking Database 105

Percona

AUGUST 21, 2023

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

C++ Servers Open Source Testing 74

Percona

AUGUST 29, 2023

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

C++ Database Storage Testing 84

Brendan Gregg

MAY 8, 2021

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.

Performance 133

Performance Latency Speed Systems 133

HammerDB

NOVEMBER 22, 2021

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 62

Metrics Benchmarking C++ Database 62

Percona

DECEMBER 5, 2022

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

Servers Cache C++ Metrics 60

Percona

OCTOBER 2, 2023

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 105

Cache Database Virtualization Servers 105