Remove 2048 Remove Database Remove Processing Remove Virtualization
article thumbnail

Using Huge Pages with PostgreSQL Running Inside Kubernetes

Percona

Modern servers operate with terabytes of RAM, and by default, processors work with virtual memory address translation for each 4KB page. OS maintains a huge list of allocated and free pages to make slow but reliable address translation from virtual to physical. It’s easy with anydbver and k3d.

C++ 97
article thumbnail

Percona Toolkit – A Quick Introduction to Summary

Percona

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. virtual = 2.2G virtual = 2.2G virtual = 2.2G virtual = 2.2G

Cache 98
article thumbnail

SQL Server I/O Basics Chapter #2

SQL Server According to Bob

KB sectors run on smaller sectors   14 System and sample databases   15 Determining the formatted sector size of database   15 What sector sizes does SQL Server support? DBCC Page Auditing DBCC page auditing is the process of executing common DBCC consistency checks as pages are read from disk.

Servers 40