DARK: Deep automatic Redis knobs tuning system depending on the persistence method. (1st July 2023)

• Record Type: Journal Article
• Authors: Seo, Juyeon; Kim, Kyeonghun; Seo, Sangmin; Park, Sanghyun
• Is Part Of: Expert systems with applications. Volume 221(2023)
• Publication Date: 2023-07-01
• Subjects: Parameter Optimization -- Redis -- Genetic Algorithm -- Deep Learning; Expert systems (Computer science) -- Periodicals; Systèmes experts (Informatique) -- Périodiques; Electronic journals; 006.33
• DOI: 10.1016/j.eswa.2023.119697
• Languages: English
• ISSNs: 0957-4174

Abstract

Abstract: Database Management System (DBMS) runs the server with numerous knobs having different roles, which are set in the configuration file, and the performance of the DBMS can easily depend on the configuration. It could derive greater performance by finding the appropriate values of knobs, but there is a limitation for an expert who seeks to ascertain the most effective parameter combination directly due to the diversity of knobs and the wide range of values that each parameter could have. In this study, we propose the DARK tuning system to improve the performance of Redis, an in-memory key-value store. Since the two persistence methods provided in Redis are not designed to operate simultaneously, the tuning was performed by classifying knobs related to persistence methods. Also, we propose the Cross-GA, a method of conducting the prediction and alignment alternately of Genetic Algorithm to improve throughput and latency simultaneously. To verify the effectiveness of the proposed method, we carried out performance evaluations through Memtier-benchmark, a benchmark program for in-memory databases. As a result of performing Redis knobs tuning via DARK, the optimal configuration was derived to improve throughput up to 39.8% and latency up to 71.3% compared to the existing configuration.