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/key-cache-restructuring.html
However, restructuring does not block queries that need to use indexes assigned to the cache. File system caching is not as efficient as using a key cache, so although queries execute, a slowdown can be anticipated. A key cache can be restructured ...
https://dev.mysql.com/doc/refman/5.7/en/ldap-pluggable-authentication.html
Note LDAP pluggable authentication is an extension included in MySQL Enterprise Edition, a commercial product. As of MySQL 5.7.19, MySQL Enterprise Edition supports an authentication method that enables MySQL Server to use LDAP (Lightweight ...
https://dev.mysql.com/doc/refman/5.7/en/locale-support.html
The locale indicated by the lc_time_names system variable controls the language used to display day and month names and abbreviations. This variable affects the output from the DATE_FORMAT(), DAYNAME(), and MONTHNAME() functions. The lc_time_names ...
https://dev.mysql.com/doc/refman/5.7/en/mathematical-functions.html
ABS(X) Returns the absolute value of X, or NULL if X is NULL. An implication of this is that ABS(-9223372036854775808) produces an error because the result cannot be stored in a signed BIGINT value. mysql> SELECT ABS(2); -> 2 mysql> SELECT ABS(-32); ...
https://dev.mysql.com/doc/refman/5.7/en/metadata-locking.html
Metadata contention increases the more that multiple queries attempt to access the same objects. MySQL uses metadata locking to manage concurrent access to database objects and to ensure data consistency. Metadata locking applies not just to ...
https://dev.mysql.com/doc/refman/5.7/en/miscellaneous-optimization-tips.html
The resulting fast database operations are then available to be reused by other queries, applications, and even code written in different programming languages. This section lists a number of miscellaneous tips for improving query processing speed: ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-api-definition.html
(NDB 7.5.0) For queries that are translated into full table scans or range scans on indexes, it is important for best performance to fetch records in properly sized batches. The speed at which queries are performed can vary by more than 40% ... The ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-disk-data-storage-requirements.html
The following items apply to Disk Data storage requirements: Variable-length columns of Disk Data tables take up a fixed amount of space. For each row, this is equal to the space required to store the largest possible value for that column. For ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-limitations-performance.html
The following performance issues are specific to or especially pronounced in NDB Cluster: Range scans. There are query performance issues due to sequential access to the NDB storage engine; it is also relatively more expensive to do many range ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-limitations-syntax.html
Using nullable columns in unique keys and primary keys means that queries using these columns are handled as full table scans. Some SQL statements relating to certain MySQL features produce errors when used with NDB tables, as described in the ...