Search Results
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-accounts-table.html
This is NULL for an internal thread, or for a user session that failed to authenticate. This is NULL for an internal thread, or for a user session that failed to authenticate. The accounts table contains a row for each account that has connected to ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-atom-molecule-events.html
For example, a row fetch might result in rows like this: Row# EVENT_NAME TIMER_START TIMER_END ---- ---------- ----------- --------- 1 wait/io/file/myisam/dfile 10001 10002 2 wait/io/table/sql/handler 10000 NULL The row fetch causes a file read. In ... For a table I/O event, there are usually two rows in events_waits_current, not ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-events-stages-current-table.html
END_EVENT_ID This column is set to NULL when the event starts and updated to the thread current event number when the event ends. If an event is produced from an instrument that has TIMED = NO, timing information is not collected, and TIMER_START, ...The table stores one row per thread showing the current status of the thread's most recent monitored stage event, so there is no system variable for configuring the table ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-mutex-instances-table.html
LOCKED_BY_THREAD_ID When a thread currently has a mutex locked, LOCKED_BY_THREAD_ID is the THREAD_ID of the locking thread, otherwise it is NULL. When a thread unlocks a mutex, mutex_instances shows that the mutex now has no owner (the THREAD_ID ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-obtaining-parent-events.html
FROM performance_schema.events_transactions_current AS parent INNER JOIN performance_schema.data_locks AS child WHERE parent.THREAD_ID = child.THREAD_ID AND parent.EVENT_ID < child.EVENT_ID AND ( child.EVENT_ID <= parent.END_EVENT_ID OR ...Rows of ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-stage-tables.html
The Performance Schema instruments stages, which are steps during the statement-execution process, such as parsing a statement, opening a table, or performing a filesort operation. Stages correspond to the thread states displayed by SHOW ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-table-wait-summary-tables.html
A value of NULL means that table I/O used no index. The following sections describe the table I/O and lock wait summary tables: table_io_waits_summary_by_index_usage: Table I/O waits per index table_io_waits_summary_by_table: Table I/O waits per ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-tp-connections-table.html
TP_PROCESSING_THREAD_NUMBER This may be NULL if no thread is currently attached to the connection. TIME_OF_EXPIRY Timestamp showing when an idle connection will expire if no new request arrives before then; this is NULL when the thread is currently ... The tp_connections table contains one row per connection managed by the Thread Pool ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-tp-thread-state-table.html
TIME_OF_ATTACH: Timestamp showing when the thread was attached, if attached to a connection; otherwise NULL. The tp_thread_state table has one row per thread created by the thread pool to handle connections. The tp_thread_state table has these ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-user-defined-functions-table.html
The value is NULL if the function was registered by a CREATE FUNCTION statement and is in the process of unloading. The value is NULL if the function was registered by a component or plugin rather than by a CREATE FUNCTION statement. The ...