Abstract
MySQL is an open database of the most common. One of the important characteristics of MySQL is that it provides rich storage engines. In the structure of Web applications, it is very important for the performance of database that the system must choose different storage engines based on different needs. But the default settings performance of MySQL is very not good, so it is necessary to optimize when the system uses MySQL. This paper discusses the most two important storage engines in MySQL, and raises the performance of MySQL by optimize MySQL based on different storage engines.
This is a preview of subscription content, log in via an institution.
Buying options
Tax calculation will be finalised at checkout
Purchases are for personal use only
Learn about institutional subscriptionsPreview
Unable to display preview. Download preview PDF.
References
Dan, A., Yu, P.S., Chung, J.-Y.: Characterization of database access pattern for analytic prediction of buffer hit probability. The VLDB Journal 4, 21–24 (1995)
Martin, P., Powley, W., Li, H., et al.: Managing Database Server Performance to Meet QoS Requirements in Electronic Commerce Systems. International Journal on Digital Libraries 3, 316–324 (2002)
Ramakrishnan, R., Gehrkc, J.: Database management systems. McGraw-Hill (2000)
Silberschatz, A., Kedem, Z.: Consistency in hierarchical database systems. J. ACM 27, 72–80 (1980)
Valentin, G., Zuliani, M., Zilio, D.C., et al.: DB2 advisor: an optimizer smart enough to recommend its own indexes. In: Proc. of 16th Intl. Conf. on Ta Engineering (2000)
Scbwartz, B.: High Performance MySQL. The O‘Reilly Press, Sebastopol (2008)
Database Test Suit, http://osdldbt.sourceforge.net
Micro architecture Codename Nehalem, http://www.intel.com
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
Pan, X., Wu, W., Gu, Y. (2011). Study and Optimization Based on MySQL Storage Engine. In: Jin, D., Lin, S. (eds) Advances in Multimedia, Software Engineering and Computing Vol.2. Advances in Intelligent and Soft Computing, vol 129. Springer, Berlin, Heidelberg. https://doi.org/10.1007/978-3-642-25986-9_28
Download citation
DOI: https://doi.org/10.1007/978-3-642-25986-9_28
Publisher Name: Springer, Berlin, Heidelberg
Print ISBN: 978-3-642-25985-2
Online ISBN: 978-3-642-25986-9
eBook Packages: EngineeringEngineering (R0)