PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.2Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/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/5.7/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/5.7/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/5.7/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/5.7/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/5.7/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 Section 2.10, “Upgrading MySQL”, for information about upgrade procedures and about issues that you should consider before ...A summary of the procedure follows and later sections provide the ...
https://dev.mysql.com/doc/refman/5.7/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/5.7/en/keyring-encrypted-file-plugin.html
To ensure that keys are flushed only when the correct keyring storage file exists, keyring_encrypted_file stores a SHA-256 checksum of the keyring in the file. Note The keyring_encrypted_file plugin is an extension included in MySQL Enterprise ...
https://dev.mysql.com/doc/refman/5.7/en/keyring-key-migration.html
If a key to be copied already exists in the destination keystore, an error occurs and the destination keystore is restored to its premigration state. A keyring migration copies keys from one keystore to another, enabling a DBA to switch a MySQL ...
https://dev.mysql.com/doc/refman/5.7/en/keyring-okv-plugin.html
Note The keyring_okv plugin is an extension included in MySQL Enterprise Edition, a commercial product. The Key Management Interoperability Protocol (KMIP) enables communication of cryptographic keys between a key management server and its clients.