PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 255.8Kb
Man Pages (Zip)
- 360.8Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/added-deprecated-removed.html
group_replication_auto_increment_increment: Determines interval between successive column values for transactions executing on this server. innodb_log_checksum_algorithm: Specifies how to generate and verify checksum stored in each redo log disk ...
https://dev.mysql.com/doc/refman/5.7/en/mysqlpump.html
--complete-insert Command-Line Format --complete-insert Write complete INSERT statements that include column names. The output generated by using --events contains CREATE EVENT statements to create the events. --hex-blob Command-Line Format ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-ndbinfo.html
With the exception of the blocks and config_params tables, what we refer to as ndbinfo “tables” are actually views generated from internal NDB tables not normally visible to the MySQL Server. All ndbinfo tables are read-only, and are generated ... ndbinfo is a database containing information specific to NDB ...
https://dev.mysql.com/doc/refman/5.7/en/migrating-from-year2.html
This section describes problems that can occur when using the 2-digit YEAR(2) data type and provides information about converting existing YEAR(2) columns to 4-digit year-valued columns, which can be declared as YEAR with an implicit display width ...Although the internal range of values for YEAR/YEAR(4) and the deprecated YEAR(2) type is the same (1901 to 2155, and 0000), the display width for YEAR(2) makes that type inherently ambiguous because displayed values indicate only the last two digits of the internal values and omit the century ...
https://dev.mysql.com/doc/refman/5.7/en/show-warnings.html
Warnings are generated for DML statements such as INSERT, UPDATE, and LOAD DATA as well as DDL statements such as CREATE TABLE and ALTER TABLE. SHOW WARNINGS is also used following EXPLAIN, to display the extended information generated by EXPLAIN.
https://dev.mysql.com/doc/refman/5.7/en/alter-table-examples.html
For NDB tables, it is also possible to change the storage type used for a table or column. row *************************** Table: t1 Create Table: CREATE TABLE `t2` ( `c1` int(11) DEFAULT NULL ) /*!50100 TABLESPACE ts_1 STORAGE DISK */ ...For MyISAM ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-fulltext-index.html
Full-text indexes are created on text-based columns (CHAR, VARCHAR, or TEXT columns) to speed up queries and DML operations on data contained within those columns. When a full-text index is dropped, the FTS_DOC_ID column that was created for the ...
https://dev.mysql.com/doc/refman/5.7/en/optimize-character.html
The GROUP BY and ORDER BY clauses can generate temporary tables, and these temporary tables can use the MEMORY storage engine if the original table does not contain any BLOB columns. For character and string columns, follow these guidelines: Use ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-data-encryption.html
keyring_aws: Communicates with the Amazon Web Services Key Management Service (AWS KMS) as a back end for key generation and uses a local file for key storage. Exporting Encrypted Tablespaces When an encrypted tablespace is exported, InnoDB ...About ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-compression-internals.html
Each row in the index node contains the values of the (user-specified or system-generated) primary key and all the other columns of the table. The pointer is in fact the value of the primary key of the table, which is used to access the clustered ...