1 / 18

Energy Efficiency Analysis of Database Servers: Insights from SIGMOD 2010 Study

This study conducted by Tsirogiannis, Harizopoulos, and Shah explores the energy efficiency of database server architectures using standard server-grade hardware. Analyzing various database tasks on a specific HP workstation, the research evaluates component power consumption, especially focusing on CPUs and storage devices. The findings reveal that energy efficiency directly correlates with performance across many database configurations. Significantly, the analysis suggests that optimizing execution plans can achieve both enhanced performance and energy efficiency, presenting important implications for future server setups and research in power management.

doria
Télécharger la présentation

Energy Efficiency Analysis of Database Servers: Insights from SIGMOD 2010 Study

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Analyzing the Energy Efficiency of a Database ServerD. Tsirogiannis (U of Toronto), S. Harizopoulos, M. Shah (HP Labs), SIGMOD’10 Shimin Chen Big Data Reading Group

  2. Goals • Energy efficiency of: • Single-machine instance of DBMS • Standard server-grade hardware components • A wide spectrum of database tasks • Assess and explore ways to improve energy efficiency

  3. Machine Configuration • HP xw8600 workstation • 64-bit Fedora 4 Linux (kernel 2.6.29) • Two Intel Xeon E5430 2.66GHz quad core CPUs (32K L1, 6MB L2) • 16GB RAM • 4 HDDs (Seagate Savvio 10K.3) • 4 SSDs (Intel X-25E)

  4. Power Measurement • Total system power: • power meter • Individual components: • clamp meter to measure 5V and 12V lines from the power supply

  5. Component Power Range:

  6. Power Proportionality of Disks • Configure 4 disks (SSDs) as RAID-0. Read a 100GB file sequentially, varying disk utilization by increasing CPU computation overhead

  7. CPUs • Consumes 85% of dynamic power • Use four micro-benchmarks to study CPU power • Two scheduling policies: • Freq adjustedby OS

  8. Big jump when a CPU becomes active • Hash join and row scan consumes more power

  9. see higher memory bus utilization

  10. CPU power is not a linear function of the number of cores used • For a fixed configuration, different operators may differ significantly (60% in the experiments)

  11. Energy vs. Performance • Energy efficiency vs. performance for a large number of DB configurations • DB: algorithm kernels, PostgreSQL, commercial System-X • Knobs: • Execution plan selection • Intra-operator parallelism (# of cores for a single operator) • Inter-query parallelism (# of independent queries in parallel) • Physical layout (row vs. column) • Storage layout (striping) • Choice of storage medium (HDD vs. SDD)

  12. Dynamic power range among the points is small, 165W + 19%

  13. Again: 169W+14% • Therefore the linear relationship

  14. Linear relationship with less than 10% variance

  15. This means • For this current server, the best performing DB execution plan is also good enough for energy efficiency

  16. More variance as idle power is reduced

  17. Power capping leads to more interesting configurations

  18. Summary • This paper studies a DB server representing the current hardware • Results show that performance and energy efficiency are highly co-related. • As server hardware becomes more energy efficient, idle power may reduce, leading to more variance • Power capping also provides interesting research challenges

More Related