Search Results
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-socket-summary-tables.html
The socket summary tables have these indexes: socket_summary_by_event_name: Primary key on (EVENT_NAME) socket_summary_by_instance: Primary key on (OBJECT_INSTANCE_BEGIN) Index on (EVENT_NAME) TRUNCATE TABLE is permitted for socket summary tables.
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-status-variable-summary-tables.html
The Performance Schema supports TRUNCATE TABLE for status variable summary tables as follows; in all cases, status for active sessions is unaffected: status_by_account: Aggregates account status from terminated sessions to user and host status, then ... The Performance Schema makes status variable information available in the tables described in Section 29.12.15, “Performance Schema Status Variable ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-status-variable-tables.html
The Performance Schema supports TRUNCATE TABLE for status variable tables as follows: global_status: Resets thread, account, host, and user status. The MySQL server maintains many status variables that provide information about its operation (see ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-system-variable-tables.html
TRUNCATE TABLE is not supported for Performance Schema system variable tables. The MySQL server maintains many system variables that indicate how it is configured (see Section 7.1.8, “Server System Variables”). System variable information is ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-table-handles-table.html
The table_handles table has these indexes: Primary key on (OBJECT_INSTANCE_BEGIN) Index on (OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME) Index on (OWNER_THREAD_ID, OWNER_EVENT_ID) TRUNCATE TABLE is not permitted for the table_handles table. The ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-threads-table.html
The threads table has these indexes: Primary key on (THREAD_ID) Index on (NAME) Index on (PROCESSLIST_ID) Index on (PROCESSLIST_USER, PROCESSLIST_HOST) Index on (PROCESSLIST_HOST) Index on (THREAD_OS_ID) Index on (RESOURCE_GROUP) TRUNCATE TABLE is ... The threads table contains a row for each server ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-tls-channel-status-table.html
Connection interface TLS properties are set at server startup, and can be updated at runtime using the ALTER INSTANCE RELOAD TLS statement. The tls_channel_status table provides information about connection interface TLS properties: mysql> SELECT * ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-tp-thread-group-state-table.html
The tp_thread_group_state table has one row per thread group in the thread pool. Each row provides information about the current state of a group. The tp_thread_group_state table has these columns: TP_GROUP_ID The thread group ID. There is at most ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-tp-thread-group-stats-table.html
The tp_thread_group_stats table has these indexes: Unique index on (TP_GROUP_ID) TRUNCATE TABLE is not permitted for the tp_thread_group_stats table. The tp_thread_group_stats table has these columns: TP_GROUP_ID The thread group ID. This number is ...
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 ...