Percona

DECEMBER 20, 2023

Please check out the Why Linux HugePages are Super Important for Database Servers: A Case with PostgreSQL blog post for more information. Unfortunately, the performance in benchmarks is almost the same as for 4KB pages. Setup I recommend starting with 2MB huge pages because it’s trivial to set up.

C++ 96

C++ Virtualization Benchmarking Database 96

Percona

OCTOBER 2, 2023

Percona Toolkit is a collection of advanced open source command-line tools, developed and used by the Percona technical staff, that are engineered to perform a variety of MySQL, MariaDB, MongoDB, and PostgreSQL server and system tasks that are too difficult or complex to perform manually. And did I mention they are open source?!

Cache 98

Cache Database Virtualization Servers 98

HammerDB

NOVEMBER 22, 2021

Introducing the PostgreSQL performance metrics viewer. HammerDB included a graphical performance metrics view for the Oracle database only. HammerDB includes the same functionality for PostgreSQL enabling the user to drill down on database metrics in real time. Prior to version 4.3, PostgreSQL Graphical Metrics.

Metrics 62

Metrics Benchmarking C++ Database 62

Percona

DECEMBER 27, 2022

Encrypting data at rest in a database management system (DBMS) refers to securing data by encrypting it when it is not being used or accessed. TDE can be applied at various levels, such as at the database, column, or cell level, depending on the organization’s specific security needs. Database-level encryption.

Database 93

Database Storage Servers Strategy 93

Percona

AUGUST 29, 2018

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. Therefore, it is imperative that these parameters are configured according to the database server and its workload.

Tuning 55

Tuning Database Servers Processing 55

Percona

MARCH 20, 2023

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 120

Games Latency Traffic Cache 120

Percona

AUGUST 21, 2023

Although the installation of LDAP includes setting the password, which will be admin, by executing the following command, one can reset the password at will: # Select "No" when asked to configure the database with dbconfig-common. # Set the domain name for your LDAP server, for example, "example.com". #

C++ 70

C++ Servers Open Source Testing 70