processlist

256 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
ID BIGINT UNSIGNED 20 null
data_lock_waits.BLOCKING_ENGINE_TRANSACTION_ID Implied ConstraintR
data_lock_waits.BLOCKING_EVENT_ID Implied ConstraintR
data_lock_waits.REQUESTING_ENGINE_TRANSACTION_ID Implied ConstraintR
data_lock_waits.REQUESTING_EVENT_ID Implied ConstraintR
data_locks.ENGINE_TRANSACTION_ID Implied ConstraintR
data_locks.EVENT_ID Implied ConstraintR
events_stages_current.END_EVENT_ID Implied ConstraintR
events_stages_current.NESTING_EVENT_ID Implied ConstraintR
events_stages_history.END_EVENT_ID Implied ConstraintR
events_stages_history.NESTING_EVENT_ID Implied ConstraintR
events_stages_history_long.END_EVENT_ID Implied ConstraintR
events_stages_history_long.EVENT_ID Implied ConstraintR
events_stages_history_long.NESTING_EVENT_ID Implied ConstraintR
events_statements_current.END_EVENT_ID Implied ConstraintR
events_statements_current.NESTING_EVENT_ID Implied ConstraintR
events_statements_current.STATEMENT_ID Implied ConstraintR
events_statements_history.END_EVENT_ID Implied ConstraintR
events_statements_history.NESTING_EVENT_ID Implied ConstraintR
events_statements_history.STATEMENT_ID Implied ConstraintR
events_statements_history_long.END_EVENT_ID Implied ConstraintR
events_statements_history_long.EVENT_ID Implied ConstraintR
events_statements_history_long.NESTING_EVENT_ID Implied ConstraintR
events_statements_history_long.STATEMENT_ID Implied ConstraintR
events_transactions_current.END_EVENT_ID Implied ConstraintR
events_transactions_current.NESTING_EVENT_ID Implied ConstraintR
events_transactions_current.TRX_ID Implied ConstraintR
events_transactions_history.END_EVENT_ID Implied ConstraintR
events_transactions_history.NESTING_EVENT_ID Implied ConstraintR
events_transactions_history.TRX_ID Implied ConstraintR
events_transactions_history_long.END_EVENT_ID Implied ConstraintR
events_transactions_history_long.EVENT_ID Implied ConstraintR
events_transactions_history_long.NESTING_EVENT_ID Implied ConstraintR
events_transactions_history_long.TRX_ID Implied ConstraintR
events_waits_current.END_EVENT_ID Implied ConstraintR
events_waits_current.NESTING_EVENT_ID Implied ConstraintR
events_waits_history.END_EVENT_ID Implied ConstraintR
events_waits_history.NESTING_EVENT_ID Implied ConstraintR
events_waits_history_long.END_EVENT_ID Implied ConstraintR
events_waits_history_long.EVENT_ID Implied ConstraintR
events_waits_history_long.NESTING_EVENT_ID Implied ConstraintR
metadata_locks.OWNER_EVENT_ID Implied ConstraintR
prepared_statements_instances.OWNER_EVENT_ID Implied ConstraintR
prepared_statements_instances.STATEMENT_ID Implied ConstraintR
table_handles.OWNER_EVENT_ID Implied ConstraintR
threads.PROCESSLIST_ID Implied ConstraintR
threads.THREAD_OS_ID Implied ConstraintR
USER VARCHAR 32 √ null
HOST VARCHAR 261 √ null
DB VARCHAR 64 √ null
COMMAND VARCHAR 16 √ null
TIME BIGINT 19 √ null
STATE VARCHAR 64 √ null
INFO LONGTEXT 2147483647 √ null

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc ID

Relationships

Close relationships within degrees of separation