PHP & Databases - How MySQL can boost or kill your PHP application | PHP Cambridge July 2020
PHP Cambridge July 2020 talk by Federico Razzoli.
The database is typically the most critical part of a system. It is responsible for storing data, guaranteeing consistency, and retrieving desired information.
And it is very tempting to just hope that this will magically happen, without the need of thinking about what the DBMS needs to do.
Unfortunately, in practice, when an application is slow the culprit is the database.
This talk is about how to make your MySQL queries fast, how to design proper indexes, how to trade-off reliability for performance (or the other way around), and how to take advantage of some useful MySQL features.
Federico is an open-source database consultant, specialised in the MySQL ecosystem. After working in some fast-growing companies as a DBA and in some consultancy companies, he decided to be a freelance. Now he helps companies with training, performance tuning, database monitoring, automation, and so on.