article thumbnail

Using Huge Pages with PostgreSQL Running Inside Kubernetes

Percona

It’s easy with anydbver and k3d. git clone [link] cd anydbver ansible-galaxy collection install theredgreek.sqlite echo PROVIDER=docker > anydbver (cd images-build; /build.sh) Start k3d cluster and install Percona Operator for PostgreSQL 2.2.0: /anydbver deploy k8s-pg:2.2.0

C++ 105
article thumbnail

Dynatrace deployment on Windows is now even more secure!

Dynatrace

The certificates for the signatures of all Dynatrace-provided binaries and installations for Microsoft Windows systems were previously based on RSA 2048 keys. New code-signing certificates follow the evolution of industry-security standards.

Insiders

Sign Up for our Newsletter

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

article thumbnail

Stuff The Internet Says On Scalability For February 1st, 2019

High Scalability

The AGC weighed 70 pounds and had 2048 words of RAM in erasable core memory and 36,864 words of ROM in core rope memory. It's HighScalability time: Memory module for the Apollo Guidance Computer (Mike Stewart). It flew to the moon. Do you like this sort of Stuff? Please go to Patreon and do what comes natural. Need cloud?

Internet 146
article thumbnail

How to analyze PostgreSQL benchmark performance with HammerDB

HammerDB

To use pgSentinel we have installed pg_stat_statements and pgsentinel and added the following to our postgresql.conf. and start the build running.

article thumbnail

SQL Server on Linux: Scatter/Gather == Vectored I/O

SQL Server According to Bob

On Linux the total number of buffers that can be read or written, in a single ABI request, is capped at 2048. Within LibOS, when we detect a request exceeding 2048 OS pages, we split the request into multiple 2048 page chunks, deemed sub-I/O requests. The buffers must be the operating system page size (4K.)

Servers 40
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. $

Tuning 59
article thumbnail

Comparisons of Proxies for MySQL

Percona

MySQL router, after the 2048 connection, could not serve anything more. As you can see, and as I was expecting, the three Proxies were behaving more or less the same, serving the same number of operations (they were capped, so why not) until they weren’t. That allows it to go a bit further.

Games 126