#!/bin/bash # Output lines suitable for sysctl configuration based # on total amount of RAM on the system. The output # will allow up to 50% of physical memory to be allocated # into shared memory. # On Linux, you can use it as follows (as root): # # ./shmsetup >> /etc/sysctl.conf # sysctl -p # Early FreeBSD versions do not support the sysconf interface # used here. The exact version where this works hasn't # been confirmed yet. page_size=`getconf PAGE_SIZE` phys_pages=`getconf _PHYS_PAGES` if [ -z "$page_size" ]; then echo Error: cannot determine page size exit 1 fi if [ -z "$phys_pages" ]; then echo Error: cannot determine number of memory pages exit 2 fi shmall=`expr $phys_pages / 2` shmmax=`expr $shmall \* $page_size`
Informações sobre bancos da dados, principalmente open source. Postgres e Firebird serão o foco principal.
segunda-feira, 30 de julho de 2012
Script para determinal valor do SHMMAX e SHMALL?
Abaixo o script para determinar o valor ideal dos parâmetros SHMMAX e SHMALL em sistemas operacionais Linux com o objetivo de melhorar a performance do PostgreSQL, segundo Greg Smith:
Assinar:
Comentários (Atom)