Search Results
https://dev.mysql.com/doc/refman/8.4/en/innodb-persistent-stats.html
When an index is added to an existing table, or when a column is added or dropped, index statistics are calculated and added to the innodb_index_stats table regardless of the value of innodb_stats_auto_recalc. The persistent optimizer statistics ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-preload-buffer-pool.html
To reduce the warmup period after restarting the server, InnoDB saves a percentage of the most recently used pages for each buffer pool at server shutdown and restores these pages at server startup. The percentage of recently used pages that is ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-row-format.html
General tablespaces support all row formats with the caveat that compressed and uncompressed tables cannot coexist in the same general tablespace due to different physical page sizes. row *************************** TABLE_ID: 55 NAME: test/t1 FLAG: ... The row format of a table determines how its rows are physically stored, which in turn can affect the performance of queries and DML ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-undo-logs.html
Undo logs exist within undo log segments, which are contained within rollback segments. An undo log is a collection of undo log records associated with a single read-write transaction. An undo log record contains information about how to undo the ...
https://dev.mysql.com/doc/refman/8.4/en/install-component.html
For example, this happens if a component name is erroneous, a named component does not exist or is already installed, or component initialization fails. [SET variable = expr [, variable = expr] ...] variable: { {GLOBAL | @@GLOBAL.} ...
https://dev.mysql.com/doc/refman/8.4/en/installing-source-distribution.html
When CMake starts, it looks for that file and reads its contents if it exists, on the assumption that the information is still correct. To install MySQL from a standard source distribution: Verify that your system satisfies the tool requirements ...
https://dev.mysql.com/doc/refman/8.4/en/installing.html
If you plan to upgrade an existing version of MySQL to a newer version rather than install MySQL for the first time, see Chapter 3, Upgrading MySQL, for information about upgrade procedures and about issues that you should consider before upgrading.
https://dev.mysql.com/doc/refman/8.4/en/invisible-indexes.html
MySQL supports invisible indexes; that is, indexes that are not used by the optimizer. The feature applies to indexes other than primary keys (either explicit or implicit). ALTER INDEX operation: ALTER TABLE t1 ALTER INDEX i_idx INVISIBLE; ALTER ...
https://dev.mysql.com/doc/refman/8.4/en/ipv6-system-support.html
It might be that you need only reconfigure an existing network interface to add an IPv6 address. Before MySQL Server can accept IPv6 connections, the operating system on your server host must support IPv6. As a simple test to determine whether that ...
https://dev.mysql.com/doc/refman/8.4/en/keyring-component-installation.html
It is not an error for a manifest file not to exist. Keyring service consumers require that a keyring component or plugin be installed: To use a keyring component, begin with the instructions here. To use a keyring plugin instead, begin with ...