PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/myisamchk-table-info.html
uint24 NULL 0 1024 Field Start Length Nullpos Nullbit Type 1 1 1 2 2 4 no zeros 3 6 81 varchar 4 87 81 varchar 5 168 3 1 1 no zeros 6 171 3 1 2 no zeros Explanations for the types of information myisamchk produces are given here. varchar prefix 0 ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-disk-data-storage-requirements.html
For example, converting a CHAR(4) column from memory-based to disk-based format increases the amount of DataMemory used per row from 4 to 8 bytes. The following items apply to Disk Data storage requirements: Variable-length columns of Disk Data ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-limitations-database-objects.html
For memory-based columns, you can work around this limitation by using a variable-width column type such as VARCHAR or defining the column as COLUMN_FORMAT=DYNAMIC; this does not work with columns stored on disk. Some database objects such as ...
https://dev.mysql.com/doc/refman/8.0/en/numeric-type-attributes.html
For example, applications can use the LPAD() function to zero-pad numbers up to the desired width, or they can store the formatted numbers in CHAR columns. MySQL supports an extension for optionally specifying the display width of integer data ...
https://dev.mysql.com/doc/refman/8.0/en/numeric-type-syntax.html
For example, applications could use the LPAD() function to zero-pad numbers up to the desired width, or they could store the formatted numbers in CHAR columns. For integer data types, M indicates the minimum display width. Display width is ...
https://dev.mysql.com/doc/refman/8.0/en/order-by-optimization.html
For example, if only the first 10 bytes of a CHAR(20) column are indexed, the index cannot distinguish values past the 10th byte and a filesort is needed. (A symptom of setting the value of this variable too high is a combination of high disk ...
https://dev.mysql.com/doc/refman/8.0/en/partitioning-columns.html
All of these columns are taken into account both for the purpose of placing rows in partitions and for the determination of which partitions are to be checked for matching rows in partition pruning. The next two sections discuss COLUMNS ...
https://dev.mysql.com/doc/refman/8.0/en/partitioning-linear-hash.html
MySQL also supports linear hashing, which differs from regular hashing in that linear hashing utilizes a linear powers-of-two algorithm whereas regular hashing employs the modulus of the hashing function's value. We call this value V; it can be ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-user-defined-functions-table.html
The value is one of int, decimal, real, char, or row. The user_defined_functions table contains a row for each loadable function registered automatically by a component or plugin, or manually by a CREATE FUNCTION statement. For information about ...
https://dev.mysql.com/doc/refman/8.0/en/replication-gtids-concepts.html
A GTID is represented as a pair of coordinates, separated by a colon character (:), as shown here: GTID = source_id:transaction_id The source_id identifies the originating server. A global transaction identifier (GTID) is a unique identifier ...