ps_setup_show_disabled()过程
显示所有当前禁用的性能架构配置。
参量
in_show_instruments BOOLEAN
:是否显示禁用的乐器。这可能是一长串的清单。in_show_threads BOOLEAN
:是否显示禁用的线程。
例
mysql>CALL sys.ps_setup_show_disabled(TRUE, TRUE); +---------------------------- + | performance_schema_enabled | +---------------------------- + | 1 | +---------------------------- + +--------------- + | enabled_users | +--------------- + | '%'@'%' | +--------------- + +------------- +---------------------- +--------- +------- + | object_type | objects | enabled | timed | +------------- +---------------------- +--------- +------- + | EVENT | mysql.% | NO | NO | | EVENT | performance_schema.% | NO | NO | | EVENT | information_schema.% | NO | NO | | FUNCTION | mysql.% | NO | NO | | FUNCTION | performance_schema.% | NO | NO | | FUNCTION | information_schema.% | NO | NO | | PROCEDURE | mysql.% | NO | NO | | PROCEDURE | performance_schema.% | NO | NO | | PROCEDURE | information_schema.% | NO | NO | | TABLE | mysql.% | NO | NO | | TABLE | performance_schema.% | NO | NO | | TABLE | information_schema.% | NO | NO | | TRIGGER | mysql.% | NO | NO | | TRIGGER | performance_schema.% | NO | NO | | TRIGGER | information_schema.% | NO | NO | +------------- +---------------------- +--------- +------- + ...