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. OS maintains a huge list of allocated and free pages to make slow but reliable address translation from virtual to physical. Unfortunately, the performance in benchmarks is almost the same as for 4KB pages.

C++ 97

C++ Virtualization Benchmarking Database 97

Percona

OCTOBER 2, 2023

You can get summaries of your database servers, or you verify replication lag on MySQL and PostgreSQL servers. You get thirty-eight scripts that can do any manner of actions, and you will find them very valuable in your regular database work. And did I mention they are open source?! 25 Buffer Pool Size | 128.0M

Cache 98

Cache Database Virtualization Servers 98

HammerDB

NOVEMBER 22, 2021

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. start the database and then login and create the extensions as follows. Prior to version 4.3, PostgreSQL Metrics Options.

Metrics 62

Metrics Benchmarking C++ Database 62

Percona

DECEMBER 5, 2022

Proxysql has a stats database which we can see with an admin login. This database contains metrics gathered by ProxySQL concerning its internal functioning. 2) mysql-query_digests_max_digest_length – This is by default set to 2048. Explanation. How do we know where the memory is getting used?

Servers 60

Servers Cache C++ Metrics 60

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 94

Database Storage Servers Strategy 94

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. About that, we must always remember the concept that each K8s/Operator cluster needs to be seen as a single service, not as a real cluster.

Games 119

Games Latency Traffic Cache 119