Operating System Tuning

• Beyond the scope of this talk
   
• Basics: make sure you have enough memory, CPU, and processes available for your RDBMS and clients. (e.g. /proc/sys/kernel/shmmax)
   
• Biggest concern is memory. Work with the DB parameters
   
• Filesystems
   
• Remember OS-level disk caching
   
• Keep the database on its own box if possible (ps -Afw)
   
• Don't forget to tune the network settings

Previous: Hardware Tuning         [Table of Contents]         Next: Database System Tuning