Search Results
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/partitioning-list.html
Note In MySQL 8.4, it is possible to match against only a list of integers (and possibly NULL—see Section 26.2.7, “How MySQL Partitioning Handles NULL”) when partitioning by LIST. List partitioning in MySQL is similar to range partitioning in ...
https://dev.mysql.com/doc/refman/8.4/en/keyring-functions-general-purpose.html
If the key cannot be created, the return value is NULL and an error occurs. mysql> SELECT @x; +------+ | @x | +------+ | NULL | +------+ mysql> SELECT keyring_key_generate('x', 'AES', 16) INTO @x; mysql> SELECT @x; +------+ | @x | +------+ | 1 | ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-functions.html
mysql> SELECT PS_CURRENT_THREAD_ID(); +------------------------+ | PS_CURRENT_THREAD_ID() | +------------------------+ | 52 | +------------------------+ mysql> SELECT PS_THREAD_ID(CONNECTION_ID()); +-------------------------------+ | ... MySQL ...
https://dev.mysql.com/doc/heatwave/en/mys-hwgenai-hw-chat.html
Default value is NULL report_progress: specifies whether information such as routine progress detail is to be reported. The HEATWAVE_CHAT routine automatically calls the ML_RAG routine which loads an LLM and runs a semantic search on the available ...
https://dev.mysql.com/doc/mysql-ai/9.4/en/mys-mysqlai-chat.html
Default value is NULL report_progress: specifies whether information such as routine progress detail is to be reported. The HEATWAVE_CHAT routine automatically calls the ML_RAG routine which loads an LLM and runs a semantic search on the available ...
https://dev.mysql.com/doc/refman/8.4/en/column-count-limit.html
mysql> CREATE TABLE t2 (c1 VARCHAR(65533) NOT NULL) ENGINE = InnoDB CHARACTER SET latin1; Query OK, 0 rows affected (0.01 sec) For MyISAM tables, NULL columns require additional space in the row to record whether their values are NULL. Each NULL ...
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/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/performance-schema-quick-start.html
row *************************** Table: setup_consumers Create Table: CREATE TABLE `setup_consumers` ( `NAME` varchar(64) NOT NULL, `ENABLED` enum('YES','NO') NOT NULL, PRIMARY KEY (`NAME`) ) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8mb4 ... This ...