Search Results
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 ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-transaction-summary-tables.html
row *************************** EVENT_NAME: transaction COUNT_STAR: 5 SUM_TIMER_WAIT: 19550092000 MIN_TIMER_WAIT: 2954148000 AVG_TIMER_WAIT: 3910018000 MAX_TIMER_WAIT: 5486275000 COUNT_READ_WRITE: 5 SUM_TIMER_READ_WRITE: 19550092000 ... The ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-wait-summary-tables.html
Each wait event 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 wait events, and aggregates that information in summary tables.
https://dev.mysql.com/doc/refman/8.4/en/performance-schema.html
In general, an event could be a function call, a wait for the operating system, a stage of an SQL statement execution such as parsing or sorting, or an entire statement or group of statements. The MySQL Performance Schema is a feature for ...