Search Results
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-setup-objects-table.html
The setup_objects table controls whether the Performance Schema monitors particular objects. This table has a maximum size of 100 rows by default. To change the table size, modify the performance_schema_setup_objects_size system variable at server ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-setup-threads-table.html
It exposes thread class names and attributes: mysql> SELECT * FROM performance_schema.setup_threads\G *************************** 1. row *************************** NAME: thread/performance_schema/setup ENABLED: YES HISTORY: YES PROPERTIES: ...
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 ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-stage-summary-tables.html
Example stage event summary information: mysql> SELECT * FROM performance_schema.events_stages_summary_global_by_event_name\G ... The Performance Schema maintains tables for collecting current and recent stage events, and aggregates that ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-startup-configuration.html
For information about specifying patterns to select instruments, see Section 29.4.9, “Naming Instruments or Consumers for Filtering Operations”. To use the MySQL Performance Schema, it must be enabled at server startup to enable event ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-statement-histogram-summary-tables.html
Example statement histogram information: mysql> SELECT * FROM performance_schema.events_statements_histogram_by_digest WHERE SCHEMA_NAME = 'mydb' AND DIGEST = 'bb3f69453119b2d7b3ae40673a9d4c7c' AND COUNT_BUCKET > 0 ORDER BY BUCKET_NUMBER\G ... The ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-status-variable-tables.html
For example: SELECT EVENT_NAME, COUNT_STAR FROM performance_schema.events_statements_summary_global_by_event_name WHERE EVENT_NAME LIKE 'statement/sql/%'; The global_status and session_status tables have these columns: VARIABLE_NAME The status ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-tls-channel-status-table.html
The tls_channel_status table provides information about connection interface TLS properties: mysql> SELECT * FROM performance_schema.tls_channel_status\G *************************** 1. Connection interface TLS properties are set at server startup, ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-tp-connections-table.html
The tp_connections table contains the following rows: CONNECTION_ID The connection ID as reported by SELECT CONNECTION_ID(). The tp_connections table contains one row per connection managed by the Thread Pool plugin. Each row provides information ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-transaction-summary-tables.html
Example transaction event summary information: mysql> SELECT * FROM performance_schema.events_transactions_summary_global_by_event_name LIMIT 1\G *************************** 1. The Performance Schema maintains tables for collecting current and ...