On configuring the Performance Schema
This article is a user guide about MySQL 5.6 Performance Schema
configuration. As with many things, the way to approach problems
may vary a lot based on systems, user experiences, or just plain
opinions, so the "Your Mileage May Vary" caution applies
here.
It is easy to get lost in details, and yet starting with the big
picture in mind helps to understand not only how, but also more
importantly why, to do things ...
The magic recipe is as follows
- Define your goals
- Define what to instrument
- Define how much detail to collect
- Provide sizing data
- Monitor sizing problems
Define your goals
Performance instrumentation in general can be used for many
different things, ranging from casual monitoring in production to
debugging in development, with every flavor in …