Parameters
| Name | Type | Mode |
|---|---|---|
| in_host | varchar(255) | IN |
| in_user | varchar(32) | IN |
Determines whether instrumentation of an account is enabled within Performance Schema.
in_host VARCHAR(255): The hostname of the account to check. in_user VARCHAR(32): The username of the account to check.
ENUM(‘YES’, ‘NO’, ‘PARTIAL’)
mysql> SELECT sys.ps_is_account_enabled(‘localhost’, ‘root’); +————————————————+ | sys.ps_is_account_enabled(‘localhost’, ‘root’) | +————————————————+ | YES | +————————————————+ 1 row in set (0.01 sec)
| Name | Type | Mode |
|---|---|---|
| in_host | varchar(255) | IN |
| in_user | varchar(32) | IN |