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/keyring.html
MySQL Server supports a keyring that enables internal server components and plugins to securely store sensitive information for later retrieval. The implementation comprises these elements: Keyring plugins that manage a backing store or communicate ...Available in MySQL Community Edition and MySQL Enterprise Edition distributions as of MySQL ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-tips.html
For example, the left-arrow and right-arrow keys move horizontally within the current input line, and the up-arrow and down-arrow keys move up and down through the set of previously entered lines. On Windows, the editing key sequences are the same ... This section provides information about techniques for more effective use of mysql and about mysql operational ...
https://dev.mysql.com/doc/refman/5.7/en/replace.html
REPLACE works exactly like INSERT, except that if an old row in the table has the same value as a new row for a PRIMARY KEY or a UNIQUE index, the old row is deleted before the new row is inserted. The server recognizes but ignores the DELAYED ...
https://dev.mysql.com/doc/refman/5.7/en/keyring-options.html
MySQL supports the following keyring-related command-line options: --keyring-migration-destination=plugin Command-Line Format --keyring-migration-destination=plugin_name Introduced 5.7.21 Type String The destination keyring plugin for key migration. The format and interpretation of the option value is the same as described for the --keyring-migration-source ...
https://dev.mysql.com/doc/refman/5.7/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 12.1, “Built-In Function and Operator Reference” For general ...
https://dev.mysql.com/doc/refman/5.7/en/group-by-functional-dependence.html
A UNIQUE index over a NOT NULL column could be used instead of a primary key and the same functional dependence would apply. As with the previous example, a UNIQUE key over NOT NULL columns could be used instead of a primary key. In each case, this ... The following discussion provides several examples of the ways in which MySQL detects functional ...
https://dev.mysql.com/doc/refman/5.7/en/index-extensions.html
InnoDB automatically extends each secondary index by appending the primary key columns to it. Consider this table definition: CREATE TABLE t1 ( i1 INT NOT NULL DEFAULT 0, i2 INT NOT NULL DEFAULT 0, d DATE DEFAULT NULL, PRIMARY KEY (i1, i2), INDEX ...It also defines a secondary index k_d on column (d), but internally InnoDB extends this index and treats it as columns (d, i1, ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-analyze-table-complexity.html
For example, columns a and b are counted for the primary key index. For the nonunique indexes, the primary key columns (a,b) are counted in addition to the user defined columns. ANALYZE TABLE complexity for InnoDB tables is dependent on: The number ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-memcached-internals.html
In this case, if memcached cannot find a key in memory, it searches for the value in an InnoDB table. For example, if you define col1, col2 as value columns, and you define | as the separator, you can issue the following memcached command to insert ... InnoDB API for the InnoDB memcached Plugin The InnoDB memcached engine accesses InnoDB through InnoDB APIs, most of which are directly adopted from embedded ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-persistent-stats.html
The number of columns in the table's primary key is also important to consider, as primary key columns are appended to each nonunique index. Note For nonunique indexes, InnoDB appends the columns of the primary key. Only two columns are defined for ... The persistent optimizer statistics feature improves plan stability by storing statistics to disk and making them persistent across server restarts so that the optimizer is more likely to make consistent choices each time for a given ...