Search Results
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-events-waits-current-table.html
For example, it can be used with GROUP BY OBJECT_INSTANCE_BEGIN to see whether the load on 1,000 mutexes (that protect, say, 1,000 pages or blocks of data) is spread evenly or just hitting a few bottlenecks. The table stores one row per thread ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-file-summary-tables.html
Each file I/O summary table has one or more grouping columns to indicate how the table aggregates events. The Performance Schema maintains file I/O summary tables that aggregate information about I/O operations. Example file I/O event summary ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-memory-summary-tables.html
row *************************** EVENT_NAME: memory/sql/TABLE COUNT_ALLOC: 1381 COUNT_FREE: 924 SUM_NUMBER_OF_BYTES_ALLOC: 2059873 SUM_NUMBER_OF_BYTES_FREE: 1407432 LOW_COUNT_USED: 0 CURRENT_COUNT_USED: 457 HIGH_COUNT_USED: 461 ...Operation counts ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-objects-summary-global-by-type-table.html
The objects_summary_global_by_type table has these grouping columns to indicate how the table aggregates events: OBJECT_TYPE, OBJECT_SCHEMA, and OBJECT_NAME. The Performance Schema maintains the objects_summary_global_by_type table for aggregating ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-replication-connection-configuration-table.html
(CHANGE REPLICATION SOURCE TO option: GTID_ONLY) For more information, see Section 20.4.1, “GTIDs and Group Replication”. This table shows the configuration parameters used by the replica for connecting to the source. Parameters stored in the ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-setup-metrics-table.html
The setup_metrics table lists the available metrics: mysql> select * from performance_schema.setup_metrics\G *************************** 34. row *************************** NAME: undo_tablespaces_active METER: mysql.inno METRIC_TYPE: ASYNC GAUGE ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-stage-summary-tables.html
Each stage summary table has one or more grouping columns to indicate how the table aggregates events. The Performance Schema maintains tables for collecting current and recent stage events, and aggregates that information in summary tables.
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-statement-histogram-summary-tables.html
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 Tables”). To permit assessment at a more fine-grained ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-status-variable-summary-tables.html
Each status variable summary table has one or more grouping columns to indicate how the table aggregates status values: status_by_account has USER, HOST, and VARIABLE_NAME columns to summarize status variables by account. The Performance Schema ...