Documentation Home
MySQL 5.7 Reference Manual
Related Documentation Download this Manual
PDF (US Ltr) - 35.1Mb
PDF (A4) - 35.2Mb
Man Pages (TGZ) - 256.4Kb
Man Pages (Zip) - 361.2Kb
Info (Gzip) - 3.4Mb
Info (Zip) - 3.4Mb
Excerpts from this Manual

MySQL 5.7 Reference Manual  / ...  / MySQL sys Schema  / sys Schema Object Reference  / sys Schema Stored Procedures  /  The ps_setup_show_enabled() Procedure

26.4.4.18 The ps_setup_show_enabled() Procedure

Displays all currently enabled Performance Schema configuration.

Parameters

  • in_show_instruments BOOLEAN: Whether to display enabled instruments. This might be a long list.

  • in_show_threads BOOLEAN: Whether to display enabled threads.

Example
mysql> CALL sys.ps_setup_show_enabled(FALSE, FALSE);+----------------------------+| performance_schema_enabled |+----------------------------+|                          1 |+----------------------------+1 row in set (0.00 sec)+---------------+| enabled_users |+---------------+| '%'@'%'       |+---------------+1 row in set (0.00 sec)+-------------+---------+---------+-------+| object_type | objects | enabled | timed |+-------------+---------+---------+-------+| EVENT       | %.%     | YES     | YES   || FUNCTION    | %.%     | YES     | YES   || PROCEDURE   | %.%     | YES     | YES   || TABLE       | %.%     | YES     | YES   || TRIGGER     | %.%     | YES     | YES   |+-------------+---------+---------+-------+5 rows in set (0.00 sec)+---------------------------+| enabled_consumers         |+---------------------------+| events_statements_current || events_statements_history || global_instrumentation    || statements_digest         || thread_instrumentation    |+---------------------------+