Tuning I/O Subsystem: A Key Component in RDBMS Performance Tuning
Hitesh Kumar Sharma (),
Christalin NELSON. S () and
Sanjeev Kumar Singh ()
Additional contact information
Hitesh Kumar Sharma: University of Petroleum and Energy Studies, India
Christalin NELSON. S: University of Petroleum and Energy Studies, India
Sanjeev Kumar Singh: Galgotia University Noida, India
Database Systems Journal, 2016, vol. 7, issue 1, 3-11
In a computer system, the fastest storage component is the CPU cache, followed by the system memory. I/O to disk is thousands of times slower than an access to memory. This fact is the key for why you try to make effective use of memory whenever possible and defer I/Os whenever you can. The majority of the user response time is actually spent waiting for a disk I/O to occur. By making good use of caches in memory and reducing I/O overhead, you can optimize performance. The goal is to retrieve data from memory whenever you can and to use the CPU for other activities whenever you have to wait for I/Os. This paper examines ways to optimize the performance of the system by taking advantage of caching and effective use of the system's CPUs.
Keywords: Tuning; I/O; RDBMS (search for similar items in EconPapers)
References: View complete reference list from CitEc
Citations Track citations by RSS feed
Downloads: (external link)
This item may be available elsewhere in EconPapers: Search for items with the same title.
Export reference: BibTeX
RIS (EndNote, ProCite, RefMan)
Persistent link: https://EconPapers.repec.org/RePEc:aes:dbjour:v:7:y:2016:i:1:p:3-11
Access Statistics for this article
Database Systems Journal is currently edited by Ion Lungu
More articles in Database Systems Journal from Academy of Economic Studies - Bucharest, Romania Contact information at EDIRC.
Bibliographic data for series maintained by Adela Bara ().