PDF (US Ltr)
- 43.2Mb
PDF (A4)
- 43.3Mb
Man Pages (TGZ)
- 296.3Kb
Man Pages (Zip)
- 401.7Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/charset-unicode-ucs2.html
For example: LATIN CAPITAL LETTER A has the code 0x0041 and it is stored as a 2-byte sequence: 0x00 0x41. CYRILLIC SMALL LETTER YERU (Unicode 0x044B) is stored as a 2-byte sequence: 0x04 0x4B. Note The ucs2 character set is deprecated in MySQL ...
https://dev.mysql.com/doc/refman/8.0/en/charset-unicode-utf8mb4.html
For a supplementary character, utf8mb4 requires four bytes to store it, whereas utf8mb3 cannot store the character at all. The utf8mb4 character set has these characteristics: Supports BMP and supplementary characters. utf8mb4 contrasts with the ...
https://dev.mysql.com/doc/refman/8.0/en/clone-plugin-limitations.html
MyISAM and CSV tables stored in any schema including the sys schema are cloned as empty tables. The clone plugin is subject to these limitations: An instance cannot be cloned from a different MySQL server series. For example, you cannot clone ...
https://dev.mysql.com/doc/refman/8.0/en/connection-access.html
Nonblank password values stored in the authentication_string column of the user table are encrypted. MySQL does not store passwords as cleartext for anyone to see. When you attempt to connect to a MySQL server, the server accepts or rejects the ...
https://dev.mysql.com/doc/refman/8.0/en/create-table-files.html
For an InnoDB table created in a file-per-table tablespace or general tablespace, table data and associated indexes are stored in a .ibd file in the database directory. When an InnoDB table is created in the system tablespace, table data and ...The ...
https://dev.mysql.com/doc/refman/8.0/en/creating-spatial-indexes.html
To drop spatial indexes, use ALTER TABLE or DROP INDEX: With ALTER TABLE: ALTER TABLE geom DROP INDEX g; With DROP INDEX: DROP INDEX g ON geom; Example: Suppose that a table geom contains more than 32,000 geometries, which are stored in the column g ... For InnoDB and MyISAM tables, MySQL can create spatial indexes using syntax similar to that for creating regular indexes, but using the SPATIAL ...
https://dev.mysql.com/doc/refman/8.0/en/data-dictionary-transactional-storage.html
The data dictionary schema stores dictionary data in transactional (InnoDB) tables. Dictionary data is protected by the same commit, rollback, and crash-recovery capabilities that protect user data that is stored in InnoDB tables. Data dictionary ...
https://dev.mysql.com/doc/refman/8.0/en/ddl-rewriter.html
The plugin removes ENCRYPTION, DATA DIRECTORY, and INDEX DIRECTORY clauses, which may be helpful when restoring tables from SQL dump files created from databases that are encrypted or that have their tables stored outside the data directory. MySQL ...
https://dev.mysql.com/doc/refman/8.0/en/derived-tables.html
This can occur if the outer query accesses any tables and an inner query invokes a stored function that changes one or more rows of a table. For information about lateral derived tables preceded by the LATERAL keyword, see Section 15.2.15.9, ...
https://dev.mysql.com/doc/refman/8.0/en/disk-issues.html
For example, store semi-important data that can be regenerated on a RAID 0 disk, but store really important data such as host information and logs on a RAID 0+1 or RAID N disk. This section describes ways to configure storage devices when you can ...