"Paul B. Henson" henson@acm.org schrieb am 16.02.2022 um 06:13 in
Nachricht 5f015d2d-8965-6c70-0c6d-7a96e9ec290c@acm.org:
On 2/15/2022 1:57 AM, Ondřej Kuzník wrote:
- if, to answer that query, you need to crawl a large part of the DB, the OS will have to page that part into memory
Do you know if there's any way to tell which pages of a memory mapped file are actually in memory at any given time? The process map just shows 5G (the max size I currently have configured for the database):
00007fece8cfb000 5242880K rw-s- data.mdb
"man pmap", maybe?
# pmap $$ 21561: -bash Address Kbytes RSS PSS Dirty Swap Mode Mapping 0000558d2476d000 964 904 904 0 0 r-xp- /usr/bin/bash 0000558d24a5e000 8 8 8 8 0 r--p- /usr/bin/bash 0000558d24a60000 16 16 16 16 0 rw-p- /usr/bin/bash 0000558d24a64000 56 44 44 44 0 rw-p- [ anon ] 0000558d25ff7000 4464 4384 4384 4384 0 rw-p- [ anon ] 00007f1ca39a8000 2528 192 35 0 0 r--p- /usr/lib/locale/en_US.utf8/LC_COLLATE 00007f1ca3c20000 28 28 0 0 0 r-xp- /lib64/libnss_compat-2.31.so 00007f1ca3c27000 2048 0 0 0 0 ---p- /lib64/libnss_compat-2.31.so 00007f1ca3e27000 4 4 4 4 0 r--p- /lib64/libnss_compat-2.31.so 00007f1ca3e28000 4 4 4 4 0 rw-p- /lib64/libnss_compat-2.31.so 00007f1ca3e29000 152 152 38 0 0 r-xp- /lib64/libtinfo.so.6.1 00007f1ca3e4f000 2044 0 0 0 0 ---p- /lib64/libtinfo.so.6.1 [...]
Thanks…