Search Results
https://dev.mysql.com/doc/heatwave/en/mys-hw-genai-run-chat.html
Run the Chat To run MySQL HeatWave Chat, perform the following steps: To delete previous chat output and state, if any, reset the @chat_options variable: mysql> SET @chat_options=NULL; Note Ensure that you use the name @chat_options for the variable. When you run MySQL HeatWave Chat, it automatically loads the default ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-varlen-encoding.html
Variable-length encoding is automatically applied when tables are loaded into MySQL HeatWave with the exception of string columns defined explicitly as dictionary-encoded columns. You can define the encoding type while creating the table or later ...
https://dev.mysql.com/doc/refman/8.4/en/index-btree-hash.html
A search using col_name IS NULL employs indexes if col_name is indexed. Understanding the B-tree and hash data structures can help predict how different queries perform on different storage engines that use these data structures in their indexes, ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-mysqld.html
row *************************** Id: 1 User: system user Host: db: Command: Daemon Time: 1 State: Waiting for event from ndbcluster Info: NULL Important To participate in an NDB Cluster, the mysqld process must be started with both the options ...To ...
https://dev.mysql.com/doc/c-api/8.4/en/mysql-query.html
int mysql_query(MYSQL *mysql, const char *stmt_str) Description Executes the SQL statement pointed to by the null-terminated string stmt_str. Normally, the string must consist of a single SQL statement without a terminating semicolon (;) or \g. If ...
https://dev.mysql.com/doc/ndb-operator/8.4/en/crd-ndbclusterstatus.html
This will be set to null if a secret has already been provided to the operator using spec.mysqlNode.rootPasswordSecretName. processedGeneration (integer): Holds the latest generation of the Ndb resource whose specs have been successfully applied to ...
https://dev.mysql.com/doc/mysql-ai/9.5/en/mys-ai-genai-run-chat.html
To delete previous chat output and state, if any, reset the @chat_options variable: mysql> SET @chat_options=NULL; Note Ensure that you use the name @chat_options for the variable. When you run GenAI Chat, it automatically loads the ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-aggregate-functions.html
The VARLEN Support column identifies functions that support variable-length encoded string columns. Table 5.1 Aggregate (GROUP BY) Functions Name VARLEN Support Description AVG() Return the average value of the argument COUNT() Yes Return a count of ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-limitations-functions.html
COUNT(NULL) in cases where it is used as an input argument for non-aggregate operators. As of MySQL 9.2.2, the maximum output width of the following functions is 65,332 bytes: JSON_ARRAYAGG() JSON_OBJECTAGG() JSON_ARRAY() JSON_OBJECT() ...
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-training-a-recommendation-model.html
If the users or items column contains NULL values, the corresponding rows are dropped and are not be considered during training. After preparing the data for a recommendation model, you can train the model. Requirements for Recommendation Training ...