Search Results
https://dev.mysql.com/doc/workbench/en/wb-performance-query-statistics.html
The Query Stats SQL editor results tab (see the next two figures) uses Performance Schema data to gather key statistics collected for executed query, such as timing, temporary tables, indexes, joins, and more. Figure 7.5 SQL Editor: Query Stats ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-probes-and-statistics.html
Once a member receives a message with statistics from another member, it calculates additional metrics regarding how many transactions were certified, applied and locally executed in the last monitoring period. The monitoring mechanism works by ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-options-variables.html
ndb_index_stat_enable Command-Line Format --ndb-index-stat-enable[={OFF|ON}] System Variable ndb_index_stat_enable Scope Global, Session Dynamic Yes SET_VAR Hint Applies No Type Boolean Default Value ON Use NDB index statistics in query optimization. The index statistics tables are always created when the server starts, regardless of this option's ... This section ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-programs-ndb-index-stat.html
ndb_index_stat provides per-fragment statistical information about indexes on NDB tables. sampleCount can be compared with the cardinality of SHOW INDEX or INFORMATION_SCHEMA.STATISTICS, although the latter two provide a view of the table as a ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-column-statistics-table.html
The COLUMN_STATISTICS table provides access to histogram statistics for column values. For information about histogram statistics, see Section 10.9.6, “Optimizer Statistics”, and Section 15.7.3.1, “ANALYZE TABLE Statement”. The ...You can ...
https://dev.mysql.com/doc/mysql-em-plugin/en/myoem-metric-sysschema-tablestatistics-category.html
Lists the Sys Schema Table Statistics metrics and provides a brief description of each. Table 6.42 Sys Schema Table Statistics Metrics NameDescriptionDelete Latency The total wait time of timed delete IO events for the table. Fetch Latency The ...
Oracle Enterprise Manager for MySQL Database User's Guide :: 6.43 Sys Schema User Statistics Metrics
https://dev.mysql.com/doc/mysql-em-plugin/en/myoem-metric-sysschema-userstatistics-category.html
Lists the Sys Schema User Statistics metrics and provides a brief description of each. Table 6.43 Sys Schema User Statistics Metrics NameDescriptionCurrent Connections The current number of connections for the user. Current Memory The current ...
https://dev.mysql.com/doc/mysql-em-plugin/en/myoem-performance-page-connections.html
The Connection Statistics page displays the connections and network statistics for the monitored MySQL instance. Table 5.1 Connections Performance Page Regions GraphDescriptionCurrent Connections Graphs the number of current, running and cached ...
https://dev.mysql.com/doc/mysql-em-plugin/en/myoem-performance-page-per-table-stats.html
Table 5.10 Per Table Statistics Dashboard NameDescription Table Name The table name. By default, rows are sorted by descending total wait time (tables with most contention first). Delete Latency The total wait time of timed delete I/O events for the ...
https://dev.mysql.com/doc/refman/8.4/en/sys-schema-table-statistics-with-buffer.html
These views summarize table statistics, including InnoDB buffer pool statistics. The schema_table_statistics_with_buffer and x$schema_table_statistics_with_buffer views have these columns: table_schema The schema that contains the table. By ...