Analyzing the energy efficiency of a database server
Analyzing the energy efficiency of a database server
复制标题
DOI：
10.1145/1807167.1807194
复制
发表时间：
2010-06
期刊：
影响因子：
--
通讯作者：
Dimitris Tsirogiannis;S. Harizopoulos;Mehul A. Shah
中科院分区：
文献类型：
--
作者：
Dimitris Tsirogiannis;S. Harizopoulos;Mehul A. Shah
大型数据中心不断上升的能源成本正在推动节能计算的议程。在本文中，我们主要关注数据库软件在影响和最终提高服务器能效方面的作用。我们首先描述了不同配置参数下数据库操作人员的电力使用概况。我们发现，常见的数据库操作可以使用服务器的全部动态功率范围，并且对于相同的CPU利用率，不同操作的CPU功耗可能相差高达60%。我们还发现，对于这些操作，CPU功率不随CPU利用率线性变化。然后，我们对几类数据库系统和存储管理器进行实验，改变从不同查询计划到压缩算法、从物理布局到CPU频率和操作系统调度的参数。与最近的研究结果相反，我们发现，在用于向外扩展（无共享）架构的单个节点中，最节能的配置通常是性能最高的配置。我们解释了在哪些情况下情况并非如此，并认为这些情况不需要重新定位数据库系统优化目标。此外，我们的结果揭示了跨节点能量优化的机会，并指出了新的横向扩展架构的方向。
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.