Leeds PHP - January 2022

✩ MySQL with Bells & Whistles - Thomas Shone (@thomas_shone)

Dive into MySQL to explore our Cargo Culting behaviours and the inner workings of MySQL and some useful tricks you may not know about.
What happens when a table doesn’t have a primary key?
What does a sane primary key look like?
What is a clustered index?
How do indexes work?
How should I design my indexes and how do I know if it is actually being used?
What tools are there out there to make my life easier?

★ About Thomas
South African lost in Amsterdam, he dabbles in security and have been involved in vulnerability disclosures with 3 different credit card processors (only one of them sent legal threats). Nowadays he spend most of his time now helping grow other developers at http://Booking.com.