Performance schema and Sys schema in MySQL 5.7
MySQL 5.7 now includes the sys schema by default, which builds upon the extensive instrumentation framework laid by Performance Schema.
Performance Schema has had 23 worklogs completed in 5.7 alone, such as memory instrumentation, tying in transactions and stored programs in to the current statement/stage/wait instruments and wait graph, prepared statement instruments, metadata lock information, improved session status and variable reporting, the new structured replication tables, and more.
The sys schema builds upon this strong foundation with easy reporting views and functions, as well as procedures to help both set up and manage the configuration of Performance Schema, and help diagnose performance issues with your database instances on the whole.
Join this webinar to hear about all of the exciting instrumentation improvements in MySQL 5.7, directly from the original developer of the sys schema.
- Mark Leith, Senior Software Development Manager
On24 Registration page will open in a new tab/window