PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/searching-on-two-keys.html
An OR using a single key is well optimized, as is the handling of AND. The one tricky case is that of searching on two different keys combined with OR: SELECT field1_index, field2_index FROM test_table WHERE field1_index = '1' OR field2_index = '1' ...You can also solve the problem efficiently by using a UNION that combines the output of two separate SELECT ...
https://dev.mysql.com/doc/refman/8.0/en/key-cache-block-size.html
It is possible to specify the size of the block buffers for an individual key cache using the key_cache_block_size variable. But setting the size of key nodes equal to the size of the I/O buffer does not always ensure the best overall performance.
https://dev.mysql.com/doc/refman/8.0/en/shared-key-cache.html
Threads can access key cache buffers simultaneously, subject to the following conditions: A buffer that is not being updated can be accessed by multiple sessions. Shared access to the key cache enables the server to improve throughput significantly. A buffer that is being updated causes sessions that need to use it to wait until the update is ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-functions-for-member-actions.html
The following functions can be used to enable and disable actions for members of a group to take in specified situations, and to reset the configuration to the default setting for all member actions. They can only be used by administrators with the ...
https://dev.mysql.com/doc/refman/8.0/en/change-replication-source-to.html
GET_SOURCE_PUBLIC_KEY = {0|1} Enables RSA key pair-based password exchange by requesting the public key from the source. For connections by accounts that authenticate using this plugin, the source does not send the public key unless requested, so it ...] CHANGE REPLICATION SOURCE TO changes the parameters that the replica server uses for connecting to the source and reading data from the ...
https://dev.mysql.com/doc/refman/8.0/en/faqs-mysql-cluster.html
There is no user-facing mechanism for influencing this selection, which is completely automatic; the fact that it is automatic is a key part of NDB Cluster's internal architecture. You must also remember to account for any column indexes as follows: ... In the following section, we answer questions that are frequently asked about MySQL NDB Cluster and the NDB storage ...
https://dev.mysql.com/doc/refman/8.0/en/using-innodb-tables.html
InnoDB tables are created using the CREATE TABLE statement; for example: CREATE TABLE t1 (a INT, b CHAR (20), PRIMARY KEY (a)) ENGINE=InnoDB; The ENGINE=InnoDB clause is not required when InnoDB is defined as the default storage engine, which it is ...However, the ENGINE clause is useful if the CREATE TABLE statement is to be replayed on a different MySQL Server instance where the default storage engine is not InnoDB or is ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-nutshell.html
It also supports more transport protocols and does not require linking against OpenSSL for RSA key pair-based password-exchange capabilities. FIPS mode imposes conditions on cryptographic operations such as restrictions on acceptable encryption ...
https://dev.mysql.com/doc/refman/8.0/en/password-management.html
To change the value for the running MySQL instance without having it carry over to subsequent restarts, use the GLOBAL keyword rather than PERSIST. To change the value for the running MySQL instance without having it carry over to subsequent ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-limitations.html
Multi-primary mode groups (members all configured with group_replication_single_primary_mode=OFF) do not support tables with multi-level foreign key dependencies, specifically tables that have defined CASCADING foreign key constraints. This is ...