PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.3Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/fulltext-search-mecab.html
To address this limitation for Japanese, MySQL provides a MeCab full-text parser plugin. In addition to tokenizing text into meaningful words, MeCab indexes are typically smaller than ngram indexes, and MeCab full-text searches are generally faster.
https://dev.mysql.com/doc/refman/5.7/en/charset-collation-information-schema.html
However, for values that correspond to objects that are represented in the file system, such as databases and tables, searches in INFORMATION_SCHEMA string columns can be case-sensitive or case-insensitive, depending on the characteristics of the ...
https://dev.mysql.com/doc/refman/5.7/en/case-sensitivity.html
This means that if you search with col_name LIKE 'a%', you get all column values that start with A or a. To make this search case-sensitive, make sure that one of the operands has a case-sensitive or binary collation. For nonbinary strings (CHAR, ...A comparison between a nonbinary string and binary string is treated as a comparison of binary ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-parameters.html
For example: SET GLOBAL innodb_ft_aux_table = 'test/t1'; After you set this variable to a name in the format db_name/table_name, the INFORMATION_SCHEMA tables INNODB_FT_INDEX_TABLE, INNODB_FT_INDEX_CACHE, INNODB_FT_CONFIG, INNODB_FT_DELETED, and ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-system-variables.html
Performance Schema system variables have the following meanings: performance_schema Command-Line Format --performance-schema[={OFF|ON}] System Variable performance_schema Scope Global Dynamic No Type Boolean Default Value ON The value of this ...The ...
https://dev.mysql.com/doc/refman/5.7/en/faqs-cjk.html
This set of Frequently Asked Questions derives from the experience of MySQL's Support and Development groups in handling many inquiries about CJK (Chinese-Japanese-Korean) issues. Why do some LIKE and FULLTEXT searches with CJK characters fail? ...
https://dev.mysql.com/doc/refman/5.7/en/explain-output.html
ref_or_null This join type is like ref, but with the addition that MySQL does an extra search for rows that contain NULL values. This means that MySQL reads a row from the first table, and then finds a matching row in the second table, the third ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-locks-set.html
If a secondary index is used in a search and the index record locks to be set are exclusive, InnoDB also retrieves the corresponding clustered index records and sets locks on them. For SERIALIZABLE level, the search sets shared next-key locks on the ... A locking read, an UPDATE, or a DELETE generally set record locks on every index record that is scanned in the processing of an SQL ...
https://dev.mysql.com/doc/refman/5.7/en/manual-info.html
This is the Reference Manual for the MySQL Database System, version 5.7, through release 5.7.44. This manual is not intended for use with older versions of the MySQL software due to the many functional and other differences between MySQL 5.7 and ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-memcached-internals.html
In this case, if memcached cannot find a key in memory, it searches for the value in an InnoDB table. Because the InnoDB memcached plugin is tightly integrated with a single memcached daemon, and the in-memory caching mechanism is handled by MySQL ... InnoDB API for the InnoDB memcached Plugin The InnoDB memcached engine accesses InnoDB through InnoDB APIs, most of which are directly adopted from embedded ...