Percona

AUGUST 29, 2018

In this post, we will discuss some important kernel parameters that can affect database server performance and how these should be tuned. You need to set a value of vm.dirty_background_bytes depending on your disk speed. Therefore, it is imperative that these parameters are configured according to the database server and its workload.

Tuning 54

Tuning Database Servers Processing 54

Percona

AUGUST 29, 2023

Columnar storage of tables can compress data, speeding up scans and supporting fast projections, both on regular and distributed tables. Depending on the configuration, one can tune a hardware RAID for either performance or redundancy. Now let’s stretch our imagination and consider a second method of high availability, ala Citus.

C++ 78

C++ Database Storage Testing 78

SQL Server According to Bob

JANUARY 11, 2020

​​ However, the ​​ algorithm ​​ has been ​​ tuned ​​ and the resulting ​​ affect ​​ is ​​ minimal. ​​ For example, ​​ the I/O speed of a snapshot database could limit certain query scalabilities.

Servers 40

Servers Cache Database Media 40