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/sys-schema-tables-with-full-table-scans.html
These views display which tables are being accessed with full table scans. The schema_tables_with_full_table_scans and x$schema_tables_with_full_table_scans views have these columns: object_schema The schema name. rows_full_scanned The total number ...
https://dev.mysql.com/doc/refman/5.7/en/sys-statements-with-full-table-scans.html
These views display normalized statements that have done full table scans. By default, rows are sorted by descending percentage of time a full scan was done and descending total latency. The statements_with_full_table_scans and ...db The default ...
https://dev.mysql.com/doc/refman/5.7/en/table-scan-avoidance.html
The output from EXPLAIN shows ALL in the type column when MySQL uses a full table scan to resolve a query. This usually happens under the following conditions: The table is so small that it is faster to perform a table scan than to bother with a ...
https://dev.mysql.com/doc/refman/5.7/en/create-table.html
| {FULLTEXT | SPATIAL} [INDEX | KEY] [index_name] (key_part,...) [index_option] ... FULLTEXT A FULLTEXT index is a special type of index used for full-text searches. A WITH PARSER clause can be specified as an index_option value to associate a ...| ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-batch-commands.html
To do so, create a text file text_file that contains the statements you wish to execute. The mysql client typically is used interactively, like this: mysql db_name However, it is also possible to put your SQL statements in a file and then tell ...
https://dev.mysql.com/doc/refman/5.7/en/server-system-variables.html
ft_boolean_syntax Command-Line Format --ft-boolean-syntax=name System Variable ft_boolean_syntax Scope Global Dynamic Yes Type String Default Value + -><()~*:""&| The list of operators supported by boolean full-text searches performed using IN ...A ... The MySQL server maintains many system variables that affect its ...
https://dev.mysql.com/doc/refman/5.7/en/create-index.html
CREATE [UNIQUE | FULLTEXT | SPATIAL] INDEX index_name [index_type] ON tbl_name (key_part,...) [index_option] [algorithm_option | lock_option] ... Full-Text Indexes FULLTEXT indexes are supported only for InnoDB and MyISAM tables and can include ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-nutshell.html
MySQL provides a built-in full-text ngram parser plugin that supports Chinese, Japanese, and Korean (CJK), and an installable MeCab full-text parser plugin for Japanese. For more information, see Section 12.9.8, “ngram Full-Text Parser”, and ...
https://dev.mysql.com/doc/refman/5.7/en/xml-functions.html
This also means the user is fully responsible for any typographical errors, since no warnings are given if (for example) $@myvairable is used where $@myvariable was intended. (Bug #32911) ExtractValue(xml_frag, xpath_expr) ExtractValue() takes two ... Table 12.16 XML Functions Name Description ExtractValue() Extract a value from an XML string using XPath notation UpdateXML() Return replaced XML fragment This section discusses XML and related functionality in ...
https://dev.mysql.com/doc/refman/5.7/en/column-indexes.html
Index Prefixes FULLTEXT Indexes Spatial Indexes Indexes in the MEMORY Storage Engine Index Prefixes With col_name(N) syntax in an index specification for a string column, you can create an index that uses only the first N characters of the column.