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.

Full Text
Published version (Free)

Talk to us

Join us for a 30 min session where you can share your feedback and ask us any queries you have

Schedule a call