Memory usage in Firebird SQL - Firebird recovery ...

MEMORY USAGE IN FIREBIRD

Alexey Kovyazin IBSurgeon ib-

2

? Replication, Recovery and Optimization for Firebird and InterBase since 2002

? Platinum Sponsor of Firebird Foundation

? Based in Moscow, Russia

ibase.ru ib-

20/05/2018 ib-

3

Agenda

Part 1: Understanding memory usage in Firebird ? Memory types in Windows and Linux ? How Firebird uses memory ? File cache and Firebird Part 2: Tuning memory usage in Firebird database ? Firebird.conf parameters for memory tuning ? Optimal firebird parameters

20/05/2018 ib-

4

PART 1: UNDERSTANDING MEMORY USAGE IN FIREBIRD

20/05/2018 ib-

5

3 main types of memory in OS

Core

Paged memory

Memory, occupied by processes

File cache

Frequently used files

20/05/2018 ib-

 ................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download