Veritas File System 5.0 Administrator's Guide (September 2006)

To enable caching on a file
◆
Enable caching on a file:
$ qioadmin -S filename=on mount_point
To disable caching on a file
◆
Disable caching on a file:
$ qioadmin -S mount_point
To make the caching setting persistent across mounts
◆
Create a qiotab file, /etc/vx/qioadmin, to list files and their caching
advisories. Based on the following example, the file /database/sell.dbf will
have caching turned on whenever the file system /database is mounted:
device=/dev/vx/dsk/datadg/database01
dates.dbf,off
names.dbf,off
sell.dbf,on
To check on the current cache advisory settings for a file
◆
Check the current cache advisory settings:
$ qioadmin -P filename mount_point
filename,OFF
To check the setting of the qio_cache_enable flag for a file system
◆
Check the setting of the qio_cache_enable flag:
$ vxtunefs -p /database01
qio_cache_enable = 1
Check the setting of the flag qio_cache_enable using the vxtunefs command,
and the individual cache advisories for each file, to verify caching.
Tuning Cached Quick I/O
Not all database files can take advantage of caching. Performance may even
degrade in some instances (due to double buffering, for example). Determining
which files and applications can benefit from Cached Quick I/O requires that you
first collect and analyze the caching statistics.
See the qiostat(1) manual page.
Quick I/O for Databases
Cached Quick I/O for databases
194