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++ 101

C++ Virtualization Benchmarking Database 101

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 142

Performance Latency Speed Systems 142

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 59

Servers Cache C++ Metrics 59

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 102

Cache Database Virtualization Servers 102

Brendan Gregg

AUGUST 18, 2019

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 | |. . ### Source Here's the code to biolatency.bt: tools# cat -n biolatency.bt. Attaching 3 probes.

Latency 68

Latency C++ Cache Programming 68

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 40

Performance Latency Speed Systems 40