Search Results
https://dev.mysql.com/doc/refman/8.4/en/optimize-table.html
Column Value Table The table name Op Always optimize Msg_type status, error, info, note, or warning Msg_text An informational message OPTIMIZE TABLE table catches and throws any errors that occur while copying table statistics from the old file to ...OPTIMIZE TABLE reorganizes the physical storage of table data and associated index data, to reduce storage space and improve I/O efficiency when accessing the ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-memory-summary-tables.html
It has these effects: In general, truncation resets the baseline for statistics, but does not change the server state. Operation counts help to understand or tune the overall pressure the server is putting on the memory allocator, which has an ...
https://dev.mysql.com/doc/refman/8.4/en/replication-threads-monitor-worker.html
A multithreaded replica's coordinator thread also prints statistics to the replica's error log on a regular basis if the verbosity setting is set to display informational messages. The statistics are printed depending on the volume of events that ...
https://dev.mysql.com/doc/refman/8.4/en/sorted-index-builds.html
Sorted Index Builds and Optimizer Statistics Sorted index builds may result in optimizer statistics that differ from those generated by the previous method of index creation. The difference in statistics, which is not expected to affect workload ...
https://dev.mysql.com/doc/refman/8.4/en/thread-pool-operation.html
When querying the performance_schema.tp_thread_group_stats table, which reports statistics per thread group, Admin thread group statistics are reported in the last row of the result set. For example, if SELECT * FROM ... The thread pool consists of ...
https://dev.mysql.com/doc/relnotes/mysql/8.4/en/news-8-4-0.html
Automatic recalculation of persistent statistics by InnoDB also updates the histogram when automatic updates are enabled. (Bug #36301441) Audit log filtering by type, using error as the type, did not work correctly. (Bug #36142157) Following an ...
https://dev.mysql.com/doc/mysql-cluster-manager/8.4/en/mcm-attribute-tables-mysqld.html
Ndb_fetch_table_stats: Number of times table statistics were fetched from tables rather than cache. ndb_index_stat_option: Comma-separated list of tunable options for NDB index statistics; list should contain no spaces. ndb-blob-read-batch-bytes: ...
https://dev.mysql.com/doc/ndbapi/en/mgm-functions-tls.html
Return value none ndb_mgm_get_tls_stats() Description Get server TLS statistics Signature int ndb_mgm_get_tls_stats ( NdbMgmHandle handle, struct ndb_mgm_tls_stats *result ) Parameters handle Management server handle (NdbMgmHandle). The functions ...
https://dev.mysql.com/doc/mysql-em-plugin/en/myoem-config-metric-optimizer-category.html
Eq Range Index Dive Limit Indicates the number of equality ranges in an equality comparison condition when the optimizer switches from using index dives to index statistics in estimating the number of qualifying rows. Histogram Generation Max Mem ...
https://dev.mysql.com/doc/mysql-em-plugin/en/myoem-homepage-menu.html
Only those menus customized for the MySQL Database plugin are described here: Performance sub-menu: opens graph pages for the following: Section 5.1, “Connection Statistics” Section 5.3, “Statements” Section 5.4, “InnoDB Buffer Pool” ...