PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 296.5Kb
Man Pages (Zip)
- 401.9Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/innodb-multiple-buffer-pools.html
Each buffer pool manages its own free lists, flush lists, LRUs, and all other data structures connected to a buffer pool. For systems with buffer pools in the multi-gigabyte range, dividing the buffer pool into separate instances can improve ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-online-ddl-limitations.html
When running an in-place online DDL operation, the thread that runs the ALTER TABLE statement applies an online log of DML operations that were run concurrently on the same table from other connection threads. The following limitations apply to ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-performance-thread_concurrency.html
For general performance information about MySQL thread handling, see Section 7.1.12.1, “Connection Interfaces”. InnoDB uses operating system threads to process requests from user transactions. (Transactions may issue many requests to InnoDB ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-preload-buffer-pool.html
Because uncompressing pages is a CPU-intensive process, it is more efficient for concurrency to perform the operation in a connection thread rather than in the single thread that performs the buffer pool restore operation. To reduce the warmup ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-redo-log.html
Modifications that did not finish updating data files before an unexpected shutdown are replayed automatically during initialization and before connections are accepted. The redo log is a disk-based data structure used during crash recovery to ...
https://dev.mysql.com/doc/refman/8.0/en/insert-on-duplicate.html
If you specify the CLIENT_FOUND_ROWS flag to the mysql_real_connect() C API function when connecting to mysqld, the affected-rows value is 1 (not 0) if an existing row is set to its current values. If you specify an ON DUPLICATE KEY UPDATE clause ...
https://dev.mysql.com/doc/refman/8.0/en/insert.html
If you specify the CLIENT_FOUND_ROWS flag to the mysql_real_connect() C API function when connecting to mysqld, the affected-rows value is 1 (not 0) if an existing row is set to its current values. INSERT [LOW_PRIORITY | DELAYED | HIGH_PRIORITY] ...
https://dev.mysql.com/doc/refman/8.0/en/ipv6-system-support.html
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 is true, try this command: $> ping6 ::1 16 bytes from ::1, icmp_seq=0 hlim=64 time=0.171 ms 16 ...
https://dev.mysql.com/doc/refman/8.0/en/keyring-oci-component.html
“user”: The OCID of the Oracle Cloud Infrastructure user that component_keyring_oci uses for connections. Note The Oracle Cloud Infrastructure Vault keyring component is included in MySQL Enterprise Edition, a commercial product.
https://dev.mysql.com/doc/refman/8.0/en/keyring-oci-plugin.html
Consequently, prior to using the keyring_oci plugin, these prerequisites must be satisfied: A user for connecting to Oracle Cloud Infrastructure must exist. Note The keyring_oci plugin is an extension included in MySQL Enterprise Edition, a ...