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/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/5.7/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/5.7/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/5.7/en/create-table.html
Indexes and Foreign Keys Several keywords apply to creation of indexes and foreign keys. For general background in addition to the following descriptions, see Section 13.1.14, “CREATE INDEX Statement”, and Section 13.1.18.5, “FOREIGN KEY ...| ...(Some valid select or union statement) CREATE TABLE creates a table with the given ...
https://dev.mysql.com/doc/refman/5.7/en/alter-table.html
Foreign Keys and Other Constraints The FOREIGN KEY and REFERENCES clauses are supported by the InnoDB and NDB storage engines, which implement ADD [CONSTRAINT [symbol]] FOREIGN KEY [index_name] (...) REFERENCES ... For ALTER TABLE, unlike CREATE ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-online-ddl-operations.html
Index Operations Primary Key Operations Column Operations Generated Column Operations Foreign Key Operations Table Operations Tablespace Operations Partitioning Operations Index Operations The following table provides an overview of online DDL ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-key-column-usage-table.html
If the constraint is a foreign key, then this is the column of the foreign key, not the column that the foreign key references. For foreign-key constraints, this column is the ordinal position in key of the table that is being referenced. The ...
https://dev.mysql.com/doc/refman/5.7/en/keyring-functions-general-purpose.html
MySQL Server supports a keyring service that enables internal server components and plugins to store sensitive information securely for later retrieval. As of MySQL 5.7.13, MySQL Server includes an SQL interface for keyring key management, ...For ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-information-schema-system-tables.html
INNODB_SYS_FOREIGN provides metadata about foreign keys defined on InnoDB tables, equivalent to the information in the SYS_FOREIGN table in the InnoDB data dictionary. INNODB_SYS_FOREIGN_COLS provides metadata about the columns of foreign keys that ...INNODB_SYS_FIELDS provides metadata about the key columns (fields) of InnoDB indexes, equivalent to the information in the SYS_FIELDS table in the InnoDB data ...
https://dev.mysql.com/doc/refman/5.7/en/creating-ssl-files-using-openssl.html
This section describes how to use the openssl command to set up SSL certificate and key files for use by MySQL servers and clients. See Section 6.3.3.1, “Creating SSL and RSA Certificates and Keys using MySQL”. Important Whatever method you use ...The first example shows a simplified procedure such as you might use from the command ...