Percona

DECEMBER 20, 2023

Modern servers operate with terabytes of RAM, and by default, processors work with virtual memory address translation for each 4KB page. Please check out the Why Linux HugePages are Super Important for Database Servers: A Case with PostgreSQL blog post for more information. Kubectl helps to check the amount of huge pages available.

C++ 105

C++ Virtualization Benchmarking Database 105

Percona

DECEMBER 5, 2022

ProxySQL is a very useful tool for gaining high availability, load balancing, query routing, query caching, query rewriting, multiplexing, and data masking. There can be an instance of ProxySQL using a lot of memory on the server. This post is related to one of the causes that can use memory on the ProxySQL server and how we handle it.

Servers 60

Servers Cache C++ Metrics 60

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. ProxySQL was penalized by the limited resources, but this was the game, we had to get the most out of the few available.

Games 126

Games Latency Traffic Cache 126

Percona

DECEMBER 27, 2022

Several tools are available for implementing disk-level encryption, including BitLocker for Windows, dm-crypt for Linux, and FileVault for MacOS. Cluster-level encryption is a security measure that encrypts data stored in a cluster of servers or storage devices. . Encryption available in databases. Microsoft SQL Server.

Database 94

Database Storage Servers Strategy 94

Percona

AUGUST 29, 2018

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. SHMMAX / SHMALL. The PostgreSQL documentation contains more information about shared memory configuration.

Tuning 59

Tuning Database Servers Processing 59

Dean Hume

OCTOBER 24, 2016

One of my favourite features of HTTP/2 is Server Push. the browser requests a web page, the server sends the HTML in the response, and then it needs to wait for the browser to parse the HTML and issue requests for all of the embedded assets before it can start sending the JavaScript, images and CSS. With HTTP/1.1, Show me the code!

Servers 40

Servers Website Games Cache 40

Dean Hume

OCTOBER 24, 2016

One of my favourite features of HTTP/2 is Server Push. the browser requests a web page, the server sends the HTML in the response, and then it needs to wait for the browser to parse the HTML and issue requests for all of the embedded assets before it can start sending the JavaScript, images and CSS. With HTTP/1.1, Show me the code!

Servers 40

Servers Website Games Cache 40