Born in 2010 as "a feature for monitoring server execution at a low level," grown over the years with performance fixes and DBA-faced features, in MySQL 8.0 Performance Schema is a mature tool, used by humans and monitoring products. In this webinar I will give an overview of Performance Schema, focusing on its tuning, performance, and usability.
Performance Schema helps to troubleshoot query performance, complicated locking issues, memory leaks, resource usage, problematic behavior, caused by inappropriate settings and much more. It comes with hundreds of options which allow precisely tune what to instrument.
Performance Schema is a potent and very complicated tool. It does not affect performance in most cases, collects a lot of data, and sometimes this data is hard to read.
In this webinar, I will guide you through the main Performance Schema features, design, and configuration. You will learn how to get the best of it. I will cover its companion sys schema and graphical monitoring tools.