Changing The Cache Size
The default database cache (page buffer) is set when the database is created, or subsequently by using gfix -b[uffers] <number-of-pages>
.Gbak
can restore a database and set the default cache size as well.The process is as follows:
tux> # Check current cache size (as root user!) tux> gstat -h employee | grep -i buffer Page buffers 0 tux> # Restore the database & change the cache size. tux> gfix -shut -tran 60 employee tux> gbak -r o -buffer 200 /backups/employee.fbk employee tux> # Check the new cache size (as root user!) tux> gstat -h employee | grep -i buffer Page buffers 200
The default cache size is used when the number of buffers is zero, as in the first example above.Gbak
allows this to be changed if desired.Gbak
, however, cannot set the cache size back to zero.You must use gfix
to do this.