PDF (US Ltr)
- 35.0Mb
PDF (A4)
- 35.1Mb
Man Pages (TGZ)
- 254.9Kb
Man Pages (Zip)
- 359.9Kb
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/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/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/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/mysql-cluster-log-statistics.html
This is the number transactions started in the last interval using this TC as the transaction coordinator. This is the number of transactions using this TC as the transaction coordinator that were committed in the last reporting interval. Because ...
https://dev.mysql.com/doc/refman/5.7/en/myisamchk-table-info.html
The output from these commands is explained later in this section. This operation is slow because it must read the entire table. myisamchk -eiv tbl_name This is like -eis, but tells you what is being done. Auto increment key, Last value The key ...
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 ...