Energy-efficient databases using sweet spot frequencies

S Götz, T Ilsche, J Cardoso, J Spillner… - 2014 IEEE/ACM 7th …, 2014 - ieeexplore.ieee.org
S Götz, T Ilsche, J Cardoso, J Spillner, T Kissinger, U Aßmann, W Lehner, WE Nagel…
2014 IEEE/ACM 7th International Conference on Utility and Cloud …, 2014ieeexplore.ieee.org
Database management systems (DBMS) are typically tuned for high performance and
scalability. Nevertheless, carbon footprint and energy efficiency are also becoming
increasing concerns. Unfortunately, existing studies mainly present theoretical contributions
but fall short on proposing practical techniques. These could be used by administrators or
query optimizers to increase the energy efficiency of the DBMS. Thus, this paper explores
the effect of so-called sweet spots, which are energy-efficient CPU frequencies, on the …
Database management systems (DBMS) are typically tuned for high performance and scalability. Nevertheless, carbon footprint and energy efficiency are also becoming increasing concerns. Unfortunately, existing studies mainly present theoretical contributions but fall short on proposing practical techniques. These could be used by administrators or query optimizers to increase the energy efficiency of the DBMS. Thus, this paper explores the effect of so-called sweet spots, which are energy-efficient CPU frequencies, on the energy required to execute queries. From our findings, we derive the Sweet Spot Technique, which relies on identifying energy-efficient sweet spots and the optimal number of threads that minimizes energy consumption for a query or an entire database workload. The technique is simple and has a practical implementation leading to energy savings of up to 50% compared to using the nominal frequency and maximum number of threads.
ieeexplore.ieee.org
Showing the best result for this search. See all results