Search Results
https://dev.mysql.com/doc/refman/8.4/en/fulltext-restrictions.html
Full-text searches are supported for InnoDB and MyISAM tables only. The exception is that for Unicode, the utf8mb3 or utf8mb4 character set can be used, but not the ucs2 character set. Although FULLTEXT indexes on ucs2 columns cannot be used, you ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-background.html
Moreover, as servers are cooperating together to create the group several other classic distributed systems problems have to be dealt with, such as network partitioning or split brain scenarios. If there is a network partition, resulting in a split ...The most common way to create a fault-tolerant system is to resort to making components redundant, in other words the component can be removed and the system should continue to operate as ...
https://dev.mysql.com/doc/refman/8.4/en/hash-joins.html
row *************************** id: 1 select_type: SIMPLE table: t1 partitions: NULL type: ALL possible_keys: NULL key: NULL key_len: NULL ref: NULL rows: 1 filtered: 100.00 Extra: NULL *************************** 2. row *************************** ...It is possible to control whether hash joins are employed using one of the BNL and NO_BNL optimizer hints, or by setting block_nested_loop=on or block_nested_loop=off as part of the setting for the optimizer_switch server system ...
https://dev.mysql.com/doc/refman/8.4/en/identifier-case-sensitivity.html
The following statement would not work because it refers to a table both as my_table and as MY_TABLE: mysql> SELECT * FROM my_table WHERE MY_TABLE.col=1; Partition, subpartition, column, index, stored routine, event, and resource group names are not ... In MySQL, databases correspond to directories within the data ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-general-table-reference.html
The following table summarizes INFORMATION_SCHEMA general tables. For greater detail, see the individual table descriptions. Table 28.2 INFORMATION_SCHEMA General Tables Table Name Description ADMINISTRABLE_ROLE_AUTHORIZATIONS Grantable users or ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-table-reference.html
The following table summarizes all available INFORMATION_SCHEMA tables. For greater detail, see the individual table descriptions. Table 28.1 INFORMATION_SCHEMA Tables Table Name Description Deprecated ADMINISTRABLE_ROLE_AUTHORIZATIONS Grantable ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-fulltext-index.html
The words are fully sorted and partitioned among the six index tables based on the character set sort weight of the word's first character. The inverted index is partitioned into six auxiliary index tables to support parallel index creation.
https://dev.mysql.com/doc/refman/8.4/en/invisible-indexes.html
row *************************** id: 1 select_type: SIMPLE table: t1 partitions: NULL type: range possible_keys: j_idx key: j_idx key_len: 5 ref: NULL rows: 2 filtered: 100.00 Extra: Using index condition mysql> EXPLAIN SELECT i, j FROM t1 WHERE j >= ... MySQL supports invisible indexes; that is, indexes that are not used by the ...
https://dev.mysql.com/doc/refman/8.4/en/limit-optimization.html
row *************************** id: 1 select_type: SIMPLE table: t partitions: NULL type: range possible_keys: i key: i key_len: 8 ref: NULL rows: 14 filtered: 100.00 Extra: Using index condition; Using filesort See also Section 10.9.2, ... If you ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-data-node-memory-management.html
All memory allocation for a data node is performed when the node is started. This ensures that the data node can run in a stable manner without using swap memory, so that NDB can be used for latency-sensitive (realtime) applications. The reserved ...