Search Results
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-setup-threads-table.html
The setup_threads table has these indexes: Primary key on (NAME) TRUNCATE TABLE is not permitted for the setup_threads table. It exposes thread class names and attributes: mysql> SELECT * FROM performance_schema.setup_threads\G ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-socket-instances-table.html
The socket_instances table has these indexes: Primary key on (OBJECT_INSTANCE_BEGIN) Index on (THREAD_ID) Index on (SOCKET_ID) Index on (IP, PORT) TRUNCATE TABLE is not permitted for the socket_instances table. The socket_instances table provides a ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-statement-histogram-summary-tables.html
The statement histogram summary tables have these indexes: events_statements_histogram_by_digest: Unique index on (SCHEMA_NAME, DIGEST, BUCKET_NUMBER) events_statements_histogram_global: Primary key on (BUCKET_NUMBER) TRUNCATE TABLE is permitted for ... The Performance Schema maintains statement event summary tables that contain information about minimum, maximum, and average statement latency (see Section 29.12.20.3, “Statement Summary ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-status-variables.html
For a given connection, if the client sends connection attribute key-value pairs for which the aggregate size is larger than the reserved storage permitted by the value of the performance_schema_session_connect_attrs_size system variable, the ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-system-variables.html
The Performance Schema automatically sizes the values of several of its parameters at server startup if they are not set explicitly. Performance Schema system variables have the following meanings: performance_schema Command-Line Format ...
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-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-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-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 columns: TP_GROUP_ID The thread group ID. This number is incremented when a statement starts executing, not when it finishes. QUERIES_QUEUED The number of statements received that were queued for execution.