MySQL 8.0 参考手册 / 第 28 章 MySQL 系统模式 / 28.4 sys 模式对象参考 / 28.4.4 sys 模式存储过程 /
28.4.4.18 ps_setup_show_enabled() 过程
显示所有当前启用的性能架构配置。
Press CTRL+C to copymysql> CALL sys.ps_setup_show_enabled(FALSE, FALSE); +----------------------------+ | performance_schema_enabled | +----------------------------+ | 1 | +----------------------------+ 1 row in set (0.01 sec) +---------------+ | enabled_users | +---------------+ | '%'@'%' | +---------------+ 1 row in set (0.01 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.02 sec) +-----------------------------+ | enabled_consumers | +-----------------------------+ | events_statements_current | | events_statements_history | | events_transactions_current | | events_transactions_history | | global_instrumentation | | statements_digest | | thread_instrumentation | +-----------------------------+