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/fixed-point-types.html
The DECIMAL and NUMERIC types store exact numeric data values. These types are used when it is important to preserve exact precision, for example with monetary data. In MySQL, NUMERIC is implemented as DECIMAL, so the following remarks about ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-ndbinfo-memory-per-fragment.html
These memory pages are managed as listed here: Fixed-size pages: These store the fixed-size parts of rows stored in a given fragment. Each row in an NDB table has a fixed-size part, consisting of a row header, and one or more fixed-size columns. A ... memory_per_fragment Table: Notes memory_per_fragment Table: Examples The memory_per_fragment table provides information about the usage of memory by individual ...
https://dev.mysql.com/doc/refman/8.0/en/static-format.html
The security is evidenced if your computer crashes while the MySQL server is writing to a fixed-format MyISAM file. Note Fixed-length row format is available only for tables having no BLOB or TEXT columns. Easy to reconstruct after a crash, because ...It is used when the table contains no variable-length columns (VARCHAR, VARBINARY, BLOB, or ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-row-format.html
Depending on column length, all or a prefix of variable-length column values are stored in the B-tree to avoid wasting storage and having to read a separate page. Fixed-length columns greater than or equal to 768 bytes are encoded as variable-length ... The row format of a table determines how its rows are physically stored, which in turn can affect the performance of queries and DML ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-programs-ndb-desc.html
--defaults-group-suffix Command-Line Format --defaults-group-suffix=string Type String Default Value [none] Also read groups with concat(group, suffix). ndb_desc provides a detailed description of one or more NDB tables. Usage ndb_desc -c ...
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. BLOB and TEXT columns also can be indexed, but a prefix length ...| {FULLTEXT | SPATIAL} [INDEX | KEY] [index_name] (key_part,...) [index_option] ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-online-add-node-example.html
In this section we provide a detailed example illustrating how to add new NDB Cluster data nodes online, starting with an NDB Cluster having 2 data nodes in a single node group and concluding with a cluster having 4 data nodes in 2 node groups.
https://dev.mysql.com/doc/refman/8.0/en/glossary.html
MySQL can build a hash index on a prefix of any length of the key defined for the B-tree, depending on the pattern of searches against the index. This distinction is important mainly in MySQL 5.1, where a feature or bug fix might apply to the InnoDB ... These terms are commonly used in information about the MySQL database ...
https://dev.mysql.com/doc/refman/8.0/en/load-data.html
If all the input lines have a common prefix that you want to ignore, you can use LINES STARTING BY 'prefix_string' to skip the prefix and anything before it. If a line does not include the prefix, the entire line is skipped. The third row in the ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-online-operations.html
row *************************** Level: Warning Code: 1478 Message: DYNAMIC column c4 with STORAGE DISK is not supported, column will become FIXED mysql> SHOW CREATE TABLE t1\G *************************** 1. row *************************** Level: ...