Physical Layer Tuning
Tuning the physical layer entails choosing and configuring the underlying hardware and operating system to improve the performance of a database system running a given set of applications.
Ultimately, a database management system runs on processor and memory chips as well as secondary devices such as flash memory and disks. Trying to use those physical resources in the best way possible has been a problem since the first databases were available. Many researchers have noticed that disk capacity has been less of an issue than disk speed (or aggregate bandwidth from an entire disk array). Main memory size has always been a critical factor, because accesses to main memory are so much faster than accesses to disk. Processor speed has been important in applications that mix sophisticated computation with data access (for example in financial analysis), such computations are often handled outside the database server. New technologies have improved the...
- 1.Gray J, Kukol P. Sequential disk IO tests for GBps land speed record. MS Research Technical Report MSR-TR-2004-62.Google Scholar
- 2.Gray J, Shanoy PJ. Rules of thumb in data engineering. In: Proceedings of the 18th International Conference on Data Engineering; 2000.Google Scholar
- 3.Hall C, Bonnet Ph. Getting priorities straight: improving Linux support for database I/O. In: Proceedings of the 31st International Conference on Very Large Data Bases; 2005.Google Scholar
- 4.Shasha D, Bonnet P. Database tuning: principles, experiments and troubleshooting techniques. San Francisco: Morgan Kaufmann; 2002.Google Scholar