Percona

OCTOBER 3, 2023

While THP can be beneficial for many applications, enabling it on a database server could have unintended consequences. In this post, we will explore THP, its impact on database servers, and how to disable it for optimal performance and stability. The concept of HugePages in Linux has existed for many years, first introduced in 2007.

Database 90

Database Servers Open Source C++ 90

Brendan Gregg

JANUARY 17, 2018

OSes usually show you virtual memory and resident memory, shown as the "VIRT" and "RES" columns in top. Here is a MySQL database server (mysqld), PID 423, and measuring its working set size for 0.1 The tool also has a cumulative mode (-C), which resets the referenced flags once then takes continuous measurements. 102.36. [.].

Cache 71

Cache Latency C++ Programming 71

Brendan Gregg

JANUARY 16, 2018

OSes usually show you virtual memory and resident memory, shown as the "VIRT" and "RES" columns in top. Here is a MySQL database server (mysqld), PID 423, and measuring its working set size for 0.1 The tool also has a cumulative mode (-C), which resets the referenced flags once then takes continuous measurements. 102.36. [.].

Cache 40

Cache Latency C++ Programming 40