Search Results
https://dev.mysql.com/doc/ndbapi/en/mgm-types.html
Enumeration values Possible values are shown, along with descriptions, in the following table: Table 3.1 Type ndb_mgm_node_type values and descriptions. Enumeration values Possible values are shown, along with descriptions, in the following table: ... This section provides information about the data types defined by the MGM ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-loading-data.html
MySQL HeatWave provides the following methods to load data to MySQL HeatWave: Automatic loading: loads tables and partitions based on usage. Loading data manually: loads one table at a time and involves executing multiple statements for each table.
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/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/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 ...
https://dev.mysql.com/doc/refman/8.4/en/programs-overview.html
mysql_tzinfo_to_sql This program loads the time zone tables in the mysql database using the contents of the host system zoneinfo database (the set of files describing time zones). mysqladmin A client that performs administrative operations, such as ...Later sections provide a more detailed description of each one, with the exception of NDB Cluster ...