Search Results
https://dev.mysql.com/doc/refman/8.4/en/information-schema-processlist-table.html
As such, the implementation of SHOW PROCESSLIST which uses this table is also deprecated. For a comparison of this table with other sources, see Sources of Process Information. This is the same value displayed in the Id column of the SHOW ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-host-cache-table.html
The host_cache_size system variable controls the size of the host cache, as well as the size of the host_cache table. Because the host_cache table exposes the contents of the host cache, it can be examined using SELECT statements. The host_cache ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-log-status-table.html
The log_status table provides information that enables an online backup tool to copy the required log files without locking those resources for the duration of the copy process. When the log_status table is queried, the server blocks logging and ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-metadata-locks-table.html
Metadata locking applies not just to tables, but also to schemas, stored programs (procedures, functions, triggers, scheduled events), tablespaces, user locks acquired with the GET_LOCK() function (see Section 14.14, “Locking Functions”), and ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-ndb-sync-excluded-objects-table.html
This table provides information about NDB database objects which cannot be automatically synchronized between NDB Cluster's dictionary and the MySQL data dictionary. row *************************** SCHEMA_NAME: NULL NAME: ts1 TYPE: TABLESPACE ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-socket-instances-table.html
The socket_instances table provides a real-time snapshot of the active connections to the MySQL server. The table contains one row per TCP/IP or Unix socket file connection. Information available in this table provides a real-time snapshot of the ...row *************************** EVENT_NAME: wait/io/socket/sql/server_unix_socket OBJECT_INSTANCE_BEGIN: 4316619408 THREAD_ID: 1 SOCKET_ID: 16 IP: PORT: 0 STATE: ACTIVE *************************** ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-socket-summary-tables.html
These socket summary tables aggregate timer and byte count information for socket operations: socket_summary_by_event_name: Aggregate timer and byte count statistics generated by the wait/io/socket/* instruments for all socket I/O operations, per ...socket_summary_by_instance: Aggregate timer and byte count statistics generated by the wait/io/socket/* instruments for all socket I/O operations, per socket ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-table-reference.html
The following table summarizes all available Performance Schema tables. For greater detail, see the individual table descriptions. Table 29.1 Performance Schema Tables Table Name Description accounts Connection statistics per client account ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-tp-thread-state-table.html
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 columns: TP_GROUP_ID The thread group ID. TP_GROUP_ID and TP_THREAD_NUMBER together provide a unique key within ...PROCESS_COUNT The 10ms interval in which the statement that uses this thread is currently ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-wait-tables.html
These tables store wait events: events_waits_current: The current wait event for each thread. There are also summary tables that aggregate information about wait events; see Section 29.12.20.1, “Wait Event Summary Tables”. For more information ... The Performance Schema instruments waits, which are events that take ...