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/mysql-cluster-what-is-new-7-5.html
The NDB handler now uses the records-per-key interface for index statistics implemented for the optimizer in MySQL 5.7.5. Important: Every table to be restored using this option must have an explicitly defined primary key. Major changes and new ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-secure-installation.html
--ssl* Options that begin with --ssl specify whether to connect to the server using encryption and indicate where to find SSL keys and certificates. This program enables you to improve the security of your MySQL installation in the following ways: ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-upgrade.html
Important In MySQL 5.7.11, the default --early-plugin-load value is the name of the keyring_file plugin library file, causing that plugin to be loaded by default. In MySQL 5.7.12 and higher, the default --early-plugin-load value is empty; to load ...
https://dev.mysql.com/doc/refman/5.7/en/optimizing-innodb-queries.html
Follow these guidelines for InnoDB indexes: Because each InnoDB table has a primary key (whether you request one or not), specify a set of primary key columns for each table, columns that are used in the most important and time-critical queries. Do ... To tune queries for InnoDB tables, create an appropriate set of indexes on each ...
https://dev.mysql.com/doc/refman/5.7/en/partitioning-management-range-list.html
For information about working with tables that are partitioned by hash or key, see Section 22.3.2, “Management of HASH and KEY Partitions”. Adding and dropping of range and list partitions are handled in a similar fashion, so we discuss the ...
https://dev.mysql.com/doc/refman/5.7/en/show-create-table.html
row *************************** Table: t Create Table: CREATE TABLE `t` ( `id` int(11) NOT NULL AUTO_INCREMENT, `s` char(60) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 SHOW CREATE TABLE quotes table and column names ...
https://dev.mysql.com/doc/refman/5.7/en/show-index.html
SHOW {INDEX | INDEXES | KEYS} {FROM | IN} tbl_name [{FROM | IN} db_name] [WHERE expr] SHOW INDEX returns table index information. row *************************** Table: city Non_unique: 0 Key_name: PRIMARY Seq_in_index: 1 Column_name: ID Collation: ...This statement requires some privilege for any column in the ...
https://dev.mysql.com/doc/refman/5.7/en/ssl-libraries.html
(yaSSL accepts these options but silently ignores them.) Accounts that authenticate using the sha256_password plugin can use RSA key files for secure password exchange over unencrypted connections. The server can automatically generate missing SSL ... MySQL can be compiled using OpenSSL or yaSSL, both of which enable encrypted connections based on the OpenSSL API: MySQL Enterprise Edition binary distributions are compiled using ...
https://dev.mysql.com/doc/refman/5.7/en/switchable-optimizations.html
The following list describes the permissible opt_name flag names, grouped by optimization strategy: Batched Key Access Flags batched_key_access (default off) Controls use of BKA join algorithm. For batched_key_access to have any effect when set to ...Its value is a set of flags, each of which has a value of on or off to indicate whether the corresponding optimizer behavior is enabled or ...
https://dev.mysql.com/doc/refman/5.7/en/sys-table-exists.html
Tests whether a given table exists as a regular table, a TEMPORARY table, or a view. If both a temporary and a permanent table exist with the given name, TEMPORARY is returned. Parameters in_db VARCHAR(64): The name of the database in which to ...