kuden-service Database

ps_setup_show_disabled

Description

Shows all currently disable Performance Schema configuration.

Disabled users is only available for MySQL 5.7.6 and later. In earlier versions it was only possible to enable users.

Parameters

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

in_show_threads (BOOLEAN): Whether to print disabled threads

Example

mysql> CALL sys.ps_setup_show_disabled(TRUE, TRUE); +—————————-+ | performance_schema_enabled | +—————————-+ | 1 | +—————————-+ 1 row in set (0.00 sec)

+——————–+ | disabled_users | +——————–+ | ‘mark’@‘localhost’ | +——————–+ 1 row in set (0.00 sec)

+————-+———————-+———+——-+ | 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 | +————-+———————-+———+——-+ 15 rows in set (0.00 sec)

Empty set (0.00 sec)

+—————————————————————————————+——-+ | disabled_instruments | timed | +—————————————————————————————+——-+ | wait/synch/mutex/sql/TC_LOG_MMAP::LOCK_tc | NO | | wait/synch/mutex/sql/LOCK_des_key_file | NO | | wait/synch/mutex/sql/MYSQL_BIN_LOG::LOCK_commit | NO | … | memory/sql/servers_cache | NO | | memory/sql/udf_mem | NO | | wait/lock/metadata/sql/mdl | NO | +—————————————————————————————+——-+ 547 rows in set (0.00 sec)

Query OK, 0 rows affected (0.01 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 disabled_users
      FROM performance_schema.setup_actors
     WHERE enabled = 'NO'
     ORDER BY disabled_users;
    SELECT object_type,
           CONCAT(object_schema, '.', object_name) AS objects,
           enabled,
           timed
      FROM performance_schema.setup_objects
     WHERE enabled = 'NO'
     ORDER BY object_type, objects;
    SELECT name AS disabled_consumers
      FROM performance_schema.setup_consumers
     WHERE enabled = 'NO'
     ORDER BY disabled_consumers;
    IF (in_show_threads) THEN
        SELECT IF(name = 'thread/sql/one_connection', 
                  CONCAT(processlist_user, '@', processlist_host), 
                  REPLACE(name, 'thread/', '')) AS disabled_threads,
        TYPE AS thread_type
          FROM performance_schema.threads
         WHERE INSTRUMENTED = 'NO'
         ORDER BY disabled_threads;
    END IF;
    IF (in_show_instruments) THEN
        SELECT name AS disabled_instruments,
               timed
          FROM performance_schema.setup_instruments
         WHERE enabled = 'NO'
         ORDER BY disabled_instruments;
    END IF;
END