ABSTRACT
Rising energy costs in large data centers are driving an agenda for energy-efficient computing. In this paper, we focus on the role of database software in affecting, and, ultimately, improving the energy efficiency of a server. We first characterize the power-use profiles of database operators under different configuration parameters. We find that common database operations can exercise the full dynamic power range of a server, and that the CPU power consumption of different operators, for the same CPU utilization, can differ by as much as 60%. We also find that for these operations CPU power does not vary linearly with CPU utilization.
We then experiment with several classes of database systems and storage managers, varying parameters that span from different query plans to compression algorithms and from physical layout to CPU frequency and operating system scheduling. Contrary to what recent work has suggested, we find that within a single node intended for use in scale-out (shared-nothing) architectures, the most energy-efficient configuration is typically the highest performing one. We explain under which circumstances this is not the case, and argue that these circumstances do not warrant a retargeting of database system optimization goals. Further, our results reveal opportunities for cross-node energy optimizations and point out directions for new scale-out architectures.
- D. G. Andersen, J. Franklin, M. Kaminsky, A. Phanishayee, L. Tan, and V. Vasudevan. Fawn: a fast array of wimpy nodes. In SOSP, pages 1--14, 2009. Google ScholarDigital Library
- L. A. Barroso and U. Hölzle. The case for energy-proportional computing. IEEE Computer, 40(12):33--37, 2007. Google ScholarDigital Library
- X. Fan, W.-D. Weber, and L. A. Barroso. Power provisioning for a warehouse-sized computer. In ISCA, 2007. Google ScholarDigital Library
- G. Graefe. Database servers tailored to improve energy efficiency. In Software Engineering for Tailor-made Data Management, pages 24--28, 2008. Google ScholarDigital Library
- J. Hamilton. Internet-scale data center power efficiency. In CIDR, 2009.Google Scholar
- S. Harizopoulos, D. J. Abadi, S. Madden, and M. Stonebraker. Oltp through the looking glass, and what we found there. In SIGMOD, 2008. Google ScholarDigital Library
- S. Harizopoulos, V. Liang, D. J. Abadi, and S. Madden. Performance tradeoffs in read-optimized databases. In VLDB, pages 487--498, 2006. Google ScholarDigital Library
- S. Harizopoulos, M. A. Shah, J. Meza, and P. Ranganathan. Energy efficiency: The new holy grail of data management systems research. In CIDR, 2009.Google Scholar
- W. Lang and J. M. Patel. Towards eco-friendly database management systems. In CIDR, 2009.Google Scholar
- J. Leverich and C. Kozyrakis. On the energy (in)efficiency of hadoop clusters. In HotPower, 2009.Google ScholarDigital Library
- J. Meza, M. A. Shah, P. Ranganathan, M. Fitzner, and J. Veazey. Tracking the power in an enterprise decision support system. In ISLPED '09, pages 261--266, 2009. Google ScholarDigital Library
- Numonyx. Phase change memory (pcm): A new memory technology to enable new memory usage models. Online, 2009. http://www.numonyx.com/Documents/WhitePapers/Numonyx_PhaseChangeMemory_WhitePaper.pdf.Google Scholar
- C. Nyberg, T. Barclay, Z. Cvetanovic, J. Gray, and D. Lomet. Alphasort: a cache-sensitive parallel external sort. The VLDB Journal, 4(4):603--628, 1995. Google ScholarDigital Library
- R. Raghavendra, P. Ranganathan, et al. No power struggles: A unified multi-level power management architecture for the data center. In ASPLOS, 2008. Google ScholarDigital Library
- S. Rivoire, P. Ranganathan, and C. Kozyrakis. A comparison of high-level full-system power models. In HotPower, 2008. Google ScholarDigital Library
- S. Rivoire, M. A. Shah, P. Ranganathan, and C. Kozyrakis. Joulesort: a balanced energy-efficiency benchmark. In SIGMOD '07, pages 365--376, 2007. Google ScholarDigital Library
- A. Shatdal, C. Kant, and J. F. Naughton. Cache conscious algorithms for relational query processing. In VLDB '94, pages 510--521, 1994. Google ScholarDigital Library
- D. Strukov, G. Snider, D. Stewart, and R. S. Williams. The missing memristor found. Nature, 453:80--83, 2008.Google ScholarCross Ref
- N. Tolia, Z. Wang, et al. Delivering energy proportionality with non energy-proportional systems - optimizing the ensemble. In HotPower, 2008. Google ScholarDigital Library
- Z. Xu, Y. Tu, and X. Wang. Exploring power-performance tradeoffs in database systems. In ICDE, 2010.Google ScholarCross Ref
Index Terms
- Analyzing the energy efficiency of a database server
Recommendations
VM Consolidation Plan for Improving the Energy Efficiency of Cloud
AbstractAchieving energy-efficiency with minimal Service Level Agreement (SLA) violation constraint is a major challenge in cloud datacenters owing to financial and environmental concerns. The static consolidation of Virtual Machines (VMs) is not much ...
VM Consolidation Plan for Improving the Energy Efficiency of Cloud
AbstractAchieving energy-efficiency with minimal Service Level Agreement (SLA) violation constraint is a major challenge in cloud datacenters owing to financial and environmental concerns. The static consolidation of Virtual Machines (VMs) is not much ...
Harnessing voltage margins for energy efficiency in multicore CPUs
MICRO-50 '17: Proceedings of the 50th Annual IEEE/ACM International Symposium on MicroarchitectureIn this paper, we present the first automated system-level analysis of multicore CPUs based on ARMv8 64-bit architecture (8-core, 28nm X-Gene 2 micro-server by AppliedMicro) when pushed to operate in scaled voltage conditions. We report detailed system-...
Comments