Abstract
In this chapter we look at the MySQL database server and how to tune it. There are three basic strategies we can employ to improve a database: adding hardware, tweaking settings within MySQL, and tweaking the queries that we send to MySQL or adding indexes so they will execute faster.
This is a preview of subscription content, log in via an institution to check access.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Preview
Unable to display preview. Download preview PDF.
Rights and permissions
Copyright information
© 2009 John Coggeshall
About this chapter
Cite this chapter
(2009). The MySQL Database. In: Zend Enterprise PHP Patterns. Apress. https://doi.org/10.1007/978-1-4302-1975-0_10
Download citation
DOI: https://doi.org/10.1007/978-1-4302-1975-0_10
Publisher Name: Apress
Print ISBN: 978-1-4302-1974-3
Online ISBN: 978-1-4302-1975-0
eBook Packages: Professional and Applied ComputingProfessional and Applied Computing (R0)Apress Access Books