Re: HELP: How much diskspace in /tmp per us

In article k9u@emory.mathcs.emory.edu, cwakins@jabba.rmc.com (Clem W. Akins) writes: >In <1994Jul15.053552.20462@hasler.ascom.ch> >nbladt@autelca.ascom.ch (Norbert Bladt) writes: > >> Hello ! >> >> After getting my problem solved with the permissions of the Informix >> files, I finally could do the performance tests for the three systems >> we have. >> During that I found that the performance depends on the amount of free >> space on the root filesystem - no system did have a /tmp filesystem. [ Some questions deleted] >2. This one's both easy and hard. The easy part: > Perform a lengthy analysis of your source code and application in light of > your database size and derive a set of statistics for your user's needs. > Include: > Largest possible request (don't forget sorting) and frequency > Largest likely request and frequency > Temp file size: min, max, avg, std dev, median and mode, etc > Balance this information against the cost of disk space on your platform > (remember I/O time, mean time between failure, admin time, not just initial > cost) > Develop a scale of values graphing the cost of solution against the usage > likelyhood. > Extend that graph to include the cost of your user's time, find the break > even point, and compare that monetary value to your budget. Be sure to > factor in expected growth and falling media costs/faster access times. > > The hard part: > Actually doing this at your site in the span of a human lifetime. We all > do this intuitively all the time, and I wonder to what degree our > performance suffers in proportion to the intuitive/explicit mix. I was afraid that I would get this answer :-) I will create a /tmp-filesystem and just make it "big enough", whatever that means or whatever is left on the disk for this purpose. That's about the best I can do, I guess. Fortunately, we have two disks: One for the DB and the other for the temporary files, the swap (never used, anyway) and the software. >Maybe I should write my own DBA book! :) Definitely :-) >Good luck, Thanks a lot. Regards, Norbert. --- Norbert Bladt, ascom Autelca AG VOICE: +41 31 999 6552 Payphone Management Software FAX: +41 31 999 6544 Worbstrasse 201 UUCP: uunet!mcsun!hslrswi!aut!nbladt CH-3073 Guemligen, Switzerland EMAIL: nbladt@autelca.ascom.ch