article thumbnail

Using Huge Pages with PostgreSQL Running Inside Kubernetes

Percona

Unfortunately, the performance in benchmarks is almost the same as for 4KB pages. 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.

C++ 98
article thumbnail

Comparisons of Proxies for MySQL

Percona

In short, each cluster is, in reality, a single database with high availability and other functionalities built in. MySQL router, after the 2048 connection, could not serve anything more. HAProxy performs better with a low number of connections, while ProxySQL performs better when a high number of connections is in place.

Games 121
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

Transparent Data Encryption (TDE)

Percona

Several tools are available for implementing disk-level encryption, including BitLocker for Windows, dm-crypt for Linux, and FileVault for MacOS. Implementing table-level encryption may require additional resources and impact performance, so carefully evaluating the trade-offs between security and performance is essential.

article thumbnail

Tune Linux Kernel Parameters For PostgreSQL Optimization

Percona

For optimum performance, a PostgreSQL database depends on the operating system parameters being defined correctly. Poorly configured OS kernel parameters can cause degradation in database server performance. This results in improved performance. SHMMAX / SHMALL. Until version 9.2, PostgreSQL switched to POSIX shared memory.

Tuning 56
article thumbnail

Data Redundancy With the PostgreSQL Citus Extension

Percona

Reference tables can be replicated to all nodes for joins and foreign keys from distributed tables and for maximum read performance. 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. citus_columnar | 11.1-1

C++ 80
article thumbnail

What are the best multi-browser testing tools?

Testsigma

To ensure the features run uniformly across various browsers and OS versions that our users have, we should perform multi-browser testing. You can also check out our post on the most common issues one can face while performing browser compatibility tests. Let us understand the importance of multi-browser testing before we proceed.

article thumbnail

A thorough introduction to bpftrace

Brendan Gregg

bpftrace is a new open source tracer for Linux for analyzing production performance problems and troubleshooting software. Linux already has many performance tools, but these are often counter-based and have limited visibility. This example instrumented one of many thousands of available events. bashreadline.bt biolatency.bt

Latency 68