Search Results
https://dev.mysql.com/doc/refman/8.4/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.4/en/identifiers.html
Otherwise, the leading dollar sign is permitted but triggers a deprecation warning. The dollar sign can still be used as the leading character of such an identifier without producing the warning, when it is quoted according to the rules given later ... Certain objects within MySQL, including database, table, index, column, alias, view, stored procedure, partition, tablespace, resource group and other object names are known as ...
https://dev.mysql.com/doc/refman/8.4/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.4/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.4/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.4/en/keywords.html
Certain keywords, such as SELECT, DELETE, or BIGINT, are reserved and require special treatment for use as identifiers such as table and column names. This may also be true for the names of built-in functions. Some keywords which are otherwise ...
https://dev.mysql.com/doc/refman/8.4/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.4/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.4/en/option-files.html
However, in an option file, you omit the leading two dashes from the option name and you specify only one option per line. Leading and trailing spaces are automatically deleted from option names and values. Most MySQL programs can read startup ...
https://dev.mysql.com/doc/refman/8.4/en/precision-math-decimal-characteristics.html
DECIMAL columns do not store a leading + character or - character or leading 0 digits. This section discusses the characteristics of the DECIMAL data type (and its synonyms), with particular regard to the following topics: Maximum number of digits ...