## Return Value 

## Example 

An ENUM(’YES’,’NO’)  value. 

mysql> SELECT sys.ps_is_instrument_default_timed(’memory/innodb/row_log_buf’); +-----------------------------------------------------------------+ | sys.ps_is_instrument_default_timed(’memory/innodb/row_log_buf’) | +-----------------------------------------------------------------+ | NO | +-----------------------------------------------------------------+ mysql> SELECT sys.ps_is_instrument_default_timed(’statement/sql/alter_user’); +----------------------------------------------------------------+ | sys.ps_is_instrument_default_timed(’statement/sql/alter_user’) | +----------------------------------------------------------------+ | YES | +----------------------------------------------------------------+ 

## 28.4.5.13 The ps_is_thread_instrumented() Function 

Returns YES  or NO  to indicate whether Performance Schema instrumentation for a given connection ID is enabled, UNKNOWN  if the ID is unknown, or NULL  if the ID is NULL . 

## Parameters 

• in_connection_id BIGINT UNSIGNED : The connection ID. This is a value of the type given in the PROCESSLIST_ID  column of the Performance Schema threads  table or the Id  column of SHOW PROCESSLIST  output. 

## Return Value 

## Example 

## 28.4.5.14 The ps_thread_account() Function 

An ENUM(’YES’,’NO’,’UNKNOWN’)  value. 

mysql> SELECT sys.ps_is_thread_instrumented(43); +-----------------------------------+ | sys.ps_is_thread_instrumented(43) | +-----------------------------------+ | UNKNOWN | +-----------------------------------+ mysql> SELECT sys.ps_is_thread_instrumented(CONNECTION_ID()); +------------------------------------------------+ | sys.ps_is_thread_instrumented(CONNECTION_ID()) | +------------------------------------------------+ | YES | +------------------------------------------------+ 

Given a Performance Schema thread ID, returns the user_name @ host_name  account associated with the thread. 

## Parameters 

• in_thread_id BIGINT UNSIGNED : The thread ID for which to return the account. The value should match the THREAD_ID  column from some Performance Schema threads  table row. 

## Return Value 

A TEXT  value. 

