PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.2Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/partitioning-maintenance.html
Example: ALTER TABLE t1 REPAIR PARTITION p0,p1; Normally, REPAIR PARTITION fails when the partition contains duplicate key errors. In MySQL 5.7.2 and later, you can use ALTER IGNORE TABLE with this option, in which case all rows that cannot be moved ... A number of table and partition maintenance tasks can be carried out using SQL statements intended for such purposes on partitioned tables in MySQL ...
https://dev.mysql.com/doc/refman/5.7/en/built-in-function-reference.html
The following table lists each built-in (native) function and operator and provides a short description of each one. For a table listing functions that are loadable at runtime, see Section 12.2, “Loadable Function Reference”. ->> Return value ...
https://dev.mysql.com/doc/refman/5.7/en/cost-model.html
The primary key for the server_cost table is the cost_name column, so it is not possible to create multiple entries for any cost estimate. Increasing this value causes a query plan that compares many keys to become more expensive. The primary key ...
https://dev.mysql.com/doc/refman/5.7/en/encrypted-connection-protocols-ciphers.html
The negotiation process depends on factors such as the SSL library used to compile the server and client, the TLS protocol and encryption cipher configuration, and which key size is used: For a connection attempt to succeed, the server and client ...
https://dev.mysql.com/doc/refman/5.7/en/explain-extended.html
That syntax is still recognized for backward compatibility but extended output is now enabled by default, so the EXTENDED keyword is superfluous and deprecated. row *************************** id: 1 select_type: PRIMARY table: t1 type: index ... For ...
https://dev.mysql.com/doc/refman/5.7/en/flush.html
To suppress logging, specify the optional NO_WRITE_TO_BINLOG keyword or its alias LOCAL. FLUSH DES_KEY_FILE Reloads the DES keys from the file that was specified with the --des-key-file option at server startup time. Consequently, --des-key-file and ...| table_synonym WITH READ LOCK | table_synonym tbl_name [, tbl_name] ...
https://dev.mysql.com/doc/refman/5.7/en/index-hints.html
index_hint: USE {INDEX|KEY} [FOR {JOIN|ORDER BY|GROUP BY}] ([index_list]) | {IGNORE|FORCE} {INDEX|KEY} [FOR {JOIN|ORDER BY|GROUP BY}] (index_list) index_list: index_name [, index_name] ... row *************************** id: 1 select_type: DELETE ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-innodb-ft-config-table.html
The INNODB_FT_CONFIG table has these columns: KEY The name designating an item of metadata for an InnoDB table containing a FULLTEXT index. The key names and their meanings include: optimize_checkpoint_limit: The number of seconds after which an ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-compression-syntax-warnings.html
SQL Compression Syntax Warnings and Errors for File-Per-Table Tablespaces When innodb_strict_mode is enabled (the default), specifying ROW_FORMAT=COMPRESSED or KEY_BLOCK_SIZE in CREATE TABLE or ALTER TABLE statements produces the following error if ... This section describes syntax warnings and errors that you may encounter when using the table compression feature with file-per-table tablespaces and general ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-fulltext-index.html
mysql> CREATE TABLE opening_lines ( FTS_DOC_ID BIGINT UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY, opening_line TEXT(500), author VARCHAR(200), title VARCHAR(200) ) ENGINE=InnoDB; If you choose to define the FTS_DOC_ID column yourself, you are ...