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.
Overview
Syllabus
Introduction
The problem with MySQL
Simple fixes
Indexes
Simple example
Using an index
Storing indexes
Explain
Explain example
Explain example 2
What is query caching
Configure query caching
Choose the right storage engine
Use a slow query log
Example slow query log
Slow query definition
Understanding data types
User table example
Questions
Procedures
Taught by
PHP UK Conference
