Publications
Detailed Information
Characterizing Database Workloads via a Comprehensive I/O Analysis : 포괄적인 IO 분석을 통한 데이터베이스의 워크로드 특성 파악
Cited 0 time in
Web of Science
Cited 0 time in Scopus
- Authors
- Advisor
- 염헌영
- Major
- 공과대학 컴퓨터공학부
- Issue Date
- 2018-02
- Publisher
- 서울대학교 대학원
- Keywords
- Database Workload Characterize ; I/O Analysis ; Mixed Read/Write ; I/O Separation ; OLTP Workload
- Description
- 학위논문 (석사)-- 서울대학교 대학원 : 공과대학 컴퓨터공학부, 2018. 2. 염헌영.
- Abstract
- Nowadays high-performance storage like NVMe is widely used for various area where massive I/O is required. Although the ideal read or write speed on those high-performance storage is much improved than previous ones, in practical usages there are many factors which are making performance degradation. One of them is occurred when the mixed read and write workload is executed. The read action cannot execute but wait until write action made a lock on same physical device for writing. Many OLTP database workloads are consisted of mixed read and write. So if those cases are happen frequently, high performance device cannot be utilized its capability.
Workloads have each characteristic. TPC-C has a table which is read only. If this table move its table file location to physically separate one, read action to this table doesn't need to wait until the write action's completion. As a result, the entire performance can be increased according to the read only table's query frequency.
In this paper I/O analysis can be used to identify the characteristics of database workloads. After the analysis is completed, the experiments which the separation of read only tables and other read/write mixed ones are executed. Without any other configuration except the location of table file, the performance TpmC from TPC-C will be increased 7% on NVMe storage. So more proactive read/write separation would be effective to improve the entire OLTP database workloads.
- Language
- English
- Files in This Item:
Item View & Download Count
Items in S-Space are protected by copyright, with all rights reserved, unless otherwise indicated.