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/fulltext-search-ngram.html
Note MySQL also provides a MeCab full-text parser plugin for Japanese, which tokenizes documents into meaningful words. The ngram parser tokenizes a sequence of text into a contiguous sequence of n characters. For example, with a token size of 2, ...
https://dev.mysql.com/doc/refman/5.7/en/fulltext-stopwords.html
The stopword list is loaded and searched for full-text queries using the server character set and collation (the values of the character_set_server and collation_server system variables). False hits or misses might occur for stopword lookups if the ...
https://dev.mysql.com/doc/refman/5.7/en/index-extensions.html
The optimizer takes into account the primary key columns of the extended secondary index when determining how and whether to use that index. row *************************** id: 1 select_type: SIMPLE table: t1 type: ref possible_keys: PRIMARY,k_d ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-file-space.html
The pages are grouped into extents of size 1MB for pages up to 16KB in size (64 consecutive 16KB pages, or 128 8KB pages, or 256 4KB pages). External off-page storage for variable-length columns differs by row format: COMPACT and REDUNDANT Row ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-information-schema-metrics-table.html
row *************************** NAME: dml_inserts SUBSYSTEM: dml COUNT: 0 MAX_COUNT: 0 MIN_COUNT: NULL AVG_COUNT: 0 COUNT_RESET: 0 MAX_COUNT_RESET: 0 MIN_COUNT_RESET: NULL AVG_COUNT_RESET: NULL TIME_ENABLED: 2014-12-04 14:18:28 TIME_DISABLED: NULL ... The INNODB_METRICS table provides information about InnoDB performance and resource-related ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-memcached-benefits.html
InnoDB can handle composing and decomposing multiple column values into a single memcached item value, reducing the amount of string parsing and concatenation required in your application. The serialization features of memcached, which can turn ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-transaction-isolation-levels.html
For other search conditions, InnoDB locks the index range scanned, using gap locks or next-key locks to block insertions by other sessions into the gaps covered by the range. Because gap locking is disabled, phantom row problems may occur, as other ... Transaction isolation is one of the foundations of database ...
https://dev.mysql.com/doc/refman/5.7/en/installing-source-distribution.html
Obtain and Unpack the Distribution Pick the directory under which you want to unpack the distribution and change location into it. Configure the Distribution Change location into the top-level directory of the unpacked distribution: $> cd ... To ...
https://dev.mysql.com/doc/refman/5.7/en/local-variable-scope.html
INTO statement, contains a reference to a column and a declared local variable with the same name, MySQL currently interprets the reference as the name of a variable. The scope of a local variable is the BEGIN ... The variable can be referred to in ...
https://dev.mysql.com/doc/refman/5.7/en/lock-tables.html
This occurs because t2 is inserted into within the trigger, so the READ request is converted to a WRITE request. LOCK {TABLE | TABLES} tbl_name [[AS] alias] lock_type [, tbl_name [[AS] alias] lock_type] ... lock_type: { READ [LOCAL] | ...