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

Abstract: 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)
Date: 2016
References: View complete reference list from CitEc
Citations:

Downloads: (external link)
http://www.dbjournal.ro/archive/23/23_1.pdf (application/pdf)

Related works:
This item may be available elsewhere in EconPapers: Search for items with the same title.

Export reference: BibTeX RIS (EndNote, ProCite, RefMan) HTML/Text

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 ().