PHP's Biggest Bottleneck - MySQL

PHP's Biggest Bottleneck - MySQL

Discover how to optimize MySQL performance in PHP applications during this 45-minute conference talk from PHP UK Conference. Learn about the common bottlenecks in MySQL and explore eight practical solutions to enhance database efficiency. Gain insights into indexing techniques, query caching, storage engine selection, and slow query log analysis. Understand the importance of proper data type usage and stored procedures. By the end of this talk, acquire the skills to diagnose and resolve MySQL performance issues like a database administrator, ultimately improving the speed and responsiveness of your PHP applications.