Search Results
https://dev.mysql.com/doc/refman/8.4/en/innodb-data-encryption.html
Once redo log data is read into memory, it is in unencrypted form. Once undo log data is read into memory, it is in unencrypted form. InnoDB supports data-at-rest encryption for file-per-table tablespaces, general tablespaces, the mysql system ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-disk-io.html
Read-Ahead If InnoDB can determine there is a high probability that data might be needed soon, it performs read-ahead operations to bring that data into the buffer pool so that it is available in memory. In random read-ahead, if InnoDB notices that ... InnoDB uses asynchronous disk I/O where possible, by creating a number of threads to handle I/O operations, while permitting other database operations to proceed while the I/O is still in ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-online-ddl-performance.html
Online operations read less data into the buffer pool than table-copy operations, which reduces purging of frequently accessed data from memory. Online DDL and Metadata Locks Online DDL operations can be viewed as having three phases: Phase 1: ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-performance-thread_concurrency.html
Once the number of executing threads reaches this limit, additional threads sleep for a number of microseconds, set by the configuration parameter innodb_thread_sleep_delay, before being placed into the queue. If the tickets run out, the thread is ... InnoDB uses operating system threads to process requests from user ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-read-only-instance.html
Querying data that has been put into a read-only state for security or data integrity reasons, such as archived backup data. The instance must have performed a slow shutdown before being put into the read-only state. You can query InnoDB tables ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-row-format.html
As more rows fit into a single disk page, queries and index lookups can work faster, less cache memory is required in the buffer pool, and less I/O is required to write out updated values. The row format of a table determines how its rows are ...
https://dev.mysql.com/doc/refman/8.4/en/keyring-key-migration.html
If the running server was using the destination keystore before the migration and should continue to use it after the migration, it should be restarted after the migration to load all keys migrated into the destination keystore. If the running ... A ...
https://dev.mysql.com/doc/refman/8.4/en/linux-installation-native.html
For Red Hat and similar distributions, the MySQL distribution is divided into a number of separate packages, mysql for the client tools, mysql-server for the server and associated tools, and mysql-libs for the libraries. Many Linux distributions ...
https://dev.mysql.com/doc/refman/8.4/en/loadable-function-reference.html
The following table lists each function that is loadable at runtime and provides a short description of each one. For a table listing built-in functions and operators, see Section 14.1, “Built-In Function and Operator Reference” For general ...
https://dev.mysql.com/doc/refman/8.4/en/macos-installation-pkg.html
When installing using the package installer, the files are installed into a directory within /usr/local matching the name of the installation version and platform. For example, the installer file mysql-8.4.6-macos10.15-x86_64.dmg installs MySQL into ... The package is located inside a disk image (.dmg) file that you first need to mount by double-clicking its icon in the ...