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/innodb-locking.html
Shared and Exclusive Locks Intention Locks Record Locks Gap Locks Next-Key Locks Insert Intention Locks AUTO-INC Locks Predicate Locks for Spatial Indexes Shared and Exclusive Locks InnoDB implements standard row-level locking where there are two ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-memcached-ddl.html
If this option is set to a value greater than 1, use READ UNCOMMITTED queries to find rows that were just inserted. You can access the underlying InnoDB table (which is test.demo_test by default) through standard SQL interfaces. However, there are ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-page-compression.html
InnoDB supports page-level compression for tables that reside in file-per-table tablespaces. Page compression is enabled by specifying the COMPRESSION attribute with CREATE TABLE or ALTER TABLE. Supported Platforms Page compression requires sparse ...
https://dev.mysql.com/doc/refman/5.7/en/is-null-optimization.html
MySQL can also optimize the combination col_name = expr OR col_name IS NULL, a form that is common in resolved subqueries. MySQL can perform the same optimization on col_name IS NULL that it can use for col_name = constant_value. For example, MySQL ...
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/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 ...