This MySQL setting makes your PHP app dead slow or crazy fast

Try our PHP Profiler: https://tideways.com/profiler/features?utm_source=yt&utm_campaign=yt-buffer-pool Subscribe to my newsletter for PHP performance content: https://tideways.com/newsletter?utm_source=yt&utm_campaign=yt-buffer-pool In this video we are going to look at the most important MySQL server configuration variable “Buffer Pool Size” and explain why it's so important, how to monitor and change it. Chapters: 00:00 Introduction 00:30 What is the InnoDB Buffer Pool? 04:39 Now to Query Metrics about the Buffer Pool 05:06 Determine current setting of InnoDB Buffer Pool 06:06 Determine InnoDB Buffer Pool Cache Hit Rate 11:33 How big is my MySQL dataset including indexes? 14:38 Changing the InnoDB Buffer Pool Size 17:22 Conclusion