• 首页
  • css3教程
  • html5教程
  • jQuery手册
  • vue手册
  • php手册
  • MySQL手册
  • apache手册
  • redis手册
  • ps_setup_show_enabled()过程

    显示所有当前启用的性能架构配置。

    参量

    • in_show_instruments BOOLEAN:是否显示启用的仪器。这可能是一长串的清单。
    • in_show_threads BOOLEAN:是否显示启用的线程。

    mysql> 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	|
    +-----------------------------	+