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/generated-column-index-optimizations.html
For example: CREATE TABLE t1 (f1 INT, gc INT AS (f1 + 1) STORED, INDEX (gc)); The generated column, gc, is defined as the expression f1 + 1. The column is also indexed and the optimizer can take that index into account during execution plan ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-locks-set.html
A locking read, an UPDATE, or a DELETE generally set record locks on every index record that is scanned in the processing of an SQL statement. It does not matter whether there are WHERE conditions in the statement that would exclude the row. InnoDB ...
https://dev.mysql.com/doc/refman/5.7/en/known-issues.html
This section lists known issues in recent versions of MySQL. For information about platform-specific issues, see the installation and debugging instructions in Section 2.1, “General Installation Guidance”, and Section 5.8, “Debugging MySQL”. The following problems are known: Subquery optimization for IN is not as effective as for ...
https://dev.mysql.com/doc/refman/5.7/en/merge-table-problems.html
The following are known problems with MERGE tables: MERGE child tables are locked through the parent table. If the parent is a temporary table, it is not locked, and thus the child tables are also not locked; this means that parallel use of the ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-install-example-data.html
Note The information in this section applies to NDB Cluster running on both Unix and Windows platforms. Working with database tables and data in NDB Cluster is not much different from doing so in standard MySQL. There are two key points to keep in ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-install-linux-rpm.html
This section covers the steps necessary to install the correct executables for each type of NDB Cluster node using RPM packages supplied by Oracle. As an alternative to the method described in this section, Oracle provides MySQL Repositories for ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-what-is-new-7-6.html
New features and other important changes in NDB Cluster 7.6 which are likely to be of interest are shown in the following list: New Disk Data table file format. A new file format is used in NDB 7.6 for NDB Disk Data tables, which makes it possible ...
https://dev.mysql.com/doc/refman/5.7/en/partitioning-limitations-locking.html
In MySQL 5.7, partition lock pruning eliminates unneeded locks in many cases, and most statements reading from or updating a partitioned MyISAM table cause only the effected partitions to be locked. For example, a SELECT from a partitioned MyISAM ...
https://dev.mysql.com/doc/refman/5.7/en/partitioning-limitations.html
This section discusses current restrictions and limitations on MySQL partitioning support. The following constructs are not permitted in partitioning expressions: Stored procedures, stored functions, loadable functions, or plugins. For a list of ...
https://dev.mysql.com/doc/refman/5.7/en/range-optimization.html
The range access method uses a single index to retrieve a subset of table rows that are contained within one or several index value intervals. The following sections describe conditions under which the optimizer uses range access. Additionally, for ...