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 …