PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 296.5Kb
Man Pages (Zip)
- 401.9Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/precision-math-decimal-characteristics.html
D is the number of digits to the right of the decimal point (the scale). Leftover Digits Number of Bytes 0 0 1–2 1 3–4 2 5–6 3 7–9 4 For example, a DECIMAL(18,9) column has nine digits on either side of the decimal point, so the integer part ... This section discusses the characteristics of the DECIMAL data type (and its synonyms), with particular regard to the following topics: Maximum number of digits Storage format Storage requirements The nonstandard MySQL extension to the upper range of DECIMAL columns The declaration syntax for a DECIMAL column is ...
https://dev.mysql.com/doc/refman/8.0/en/precision-math-expressions.html
(If strict SQL mode is not enabled, truncation for INSERT is permissible.) Handling of a numeric expression depends on what kind of values the expression contains: If any approximate values are present, the expression is approximate and is evaluated ... With precision math, exact-value numbers are used as given whenever ...
https://dev.mysql.com/doc/refman/8.0/en/replication-gtids-howto.html
Binary logs containing transactions without GTIDs cannot be used on servers where GTIDs are enabled, so backups taken before this point cannot be used with your new configuration. If you use binary logs for anything other than replication, for ...
https://dev.mysql.com/doc/refman/8.0/en/replication-options-replica.html
replica_checkpoint_group Command-Line Format --replica-checkpoint-group=# Introduced 8.0.26 System Variable replica_checkpoint_group Scope Global Dynamic Yes SET_VAR Hint Applies No Type Integer Default Value 512 Minimum Value 32 Maximum Value ...
https://dev.mysql.com/doc/refman/8.0/en/server-options.html
To enable it, specify a value greater than 0; this value also becomes the default timeout for individual synchronization points. For a description of the Debug Sync facility and how to use synchronization points, see MySQL Internals: Test ... When ...
https://dev.mysql.com/doc/refman/8.0/en/source-configuration-options.html
(The default value is 0, which disables Debug Sync.) N becomes the default timeout for individual synchronization points. For a description of the Debug Sync facility and how to use synchronization points, see MySQL Internals: Test Synchronization.
https://dev.mysql.com/doc/refman/8.0/en/spatial-type-overview.html
Some spatial data types hold single geometry values: GEOMETRY POINT LINESTRING POLYGON GEOMETRY can store geometry values of any type. The other single-value types (POINT, LINESTRING, and POLYGON) restrict their values to a particular geometry type.
https://dev.mysql.com/doc/refman/8.0/en/alter-table.html
The exception referred to earlier is that ALTER TABLE blocks reads (not just writes) at the point where it is ready to clear outdated table structures from the table and table definition caches. ALTER TABLE tbl_name [alter_option [, alter_option] ...
https://dev.mysql.com/doc/refman/8.0/en/backup-policy.html
A full backup (a snapshot of the data at a point in time) can be done in MySQL with several tools. For example, MySQL Enterprise Backup can perform a physical backup of an entire instance, with optimizations to minimize overhead and avoid disruption ...
https://dev.mysql.com/doc/refman/8.0/en/charset-unicode.html
BMP characters have these characteristics: Their code point values are between 0 and 65535 (or U+0000 and U+FFFF). Supplementary characters lie outside the BMP: Their code point values are between U+10000 and U+10FFFF). The Unicode Standard ...