Anzeige
Erschienen in:
2017 | OriginalPaper | Buchkapitel
Online Transaction Processing (OLTP) Performance Improvement Using File-Systems Layer Transparent Compression
verfasst von : Suharjito, Adrianus B. Kurnadi
Erschienen in: Intelligent Information and Database Systems
Aktivieren Sie unsere intelligente Suche, um passende Fachinhalte oder Patente zu finden.
Wählen Sie Textabschnitte aus um mit Künstlicher Intelligenz passenden Patente zu finden. powered by
Markieren Sie Textabschnitte, um KI-gestützt weitere passende Inhalte zu finden. powered by
Abstract
In this research, we use three Swingbench OLTP benchmark scenarios to examine that three compression algorithm in ZFS file-systems namely LZ4, LZJB and ZLE can improve OLTP database performance. Beside the database performance, we also compare how much storage can be saved, impact to maximum response time, and the increase of CPU utilization from the three compression algorithms. The acquired data were then be analyzed using Analytic Hierarchy Process to find out the highest ranking compression in terms of benefits and benefits to cost ratio. The result indicates that LZJB achieved the highest performance improvement, LZ4 achieved the highest storage saving and ZLE achieved the smallest CPU utilization overhead. The safest algorithm that did not experience any reduction in database performance or increase of maximum response time in this research is LZJB.