Linux – DBA Notes

General Linux Postgres postgresql

HUGE PAGES AND POSTGRESQL

Bulent Soylu March 9, 2024 hugepages postgresql

On any modern system, applications don’t use physical memory directly. Instead, they use a virtual memory address model to make it easier to handle memory…

Linux Oracle performance

How to configure HugePages for Oracle Database Server

Hugepages and Large Pages If you run a Oracle Database on a Linux Server with more than 16 GB physical memory and your System Global…

Linux MySQL Oracle postgresql Windows

How to get Connected Two Virtual Machines In VirtualBox

Bulent Soylu October 6, 2023 sandbox virtual machine virtualbox vm

If you ever need to run multiple OSes simultaneously, a virtual machine (VM) is one of your best options. It’s cost-effective, provides relatively good performance,…

Linux

Find Top Running Processes by Memory and CPU Usage

Bulent Soylu August 11, 2023 cpu linux memory ram

1. top command The top command gives real-time information about the running processes as well as a summary of system information. It displays uptime, load averages, CPU…

Linux

How to troubleshoot high memory usage in linux

Bulent Soylu August 11, 2023 linux memory

There are situations where your server shows unintended behaviors like a slow response from websites, failures with services, inability to start applications, server crashes etc.…

Linux Oracle performance

What is the usecase of dev shm

Bulent Soylu August 2, 2023 /dev/shm oracle performance tmpfs

/dev/shm is a temporary file storage filesystem (see tmpfs) that uses RAM for the storage. It can function as shared memory that facilitates IPC. It is a…

Linux performance SQL

Understanding IOPS vs. throughput

Bulent Soylu January 9, 2023 linux oracle performance

Input/output operations per second (IOPS) and data throughput are two popular performance characteristics of any storage system. In the early days of computer technology, when…