PDF (US Ltr)
- 41.8Mb
PDF (A4)
- 41.9Mb
Man Pages (TGZ)
- 272.4Kb
Man Pages (Zip)
- 378.4Kb
Info (Gzip)
- 4.2Mb
Info (Zip)
- 4.2Mb
Search Results
https://dev.mysql.com/doc/refman/9.7/en/myisampack.html
When the table is used later, the server reads into memory the information needed to decompress columns. This results in much better performance when accessing individual rows, because you only have to uncompress exactly one row. MySQL uses mmap() ...
https://dev.mysql.com/doc/refman/9.7/en/no-matching-rows.html
If you have a complicated query that uses many tables but that returns no rows, you should use the following procedure to find out what is wrong: Test the query with EXPLAIN to check whether you can find something that is obviously wrong. Select ...
https://dev.mysql.com/doc/refman/9.7/en/numeric-functions.html
Table 14.8 Numeric Functions and Operators Name Description %, MOD Modulo operator * Multiplication operator + Addition operator - Minus operator - Change the sign of the argument / Division operator ABS() Return the absolute value ACOS() Return ...
https://dev.mysql.com/doc/refman/9.7/en/numeric-type-attributes.html
MySQL supports an extension for optionally specifying the display width of integer data types in parentheses following the base keyword for the type. For example, INT(4) specifies an INT with a display width of four digits. This optional display ...
https://dev.mysql.com/doc/refman/9.7/en/optimizer-statistics.html
The column_statistics data dictionary table stores histogram statistics about column values, for use by the optimizer in constructing query execution plans. The column_statistics table has these characteristics: The table contains statistics for ...
https://dev.mysql.com/doc/refman/9.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/9.7/en/partitioning-columns.html
The next two sections discuss COLUMNS partitioning, which are variants on RANGE and LIST partitioning. COLUMNS partitioning enables the use of multiple columns in partitioning keys. All of these columns are taken into account both for the purpose ...
https://dev.mysql.com/doc/refman/9.7/en/partitioning-limitations-functions.html
This section discusses limitations in MySQL Partitioning relating specifically to functions used in partitioning expressions. Each of these functions returns an integer only if it is passed an argument of an exact numeric type, such as one of the ...
https://dev.mysql.com/doc/refman/9.7/en/partitioning-overview.html
This section provides a conceptual overview of partitioning in MySQL 9.7. For information on partitioning restrictions and feature limitations, see Section 26.6, “Restrictions and Limitations on Partitioning”. The SQL standard does not provide ...
https://dev.mysql.com/doc/refman/9.7/en/partitioning-types.html
This section discusses the types of partitioning which are available in MySQL 9.7. This type of partitioning assigns rows to partitions based on column values falling within a given range. For information about an extension to this type, RANGE ...