Abstract
The power consumption of modern datacenters is increasing rapidly. Storage in datacenter consumes much power. Today, databases, especially those for OLTP, have become a major storage application in datacenters. Therefore, power-saving management for OLTP applications has become an important task for user budgets and datacenter operations. This paper presents a description of a novel power-saving method for large storage systems based on application I/O behavior of OLTP applications. Features of our approach are (i) measurement of actual RAID storage power consumption, (ii) analysis of I/O behavior characteristics of OLTP applications, and (iii) delayed write operation at a storage cache level based on the I/O behavior of OLTP applications. We present a measured result of power consumption of storages during an OLTP application is running, and simulations results of our power-saving methods with varying cache size of storage, which demonstrate that our method provides substantially lower storage power consumption than that of a conventional OLTP environment.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Preview
Unable to display preview. Download preview PDF.
References
U.s. environmental protection agency energy star program, report to congress on server and data center energy efficiency public law, 109–431 (2007)
Bauer, R.: Building the green data center: Towards best practices and technical considerations (2008)
Chu, P.B., Reinsel, E.: Green storage ii: Metrics and measurement (2008)
Colarelli, D., Grunwald, D.: Massive arrays of idle disks for storage archives. In: ACM /IEEE 2002 Conference on Supercomputing, pp. 47–57 (2002)
Transaction Processing Performance Council. Tpc-c, an online transaction processing benchmark
Gens, F.: Idc predictions 2011: Welcome to the new mainstream. IDC White Paper #225878 (2010)
Gniady, C., Hu, Y.C., Lu, Y.H.: Program counter based techniques for dynamic power management. In: Proc. of 10th International Symposium on High Performance Computer Architecutre, pp. 24–35. IEEE (2004)
Harizopoulos, S., Shah, M.A., Meza, J., Ranganathan, P.: Energy efficiency: The new holy grail of data management systems research. In: 4th Biennial Conf. on Innovative Data Systems, pp. 112–123 (2009)
Heath, T., Pinheiro, E., Hom, J., Kremer, U., Bianchini, R.: Application transformations for power and performance-aware device management. In: 11th International Conference on Parallel Architectures and Compilation Techniques, pp. 121–130 (2002)
Li, D., Wang, J.: Eeraid: Power efficient redundant and inexpensive disk arrays. Proc. 11th Workshop on ACM SIGOPS European Workshop, 174–180 (2004)
Mandagere, N., Diehl, J., Du, D.H.-C.: Greenstor: Application-aided energy-efficient storage. In: MSST, pp. 16–29. IEEE Computer Society (2007)
Papathanasiou, A.E., Scott, M.L.: Energy efficient prefetching and caching. In: Proc. of USENIX 2004 Annual Technical Conference, pp. 255–268. USENIX Association Berkeley (2004)
Pinheiro, E., Bianchini, R.: Energy conservation techniques for disk array based servers. In: Proc. 18th Annual International Conference on Supercomputing, pp. 68–78. ACM (2004)
Poess, M., Nambiar, R.O.: Tuning servers, storage and database for power efficient data warehouse. In: 26th IEEE International Conf. on Data Engineering, pp. 1006–1017. IEEE Computer Society (2010)
Reinsel, D.: White paper datacenter ssds: Solid footing for growth. IDC White Paper # 210290 (2008)
Son, S.W., Chen, G., Kandemir, M.T.: Disk layout optimization for reducing energy consumption. In: ICS, pp. 274–283. ACM (2005)
Son, S.W., Kandemir, M., Choudhary, A.: Software-directed disk power management for scientific applications. In: Proc. of 19th IEEE International Parallel and Distributed Proceesing Symposium. IEEE Computer Society (2005)
Tkachenko, V.: tpcc-mysql
Ueno, Y., Goda, K., Kitsuregawa, M.: A study on disk array power reduction using query plan for database systems (2007)
Oldham Weddle, C., Qian, M.J., Wang, A.A.: Paraid: A gear-shifting power-aware raid. In: 5th USENIX Conference on File and Storage, pp. 245–267. USENIX Association (2007)
Yao, X., Wang, J.: Rimac: A novel redundancy based hierarchical cache architecture for power efficient. In: Proc. 2006 EuroSys Conference on High Performance Storage System, pp. 249–262 (2006)
Author information
Authors and Affiliations
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2011 Springer-Verlag Berlin Heidelberg
About this paper
Cite this paper
Nishikawa, N., Nakano, M., Kitsuregawa, M. (2011). Cache Effect for Power Savings of Large Storage Systems with OLTP Applications. In: Kikuchi, S., Madaan, A., Sachdeva, S., Bhalla, S. (eds) Databases in Networked Information Systems. DNIS 2011. Lecture Notes in Computer Science, vol 7108. Springer, Berlin, Heidelberg. https://doi.org/10.1007/978-3-642-25731-5_20
Download citation
DOI: https://doi.org/10.1007/978-3-642-25731-5_20
Publisher Name: Springer, Berlin, Heidelberg
Print ISBN: 978-3-642-25730-8
Online ISBN: 978-3-642-25731-5
eBook Packages: Computer ScienceComputer Science (R0)