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.
KeywordsDatabase Server Execution Plan Buffer Pool Online Analytical Processing Storage Engine
Unable to display preview. Download preview PDF.