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/optimizing-spatial-analysis.html
For a horizontal or a vertical linestring, the MBR is a rectangle degenerated into the linestring. For a point, the MBR is a rectangle degenerated into the point. For MyISAM and InnoDB tables, search operations in columns containing spatial data ...
https://dev.mysql.com/doc/refman/5.7/en/order-by-optimization.html
For example: INSERT INTO foo SELECT a, COUNT(*) FROM bar GROUP BY a ORDER BY NULL; The optimizer may still choose to use sorting to implement grouping operations. (Up to 15 temporary disk files are merged and there must be room in memory for at ...
https://dev.mysql.com/doc/refman/5.7/en/out-of-range-and-overflow.html
If no restrictive modes are enabled, MySQL clips the value to the appropriate endpoint of the column data type range and stores the resulting value instead. When an out-of-range value is assigned to an integer column, MySQL stores the value ...
https://dev.mysql.com/doc/refman/5.7/en/outer-join-simplification.html
When the optimizer evaluates plans for outer join operations, it takes into consideration only plans where, for each such operation, the outer tables are accessed before the inner tables. Table expressions in the FROM clause of a query are ...
https://dev.mysql.com/doc/refman/5.7/en/partitioning-columns-list.html
This is a variant of LIST partitioning that enables the use of multiple columns as partition keys, and for columns of data types other than integer types to be used as partitioning columns; you can use string types, DATE, and DATETIME columns. In ...
https://dev.mysql.com/doc/refman/5.7/en/partitioning-management-hash-key.html
Suppose that you have a table containing data about clients, which is divided into twelve partitions. Tables which are partitioned by hash or by key are very similar to one another with regard to making changes in a partitioning setup, and both ...
https://dev.mysql.com/doc/refman/5.7/en/partitioning-overview.html
There are no plans at this time to introduce vertical partitioning into MySQL. This section provides a conceptual overview of partitioning in MySQL 5.7. For information on partitioning restrictions and feature limitations, see Section 22.6, ...
https://dev.mysql.com/doc/refman/5.7/en/partitioning-subpartitions.html
Each of these partitions—p0, p1, and p2—is further divided into 2 subpartitions. In effect, the entire table is divided into 3 * 2 = 6 partitions. Subpartitioning—also known as composite partitioning—is the further division of each ...
https://dev.mysql.com/doc/refman/5.7/en/partitioning-types.html
With this type of partitioning, a partition is selected based on the value returned by a user-defined expression that operates on column values in rows to be inserted into the table. When a new row is inserted into a partitioned table, it is these ... This section discusses the types of partitioning which are available in MySQL ...
https://dev.mysql.com/doc/refman/5.7/en/password-hashing.html
However, a pre-4.1 client that attempts to connect to a 4.1 or higher server may run into difficulties. If the column has not been updated and still has the pre-4.1 width of 16 bytes, the server notices that long hashes cannot fit into it and ...