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/index-condition-pushdown-optimization.html
Applicability of the Index Condition Pushdown optimization is subject to these conditions: ICP is used for the range, ref, eq_ref, and ref_or_null access methods when there is a need to access full table rows. The goal of ICP is to reduce the number ... Index Condition Pushdown (ICP) is an optimization for the case where MySQL retrieves rows from a table using an ...
https://dev.mysql.com/doc/refman/5.7/en/alter-table.html
| ADD {FULLTEXT | SPATIAL} [INDEX | KEY] [index_name] (key_part,...) [index_option] ... TABLESPACE operations always cause a full table rebuild, even if the TABLESPACE attribute has not changed from its previous value. Changing the Character Set To ... ALTER TABLE tbl_name [alter_option [, alter_option] ...] [partition_options] alter_option: { table_options | ADD [COLUMN] col_name column_definition [FIRST | AFTER col_name] | ADD [COLUMN] (col_name column_definition,...) | ADD {INDEX | KEY} [index_name] [index_type] (key_part,...) [index_option] ...
https://dev.mysql.com/doc/refman/5.7/en/replication-options-binary-log.html
noblob: Log all columns (same as full), except for BLOB and TEXT columns that are not required to identify rows, or that have not changed. Prior to MySQL 5.7.2, this option caused any statements containing fully qualified table names not to be ...
https://dev.mysql.com/doc/refman/5.7/en/load-data.html
For a LOCAL load operation, the client program reads a text file located on the client host. If none of REPLACE, IGNORE, or LOCAL is specified, an error occurs when a duplicate key value is found, and the rest of the text file is ignored. See the ...
https://dev.mysql.com/doc/refman/5.7/en/explain-output.html
In the following examples, MySQL can use a ref join to process ref_table: SELECT * FROM ref_table WHERE key_column=expr; SELECT * FROM ref_table,other_table WHERE ref_table.key_column=other_table.column; SELECT * FROM ref_table,other_table WHERE ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-programs-ndb-mgmd.html
Care should also be taken if you intend to use any other ndb_mgmd options that affect the starting of the management server, and you should make absolutely certain you fully understand and allow for any possible consequences of doing so. Do not ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-innodb-ft-being-deleted-table.html
For information about running OPTIMIZE TABLE on tables with FULLTEXT indexes, see Section 12.9.6, “Fine-Tuning MySQL Full-Text Search”. Before querying it, set the value of the innodb_ft_aux_table system variable to the name (including the ...
https://dev.mysql.com/doc/refman/5.7/en/dba-dtrace-mysqld-ref.html
The arguments are: query: The full text of the submitted query. The single argument, query, is a string containing the full text of the original query. The arguments are: query: The full text of the submitted query. The status argument contains 0 if ... MySQL supports the following static probes, organized into groups of ...
https://dev.mysql.com/doc/refman/5.7/en/server-options.html
For a brief summary, execute this command: mysqld --help To see the full list, use this command: mysqld --verbose --help Some of the items in the list are actually system variables that can be set at server startup. Section 5.1.7, “Server System ... When you start the mysqld server, you can specify program options using any of the methods described in Section 4.2.2, “Specifying Program ...
https://dev.mysql.com/doc/refman/5.7/en/sorted-index-builds.html
Sorted Index Builds and Full-Text Index Support Sorted index builds are supported for fulltext indexes. Previously, SQL was used to insert entries into a fulltext index. When the sort buffer becomes full, entries are sorted and written out to a ...