Potentiality of Power Management on Database Systems with Power Saving Function of Disk Drives

Nishikawa, N., Nakano, M. and Kitsuregawa, M.

Power consumption of modern datacenters is increasing rapidly. Databases, especially OLTPs, have become a major application at datacenters. Therefore, power-saving management for OLTP applications has become an important task for user budgets and datacenter operations. A recent report described that disk drives consume about 70% of total power of IT equipment when such large OLTP applications are executed. As described in this paper, we specifically examine a novel power-saving management for multiple disk drives of OLTP applications. First, we constructed an experimental system with power meter, and measured basic power consumption and I/O behaviors of OLTP applications. Then we show that basic measurement results confirm there is still the potentiality of power-saving even though OLTP applications are running. We propose a new method that delays database writes based on this I/O behavior knowledge at run time. Experimental and simulation results obtained using our power-saving methods are explained. Our method provides dynamic power saving of disk drives running TPC–C applications, which issue many I/Os to the disk drives.

Cite as: Nishikawa, N., Nakano, M. and Kitsuregawa, M. (2011). Potentiality of Power Management on Database Systems with Power Saving Function of Disk Drives. In Proc. Australasian Database Conference (ADC 2011) Perth, Australia. CRPIT, 115. Heng Tao Shen and Yanchun Zhang Eds., ACS. 37-46

(from crpit.com) (local if available)