I thought it was worth a moment to reiterate on the new
Performance Schema related defaults that MySQL 5.7.7 brings to
the table, for various reasons.
For one, most of you might have noticed that profiling was marked as deprecated in MySQL 5.6.7.
So it is expected that you invest into learning more about
Performance Schema (and Mark’s sys schema!).
Second, there are lots of virtual environments and appliances out
there running Community Edition MySQL where Performance Schema
can be a useful tool for analyzing performance. Thus, expect to
see more articles about using PERFORMANCE_SCHEMA and SYS_SCHEMA
Third, we have more and more junior readers who might benefit
from light reads such as this.
The new defaults that I wanted to highlight are mentioned in the