• 首页
  • css3教程
  • html5教程
  • jQuery手册
  • vue手册
  • php手册
  • MySQL手册
  • apache手册
  • redis手册
  • 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	|
    +-------------	+----------------------	+---------	+-------	+
    
    ...