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/charset-errors.html
Binary string values are copied as is for bytes in the range 0x20 to 0x7E, and using \x hexadecimal encoding for bytes outside that range. For more information about character_set_results, see Section 12.4, “Connection Character Sets and ... This ...
https://dev.mysql.com/doc/refman/8.0/en/choosing-types.html
All basic calculations (+, -, *, and /) with DECIMAL columns are done with precision of 65 decimal (base 10) digits. This enables you to do all calculations with 64-bit integers and then convert results back to floating-point values as necessary.
https://dev.mysql.com/doc/refman/8.0/en/clone-plugin-compressed-data.html
The following requirements apply when cloning remote data: The recipient file system must support sparse files and hole punching for hole punching to occur on the recipient. The donor and recipient file systems must have the same block size. If file ...
https://dev.mysql.com/doc/refman/8.0/en/clone-plugin-encrypted-data.html
Tablespace keys are decrypted at the donor before transport and re-encrypted at the recipient using the recipient master key. Note The innodb_redo_log_encrypt and innodb_undo_log_encrypt variable settings cannot be modified while a cloning operation ...The following requirements apply: A secure connection is required when cloning remote data to ensure safe transfer of unencrypted tablespace keys over the ...
https://dev.mysql.com/doc/refman/8.0/en/collation-diagnostics.html
For example, the following message results if a collation definition contains a <aaa> tag: [Warning] Buffered warning: Unknown LDML tag: 'charsets/charset/collation/rules/aaa' If collation initialization is not possible, the server reports an ...
https://dev.mysql.com/doc/refman/8.0/en/compressed-format.html
Note While a compressed table is read only, and you cannot therefore update or add rows in the table, DDL (Data Definition Language) operations are still valid. For example, you may still use DROP to drop the table, and TRUNCATE TABLE to empty the ... Compressed storage format is a read-only format that is generated with the myisampack ...
https://dev.mysql.com/doc/refman/8.0/en/controlling-optimizer.html
MySQL provides optimizer control through system variables that affect how query plans are evaluated, switchable optimizations, optimizer and index hints, and the optimizer cost model. The server maintains histogram statistics about column values in ...
https://dev.mysql.com/doc/refman/8.0/en/create-function.html
The CREATE FUNCTION statement is used to create stored functions and loadable functions: For information about creating stored functions, see Section 15.1.17, “CREATE PROCEDURE and CREATE FUNCTION Statements”. For information about creating ...
https://dev.mysql.com/doc/refman/8.0/en/creating-spatial-indexes.html
For InnoDB and MyISAM tables, MySQL can create spatial indexes using syntax similar to that for creating regular indexes, but using the SPATIAL keyword. For more information, see Section 13.4.1, “Spatial Data Types”, and Section 10.3.3, ...For ...
https://dev.mysql.com/doc/refman/8.0/en/data-dictionary-transactional-storage.html
The mysql.ibd tablespace file must reside in the MySQL data directory and its name cannot be modified or used by another tablespace. Dictionary data is protected by the same commit, rollback, and crash-recovery capabilities that protect user data ...