PDF (US Ltr)
- 35.0Mb
PDF (A4)
- 35.1Mb
Man Pages (TGZ)
- 254.9Kb
Man Pages (Zip)
- 359.9Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/faqs-tablespace-encryption.html
Can indexed columns be encrypted? InnoDB data-at-rest encryption supports all indexes transparently. The master encryption key is generated when tablespace encryption is enabled, and is stored outside the database. The master encryption key is ...Is ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-programs-ndb-index-stat.html
The following options are used to generate and update the statistics tables in the NDB kernel. ndb_index_stat provides per-fragment statistical information about indexes on NDB tables. This includes cache version and age, number of index entries ...
https://dev.mysql.com/doc/refman/5.7/en/outer-join-optimization.html
If there is a row in A that matches the WHERE clause, but there is no row in B that matches the ON condition, an extra B row is generated with all columns set to NULL. For a LEFT JOIN, if the WHERE condition is always false for the generated NULL ...
https://dev.mysql.com/doc/refman/5.7/en/dynamic-format.html
Dynamic storage format is used if a MyISAM table contains any variable-length columns (VARCHAR, VARBINARY, BLOB, or TEXT), or if the table was created with the ROW_FORMAT=DYNAMIC table option. If you have fixed-length columns that you access or ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-information-schema-system-tables.html
INNODB_SYS_COLUMNS provides metadata about InnoDB table columns, equivalent to the information in the SYS_COLUMNS table in the InnoDB data dictionary. INNODB_SYS_FIELDS provides metadata about the key columns (fields) of InnoDB indexes, equivalent ... You can extract metadata about schema objects managed by InnoDB using InnoDB INFORMATION_SCHEMA system ...
https://dev.mysql.com/doc/refman/5.7/en/partitioning-overview.html
The SQL language itself is intended to work independently of any data structures or media underlying the schemas, tables, rows, or columns with which it works. This expression can be a column value, a function acting on one or more column values, or ... This section provides a conceptual overview of partitioning in MySQL ...
https://dev.mysql.com/doc/refman/5.7/en/replication-features-auto-increment.html
Statement-based replication of AUTO_INCREMENT, LAST_INSERT_ID(), and TIMESTAMP values is done correctly, subject to the following exceptions: When using statement-based replication prior to MySQL 5.7.1, AUTO_INCREMENT columns in tables on the ...
https://dev.mysql.com/doc/refman/5.7/en/constraint-invalid-data.html
For strings, MySQL stores either the empty string or as much of the string as can be stored in the column. If you try to store a string that does not start with a number into a numeric column, MySQL Server stores 0. Invalid values for ENUM and SET ... MySQL 5.7.5 and later uses strict SQL mode by default, which treats invalid values such that the server rejects them and aborts the statement in which they occur (see Section 5.1.10, “Server SQL ...
https://dev.mysql.com/doc/refman/5.7/en/data-type-defaults.html
Explicit Default Handling Implicit Default Handling Explicit Default Handling A DEFAULT value clause in a data type specification explicitly indicates a default value for a column. In the definition of an integer column, it is an alias for NOT NULL ... Data type specifications can have explicit or implicit default ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-introduction.html
INFORMATION_SCHEMA provides access to database metadata, information about the MySQL server such as the name of a database or table, the data type of a column, or access privileges. Character Set Considerations The definition for character columns ...Other terms that are sometimes used for this information are data dictionary and system ...