PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 296.6Kb
Man Pages (Zip)
- 402.0Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/bit-value-literals.html
A leading 0b is case-sensitive and cannot be written as 0B. In numeric contexts, MySQL treats a bit literal like an integer. To ensure numeric treatment of a bit literal, use it in numeric context. For example, a bit literal assigned to a ...
https://dev.mysql.com/doc/refman/8.0/en/create-table.html
For CHAR, VARCHAR, BINARY, and VARBINARY columns, indexes can be created that use only the leading part of column values, using col_name(length) syntax to specify an index prefix length. | {FULLTEXT | SPATIAL} [INDEX | KEY] [index_name] ...
https://dev.mysql.com/doc/refman/8.0/en/delete.html
DELETE QUICK is not useful when deleted values lead to underfilled index blocks spanning a range of index values for which new inserts occur again. In this case, use of QUICK can lead to wasted space in the index that remains unreclaimed. DELETE is ...
https://dev.mysql.com/doc/refman/8.0/en/glossary.html
InnoDB does not use the beta designation, preferring an early adopter phase that can extend over several point releases, leading to a GA release. index prefix In an index that applies to multiple columns (known as a composite index), the initial or ... These terms are commonly used in information about the MySQL database ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-compression-internals.html
Files are typically divided into fixed-size blocks that are compressed into variable-size blocks, which easily leads into fragmentation. Depending on the workload, this smaller database can in turn lead to a reduction in I/O, and an increase in ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-compression-tuning.html
If the system performs DML operations on compressed tables, and the way the data is distributed leads to expensive compression failures at runtime, you might adjust additional advanced configuration options. If the compressed page size is set too ...
https://dev.mysql.com/doc/refman/8.0/en/json.html
For paths used in MySQL JSON functions, the scope is always the document being searched or otherwise operated on, represented by a leading $ character. The JSON data type provides these advantages over storing JSON-format strings in a string column: ...
https://dev.mysql.com/doc/refman/8.0/en/myisampack.html
pre-space The number of decimal columns that are stored with leading spaces. In this case, each value contains a count for the number of leading spaces. When the table is used later, the server reads into memory the information needed to decompress ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-replication-conflict-resolution.html
A value that is too small can result in false positives, while one that is too large could lead to excessive wasted space in the database. This means that further conflicts during the propagation of any subsequent realignment operations are not ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-what-is-new.html
This library is used internally for development, and is not required for normal use; its inclusion in these programs could lead to unwanted issues when testing. The following sections describe changes in the implementation of MySQL NDB Cluster in ...