Pre-General Availability Draft: 2018-02-22
The Performance Schema is mandatory and always compiled in. It is possible to exclude certain parts of the Performance Schema instrumentation. For example, to exclude stage and statement instrumentation, do this:
shell> cmake . \ -DDISABLE_PSI_STAGE=1 \ -DDISABLE_PSI_STATEMENT=1
For more information, see the descriptions of the
CMake options in
Section 2.8.4, “MySQL Source-Configuration Options”.
If you install MySQL over a previous installation that was
configured without the Performance Schema (or with an older
version of the Performance Schema that may not have all the
current tables), run mysql_upgrade after
starting the server to ensure that the
performance_schema database exists with all
current tables. Then restart the server. One indication that you
need to do this is the presence of messages such as the following
in the error log:
[ERROR] Native table 'performance_schema'.'events_waits_history' has the wrong structure [ERROR] Native table 'performance_schema'.'events_waits_history_long' has the wrong structure ...
Because the Performance Schema is configured into the server at
build time, a row for
PERFORMANCE_SCHEMA appears in the
SHOW ENGINES. This
means that the Performance Schema is available, not that it is
enabled. To enable it, you must do so at server startup, as
described in the next section.