Search

Download this Manual
PDF (US Ltr) - 43.2Mb
PDF (A4) - 43.3Mb
Man Pages (TGZ) - 295.2Kb
Man Pages (Zip) - 400.4Kb
Info (Gzip) - 4.3Mb
Info (Zip) - 4.3Mb


Displaying 161 to 170 of 1145 total results
https://dev.mysql.com/doc/refman/8.0/en/replication-binlog-encryption-encryption-keys.html
The keyring service handles the creation, retrieval, and deletion of the binary log encryption keys. A server instance only creates and removes keys generated for itself, but it can read keys generated for other instances if they are stored in the ... The binary log encryption keys used to encrypt the file passwords for the log files are 256-bit keys that are generated specifically for each MySQL server instance using MySQL Server's keyring service (see Section 8.4.4, “The MySQL ...
https://dev.mysql.com/doc/refman/8.0/en/string-comparison-functions.html
If the NO_BACKSLASH_ESCAPES SQL mode is enabled, the sequence cannot be empty. For example, consider the following table and data: CREATE TABLE foo (bar VARCHAR(10)); INSERT INTO foo VALUES (NULL), (NULL); The query SELECT COUNT(*) FROM foo WHERE ...
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/component-loading.html
For subsequent server restarts, the loader service loads any components listed in mysql.component during the startup sequence. The loader service also unregisters the components from the mysql.component system table so that the server no longer ...
https://dev.mysql.com/doc/refman/8.0/en/faqs-general.html
Why did MySQL version numbering skip versions 6 and 7 and go straight to 8.0? A.1.3. Does MySQL have a NOW() function with fractions of seconds? A.1.7. Which version of MySQL is production-ready (GA)? MySQL 9.6, 8.4, and 8.0 are actively supported ...
https://dev.mysql.com/doc/refman/8.0/en/gis-data-formats.html
For example, a WKB value that corresponds to POINT(1 -1) consists of this sequence of 21 bytes, each represented by two hexadecimal digits: 0101000000000000000000F03F000000000000F0BF The sequence consists of the components shown in the following ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-innodb-buffer-page-lru-table.html
The INNODB_BUFFER_PAGE_LRU table provides information about the pages in the InnoDB buffer pool; in particular, how they are ordered in the LRU list that determines which pages to evict from the buffer pool when it becomes full. The ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-innodb-buffer-page-table.html
The INNODB_BUFFER_PAGE table provides information about each page in the InnoDB buffer pool. For related usage information and examples, see Section 17.15.5, “InnoDB INFORMATION_SCHEMA Buffer Pool Tables”. Do not query this table on a ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-innodb-columns-table.html
When a column is dropped, the remaining columns are reordered so that the sequence has no gaps. The POS value for a virtual generated column encodes the column sequence number and ordinal position of the column. For related usage information and ...
https://dev.mysql.com/doc/refman/8.0/en/keyring-plugin-installation.html
A keyring component or plugin must be loaded early during the server startup sequence so that other components can access it as necessary during their own initialization. However, keyring plugins loaded using those methods may be available too late ... Keyring service consumers require that a keyring component or plugin be installed: To use a keyring plugin, begin with the instructions ...
Displaying 161 to 170 of 1145 total results