Search Results
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-training-a-forecasting-model.html
Therefore, the predict table must not overlap the datetime_index with the training table. The start date in the predict table must be a date immediately following the last date in the training table when exogenous_variables are used. For example, ...
https://dev.mysql.com/doc/heatwave/en/mys-hwgenai-ml-rag.html
vector_store: the list of vector store tables used for context retrieval. It can include the following parameters: vector_store: specifies a list of loaded vector store tables to use for context retrieval. By default, the routine performs a global ... The ML_RAG routine performs retrieval-augmented generation (RAG) by: Taking a natural-language ...
https://dev.mysql.com/doc/refman/8.4/en/charset-conversion.html
To convert a binary or nonbinary string column to use a particular character set, use ALTER TABLE. Suppose that a table t has a binary column named col1 defined as VARBINARY(50). To remove these bytes, use the TRIM() function: UPDATE t SET col1 = ...For successful conversion to occur, one of the following conditions must apply: If the column has a binary data type (BINARY, VARBINARY, BLOB), all the values that it contains must be encoded using a single character set (the character set you're converting the column ...
https://dev.mysql.com/doc/refman/8.4/en/connection-access.html
The server performs identity and credentials checking using columns in the user table, accepting the connection only if these conditions are satisfied: The client host name and user name match the Host and User columns in some user table row. If the ... When you attempt to connect to a MySQL server, the server accepts or rejects the connection based on these conditions: Your identity and whether you can verify it by supplying the proper ...
https://dev.mysql.com/doc/refman/8.4/en/index-hints.html
They also work with multi-table DELETE statements, but not with single-table DELETE, as shown later in this section. (For the general syntax for specifying tables in a SELECT statement, see Section 15.2.13.2, “JOIN Clause”.) The syntax for ...
https://dev.mysql.com/doc/refman/8.4/en/json-search-functions.html
Queries using JSON_CONTAINS() on InnoDB tables can be optimized using multi-valued indexes; see Multi-Valued Indexes, for more information. row *************************** id: 1 select_type: SIMPLE table: jemp partitions: NULL type: range ... The ...
https://dev.mysql.com/doc/refman/8.4/en/load-index.html
| ALL } The LOAD INDEX INTO CACHE statement preloads a table index into the key cache to which it has been assigned by an explicit CACHE INDEX statement, or into the default key cache otherwise. LOAD INDEX INTO CACHE applies only to MyISAM tables, ...tbl_index_list: tbl_name [PARTITION (partition_list)] [{INDEX|KEY} (index_name[, index_name] ...)] [IGNORE LEAVES] partition_list: { partition_name[, partition_name] ...
https://dev.mysql.com/doc/refman/8.4/en/multiple-key-caches.html
This feature enables you to assign different table indexes to different key caches. Where there are multiple key caches, the server must know which cache to use when processing queries for a given MyISAM table. By default, all MyISAM table indexes ... Note As of MySQL 8.4, the compound-part structured-variable syntax discussed here for referring to multiple MyISAM key caches is ...
https://dev.mysql.com/doc/refman/8.4/en/optimize-overview.html
Database performance depends on several factors at the database level, such as tables, queries, and configuration settings. In practice, the advanced InnoDB performance features mean that InnoDB tables often outperform the simpler MyISAM tables, ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-obtaining-parent-events.html
Rows of this table have a THREAD_ID column indicating the thread ID of the session that owns the lock, and an EVENT_ID column indicating the Performance Schema event that caused the lock. To find lock information, data_locks is the table containing ...The relation is based on a nested set data model, so the join has several ...