Search Results
https://dev.mysql.com/doc/refman/8.4/en/information-schema-innodb-trx-table.html
When the adaptive hash index search system is partitioned, a single transaction does not lock the entire adaptive hash index. Adaptive hash index partitioning is controlled by innodb_adaptive_hash_index_parts, which is set to 8 by default. When the ... The INNODB_TRX table provides information about every transaction currently executing inside InnoDB, including whether the transaction is waiting for a lock, when the transaction started, and the SQL statement the transaction is executing, if ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-optimization.html
row *************************** id: 1 select_type: SIMPLE table: cs partitions: NULL type: const possible_keys: PRIMARY,name key: name key_len: 194 ref: const rows: 1 filtered: 100.00 Extra: Using index *************************** 2. row ...
https://dev.mysql.com/doc/refman/8.4/en/json-search-functions.html
row *************************** id: 1 select_type: SIMPLE table: jemp partitions: NULL type: range possible_keys: i key: i key_len: 5 ref: NULL rows: 2 filtered: 100.00 Extra: Using where 1 row in set, 1 warning (0.00 sec) mysql> SHOW WARNINGS\G ...
https://dev.mysql.com/doc/refman/8.4/en/keywords.html
Certain keywords, such as SELECT, DELETE, or BIGINT, are reserved and require special treatment for use as identifiers such as table and column names. This may also be true for the names of built-in functions. Some keywords which are otherwise ...
https://dev.mysql.com/doc/refman/8.4/en/merge-storage-engine.html
An alternative to a MERGE table is a partitioned table, which stores partitions of a single table in separate files and enables some operations to be performed more efficiently. The MERGE storage engine, also known as the MRG_MyISAM engine, is a ...
https://dev.mysql.com/doc/refman/8.4/en/merge-table-problems.html
That is, you cannot partition a MERGE table, nor can any of a MERGE table's underlying MyISAM tables be partitioned. The following are known problems with MERGE tables: MERGE child tables are locked through the parent table. If the parent is a ...
https://dev.mysql.com/doc/refman/8.4/en/myisam-storage-engine.html
In MySQL 8.4, the MyISAM storage engine provides no partitioning support. Partitioned MyISAM tables created in previous versions of MySQL cannot be used in MySQL 8.4. For more information, see Section 26.6.2, “Partitioning Limitations Relating to ... MyISAM is based on the older (and no longer available) ISAM storage engine but has many useful ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-basics.html
There are as many data nodes as there are fragment replicas, times the number of fragments (see Section 25.2.2, “NDB Cluster Nodes, Node Groups, Fragment Replicas, and Partitions”). For a brief introduction to the relationships between nodes, ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-log-events.html
An event report reported in the event logs has the following format: datetime [string] severity -- message For example: 09:19:30 2005-07-24 [NDB] INFO -- Node 4 Start phase 4 completed This section discusses all reportable events, ordered by ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-log-startup-messages.html
Possible startup messages with descriptions are provided in the following list: Initial start, waiting for %s to connect, nodes [ all: %s connected: %s no-wait: %s ] Waiting until nodes: %s connects, nodes [ all: %s connected: %s no-wait: %s ] ...