Databases play a key role in dynamic websites. All incoming and outgoing data is stored in a database. So, if the database for a PHP application is not well designed and optimized, it will effect the application's performance tremendously. In this chapter, we will look into the ways of optimizing our PHP application's database. The following topics will be covered in this chapter:
MySQL
Query caching
The MyISAM and InnoDB storage engines
The Percona DB and Percona XtraDB storage engines
MySQL performance monitoring tools
Redis
Memcached