Search Results
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-prepared-statements-instances-table.html
This table enables inspection of prepared statements used in the server and provides aggregated statistics about them. Timing statistics for repreparation are not available because it is counted as part of statement execution, not as a separate ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-status-variables.html
Performance_schema_nested_statement_lost The number of stored program statements for which statistics were lost. Performance_schema_program_lost The number of stored programs for which statistics were lost. Performance_schema_table_lock_stat_lost ...
https://dev.mysql.com/doc/refman/8.4/en/range-optimization.html
Otherwise, any index on col_name is nonunique and the optimizer can estimate the row count for each range using dives into the index or index statistics. Use of index statistics is less accurate than index dives but permits faster row estimation for ... The range access method uses a single index to retrieve a subset of table rows that are contained within one or several index value ...
https://dev.mysql.com/doc/refman/8.4/en/show-index.html
Cardinality is counted based on statistics stored as integers, so the value is not necessarily exact even for small tables. Information about table indexes is also available from the INFORMATION_SCHEMA STATISTICS table. The extended information ...
https://dev.mysql.com/doc/refman/8.4/en/sys-ps-trace-statement-digest.html
The result is a report of all statistics tracked within Performance Schema for that digest for the interval. Traces all Performance Schema instrumentation for a specific statement digest. If you find a statement of interest within the Performance ...
https://dev.mysql.com/doc/refman/8.4/en/telemetry-metrics-meter-metrics.html
index_stat_lost Performance_schema_index_stat_lost ASYNC COUNTER The number of indexes for which statistics were lost. nested_statement_lost Performance_schema_nested_statement_lost ASYNC COUNTER The number of stored program statements for which ...
https://dev.mysql.com/doc/workbench/en/wb-performance-dashboard.html
Figure 7.1 Performance: Dashboard Network Status This highlights statistics for network traffic sent and received by the MySQL server over client connections. MySQL Status This highlights the primary MySQL server activity and performance statistics.
https://dev.mysql.com/doc/workbench/en/wb-what-is-new-61.html
Generally, this new performance reporting feature provides a graphical representation of key statistics from the MySQL server status, and provides an overview of the MySQL server subsystems. Figure 1.26 SQL Editor: Field Types Query Stats Query ...
https://dev.mysql.com/doc/mysql-monitor/8.0/en/mem-agent-rights.html
Examples of these types of statements include getting database metadata from INFORMATION_SCHEMA tables, or any custom SQL that is used to monitor application specific statistics. SELECT: MySQL Enterprise Monitor Agent can collect statistics for ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-auto-parallel-load-syntax.html
If set to true, the default setting, Lakehouse Auto Parallel Load samples the data to infer the schema and collect statistics. If set to false, Lakehouse Auto Parallel Load performs a full scan to infer the schema and collect statistics. The ...