https://dev.mysql.com/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/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/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 ...
https://dev.mysql.com/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/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/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/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/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 ] ...
https://dev.mysql.com/group-by-modifiers.html
The GROUP BY clause permits a WITH ROLLUP modifier that causes summary output to include extra rows that represent higher-level (that is, super-aggregate) summary operations. ROLLUP thus enables you to answer questions at multiple levels of ...
https://dev.mysql.com/help.html
HELP 'search_string' The HELP statement returns online information from the MySQL Reference Manual. Its proper operation requires that the help tables in the mysql database be initialized with help topic information (see Section 5.1.14, ...
