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/performance-schema-statement-digests.html
For each digest, a representative statement that produces the digest is stored as a sample. The copy of the normalized statement digest is stored in the appropriate Performance Schema tables, along with the SHA-256 hash value computed from the ...
https://dev.mysql.com/doc/refman/8.0/en/create-index.html
A key_part specification can end with ASC or DESC to specify whether index values are stored in ascending or descending order. Use of functional key parts enables indexing of values not stored directly in the table. Subqueries, parameters, ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-memcached-internals.html
caching: Use both InnoDB and the memcached engine as data stores. config_options Table The config_options table stores memcached-related settings that can be changed at runtime using SQL. For example, if you define col1, col2 as value columns, and ... InnoDB API for the InnoDB memcached Plugin The InnoDB memcached engine accesses InnoDB through InnoDB APIs, most of which are directly adopted from embedded ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-online-ddl-operations.html
The rows of an InnoDB table are stored in a clustered index organized based on the primary key, forming what some database systems call an “index-organized table”. Dropping a column default value ALTER TABLE tbl ALTER COLUMN col DROP DEFAULT, ...
https://dev.mysql.com/doc/refman/8.0/en/char.html
The CHAR and VARCHAR types are similar, but differ in the way they are stored and retrieved. The CHAR and VARCHAR types are declared with a length that indicates the maximum number of characters you want to store. When CHAR values are stored, they ...They also differ in maximum length and in whether trailing spaces are ...
https://dev.mysql.com/doc/refman/8.0/en/string-type-syntax.html
[NATIONAL] CHAR[(M)] [CHARACTER SET charset_name] [COLLATE collation_name] A fixed-length string that is always right-padded with spaces to the specified length when stored. MySQL stores VARCHAR values as a 1-byte or 2-byte length prefix plus data.
https://dev.mysql.com/doc/refman/8.0/en/diagnostics-area.html
The following example shows the effect of various statements on the diagnostics area, using SHOW WARNINGS to display information about conditions stored there. Diagnostics areas are pushed to and popped from the stack under the following ... SQL ...
https://dev.mysql.com/doc/refman/8.0/en/exists-and-not-exists-subqueries.html
If a subquery returns any rows at all, EXISTS subquery is TRUE, and NOT EXISTS subquery is FALSE. For example: SELECT column1 FROM t1 WHERE EXISTS (SELECT * FROM t2); Traditionally, an EXISTS subquery starts with SELECT *, but it could begin with ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-compression-internals.html
InnoDB Data Storage and Compression All user data in InnoDB tables is stored in pages comprising a B-tree index (the clustered index). The compression of B-tree nodes (of both clustered and secondary indexes) is handled differently from compression ... This section describes some internal implementation details about compression for InnoDB ...
https://dev.mysql.com/doc/refman/8.0/en/keyring-service.html
MySQL Server supports a keyring service that enables internal components and plugins to securely store sensitive information for later retrieval. This section describes how to use the keyring service functions to store, retrieve, and remove keys in ...MySQL distributions provide a keyring interface that is accessible at two levels: At the SQL level, as a set of loadable functions that each map onto calls to the service ...