kuden-service Database

ps_setup_show_enabled

Description

Shows all currently enabled Performance Schema configuration.

Parameters

in_show_instruments (BOOLEAN): Whether to print enabled instruments (can print many items)

in_show_threads (BOOLEAN): Whether to print enabled threads

Example

mysql> CALL sys.ps_setup_show_enabled(TRUE, TRUE); +—————————-+ | performance_schema_enabled | +—————————-+ | 1 | +—————————-+ 1 row in set (0.00 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.01 sec)

+————————————-+——-+ | enabled_instruments | timed | +————————————-+——-+ | wait/io/file/sql/map | YES | | wait/io/file/sql/binlog | YES | … | statement/com/Error | YES | | statement/com/ | YES | | idle | YES | +————————————-+——-+ 210 rows in set (0.08 sec)

Query OK, 0 rows affected (0.89 sec)

Parameters

Name	Type	Mode
in_show_instruments	tinyint(1)	IN
in_show_threads	tinyint(1)	IN

Definition

BEGIN
    SELECT @@performance_schema AS performance_schema_enabled;
    SELECT CONCAT(''', user, ''@'', host, ''') AS enabled_users
      FROM performance_schema.setup_actors
     WHERE enabled = 'YES'
     ORDER BY enabled_users;
    SELECT object_type,
           CONCAT(object_schema, '.', object_name) AS objects,
           enabled,
           timed
      FROM performance_schema.setup_objects
     WHERE enabled = 'YES'
     ORDER BY object_type, objects;
    SELECT name AS enabled_consumers
      FROM performance_schema.setup_consumers
     WHERE enabled = 'YES'
     ORDER BY enabled_consumers;
    IF (in_show_threads) THEN
        SELECT IF(name = 'thread/sql/one_connection', 
                  CONCAT(processlist_user, '@', processlist_host), 
                  REPLACE(name, 'thread/', '')) AS enabled_threads,
        TYPE AS thread_type
          FROM performance_schema.threads
         WHERE INSTRUMENTED = 'YES'
         ORDER BY enabled_threads;
    END IF;
    IF (in_show_instruments) THEN
        SELECT name AS enabled_instruments,
               timed
          FROM performance_schema.setup_instruments
         WHERE enabled = 'YES'
         ORDER BY enabled_instruments;
    END IF;
END