https://dev.mysql.com/fulltext-search-mecab.html
The MeCab full-text parser plugin is a full-text parser plugin for Japanese that tokenizes a sequence of text into meaningful words. For example, MeCab tokenizes “データベース管理” (“Database Management”) into ... The built-in MySQL ...
https://dev.mysql.com/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/group-by-modifiers.html
The NULL values do appear as NULL on the client side and can be tested as such using any MySQL client programming interface. However, at this point, you cannot distinguish whether a NULL represents a regular grouped value or a super-aggregate value.
https://dev.mysql.com/group-replication-adding-instances.html
At this point, the group has one member in it, server s1, which has some data in it. At this point server s2 only needs to be added to the already existing group. Once this process completed, s2 could join the group as a member, and at this point ...It is now time to expand the group by adding the other two servers configured ...
https://dev.mysql.com/group-replication-bootstrap.html
mysql> CREATE DATABASE test; mysql> USE test; mysql> CREATE TABLE t1 (c1 INT PRIMARY KEY, c2 TEXT NOT NULL); mysql> INSERT INTO t1 VALUES (1, 'Luis'); Check the content of table t1 and the binary log. Also, the data was inserted into the table and ... The process of starting a group for the first time is called ...
https://dev.mysql.com/identifier-qualifiers.html
An unqualified name is permitted in contexts where interpretation of the name is unambiguous. A qualified name includes at least one qualifier to clarify the interpretive context by overriding a default context or providing missing context. For ...
https://dev.mysql.com/index-extensions.html
Consider this table definition: CREATE TABLE t1 ( i1 INT NOT NULL DEFAULT 0, i2 INT NOT NULL DEFAULT 0, d DATE DEFAULT NULL, PRIMARY KEY (i1, i2), INDEX k_d (d) ) ENGINE = InnoDB; This table defines the primary key on columns (i1, i2). It also ...
https://dev.mysql.com/innodb-columns-table.html
1 = VARCHAR, 2 = CHAR, 3 = FIXBINARY, 4 = BINARY, 5 = BLOB, 6 = INT, 7 = SYS_CHILD, 8 = SYS, 9 = FLOAT, 10 = DOUBLE, 11 = DECIMAL, 12 = VARMYSQL, 13 = MYSQL, 14 = GEOMETRY. LEN The column length, for example 4 for INT and 8 for BIGINT. An explicitly ...For related usage information and examples, see Section 15.15.3, “InnoDB INFORMATION_SCHEMA Schema Object ...
https://dev.mysql.com/innodb-compression-usage.html
The system tablespace (space 0, the .ibdata files) can contain user-created tables, but it also contains internal system data, which is never compressed. The KEY_BLOCK_SIZE value is treated as a hint; a different size could be used by InnoDB if ...
https://dev.mysql.com/innodb-information-schema-temp-table-info.html
It does not provide information about internal InnoDB temporary tables used by the optimizer. Create a simple InnoDB temporary table: mysql> CREATE TEMPORARY TABLE t1 (c1 INT PRIMARY KEY) ENGINE=INNODB; Query INNODB_TEMP_TABLE_INFO to view the ...
