Re: Database Usage of Unix FFS

lparsons_at_world.std.com (Lee E Parsons) writes:

>Situation: Large database files are the only files on a group of UNIX
> Fast FileSystem partitions. These files are created by the
> database on initialization and if any are deleted all
> are deleted. The files would likely be 50 to 100mb each.
> 1 partition = 1 drive.
>
>Given the low number of unix creates/delete on these drives, please
>comment on the following statements.
>
>1) It would seem reasonable in this case to turn the minfree option
> on the FFS down as low as possable (0%) and use as much of the
> drive as you can (100%).
>

• (I/O distribution considerations aside. Of course.) ****

> Since you wont be doing any creates or deleted you don't need any
> free space to increase your performance.

Yes most definitly. Also, you can reduce the number of inodes as well, as typically there are a very few very large files. Also, when you are using very large virtual file systems this should be done or you waste a lot of disk space

regards

-- 
Rob Logie,      Telecom Australia | The opinions expressed are mine alone and in
Telstra Corp.     ACN 051 775 556 | no-way reflect the views or policies of the
ITG NP Support, Queensland        | Telstra Corporation Limited
EMAIL: logier_at_qus102.qld.npb.telecom.com.au| "These are my opinions alone"