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