PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 296.5Kb
Man Pages (Zip)
- 401.9Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/data-size.html
Design your tables to minimize their space on the disk. This can result in huge improvements by reducing the amount of data written to and read from disk. Smaller tables normally require less main memory while their contents are being actively ...
https://dev.mysql.com/doc/refman/8.0/en/dynamic-format.html
Each row is preceded by a bitmap that indicates which columns contain the empty string (for string columns) or zero (for numeric columns). If a string column has a length of zero after trailing space removal, or a numeric column has a value of zero, ... Dynamic storage format is used if a MyISAM table contains any variable-length columns (VARCHAR, VARBINARY, BLOB, or TEXT), or if the table was created with the ROW_FORMAT=DYNAMIC table ...
https://dev.mysql.com/doc/refman/8.0/en/engine-condition-pushdown-optimization.html
This exclusion extends to JSON, BIT, and ENUM columns as well. This optimization improves the efficiency of direct comparisons between a nonindexed column and a constant. In such cases, the condition is “pushed down” to the storage engine for ...
https://dev.mysql.com/doc/refman/8.0/en/enterprise-encryption-usage.html
To use MySQL Enterprise Encryption in applications, invoke the functions that are appropriate for the operations you wish to perform. In releases before MySQL 8.0.30, MySQL Enterprise Encryption's functions are based on the openssl_udf shared ...
https://dev.mysql.com/doc/refman/8.0/en/floating-point-types.html
For FLOAT, the SQL standard permits an optional specification of the precision (but not the range of the exponent) in bits following the keyword FLOAT in parentheses, that is, FLOAT(p). The FLOAT and DOUBLE types represent approximate numeric data ...
https://dev.mysql.com/doc/refman/8.0/en/general-tablespaces.html
The unique file name is a 128 bit UUID formatted into five groups of hexadecimal numbers separated by dashes (aaaaaaaa-bbbb-cccc-dddd-eeeeeeeeeeee). A general tablespace is a shared InnoDB tablespace that is created using CREATE TABLESPACE syntax.
https://dev.mysql.com/doc/refman/8.0/en/gis-class-geometry.html
If a larger value is given, only the lower 32 bits are used. It is a noninstantiable class but has a number of properties, described in the following list, that are common to all geometry values created from any of the Geometry subclasses. Geometry ...
https://dev.mysql.com/doc/refman/8.0/en/gis-data-formats.html
Two standard spatial data formats are used to represent geometry objects in queries: Well-Known Text (WKT) format Well-Known Binary (WKB) format Internally, MySQL stores geometry values in a format that is not identical to either WKT or WKB format.
https://dev.mysql.com/doc/refman/8.0/en/gis-general-property-functions.html
If any SRID argument is not within the range of a 32-bit unsigned integer, an ER_DATA_OUT_OF_RANGE error occurs. The functions listed in this section do not restrict their argument and accept a geometry value of any type. Unless otherwise ...
https://dev.mysql.com/doc/refman/8.0/en/grant.html
To accommodate granting rights to users from arbitrary hosts, MySQL supports specifying the user value in the form 'user_name'@'host_name'. If you are using table, column, or routine privileges for even one user, the server examines table, column, ...[WITH GRANT OPTION] [AS user [WITH ROLE DEFAULT | NONE | ALL | ALL EXCEPT role [, role ] ...