PDF (US Ltr)
- 35.0Mb
PDF (A4)
- 35.1Mb
Man Pages (TGZ)
- 254.9Kb
Man Pages (Zip)
- 359.9Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/bnl-bka-optimization.html
After submission of the keys, the MRR engine functions perform lookups in the index in an optimal way, fetching the rows of the joined table found by these keys, and starts feeding the BKA join algorithm with matching rows. The following setting ...
https://dev.mysql.com/doc/refman/5.7/en/gis-data-formats.html
(Internal format is like WKB but with an initial 4 bytes to indicate the SRID.) There are functions available to convert between different data formats; see Section 12.16.6, “Geometry Format Conversion Functions”. This differs from the syntax ...
https://dev.mysql.com/doc/refman/5.7/en/implicit-commit.html
ALTER FUNCTION, CREATE FUNCTION and DROP FUNCTION also cause an implicit commit when used with stored functions, but not with loadable functions. (ALTER FUNCTION can only be used with stored functions.) CREATE TABLE and DROP TABLE statements do not ... The statements listed in this section (and any synonyms for them) implicitly end any transaction active in the current session, as if you had done a COMMIT before executing the ...
https://dev.mysql.com/doc/refman/5.7/en/keyring-okv-plugin.html
If two or more MySQL Server instances use the same set of credentials, they can interfere with each other’s functioning. The keyring_okv plugin supports the functions that comprise the standard MySQL Keyring service interface. Keyring operations ... Note The keyring_okv plugin is an extension included in MySQL Enterprise Edition, a commercial ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-option-tables.html
ndb-connectstring: Address of NDB management server distributing configuration information for this cluster. Ndb_conflict_fn_epoch: Number of rows that have been found in conflict by NDB$EPOCH() NDB replication conflict detection function. The ...
https://dev.mysql.com/doc/refman/5.7/en/sys-sys-config.html
As an efficiency measure to minimize the number of direct reads from the sys_config table, sys schema functions that use a value from this table check for a user-defined variable with a corresponding name, which is the user-defined variable having ... This table contains sys schema configuration options, one row per ...
https://dev.mysql.com/doc/refman/5.7/en/alter-table-partition-operations.html
ALGORITHM=1 causes the server to use the same key-hashing functions as MySQL 5.1 when computing the placement of rows in partitions; ALGORITHM=2 means that the server employs the key-hashing functions implemented and used by default for new KEY ...
https://dev.mysql.com/doc/refman/5.7/en/compatibility.html
You can also find information about functionality missing from MySQL Server, and how to work around some of the differences. We are not targeting real-time support, although MySQL replication capabilities offer significant functionality. We ... This ...
https://dev.mysql.com/doc/refman/5.7/en/group-by-optimization.html
The most general way to satisfy a GROUP BY clause is to scan the whole table and create a new temporary table where all rows from each group are consecutive, and then use this temporary table to discover groups and apply aggregate functions (if ...
https://dev.mysql.com/doc/refman/5.7/en/keyring.html
This service is accessible at two levels: SQL interface: In SQL statements, call the functions described in Section 6.4.4.8, “General-Purpose Keyring Key-Management Functions”. C interface: In C-language code, call the keyring service functions ... MySQL Server supports a keyring that enables internal server components and plugins to securely store sensitive information for later ...