Search Results
https://dev.mysql.com/doc/heatwave/en/mys-hw-rpd-preload-stats-table.html
The rpd_preload_stats table stores column level statistics collected from InnoDB tables. The statistics are used to estimate the number of MySQL HeatWave nodes required for a given dataset before loading the tables into the MySQL HeatWave Cluster.
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-params-ndbd.html
IndexStatSaveScale: Scaling factor used in determining size of stored index statistics. IndexStatTriggerPct: Threshold percent change in DML operations for index statistics updates. IndexStatUpdateDelay: Minimum delay between automatic index ... The ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-connection-tables.html
Each connection table has CURRENT_CONNECTIONS and TOTAL_CONNECTIONS columns to track the current and total number of connections per “tracking value” on which its statistics are based. The Performance Schema maintains summary tables that ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-statement-summary-tables.html
The events_statements_summary_by_program table has these additional summary columns: COUNT_STATEMENTS, SUM_STATEMENTS_WAIT, MIN_STATEMENTS_WAIT, AVG_STATEMENTS_WAIT, MAX_STATEMENTS_WAIT Statistics about nested statements invoked during stored ...
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/mysql-cluster-manager/8.4/en/mcm-attribute-tables-ndbd.html
IndexStatSaveScale: Scaling factor used in determining size of stored index statistics. IndexStatTriggerPct: Threshold percent change in DML operations for index statistics updates. IndexStatUpdateDelay: Minimum delay between automatic index ...
https://dev.mysql.com/doc/mysql-monitor/8.0/en/mem-query-analyzer-queries.html
Example SQL Statements: (Displayed only if Example Query is enabled) Normalized SQL Statement and Statistics The Normalized SQL Statement displays the normalized version of the SQL statement, while the Statistics displays useful information on the ... Click on an individual query to see more detailed information about the individual query in the Details ...
https://dev.mysql.com/doc/mysql-monitor/8.0/en/schema-advisor-ref.html
Default frequency 00:10:00 Default auto-close enabled no MyISAM Indexes Found with No Statistics The MySQL optimizer needs index statistics to help make choices about whether to use indexes to satisfy SQL queries. Having no statistics or outdated ...
https://dev.mysql.com/doc/heatwave-aws/en/heatwave-aws-autopilot-shape-advisor.html
The Auto Shape Prediction feature begins to collect MySQL statistics that reflect the current workload. It collects statistics at varying intervals, and Auto Shape Prediction creates a prediction every five minutes while it is active. The Auto Shape ... Autopilot Shape Advisor 17.3 Autopilot Shape Advisor Use the Auto Shape Prediction feature in MySQL HeatWave Autopilot for MySQL HeatWave on AWS to analyze the workload and assess the suitability of the current MySQL ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-table-reference.html
The following table summarizes all available INFORMATION_SCHEMA tables. For greater detail, see the individual table descriptions. Table 28.1 INFORMATION_SCHEMA Tables Table Name Description Deprecated ADMINISTRABLE_ROLE_AUTHORIZATIONS Grantable ...